Lead SQL Developer

Lead SQL Developer

Gloucester Full-Time 43200 - 72000 £ / year (est.) No home office possible
L

At a Glance

  • Tasks: Join us as a Lead SQL Developer, optimising databases and enhancing performance for a unique crime-fighting capability.
  • Company: Be part of Leonardo, a leader in technology with a commitment to innovation and employee wellbeing.
  • Benefits: Enjoy flexible working hours, a generous pension scheme, and access to over 4000 online courses.
  • Why this job: Make a real impact on UK policing while working in a supportive and award-winning environment.
  • Qualifications: Strong SQL skills, a degree in IT or related field, and experience with database performance tuning required.
  • Other info: Hybrid working options available; perfect for students seeking flexibility.

The predicted salary is between 43200 - 72000 £ per year.

Social network you want to login/join with:

We are looking to recruit a Principal SQL Developer to work on the support of a truly unique capability, NAS. NAS is understood to be the largest number plate recognition database in the world supporting UK Policing and Law Enforcement in the detection and prevention of serious crime. The system processes over 50 million vehicle movements per day and holds a dataset of up to 60 billion records in what has been described to us as the largest Microsoft SQL Server instance in the UK.

We are looking for a forward thinking individual with strong SQL capabilities. In return, we offer our, having wonthe Best Flexible Working Policy Award, Best Flexible Benefits Strategy and Best Flexible Benefits Plan in 2023.

  • Performance Tuning : Analyse and optimise SQL Server Databases for performance efficiency. This includes tuning complex queries, indexes, and server configurations.
  • Troubleshooting : Identify and resolve database performance issues. Provide solutions for query optimisation and server tuning.
  • Best Practice Implementation : Develop and implement best practices for database design, tuning, and maintenance.
  • Collaboration : Work closes with customer and development teams to optimise SQL queries and database schemas based on application requirements.
  • Monitoring : Support in implementing database monitoring tool to pre-emptively identify potential issues.
  • Capacity Planning : Assist in capacity planning and resource optimisation for SQL Server environments
  • Documentation : Create and maintain comprehensive documentation regarding database configuration, optimisations and best practices.
  • Bachelor’s degree in Computer Science, Information Technology or a related field.
  • Strong proficiency with SQL and its variation among popular databases
  • In-depth knowledge of SQL Server performance tuning techniques
  • Proficiency in T-SQL, including writing and optimising queries, Index Management
  • Ability to plan resource requirements from high level specifications
  • Understanding of Database Engine Internals, i.e. Understanding of SQL Servers internal architecture, including how queries are processed, how data is stored and how indexes are utilised
  • Familiar with clustered SQL setups and architectures for replicating data
  • Knowledge of Locking, Concurrency Partitioning
  • Experience in configuring SQL Server Resource Governor
  • Experience in using SQL Server Profiler and Extended Events
  • Understanding of Database Sharding
  • Understanding of high availability and disaster recover
  • Proficient understanding of database structures, theories and best practices.
  • Certifications in SQL Server or related fields
  • Experience with cloud-base database solutions
  • Familiarity with other database technologies

Security Clearance

:

Life at Leonardo

With a company funded benefits package, a commitment to learning and development, and a flexible approach to working hours focused on the needs of both our employees and customers, a career with Leonardo has never offered as many opportunities or been more accessible to as many people.

  • Pension: Award winning pension scheme (up to 10% employer contribution)
  • Holidays: 25 days plus bank holidays, option to buy/sell leave and to accrue up to 12 additional flexi leave days per year
  • Flexible Working: Flexible hours with hybrid working options. For part time opportunities, please talk to us
  • Wellbeing: Employee Assistance Programme, access to Mental Health support, Financial wellbeing support, network groups (Enable, Pride, Equalise, Reservists, Carers)
  • Lifestyle: Discounted Gym membership, Cycle to work scheme
  • Company funded flexible benefits: Access to private healthcare, dental schemes, Workplace ISA, Go Green Car Scheme, technology and lifestyle options (£500 annual allowance)
  • Training: Free access to more than 4000 online courses via Coursera
  • Referral Incentive: You can earn a reward for successfully referring a friend or family member
  • Bonus: Scheme in place for all employees at management level and below

