Senior SQL Server Performance Engineer

RE Partners Consulting; United States; Remote; USD 150,000 - 170,000; Full time

Job summary

RE Partners Consulting is seeking a highly skilled SQL Server Database Optimization Engineer to audit, analyze, and optimize our complex database systems. The role focuses on reducing bottlenecks, refactoring stored procedures, and improving performance across a large environment.

You will work cross-functionally with developers and operations to implement governance and best practices. The base salary ranges from $150,000 to $170,000 per year, with potential bonuses and benefits based on

Qualifications

• 5+ years of hands-on experience with SQL Server (2016+).
• Proven experience in performance tuning and troubleshooting SQL locks, deadlocks, and query bottlenecks.
• Deep knowledge of SQL, T-SQL, indexing strategies, and execution plans.
• Experience in reverse engineering large-scale, legacy stored procedure logic.
• Ability to communicate findings and improvement plans to both technical and non-technical stakeholders.

Responsibilities

• Database Analysis & Audit: Analyze existing SQL Server schema, stored procedures, indexes, and relationships.
• Identify performance bottlenecks, frequent locking/blocking issues, and inefficient query patterns. Query Optimization
• Refactor and optimize poorly written SQL queries and stored procedures. Educate developers on writing performant SQL and best practices.
• Database Clean-Up & Refactoring: Rationalize and refactor redundant or obsolete stored procedures and tables. Simplify overly complex joins and table relationships.
• Performance Tuning: Implement and monitor indexing strategies, query plans, and partitioning as needed. Use tools like SQL Profiler, Extended Events, and DMVs for diagnostics.
• Governance & Best Practices: Define and implement database standards and governance procedures. Contribute to database documentation and change management protocols.

Skills

SQL Server

Performance tuning

Query optimization

T-SQL

Communication

Tools

SQL Profiler

Extended Events

DMVs

Redgate

SolarWinds

CI/CD for databases

Job description

RE Partners Consulting is seeking a highly skilled SQL Server Database Optimization Engineer to audit, analyze, and optimize our complex database systems. The role focuses on reducing bottlenecks, refactoring stored procedures, and improving performance across a large environment.

You will work cross-functionally with developers and operations to implement governance and best practices. The base salary ranges from $150,000 to $170,000 per year, with potential bonuses and benefits based on