Wanted: SQL Developer / Database Performance Specialist

Trace Solutions is a pioneering, employee-owned software company that builds enterprise-grade property management and accounting systems. For over 50 years, our software has served as the technological backbone for major UK managing agents and housing associations. We are a mid-sized organisation of around 60 people, based in Clerkenwell in central London, with a strong focus on providing exemplary service and cultivating absurdly happy customers.

The development function at Trace Solutions brings together deep industry heritage and modern innovation across two core teams. Our PowerBuilder Development Team is dedicated to supporting and enhancing our highly successful, enterprise-grade legacy platform (built on a PowerBuilder and SQL Server architecture). Concurrently, our Web Development Team is tasked with building Mojo, a cutting-edge, cloud-based platform destined to completely replace TRAMPS/BlueBox/o6ix. A critical bridge between these systems is our data infrastructure, which has a reputation for rock-solid reliability.

Our team’s core values

• Psychological Safety: We foster a respectful, no-blame working environment where everyone has a right to be heard and mistakes are treated as learning opportunities.
• Collaborative Mindset: We work together, actively asking for support when we need it and freely offering it when we can.
• Pragmatic Excellence: We take pride in our code quality but remain practical and solution-oriented when balancing business-critical deadlines.

How we work

Our engineering teams are organised into small, Agile teams of 5 to 6 people using Scrum to deliver focussed product increments. Our time is split across three core areas:

• Core Product Development: Building the next generation of our Mojo platform.
• Client Requests: Delivering tailored, high-value features directly for our users.
• 3rd-Line Support: Diving deep into complex, rewarding technical troubleshooting to assist our internal support teams

We operate a hybrid working model with a minimum of 2 days per week in our London office. We choose to work this way because we value face-to-face collaboration, team brainstorming, and peer-to-peer mentoring.

What we are looking for

The SQL Developer & Database Performance Specialist is expected to be our internal “SQL Whisperer.” You will have a profound understanding of how database queries execute inside Microsoft SQL Server, coupled with a passion for hunting down reporting efficiencies and improving system performance. This role is a hands-on technical position embedded within the engineering cycle, acting as a critical bridge between legacy reporting logic and modern cloud database architecture.

Your primary mission will be to ensure our core SQL Server database runs optimally to support current TRAMPS/BlueBox/o6ix installations, while providing the clean execution paths needed as we transition to our modern cloud future. Additionally, you will act as the go-to technical resource across all squads: writing new, optimised T-SQL queries for emerging product features, diving into the database to diagnose and resolve reported application bugs, and inefficiencies to ensure our platforms run flawlessly.

Technical skills – must be familiar with:

• Deep profiling of database queries using SQL Server Management Studio (SSMS), Plan Cache analysis, and Extended Events.
• Reading and evaluating Execution Plans to spot performance bottlenecks (e.g., expensive table scans, bad cardinality estimates, or costly joins).
• Designing and implementing advanced indexing strategies specifically optimised for heavy read/reporting workloads.
• Writing, refactoring, and optimising complex T-SQL queries, database views, and stored procedures.
• Diagnosing database resource issues such as locking, blocking, or parameter sniffing.
• Working with version control systems such as Git.

Technical skills – bonus points:

• Experience working alongside legacy client-server application logic (such as PowerBuilder) where code cannot easily be modified on the front-end.
• Exposure to property management software, multi-ledger accounting, or related business domains.
• An interest and some experience in using AI tools (such as Claude Code) to assist with query construction, debugging, and productivity.
• Agile working practices and Scrum ceremonies.

Personal skills & mindset

• Analytical Thinker: Demonstrates strong problem-solving skills and genuinely enjoys uncovering the “why” behind sudden drops in query or database performance.
• Proactive Growth: Takes active steps to continuously improve your own technical and professional skills.
• Resourceful Collaboration: Can investigate issues independently but seeks input from others when appropriate and shares knowledge openly.
• Pragmatic Problem Solver: Comfortable evaluating trade-offs between complex database redesigns and fast, effective tactical fixes (like an index or a quick query rewrite).
• Clear Communicator: Communicates effectively with both technical and non-technical colleagues, ensuring complex performance risks are easily understood.

Responsibilities of the role

• Performance Optimisation: Methodically hunt down, isolate, and resolve slow-running reporting queries across both the legacy TRAMPS/BlueBox/o6ix system and Mojo platform workflows.
• Query Crafting: Write clean, efficient, and highly optimised new T-SQL queries and procedures to support emerging product features in the cloud ecosystem.
• Defect Investigation: Actively partner with developers and 2nd/3rd -line support to diagnose, trace, and debug complex data-related application bugs.
• Index Architecture: Design, monitor, and maintain indexing structures across our property schemas to maximise read efficiency while minimising structural overhead.
• Environment & Data Support: Assist engineering teams with complex query plans, test data design, and performance-profiling inside our development and staging database environments.

Why Join Us?

We are an employee-owned PropTech company with deep roots in property management software. From our base in Clerkenwell, we support around 300 organisations with our suite of products TRAMPS, BlueBox, o6ix, Mojo and Estateman which help clients automate processes, analyse information and integrate seamlessly with best-of-breed applications.

With around 60 people and a genuine culture of ownership and collaboration, we’re one of the leading innovators in our sector. Growth in our web-based Mojo platform means the business is expanding, and this role sits at the centre of that momentum.

Join us and be part of a company that values expertise, innovation, and collaboration.

Don’t tick every box? No problem – if you believe your skills and experience would make you a valuable addition to our team, we’d still love to hear from you. Potential candidates should drop us a line at this email address.

Strictly no agencies.