Senior SQL Server DBA

ADP, Inc.; Parsippany-Troy Hills (NJ); On-site; USD 110,000 - 135,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Life insurance

401(k)

Paid time off

Job summary

Agadia, based in Parsippany, NJ, seeks a Senior SQL Server DBA to manage enterprise SQL Server environments, focusing on health, performance, availability, and security. The role is about 70% production/system DBA and 30% development DBA, with emphasis on proactive administration and automation.

The candidate will monitor, configure, patch, and upgrade SQL Server, implement HA/DR, perform backups/restores, and optimize queries and procedures. On-site presence in Parsippany is required.

Qualifications

• 6+ years of Microsoft SQL Server administration experience
• Strong knowledge of Always On Availability Groups, Windows Failover Clustering, HA, and DR
• Backup, restore, recovery, and disaster recovery expertise
• Strong SQL Server performance tuning and troubleshooting skills
• Experience with execution plans, Query Store, wait statistics, and indexing
• Strong T-SQL skills including review and optimization of stored procedures and queries
• Experience with SQL Sentry, SolarWinds DPA, Redgate or similar tools
• Experience with database growth monitoring and capacity planning
• Experience with SQL Server security, auditing, and access management
• PowerShell or scripting for DBA automation

Responsibilities

• Monitor and manage SQL Server environments across production and non-production
• Proactively monitor CPU, memory, storage, I/O, growth, TempDB, backups, and jobs
• Perform capacity planning and forecast growth
• Build and maintain database health, performance, and capacity dashboards
• Install, configure, patch, and upgrade SQL Server environments
• Manage Always On Availability Groups, Windows Clustering, HA, and DR
• Maintain and validate backup, restore, and disaster recovery procedures
• Troubleshoot production database issues and perform root cause analysis
• Perform query, stored procedure, and performance tuning
• Use tools like SQL Sentry, SolarWinds DPA, Redgate, Query Store, Extended Events for issues
• Maintain indexing and statistics strategies
• Administer database security, permissions, encryption, auditing
• Review code and schema changes
• Build T-SQL, PowerShell, or other automation for monitoring and maintenance
• Support SSIS, SSRS, and Power BI where needed
• Maintain standards, runbooks, and documentation
• Mentor junior team members and collaborate with other teams

Skills

SQL Server administration

Always On Availability Groups

Windows Failover Clustering

Backup and disaster recovery

Performance tuning

T-SQL optimization

Automation with PowerShell

Monitoring tools

Tools

SQL Sentry

SolarWinds DPA

Redgate

Query Store

Extended Events

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Senior SQL Server DBA

Full Time Parsippany, NJ, US

9 days ago Requisition ID: 1020

Salary Range: $110,000.00 To $135,000.00 Annually

About Agadia

Agadia specializes in healthcare management technology and provides utilization management software solutions to healthcare organizations across the United States. We are headquartered in Parsippany, NJ.

Job Overview

Agadia is seeking an experienced Senior SQL Server DBA to manage the health, performance, availability, security, and capacity of our enterprise SQL Server environments.

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 T-SQL 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 non-production.
• 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 T-SQL, stored procedures, schema changes, and database code developed by application teams.
• Build T-SQL, 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 Microsoft SQL Server administration experience .
• 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 T-SQL 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.
• 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 through scripting and automation.
• Problem Solving – Troubleshoot 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.

Please note: The Salary range is based on our market pay structure & includes benefits (Medical, Dental, Vision, life Insurance, 401 & PTO, etc.), and will be determined based on the candidate's experience, qualifications, and evaluation.