Description:
We are seeking an experienced SQL Database Administrator with expertise in configuring SQL Database clusters and implementing SQL Always On Availability Groups for disaster recovery (DR). The ideal candidate will be responsible for ensuring high availability, disaster recovery readiness, and optimal performance of SQL databases across production and DR environments.
Key Responsibilities:
- SQL Database Clustering:
- Design, configure, and maintain SQL Server clusters to ensure high availability and scalability.
- Troubleshoot and resolve cluster-related issues, ensuring minimal downtime.
- Perform failover testing and cluster health checks regularly.
- SQL Always On Configuration:
- Implement and manage SQL Always On Availability Groups for both high availability (HA) and disaster recovery (DR) scenarios.
- Monitor and maintain Always On configurations, ensuring data synchronization across replicas.
- Ensure automatic and manual failover between primary and secondary databases during planned/unplanned outages.
- Disaster Recovery Planning and Testing:
- Develop and implement disaster recovery strategies and policies for SQL Server databases.
- Regularly test DR plans, including failover to secondary sites and recovery procedures.
- Ensure RTO (Recovery Time Objective) and RPO (Recovery Point Objective) targets are met.
Required Qualifications:
- Experience:
- Minimum 5+ years of experience as an SQL Database Administrator.
- Proven experience configuring SQL Server clusters and Always On Availability Groups.
- Strong knowledge of disaster recovery and high availability (HA) best practices.
- Technical Skills:
- In-depth knowledge of SQL Server (versions 2016, 2017, 2019, or later).
- Hands-on experience with Windows Server Failover Clustering (WSFC).
- Expertise in SQL Always On Availability Groups setup, configuration, and management.
- Strong experience with backups, replication, and other DR strategies.
- Familiarity with monitoring and performance tuning tools (e.g., SQL Profiler, PerfMon, etc.).