Senior SQL Server DBA
Senior SQL Server DBAOnsite, NYC | Contract | In-person interview | 8+ years
About the Role:
Our client in New York City needs a senior SQL Server DBA to support business-critical production databases. You will build new SQL Server environments, maintain existing ones, and manage high availability and disaster recovery across multiple data centers. The client is also moving a legacy Ingres platform to SQL Server, so Ingres migration experience is a strong plus.
Required Skills:
- 8+ years of SQL Server administration in production, including installs, upgrades, maintenance, security (logins, roles, permissions) and Windows Server/Active Directory integration
- Performance tuning: execution plans, indexing, and troubleshooting queries, stored procedures and triggers
- Always On Availability Groups across multiple nodes and sites, sync and async commit, WSFC and quorum (File Share and Cloud Witness), and log shipping
- Backup, recovery and DR testing, including failover/failback and HA/DR runbooksSSIS/ETL development and support
- PowerShell, T-SQL and batch scripting for maintenance, deployments and alerts
- PreferredIngres to SQL Server migration: schema and data type conversion, dependency analysis, data reconciliation, cutover and post-go-live support
- Modernizing large legacy databases
- Data modeling, database design and database source control
- Utilities or T&D industry experience
What You Will Do:
Install, configure, patch and upgrade SQL Server and support the Windows Servers it runs onMonitor and maintain production systems, plan capacity, and resolve outages, blocking, deadlocks and failed jobs with root cause analysis Manage Always On Availability Groups, WSFC, log shipping and backups to meet RPO/RTO, and run regular failover tests Tune performance and support T-SQL, SSIS/ETL, application releases and defect fixes with development and QAAutomate tasks with PowerShell and T-SQL and work with application, network and infrastructure teams