Senior SQL Server Performance Engineer (Hybrid)

RE Partners; Greater London; Hybrid; GBP 90,000 - 125,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

RE Partners in London is seeking a highly skilled SQL Server Engineer to lead the audit, analysis, and optimization of a complex database ecosystem with millions of procedures, frequent locks, and performance bottlenecks.

You will mentor developers, refactor legacy logic, implement indexing and partitioning, and define governance standards. This is a hybrid, long-term role with 2-3 days in the London office and the rest remote; right-to-work in the UK only.

Qualifications

• 5+ years of hands-on SQL Server experience (2016+).
• Deep knowledge of T-SQL, indexing, and execution plans.
• Skilled in troubleshooting locks, deadlocks, and bottlenecks.
• Experience reverse engineering large legacy stored procedures.
• Financial services or energy sector exposure is welcome.

Responsibilities

• Analyze existing schema, procedures, indexes to identify bottlenecks and locks.
• Refactor poorly written queries; mentor developers on performance.
• Rationalize and refactor obsolete procedures and tables.
• Implement indexing strategies, query plans, and partitioning; use DMVs for diagnostics.
• Define and implement database standards and governance procedures.

Skills

T-SQL

Indexing

Execution plans

Deadlocks

Stakeholder comms

Tools

SQL Profiler

Extended Events

DMVs

Redgate

SolarWinds

SQL Sentry

Job description

RE Partners in London is seeking a highly skilled SQL Server Engineer to lead the audit, analysis, and optimization of a complex database ecosystem with millions of procedures, frequent locks, and performance bottlenecks.

You will mentor developers, refactor legacy logic, implement indexing and partitioning, and define governance standards. This is a hybrid, long-term role with 2-3 days in the London office and the rest remote; right-to-work in the UK only.