Senior SQL Server DBA L4

7Th Sky Tech · Iselin, NJ · 2 days ago

On-siteInformation TechnologyContract

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.

Candidate requirements

Work location: Jersey City, NJ. Visa eligibility: US Citizens (USC) and Green Card holders (GC) only. Experience: 15+ years preferred. Note: Client requirement specifies DOB 1987; confirm whether this is a mandatory screening criterion before publishing.

Skills