SQL DBA

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

We are looking for a SQL Server Database Administrator (DBA):

We are seeking an experienced, hands-on SQL Server Database Administrator (DBA) to support and maintain enterprise-level database environments. This individual will be responsible for ensuring database performance, availability, security, and reliability while working closely with application development, infrastructure, and engineering teams. The ideal candidate will have strong expertise in Microsoft SQL Server administration, performance tuning, troubleshooting, and database optimization. We are looking for someone who can proactively identify issues, improve database efficiency, and support business-critical applications in a fast-paced, highly collaborative environment.

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.

Requirements:

• 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.

Preferred Skills:

• Experience with SQL Server Always On Availability Groups, replication, and failover clustering.
• Experience with cloud-hosted SQL Server environments, particularly Microsoft Azure or AWS.
• Knowledge of database automation using PowerShell or other scripting tools.
• Familiarity with CI/CD pipelines and database deployment processes.
• Experience with large-scale, high-volume transactional database environments.
• Understanding of database architecture, data modeling, and capacity planning.
• Experience working in Agile development environments.