Sql Server Database Administrator

Senior SQL Server DBA Job Summary

We are seeking an experienced Senior SQL Server DBA for a 1-year on-site contract in New York City. This role focuses on supporting business-critical SQL Server databases, production environments, performance optimization, high availability, disaster recovery, and database modernization.

Senior SQL Server DBA Responsibilities

• Install, configure, patch, upgrade, and maintain SQL Server environments.
• Troubleshoot production incidents, failed jobs, deadlocks, and performance issues.
• Optimize SQL queries, stored procedures, indexing, and execution plans.
• Develop and support SSIS packages, ETL processes, and SQL Server Agent jobs.
• Manage database security, backups, recovery, and access controls.
• Implement and support Always On Availability Groups (AOAG), WSFC, and HA/DR solutions.
• Conduct disaster recovery testing and support RPO/RTO requirements.
• Automate database administration using PowerShell, T-SQL, and batch scripting.
• Support Windows Server environments, Active Directory, and network connectivity.

Senior SQL Server DBA Required Qualifications

• 8+ years of database administration and production support experience.
• Strong Microsoft SQL Server administration, engineering, and performance tuning expertise.
• Hands-on experience with AOAG, WSFC, backup/recovery, and disaster recovery.
• Proficiency in T-SQL, PowerShell, SSIS, and ETL troubleshooting.
• Experience supporting business-critical databases on Windows Server.

Senior SQL Server DBA Highly Preferred Qualifications

• INGRES-to-SQL Server migration experience, including schema conversion and data validation.
• Utilities / Transmission & Distribution (T&D) industry experience.
• Legacy database modernization, migration testing, and production cutover.
• Data modeling, database design, and database source control.