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 unique crime-fighting capability.
- Company: Be part of Leonardo, a leader in technology supporting UK Policing with the largest number plate recognition database.
- Benefits: Enjoy flexible working hours, a generous pension scheme, and access to 4,000 online courses for free.
- Why this job: Make a real impact on public safety while developing your skills in a supportive and innovative environment.
- Qualifications: A degree in IT or related field, strong SQL skills, and experience with performance tuning are essential.
- Other info: This role requires security clearance; part-time options are available.
The predicted salary is between 43200 - 72000 £ per year.
We are looking to recruit a Principal SQL Developer to work on supporting 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, described as the largest Microsoft SQL Server instance in the UK. We seek a forward-thinking individual with strong SQL capabilities. In return, we offer our employees award-winning flexible working policies, benefits, and plans, recognized in 2023.
Responsibilities:
- Performance Tuning: Analyze and optimize SQL Server databases for performance 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 implement 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 requirements.
- Monitoring: Support the implementation of database monitoring tools to pre-emptively identify potential issues.
- Capacity Planning: Assist in capacity planning and resource optimization for SQL Server environments.
- Documentation: Create and maintain comprehensive documentation regarding database configuration, optimizations, and best practices.
Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Strong proficiency with SQL and variations among popular databases.
- In-depth knowledge of SQL Server performance tuning techniques.
- Proficiency in T-SQL, including writing and optimizing queries, index management.
- Ability to plan resource requirements from high-level specifications.
- Understanding of Database Engine Internals, including how queries are processed, data is stored, and indexes are utilized.
- Familiarity with clustered SQL setups and architectures for data replication.
- Knowledge of locking, concurrency, partitioning.
- Experience in configuring SQL Server Resource Governor.
- Experience using SQL Server Profiler and Extended Events.
- Understanding of database sharding, high availability, and disaster recovery.
- Proficient understanding of database structures, theories, and best practices.
- Certifications in SQL Server or related fields.
- Experience with cloud-based database solutions.
- Familiarity with other database technologies.
Security Clearance: This position requires security clearance.
Life at Leonardo: With a funded benefits package, commitment to learning and development, and flexible working hours, a career with Leonardo offers many opportunities.
- 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 per year.
- Flexible Working: Flexible hours with hybrid working options. Part-time opportunities available.
- Wellbeing: Employee Assistance Programme, mental health support, financial wellbeing support, and 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 options (£500 annual allowance).
- Training: Free 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 datasets or high-volume database environments. Given that this role involves working with the largest 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 collaboration, so sharing examples of how you've optimised SQL queries based on application requirements will be beneficial.
✨Tip Number 4
Since security clearance is required, be ready to talk about your understanding of data security and compliance. If you have previous experience in roles that required similar clearances, make sure to mention that as it will strengthen your application.
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 practices in database management, as these are key responsibilities for the Lead SQL Developer role.
Craft a Compelling Cover Letter: Write a cover letter that showcases your passion for database technology and your understanding of the unique capabilities of NAS. Mention specific experiences where you've optimised SQL queries or resolved performance issues.
Highlight Relevant Qualifications: Clearly list your qualifications, including your degree in Computer Science or related fields, certifications in SQL Server, and any experience with cloud-based database solutions. This will demonstrate your suitability for the role.
Showcase Collaboration Skills: Since collaboration is essential for this position, include examples of how you've worked with teams to optimise database schemas or improve application performance. This will show that you can effectively communicate and work with others.
How to prepare for a job interview at Leonardo
✨Showcase Your SQL Expertise
Make sure to highlight your strong SQL capabilities 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 of NAS
Familiarise yourself with the unique capabilities of the NAS system and its significance in UK policing. Being able to discuss how your skills can contribute to such a critical project will show your enthusiasm and commitment to the role.
✨Prepare for Technical Questions
Expect technical questions related to performance tuning, troubleshooting, and best practices in SQL Server. Brush up on your knowledge of T-SQL, indexing, and database design principles to confidently answer these queries.
✨Demonstrate Collaborative Skills
Since the role involves working closely with customers and development teams, be ready to share examples of how you've successfully collaborated in past projects. Highlight your communication skills and ability to work in a team environment.
