Description
You will manage and maintain Microsoft SQL Server environments, ensuring availability, performance, and disaster recovery readiness.
This role is on-site.
Responsibilities
- Install, configure, upgrade, and patch SQL Server (2012–2022) in standalone, clustered, and Always On Availability Group environments.
- Manage production, UAT, and development instances to meet SLAs for availability and performance.
- Identify and resolve performance bottlenecks using execution plans and DMV analysis.
- Design and maintain backup/recovery strategies and support disaster recovery exercises.
- Develop T-SQL and PowerShell scripts to automate operations and improve efficiency.
Required Skills
- 11+ years of hands-on experience administering Microsoft SQL Server.
- Strong expertise in T-SQL and complex query optimization.
- Deep knowledge of SQL Server internals, architecture, and Always On Availability Groups.
- Experience managing Windows Server environments.
- Proficiency in database backup, recovery, and high availability configurations.
- Familiarity with monitoring tools (e.g., SCOM, Redgate, SolarWinds).
- Experience with PowerShell scripting for database automation.
Preferred Skills
- Experience with Azure SQL and CI/CD pipelines.