Senior SQL Server DBA — New York, NY

Job Description

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.