Senior SQL Server DBA L4

About the role

We are seeking an experienced Senior SQL Server Database Administrator (DBA) – L4 to manage, optimize, and support enterprise-level database environments. The ideal candidate will have strong expertise in Microsoft SQL Server administration, performance tuning, cloud database management, high availability, disaster recovery, and automation. This role requires a hands-on technical expert capable of handling complex production issues, providing L3/SME-level support, collaborating with clients, and ensuring database performance, availability, security, and reliability in mission-critical environments.

Responsibilities

• Design, implement, administer, and maintain Microsoft SQL Server databases in large-scale enterprise environments.
• Perform advanced SQL Server performance tuning using DMVs, execution plans, SQL Server Internals, and Performance Monitor (PerfMon).
• Manage High Availability (HA) and Disaster Recovery (DR) solutions, including Always On Availability Groups, database mirroring, replication, and clustering.
• Implement database partitioning, compression, security controls, backup strategies, and recovery procedures.
• Develop and maintain T-SQL scripts and automation solutions using PowerShell and Python.
• Support SSIS, SSRS, and SSAS environments.
• Administer and support AWS RDS and other cloud database services.
• Work with MySQL, Linux-based environments, and Snowflake as required.
• Provide L3 production support, root cause analysis, incident resolution, and problem management in accordance with ITIL processes.
• Maintain technical documentation, operational procedures, and knowledge repositories using SharePoint 2010/2013.
• Collaborate with clients, application teams, infrastructure teams, and stakeholders to resolve complex database issues.
• Participate in on-call rotations and ensure timely resolution of critical production incidents.
• Take ownership of database stability, performance, availability, and continuous improvement initiatives.

Requirements

• 10+ years of hands-on Microsoft SQL Server DBA experience; 15+ years of overall experience preferred.
• Strong knowledge of SQL Server performance tuning, internals, DMVs, and PerfMon.
• Extensive experience with Always On, mirroring, replication, and clustering.
• Experience with SQL Server partitioning, compression, database security, backup, and recovery.
• Strong T-SQL skills and scripting experience with PowerShell and/or Python.
• Working knowledge of SSIS, SSRS, and SSAS.
• Minimum 6 months of experience with AWS RDS and cloud database administration.
• Familiarity with MySQL, Linux, and Snowflake.
• Experience in L3 support, SME responsibilities, ITIL processes, and critical production environments.
• Experience maintaining technical documentation using SharePoint 2010/2013.
• Excellent communication, troubleshooting, documentation, and client-facing skills.
• Ability to work independently, manage priorities, and participate in on-call support.

Work location: Jersey City, NJ. Visa eligibility: US Citizens (USC) and Green Card holders (GC). Full-time or contract as applicable. 15+ years overall experience preferred. Note: Client requirement references DOB 1987; confirm whether this is a mandatory screening criterion.

Skills

• Availability
• SQL
• Database
• Performance tuning
• SQL Server
• Microsoft SQL Server