We are looking for an experienced Senior SQL Server DBA with strong hands-on experience in SQL Server administration, engineering, and production support. The candidate will be responsible for managing business-critical SQL Server environments, performance tuning, database maintenance, troubleshooting, automation, and High Availability/Disaster Recovery (HA/DR) solutions.
Key Responsibilities & Required Skills
- Install, configure, administer, patch, upgrade, and maintain SQL Server environments across production and non-production systems.
- Strong hands-on experience with T-SQL, stored procedures, views, triggers, indexing, query optimization, and execution plan analysis.
- Perform database monitoring, health checks, integrity checks, backup/recovery, index maintenance, and SQL Server Agent job management.
- Troubleshoot production incidents, blocking, deadlocks, performance issues, failed jobs, and database connectivity problems.
- Develop, support, and troubleshoot SSIS packages and ETL processes.
- Design, implement, and support SQL Server HA/DR solutions, including Always On Availability Groups (AOAG), Windows Server Failover Clustering (WSFC), and Log Shipping.
- Experience with multi-node/multi-datacenter configurations, synchronous/asynchronous commit modes, quorum, File Share Witness, and Cloud Witness.
- Conduct DR drills, failover/failback testing, and maintain recovery runbooks based on RPO/RTO requirements.
- Strong experience supporting SQL Server on Windows Server, including service accounts, Active Directory authentication, ports, and firewall configurations.
- Work with infrastructure and network teams to troubleshoot connectivity issues.
- Develop automation scripts using PowerShell, T-SQL, and Windows Batch.
- Support database deployments, application releases, post-release validation, and production stabilization.
- Maintain technical documentation and collaborate with application, development, QA, and infrastructure teams.
Highly Preferred Skills
- Direct hands-on experience with INGRES-to-SQL Server migration.
- Knowledge of INGRES SQL, database objects, schemas, and data types.
- Experience with schema/object migration, dependency analysis, data migration, reconciliation, and post-migration validation.
- Experience supporting migration testing, cutover, and post-production stabilization.
- Utilities / Transmission & Distribution (T&D) domain experience.
- Strong data modeling and database design knowledge, including logical/physical models, relationships, keys, constraints, and normalization.
- Experience with database source control/version control tools.