Ontwikkelaar in London

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.

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.

Pragmatic Excellence: We take pride in our code quality but remain practical and solution-oriented when balancing business-critical deadlines.

Our engineering function is organised into small teams, with time split across three core areas:

• Core Product Development
• 2nd/3rd-Line Support

We operate a hybrid working model with a minimum of 2 days per week in our London office.

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.

Key responsibilities include:

• 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.
• Writing, refactoring, and optimising complex T-SQL queries, database views, and stored procedures.
• Diagnosing database resource issues such as locking, blocking, or parameter sniffing.

Bonus points for any of the following:

• 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.

We offer a culture built on transparency, innovation, and mutual respect — with real opportunities to grow your skills, take on meaningful work, and make a lasting impact in the PropTech space.

Benefits include:

• Enhanced pension scheme
• ~25 days annual leave (plus bank holidays)
• ~ Life assurance
• ~ Hybrid working arrangements (2 days a week in our Clerkenwell office)

We do not discriminate on the basis of age, disability, gender reassignment, marriage or civil partnership, pregnancy or maternity, race, religion or belief, sex, or sexual orientation.