Please note that if you are NOT a passport holder of the country for the vacancy you might need a work permit. Check our Blog for more information.

Bank or payment details should not be provided when applying for a job. Eurojobs.com is not responsible for any external website content. All applications should be made via the \’Apply now\’ button.

Created on 22/06/2025 by TN United Kingdom

#J-18808-Ljbffr

Lead SQL Developer employer: Leonardo

At Leonardo, we pride ourselves on being an exceptional employer, offering a dynamic work environment that champions flexibility and employee well-being. With award-winning benefits, including a generous pension scheme, extensive training opportunities, and a commitment to mental health support, we empower our employees to thrive both personally and professionally. Join us in our mission to support UK Policing and Law Enforcement while enjoying a culture that values collaboration, innovation, and continuous growth.
L

Contact Detail:

Leonardo Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Lead SQL Developer

✨Tip Number 1

Familiarise yourself with the specific SQL Server performance tuning techniques mentioned in the job description. Being able to discuss these in detail during your interview will show that you have the expertise they are looking for.

✨Tip Number 2

Highlight any experience you have with large datasets or high-volume database environments. Given that this role involves working with a massive number plate recognition database, demonstrating your ability to handle similar challenges will set you apart.

✨Tip Number 3

Prepare to discuss your collaborative experiences with development teams. This role requires close work with others to optimise SQL queries, so showcasing your teamwork skills and how you've successfully collaborated in the past will be beneficial.

✨Tip Number 4

Research the company’s commitment to flexible working and employee wellbeing. Being knowledgeable about their culture and values can help you align your answers during the interview, showing that you're a good fit for their team.

We think you need these skills to ace Lead SQL Developer

Strong SQL Proficiency
T-SQL Query Optimisation
SQL Server Performance Tuning
Database Design Best Practices
Complex Query Analysis
Index Management
Database Monitoring Tools Implementation
Capacity Planning and Resource Optimisation
Understanding of SQL Server Internals
Experience with Clustered SQL Setups
Knowledge of Locking and Concurrency
SQL Server Resource Governor Configuration
SQL Server Profiler and Extended Events Usage
Database Sharding Understanding
High Availability and Disaster Recovery Knowledge
Documentation Skills for Database Configurations

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your SQL development experience, particularly in performance tuning and troubleshooting. Use specific examples that demonstrate your skills with SQL Server and T-SQL.

Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the role and the unique capabilities of the NAS system. Mention how your background aligns with their needs, especially in database design and optimisation.

Showcase Relevant Skills: Clearly outline your proficiency in SQL Server performance tuning techniques and any relevant certifications. Highlight your understanding of database structures and best practices, as well as your experience with cloud-based solutions.

Prepare for Technical Questions: Anticipate technical questions related to SQL Server internals, query optimisation, and capacity planning. Be ready to discuss your previous experiences and how you approached complex database challenges.

How to prepare for a job interview at Leonardo

✨Showcase Your SQL Expertise

Be prepared to discuss your experience with SQL Server, particularly in performance tuning and query optimisation. Bring examples of complex queries you've worked on and how you improved their efficiency.

✨Understand the Role of NAS

Familiarise yourself with the unique capabilities of the NAS system and its importance in law enforcement. This will demonstrate your interest in the role and how your skills can contribute to its success.

✨Prepare for Technical Questions

Expect technical questions related to database design, indexing, and troubleshooting. Brush up on best practices and be ready to explain your thought process when solving database issues.

✨Emphasise Collaboration Skills

Highlight your ability to work closely with development teams and customers. Share examples of how you've collaborated in the past to optimise database schemas and improve application performance.

L
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>