Senior SQL Server DBA - Hybrid | Always On & Performance

Aegistech

New Jersey

Hybrid

USD 120,000 - 170,000

Full time

10 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Aegistech in Parsippany, NJ is seeking an experienced Senior SQL Server DBA to manage health, security, and capacity of enterprise SQL Server environments in a hybrid onsite role. The position is approximately 70% Production DBA and 30% Development DBA.

The role focuses on proactive administration, monitoring, capacity planning, backups, patching, automation, and strong T-SQL skills to troubleshoot issues and optimize performance. Local candidates only, no relocation, work authorization required.

Qualifications

  • 6+ years of post-graduation experience in Microsoft SQL Server administration.
  • Strong knowledge of Always On Availability Groups, Windows Failover Clustering, HA, and DR.
  • 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.

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

SQL Server admin
T-SQL
Performance tuning
Automation scripting
HA/DR
Monitoring tools
Security & auditing
PowerShell

Tools

SQL Sentry
SolarWinds DPA
Redgate
Query Store
Extended Events

Job description

Aegistech in Parsippany, NJ is seeking an experienced Senior SQL Server DBA to manage health, security, and capacity of enterprise SQL Server environments in a hybrid onsite role. The position is approximately 70% Production DBA and 30% Development DBA.

The role focuses on proactive administration, monitoring, capacity planning, backups, patching, automation, and strong T-SQL skills to troubleshoot issues and optimize performance. Local candidates only, no relocation, work authorization required.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior SQL Server DBA - Automation & HA/DR Expert
Senior SQL Server DBA - Automation & HA/DR Expert

Agadia Systems • Littleton (NJ)

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

Aegistech • New Jersey

Hybrid
USD 120,000 - 170,000
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 DB Developer & DBA - Hybrid
Senior SQL Server DB Developer & DBA - Hybrid

Ahead • New Bedford (MA)

Hybrid
USD 120,000 - 150,000
Medical, Dental, and Vision Insurance
401(k) Plan with Company Match
Paid Time Off and Holidays
+1
Senior SQL Server DBA - Performance, Always On & Security
Senior SQL Server DBA - Performance, Always On & Security

HocxHire • New Jersey

Hybrid
USD 120,000 - 150,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
Azure SQL & SQL Server DBA — Hybrid NYC, Always On Expert
Azure SQL & SQL Server DBA — Hybrid NYC, Always On Expert

Tech Mirrors • New York (NY)

Hybrid
USD 110,000 - 150,000
Senior SQL Server DBA
Senior SQL Server DBA

HocxHire • New Jersey

Hybrid
USD 120,000 - 150,000
Hybrid SQL Server DBA for 24/7 Production & HA
Hybrid SQL Server DBA for 24/7 Production & HA

TECHNOLOGY PARTNERS INC • United States

Hybrid
USD 39,000 - 55,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