Database Administrator
Core
Managing Microsoft SQL Server environments, implementing complex data transformations for data warehousing, and ensuring high availability and performance.
Role type
Senior Database Administrator (SQL Server)
Builds
Data warehouse loads, high-availability database configurations, and automated maintenance scripts.
Domain
Enterprise IT / Data Management / Business Intelligence
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Microsoft SQL Server administration, SSIS/SSAS/SSRS, T-SQL (DML/DDL/TCL), PowerShell scripting, database backup and restore, log shipping, indexing and partitioning, data modeling (Erwin/ERStudio), troubleshooting.
Preferred skills
SQL Server 2012 Replication, Analysis Services, MCDBA or MCSA certification.
Technologies
Microsoft SQL Server 2012, VMware, Apache Subversion, Erwin, ERStudio, Microsoft Office 2013.
Responsibilities
Troubleshoot and resolve database problems, implement complex normalization and transformation logic using SSIS, manage high availability features like log shipping and backup/restore, optimize performance through indexing and partitioning.
Seniority
Senior, hands-on IC
