Senior SQL Server DBA L4
7Th Sky Tech · Chicago, IL · 2 days ago
On-siteInformation TechnologyContract
Location: Jersey City, NJ Experience: 15+ Years Visa: USC / Green Card (GC) Job Type: Full-Time / Contract (as applicable) Job Summary 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. Key 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. Required Skills And Qualifications 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) Experience: 15+ years preferred DOB: 1987 (as specified in the requirement; confirm whether this is a mandatory client screening criterion before publishing) How to Apply Interested candidates who meet the requirements can share their updated resume along with their current location, work authorization, contact details, and availability. Apply now or message us on LinkedIn to discuss this opportunity. Skills: availability,sql,database,performance tuning,sql server,microsoft sql server