Sr. SQL Server Performance Engineer/ DBA

Advanced
Florham Park, NJ, United States
1 day ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
7 years minimum
Working hours
Regular working hours

Tech stack

Application Performance Management Backup Devices Databases Disaster Recovery Microsoft SQL Server SQL Azure Performance Tuning Windows PowerShell Query Optimization Software Engineering SQL Stored Procedures SQL Databases
+6 more
Transact-SQL Diagnostic Tools System Availability Database Optimization Amazon Relational Database Service SQL Server Management Studio (SSMS)

Job description

We are seeking a hands-on Senior SQL Server Performance Engineer / DBA with a strong focus on performance optimization (70%) and database administration (30%).

This is a performance-focused role, not a traditional DBA position. The ideal candidate can independently diagnose and resolve complex SQL Server performance issues, optimize T-SQL queries, and work directly with application developers to improve application performance., * Diagnose and resolve SQL Server performance issues, including slow queries, blocking, deadlocks, and resource bottlenecks.

  • Optimize complex T-SQL queries, stored procedures, execution plans, and indexing strategies.
  • Use Query Store, Extended Events, DMVs, and SSMS to investigate and resolve performance issues.
  • Collaborate with application developers to troubleshoot application slowdowns and SQL-related issues.
  • Perform root cause analysis and implement long-term performance improvements.
  • Support SQL Server production environments, including maintenance, deployments, backups, recovery, and scheduled weekend support.

Requirements

Performance Engineering, Microsoft SQL Server, Database Administration, Performance Engineering, Microsoft SQL Server, Database Administration, Performance Tuning/Optimization, Identify Issues, Microsoft Transact-SQL (T-SQL), Software Development, * 7+ years of hands-on SQL Server experience, with significant focus on performance engineering and optimization.

  • Advanced T-SQL development, query optimization, stored procedure tuning, and execution plan analysis.
  • Proven experience independently diagnosing and resolving complex SQL Server performance issues.
  • Strong understanding of SQL Server internals, including locking, blocking, deadlocks, memory, and I/O.
  • Hands-on experience with SQL Server performance diagnostic tools.
  • Experience troubleshooting database-related application issues alongside development teams.
  • Solid production SQL Server DBA experience., * SQL Server Always On, high availability, and disaster recovery.
  • PowerShell scripting and database automation.
  • Azure SQL or AWS RDS for SQL Server.
  • Experience with high-volume transactional systems and CI/CD pipelines.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…