SQL Dba
Core
Managing SQL Server 2008R2 through 2016 instances, ensuring high availability, disaster recovery, and performance optimization.
Role type
Senior SQL Database Administrator
Builds
Production OLTP/OLAP database instances
Domain
Enterprise Database Administration
Deliverable
production ML models | infrastructure
Required skills
SQL Server administration, disaster recovery planning, high availability configuration, database encryption, backup and restore, performance tuning, automation scripting
Preferred skills
PowerShell, SSIS, 3rd party monitoring tools (Quest Foglight/App Dynamics), query optimization
Technologies
SQL Server 2008R2/2012/2014/2016, AlwaysOn, Clustering, Log-shipping, Mirroring, Replication, PowerShell, SSIS, Quest Foglight, App Dynamics
Responsibilities
Install, patch, upgrade, and configure SQL Server instances; implement and monitor disaster recovery and high availability solutions; optimize query performance and tune database instances; automate routine maintenance tasks; troubleshoot and resolve database issues; prepare and share knowledge articles with the team.
Seniority
Senior, hands-on IC