Database Administrator

RE Partners

SQL Server Database Optimization Engineer at RE Partners consulting. Leading efforts in optimizing complex database systems with 5+ years of experience required.

Posted 7/22/2026full-time🇬🇧 United KingdomMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive experience in SQL Server performance tuning, query optimization, and database governance. Capable of educating teams on best practices while effectively communicating technical findings to diverse stakeholders.

Highest-signal resume keywords

SQL Server (2016+)Performance TuningT-SQLIndexing StrategiesAgile Environment

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLStored ProceduresQuery OptimizationDatabase DocumentationChange ManagementData ModelingSchema RedesignExecution PlansReverse EngineeringDiagnostics

Soft Skills

CommunicationCollaboration

Tools & Technologies

SQL ProfilerExtended EventsDMVsRedgateSolarWindsSQL Sentry

Industry Keywords

Database StandardsGovernance ProceduresCI/CD PracticesPerformance BottlenecksLocking/Blocking Issues

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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.
Nice to Have Experience with data modeling and schema redesign.
Familiarity with database monitoring tools (e.g., Redgate, SolarWinds, or SQL Sentry).
Understanding of CI/CD practices for database changes.
Experience working in an Agile or DevOps environment.

Benefits

Comp & perks

Equal Opportunity Employer: We are an equal opportunity employer and welcome applications from all qualified individuals regardless of race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, or veteran status.