At a Glance
- Tasks: Optimise SQL queries and maintain robust database architectures in a dynamic environment.
- Company: Leading consultancy working on critical public sector programmes.
- Benefits: Hybrid work model, competitive pay, and opportunity for rapid career growth.
- Other info: Fast-moving hiring process; immediate start for the right candidate.
- Why this job: Join a fast-paced team and make a real impact on vital systems.
- Qualifications: Strong SQL development skills and experience with Microsoft SQL Server required.
The predicted salary is between 40000 - 50000 £ per year.
Location: Hybrid – 3 days per week in Stratford
Duration: 3 months (initial)
Start: ASAP
Security Clearance: Active SC required (non‑negotiable)
We’re working with a leading consultancy on a critical public sector programme, and are looking for an experienced SQL Developer / Database Specialist to join on an initial 3‑month contract. This is a hands‑on role focused on high‑performance SQL development and database optimisation within a complex, enterprise‑scale data environment. You’ll play a key role in ensuring performance, scalability, and reliability across critical systems.
Key Responsibilities
- Tuning and optimising complex SQL queries at scale
- Designing and maintaining robust database architectures (OLTP / OLAP)
- Supporting a multi-layered ecosystem including SQL Server, IIS, and Elasticsearch
- Building and maintaining ETL pipelines and data integration processes
- Ensuring data integrity, security, and performance across systems
Experience Required
- Strong background in SQL Development / Database Engineering / DBA roles
- Deep expertise in Microsoft SQL Server (T‑SQL)
- Advanced SQL skills including CTEs, joins, subqueries, and performance tuning
- Experience working with at least one additional RDBMS (e.g. PostgreSQL or MySQL)
- Proven ability to hit the ground running in fast‑paced, delivery‑focused environments
Nice to Have
- Elasticsearch
- Familiarity with performance tuning tools (e.g. Execution Plans, Profiler, Query Store)
This is a fast-moving hiring process, and we’re looking for someone who can start quickly. If you hold active SC clearance and are interested, please apply with your CV and we’ll be in touch.
SQL Developer in London employer: TRIA
Join a leading consultancy that values innovation and excellence in the public sector, offering a dynamic hybrid work environment in Stratford. With a strong focus on employee development, you will have access to cutting-edge projects and opportunities for professional growth while contributing to critical systems that impact the community. Enjoy a collaborative culture that prioritises performance and reliability, making it an ideal place for skilled SQL Developers seeking meaningful and rewarding work.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Developer in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who might know about opportunities in SQL development. A friendly chat can sometimes lead to job openings that aren't even advertised.
✨Tip Number 2
Prepare for interviews by brushing up on your SQL skills and understanding the specific needs of the role. Practise common interview questions related to database optimisation and performance tuning to show you’re ready to hit the ground running.
✨Tip Number 3
Don’t underestimate the power of a strong online presence! Update your LinkedIn profile with your latest skills and projects, and engage with relevant content to get noticed by recruiters looking for SQL Developers.
✨Tip Number 4
Apply through our website for the best chance at landing the job! We’re all about making the process smooth and straightforward, so don’t miss out on the opportunity to showcase your skills directly to us.
We think you need these skills to ace SQL Developer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL development experience and any relevant database engineering roles. We want to see how your skills match the job description, so don’t be shy about showcasing your expertise in Microsoft SQL Server and other RDBMS.
Showcase Your Skills:When writing your application, emphasise your advanced SQL skills, especially around performance tuning and complex queries. We’re looking for someone who can hit the ground running, so let us know how you’ve done this in past roles!
Be Clear and Concise:Keep your application straightforward and to the point. We appreciate clarity, so avoid jargon unless it’s necessary. Make it easy for us to see why you’re a great fit for this SQL Developer role.
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, we love seeing applications come directly from our site!
How to prepare for a job interview at TRIA
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills, especially T-SQL. Be prepared to discuss complex queries, performance tuning, and database optimisation techniques. Practising with real-world scenarios can help you articulate your thought process during the interview.
✨Familiarise Yourself with the Tech Stack
Since the role involves working with SQL Server, IIS, and Elasticsearch, it’s crucial to understand how these technologies interact. Do some research on common challenges and solutions in a multi-layered ecosystem to show your depth of knowledge.
✨Prepare for Practical Tests
You might be asked to solve SQL problems or optimise queries on the spot. Practise with sample questions or use platforms that simulate technical interviews. This will help you feel more confident and ready to demonstrate your skills.
✨Highlight Your Experience with RDBMS
If you have experience with other RDBMS like PostgreSQL or MySQL, make sure to mention it. Discuss how your diverse background can bring value to the team, especially in terms of performance tuning and data integrity across different systems.
