SQL Performance Engineer: Legacy & Cloud DB Expert (Hybrid)

Trace Solutions Ltd; Greater London; Hybrid; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Enhanced pension scheme

25 days annual leave

Life assurance

Group Income Protection

Hybrid working arrangements (2 days a/

Hybrid working arrangements (2 days a

Job summary

Trace Solutions is seeking a SQL Developer & Database Performance Specialist to optimise our Microsoft SQL Server databases across the TRAMPS/BlueBox/o6ix legacy reporting layer and the Mojo cloud platform. You will be the internal SQL whisperer, tuning queries and improving run times in a hands-on role embedded in engineering.

Based in Clerkenwell, London, this hybrid position requires collaboration across squads, strong problem solving, and willingness to mentor others as we migrate to modern

Qualifications

• Strong experience with Microsoft SQL Server databases and query tuning.
• Hands-on ability to diagnose performance bottlenecks and optimise reporting queries.
• Experience with T-SQL, indexing strategies, and read-heavy workloads.
• Familiarity with Git and version control in a team environment.

Responsibilities

• Performance Optimisation: hunt down, isolate, and resolve slow‑running reporting queries across TRAMPS/BlueBox/o6ix and Mojo workflows.
• Query Crafting: write clean, efficient T‑SQL queries and procedures to support cloud features.
• Defect Investigation: partner with developers to diagnose and fix data-related bugs and inefficiencies.
• Index Architecture: design and maintain indexing structures to maximise read performance with minimal overhead.
• Environment & Data Support: assist engineering teams with query plans, test data design, and performance profiling.

Skills

SQL Server

T-SQL

Query tuning

Indexing

Performance analysis

Git

Tools

SSMS

Execution Plans

Plan Cache

PowerBuilder

Job description

Trace Solutions is seeking a SQL Developer & Database Performance Specialist to optimise our Microsoft SQL Server databases across the TRAMPS/BlueBox/o6ix legacy reporting layer and the Mojo cloud platform. You will be the internal SQL whisperer, tuning queries and improving run times in a hands-on role embedded in engineering.

Based in Clerkenwell, London, this hybrid position requires collaboration across squads, strong problem solving, and willingness to mentor others as we migrate to modern