Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a Lead SQL Developer, optimising databases and enhancing performance for a major crime prevention system.
- Company: Be part of Leonardo, a leader in technology supporting UK Policing with the largest SQL Server instance.
- Benefits: Enjoy flexible working hours, a competitive pension scheme, and access to 4,000 online courses.
- Why this job: Make a real impact on public safety while developing your skills in a supportive and innovative environment.
- Qualifications: Bachelor’s degree in IT or related field, strong SQL skills, and experience with SQL Server performance tuning.
- Other info: Part-time opportunities available; enjoy a range of corporate perks and wellbeing support.
The predicted salary is between 43200 - 72000 £ per year.
We are looking to recruit a Principal SQL Developer to work on supporting a unique capability, NAS. NAS is believed 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 daily and holds up to 60 billion records, in what is described as the largest Microsoft SQL Server instance in the UK. We seek a forward-thinking individual with strong SQL skills. In return, we offer a competitive package, including recognition for our flexible working policies, benefits, and plans in 2023.
Responsibilities include:
- Performance Tuning: Analyze and optimize SQL Server databases for efficiency, including tuning complex queries, indexes, and server configurations.
- Troubleshooting: Identify and resolve database performance issues, providing solutions for query optimization and server tuning.
- Best Practice Implementation: Develop and enforce best practices for database design, tuning, and maintenance.
- Collaboration: Work closely with customers and development teams to optimize SQL queries and database schemas based on application needs.
- Monitoring: Support the implementation of database monitoring tools to proactively identify potential issues.
- Capacity Planning: Assist in planning resource requirements and optimizing SQL Server environments.
- Documentation: Create and maintain comprehensive documentation on database configurations, optimizations, and best practices.
Minimum Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Strong proficiency with SQL and familiarity across popular database systems.
- In-depth knowledge of SQL Server performance tuning techniques.
- Proficiency in T-SQL, including writing and optimizing queries and managing indexes.
- Understanding of SQL Server internal architecture, including query processing, data storage, and index utilization.
- Experience with clustered SQL setups and data replication architectures.
- Knowledge of locking, concurrency, and partitioning.
- Experience configuring SQL Server Resource Governor.
- Experience using SQL Server Profiler and Extended Events.
- Understanding of database sharding, high availability, and disaster recovery.
- Certifications in SQL Server or related fields are desirable.
- Experience with cloud-based database solutions and familiarity with other database technologies.
Security Clearance: Details to be provided during the interview process.
Life at Leonardo: We offer a comprehensive benefits package, commitment to learning and development, and flexible working hours tailored to employee and customer needs. A career with Leonardo provides numerous opportunities and accessibility.
- Pension: Award-winning pension scheme (up to 10% employer contribution)
- Holidays: 25 days plus bank holidays, with options to buy/sell leave and accrue up to 12 additional flexi leave days annually.
- Flexible Working: Flexible hours and hybrid working options. Part-time opportunities available.
- Wellbeing: Employee Assistance Programme, mental health support, financial wellbeing support, and various network groups.
- Lifestyle: Discounted gym memberships, cycle-to-work scheme.
- Company-funded benefits: Private healthcare, dental schemes, Workplace ISA, Go Green Car Scheme, technology and lifestyle allowances (£500/year).
- Training: Access to over 4,000 online courses via Coursera.
- Referral Incentive: Rewards for successful referrals.
- Bonus Scheme: Available for all employees at management level and below.
Lead SQL Developer employer: Leonardo
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-scale databases or similar projects. Since this role involves working with a massive database, demonstrating your ability to handle complex data environments will set you apart.
✨Tip Number 3
Prepare to discuss your collaborative experiences with development teams. This role requires close collaboration, so sharing examples of how you've optimised SQL queries based on application needs will be beneficial.
✨Tip Number 4
Research the company’s commitment to flexible working and employee wellbeing. Being knowledgeable about their culture and benefits can help you align your answers with their values during the interview.
We think you need these skills to ace Lead SQL Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your SQL skills and relevant experience. Focus on performance tuning, troubleshooting, and best practice implementation, as these are key responsibilities for the Lead SQL Developer role.
Craft a Strong Cover Letter: Write a cover letter that showcases your passion for database management and your understanding of the unique capabilities of the NAS system. Mention specific experiences that demonstrate your proficiency in SQL Server and T-SQL.
Highlight Relevant Qualifications: Clearly list your qualifications, including your degree in Computer Science or related fields, any certifications in SQL Server, and your experience with cloud-based database solutions. This will help you stand out to the hiring team.
Showcase Problem-Solving Skills: In your application, provide examples of how you've identified and resolved database performance issues in the past. This will demonstrate your ability to troubleshoot effectively, which is crucial for this position.
How to prepare for a job interview at Leonardo
✨Showcase Your SQL Expertise
Make sure to highlight your strong SQL skills during the interview. Be prepared to discuss specific projects where you've optimised queries or improved database performance, as this will demonstrate your hands-on experience and understanding of SQL Server.
✨Understand the Role's Responsibilities
Familiarise yourself with the key responsibilities outlined in the job description, such as performance tuning and troubleshooting. Prepare examples from your past work that align with these tasks to show how you can contribute effectively to the team.
✨Discuss Best Practices
Be ready to talk about best practices for database design and maintenance. This could include your approach to documentation, capacity planning, and implementing monitoring tools. Showing that you prioritise best practices will reflect your commitment to quality work.
✨Prepare for Technical Questions
Expect technical questions related to SQL Server performance tuning techniques and internal architecture. Brush up on topics like locking, concurrency, and data replication architectures, as well as any relevant certifications you may have, to demonstrate your depth of knowledge.
