Senior SQL Server DBA

Aegistech; New Jersey; Hybrid; USD 120,000 - 150,000; Full time

Job summary

Our client in Northern New Jersey seeks an experienced Senior SQL Server DBA to manage health, performance, availability, security, and capacity of enterprise SQL Server environments. The role is hybrid, onsite in Parsippany, NJ, with 34 days onsite per year.

Local candidates only; no relocation. The role focuses on proactive administration, monitoring, backups, patching, automation, and security, with strong T-SQL skills to troubleshoot performance issues and optimize database code.

Qualifications

• 6+ years of post-graduation experience in MS SQL Server administration.
• Deep knowledge of Always On AG, Windows Failover Clustering, HA/DR.
• Strong backup/restore, disaster recovery expertise.
• Advanced SQL Server performance tuning and troubleshooting skills.
• Experience with execution plans, wait stats, blocking, indexing, and statistics.
• Proficient in reviewing and optimizing stored procedures and queries.
• Familiar with monitoring tools like SQL Sentry, SolarWinds DPA, Redgate.

Responsibilities

• Monitor and manage SQL Server environments across production and nonproduction.
• Proactively monitor CPU, memory, storage, I/O, database growth, and logs.
• Plan capacity and forecast growth for databases and infrastructure.
• Build and maintain health, performance, and capacity dashboards.
• Install, configure, patch, and upgrade SQL Server environments.
• Manage Always On, Windows Clustering, HA, and DR.
• Validate backup, restore, and disaster recovery procedures regularly.
• Troubleshoot production DB issues and perform root cause analysis.
• Optimize queries, stored procedures, execution plans, and indexing.
• Develop automation for monitoring, maintenance, and reporting.
• Support SSIS, SSRS, and Power BI where DB expertise is required.
• Maintain standards, runbooks, and documentation; mentor juniors.

Skills

SQL Server Admin

Always On Availability Groups

Windows Failover Clustering

Performance tuning

T-SQL

Automation

PowerShell

Tools

SQL Sentry

SolarWinds DPA

Redgate

Query Store

Extended Events

Job description

Our client in Northern NJ is seeking an experienced Senior SQL Server DBA to manage the health, performance, availability, security, and capacity of our enterprise SQL Server environments. This position is hybrid, onsite 34 days in Northern NJ. Local candidates only/No Relocation.

This role is not eligible for employer-sponsored work authorization (e.g., H1B, OPT, CPT, etc.) or transfer. Candidates must have valid U.S. work authorization

This role is approximately 70% Production/System DBA and 30% Development DBA.

The primary focus is proactive administration of SQL Server infrastructure, including server monitoring, performance management, capacity planning, HA/DR, backups, security, patching, and automation. The role also requires strong TSQL skills to troubleshoot performance issues, review development code, and build DBA automation and monitoring solutions.

We are looking for someone who actively manages the environment, identifies risks and growth trends early, and resolves issues before they impact production.

Responsibilities:

• Monitor and manage SQL Server environments across production and nonproduction.
• Proactively monitor CPU, memory, storage, I/O, database growth, TempDB, transaction logs, blocking, waits, jobs, and backups.
• Perform capacity planning and forecast database, storage, and infrastructure growth.
• Build and maintain database health, performance, and capacity dashboards.
• Install, configure, patch, and upgrade SQL Server environments.
• Manage SQL Server Always On Availability Groups, Windows Clustering, HA, and DR.
• Maintain and regularly validate backup, restore, and disaster recovery procedures.
• Troubleshoot production database issues and participate in root cause analysis.
• Perform query, stored procedure, execution plan, indexing, and database performance tuning.
• Use tools such as SQL Sentry, SolarWinds DPA, Redgate, Query Store, and Extended Events to identify performance issues and trends.
• Maintain indexing and statistics strategies based on actual system usage.
• Administer database security, permissions, encryption, auditing, and access controls.
• Review TSQL, stored procedures, schema changes, and database code developed by application teams.
• Build TSQL, PowerShell, or other automation for monitoring, health checks, maintenance, reporting, and routine DBA activities.
• Support SQL Server Agent, SSIS, SSRS, and Power BI where database expertise is required.
• Maintain database standards, operational documentation, and runbooks.
• Mentor junior team members and work closely with development, infrastructure, security, and support teams.

Skills and Qualifications:

• 6+ years of post-graduation experience in Microsoft SQL Server administration.
• Strong knowledge of SQL Server Always On Availability Groups, Windows Failover Clustering, HA, and DR.
• Strong experience with backup, restore, recovery, and disaster recovery.
• Strong SQL Server performance tuning and troubleshooting skills.
• Experience with execution plans, Query Store, wait statistics, blocking, TempDB, memory, CPU, I/O, indexes, and statistics.
• Strong TSQL skills with the ability to review and optimize stored procedures and queries.
• Experience with database monitoring tools such as SQL Sentry, SolarWinds DPA, Redgate, or similar platforms.
• Experience with database growth monitoring and capacity planning.
• Experience with SQL Server security, auditing, and access management.
• Experience with Windows Server, Active Directory, and clustering.
• Experience with PowerShell or other scripting for DBA automation.
• Familiarity with SSIS, SSRS, Power BI, source control, and database change management.
• Experience in healthcare or another regulated environment is a plus.
• Exposure to Azure or other cloud-hosted database environments is a plus.
• Comfortable leveraging AI-assisted tools for troubleshooting, query analysis, documentation, and automation while independently validating results.
• Must be able to work from our Parsippany, NJ office.
• Applicants must be legally authorized to work in the United States, and the company does not provide employment visa sponsorship now or in the future
• Proactive Ownership – Identifies risks, trends, and performance issues before they become incidents.
• Performance Focus – Uses monitoring tools and system telemetry to improve SQL Server performance.
• Automation Mindset – Reduces repetitive DBA work by automating tasks.
• Problem Solving – Troubleshoots complex production and application database issues.
• Communication – Clearly communicates technical risks, findings, and recommendations.
• Continuous Improvement – Regularly identifies opportunities to improve reliability, scalability, and operational processes.