Senior SQL Server DBA — Performance, HA & Automation

Advanced Tech Placement; Florham Park (NJ); On-site; USD 110,000 - 140,000; Full time

Job summary

Advanced Tech Placement is actively seeking an experienced SQL Server Database Administrator (DBA) to support and optimize enterprise-scale SQL Server environments. You will ensure performance, security, and high availability while collaborating with development, infrastructure, and engineering teams.

The role focuses on monitoring, backups, disaster recovery, and tuning of complex queries, indexes, and configurations.

Qualifications

• 5+ years of hands-on experience administering Microsoft SQL Server databases in enterprise environments.
• Strong experience with SQL Server installation, configuration, maintenance, and troubleshooting.
• Advanced proficiency in T-SQL, including writing, reviewing, and optimizing complex SQL queries and stored procedures.
• Demonstrated experience with SQL Server performance tuning, indexing, execution plans, and query optimization.
• Strong understanding of backup and recovery strategies, database security, and high-availability solutions.
• Experience supporting production databases and resolving critical performance or availability issues.
• Familiarity with SQL Server Management Studio (SSMS), SQL Server Agent, and database monitoring tools.
• Experience collaborating with application development teams to support database changes and deployments.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication skills and the ability to work effectively across technical teams.

Responsibilities

• Install, configure, maintain, and administer Microsoft SQL Server databases across development, testing, and production environments.
• Monitor database health, performance, availability, and capacity to ensure optimal operations.
• Manage database backups, restores, recovery procedures, and disaster recovery planning.
• Perform database upgrades, patching, migrations, and routine maintenance.
• Maintain database security, user permissions, access controls, and compliance with organizational standards.
• Analyze and troubleshoot SQL Server performance issues, including slow-running queries, blocking, deadlocks, and resource utilization.
• Optimize SQL queries, stored procedures, indexes, and database configurations.
• Utilize SQL Server monitoring and diagnostic tools to identify performance bottlenecks.
• Review execution plans and recommend improvements to database performance and scalability.
• Proactively identify opportunities to improve database reliability and operational efficiency.
• Partner with application developers, architects, and engineering teams to support database requirements for enterprise applications.
• Assist development teams with SQL query optimization, database design, and troubleshooting.
• Support database deployments, schema changes, and application releases.
• Collaborate with cross-functional teams to resolve production incidents and database-related application issues.
• Provide technical guidance on database best practices, performance, and scalability.
• Support SQL Server high-availability and disaster recovery solutions, including Always On Availability Groups and failover clustering.
• Develop and maintain automation scripts using T-SQL and PowerShell to streamline database administration.
• Ensure database environments follow established security, backup, and recovery standards.
• Participate in production support, incident resolution, and root cause analysis.
• Maintain accurate documentation of database configurations, operational procedures, and troubleshooting processes.

Skills

SQL Server

T-SQL

Performance tuning

Troubleshooting

Analytical thinking

Communication

Tools

SSMS

PowerShell

SQL Server Agent

Job description

Advanced Tech Placement is actively seeking an experienced SQL Server Database Administrator (DBA) to support and optimize enterprise-scale SQL Server environments. You will ensure performance, security, and high availability while collaborating with development, infrastructure, and engineering teams.

The role focuses on monitoring, backups, disaster recovery, and tuning of complex queries, indexes, and configurations.