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: Competitive daily rate, hybrid work model, and opportunity for immediate start.
- Other info: Fast-moving hiring process; ideal for those ready to hit the ground running.
- Why this job: Join a fast-paced team and make a real impact on essential systems.
- Qualifications: Strong SQL development skills and experience with Microsoft SQL Server required.
Location: Hybrid - 3 days per week in Stratford
Rate: £400-£500/day - OUTSIDE IR35
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
- 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
- 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 Stratford employer: TRIA
Join a leading consultancy that values innovation and expertise, offering a dynamic work environment in Stratford. With a strong focus on employee growth and development, we provide opportunities to enhance your skills while working on critical public sector projects. Enjoy the flexibility of a hybrid work model, competitive rates, and the chance to make a meaningful impact in a collaborative team culture.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Developer in Stratford
✨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 personal recommendation can make all the difference.
✨Tip Number 2
Prepare for interviews by brushing up on your SQL skills and understanding the latest trends in database optimisation. We recommend practising common interview questions and scenarios related to performance tuning and data integrity.
✨Tip Number 3
Showcase your projects! If you've worked on any significant SQL or database projects, be ready to discuss them in detail. Highlight your role, the challenges you faced, and how you optimised performance.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take that extra step!
We think you need these skills to ace SQL Developer in Stratford
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL development experience and any relevant database engineering skills. We want to see how your background aligns with the key responsibilities mentioned in the job description.
Show Off Your Skills:Don’t hold back on showcasing your advanced SQL skills! Include specific examples of complex queries you've optimised or database architectures you've designed. This is your chance to shine!
Be Clear and Concise:Keep your application straightforward and to the point. We appreciate clarity, so make sure your experience and achievements are easy to read and understand. Avoid jargon unless it’s relevant!
Apply Through Our Website:We encourage you to apply directly through our website. It streamlines the process for us and ensures your application gets the attention it deserves. Plus, we’re excited to hear from you!
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 ready to discuss complex queries, performance tuning, and database architectures. Practising with real-world scenarios can help you articulate your thought process during the interview.
✨Familiarise Yourself with the Tech Stack
Since this role involves working with SQL Server, IIS, and Elasticsearch, it’s crucial to understand how these technologies interact. Do some research on best practices for optimising performance in these environments, and be prepared to share your insights.
✨Showcase Your Problem-Solving Skills
Prepare to discuss specific challenges you've faced in previous roles, particularly around tuning SQL queries or maintaining data integrity. Use the STAR method (Situation, Task, Action, Result) to structure your answers and highlight your impact.
✨Understand the Importance of Security Clearance
Since active SC clearance is non-negotiable, be ready to discuss your experience with security protocols and data protection. This shows that you take compliance seriously and understand the critical nature of the public sector work you'll be involved in.
