Senior SQL Server DBA - Automation & HA/DR Expert

Agadia Systems

Littleton (NJ)

On-site

USD 110,000 - 135,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Agadia Systems, based in Parsippany, NJ, seeks an experienced Senior SQL Server DBA to manage enterprise SQL Server environments, focusing on production stability and development support. You will monitor performance, plan capacity, and implement automation to enhance reliability.

The role emphasizes Always On, HA/DR, backups, and security, with strong T-SQL skills to optimize queries and troubleshoot issues. Office-based position requiring on-site presence in Parsippany.

Qualifications

  • 6+ years of Microsoft SQL Server administration experience.
  • Expertise in Always On, Windows Failover Clustering, HA/DR.
  • Strong backup, restore, and disaster recovery skills.
  • Proficient in SQL performance tuning and troubleshooting.
  • Experience with execution plans, Query Store, waits, indexing.
  • PowerShell or scripting for automation.
  • Familiar with SSIS/SSRS/Power BI.
  • Healthcare or regulated environment is a plus.
  • Azure exposure is a plus.

Responsibilities

  • Monitor and manage SQL Server environments across production and non-production.
  • Proactively monitor CPU, memory, storage, I/O, DB growth, TempDB, logs, blocking, waits, jobs, 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 Always On Availability Groups, Windows Clustering, HA, and DR.
  • Validate backup, restore, and disaster recovery procedures.
  • Troubleshoot production database issues and perform root cause analysis.
  • Tune queries, stored procedures, execution plans, indexing, and performance.
  • Use SQL Sentry, SolarWinds DPA, Redgate, Query Store, Extended Events for analysis.
  • Maintain indexing strategies and statistics; ensure security and access controls.
  • Review code and perform automation for monitoring and maintenance.
  • Support SSIS, SSRS, and Power BI where needed.
  • Maintain runbooks and operational documentation; mentor juniors.

Skills

SQL Server Admin
Always On
Windows Clustering
T-SQL
PowerShell
Automation
Performance Tuning
Backup/DR
Security & Auditing
Azure Cloud

Tools

SQL Sentry
SolarWinds DPA
Redgate
Query Store
Extended Events

Job description

Agadia Systems, based in Parsippany, NJ, seeks an experienced Senior SQL Server DBA to manage enterprise SQL Server environments, focusing on production stability and development support. You will monitor performance, plan capacity, and implement automation to enhance reliability.

The role emphasizes Always On, HA/DR, backups, and security, with strong T-SQL skills to optimize queries and troubleshoot issues. Office-based position requiring on-site presence in Parsippany.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior SQL Server DBA — HA/DR & Automation Leader
Senior SQL Server DBA — HA/DR & Automation Leader

ADP, Inc. • Parsippany-Troy Hills (NJ)

On-site
USD 110,000 - 135,000
Medical benefits
Dental benefits
Vision benefits
+3
Senior SQL Server Architect & Automation
Senior SQL Server Architect & Automation

ADP, Inc. • Parsippany-Troy Hills (NJ)

On-site
USD 100,000 - 120,000
Senior SQL Server DBA – Production & Dev Automation
Senior SQL Server DBA – Production & Dev Automation

Agadia • Parsippany-Troy Hills (NJ)

On-site
USD 120,000 - 160,000
Senior SQL Server Developer - Performance & Automation
Senior SQL Server Developer - Performance & Automation

Agadia • Parsippany-Troy Hills (NJ)

On-site
USD 110,000 - 150,000
Senior SQL Server DBA
Senior SQL Server DBA

Agadia Systems • Littleton (NJ)

On-site
USD 110,000 - 135,000
Senior SQL Server DBA
Senior SQL Server DBA

ADP, Inc. • Parsippany-Troy Hills (NJ)

On-site
USD 110,000 - 135,000
Medical benefits
Dental benefits
Vision benefits
+3
Senior SQL Server DBA
Senior SQL Server DBA

Agadia • Parsippany-Troy Hills (NJ)

On-site
USD 120,000 - 160,000
Senior SQL Server DBA
Senior SQL Server DBA

Aegistech • New Jersey

Hybrid
USD 120,000 - 170,000
Senior SQL Server DBA - Hybrid | Always On & Performance
Senior SQL Server DBA - Hybrid | Always On & Performance

Aegistech • New Jersey

Hybrid
USD 120,000 - 170,000
Senior DBA
Senior DBA

FutureRecruit.net • Parsippany-Troy Hills (NJ)

On-site
USD 100,000 - 130,000