Lead SQL Developer

Leonardo

West of England

Hybrid

GBP 75,000 - 110,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Pension: Award winning pension scheme
Hybrid working options
Private healthcare

Job summary

Leonardo UK is seeking a Principal SQL Developer to join its NAS data platform. The role focuses on optimizing SQL Server performance for a massive database used by UK policing and law enforcement.

You will implement best practices, write efficient T-SQL, tune queries and indexes, and collaborate with customers and development teams to scale the system while ensuring reliability and security. Hybrid working options are available.

Qualifications

  • Bachelor's degree in Computer Science or related field.
  • Strong proficiency with SQL and various databases.
  • In-depth knowledge of SQL Server performance tuning techniques.
  • Proficiency in T-SQL, including writing and optimising queries, Index Management.
  • Understanding of SQL Server internals and how queries are processed.
  • Familiar with clustered SQL setups and data replication.
  • Knowledge of locking and concurrency concepts.
  • Experience configuring Resource Governor and using profiling tools.
  • Experience with Profiler and Extended Events.
  • Understanding of database sharding and high availability.

Responsibilities

  • Performance Tuning: Analyse and optimise SQL Server Databases for performance efficiency.
  • Troubleshooting: Identify and resolve database performance issues and optimise queries.
  • Best Practice Implementation: Develop and implement database design and maintenance practices.
  • Collaboration: Work with customers and development teams to optimise queries and schemas.
  • Monitoring: Implement database monitoring to pre-empt issues.
  • Capacity Planning: Assist in resource planning for SQL Server environments.
  • Documentation: Create comprehensive docs on configuration and best practices.

Skills

SQL performance tuning
T-SQL queries
Index management
Database internals
Replication concepts

Education

Bachelor's degree in CS/IT

Tools

SQL Server Profiler
Extended Events
Resource Governor
Database Sharding

Job description

Job Description

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 award-winning flexible benefits plan , having won the Best Flexible Working Policy Award, Best Flexible Benefits Strategy and Best Flexible Benefits Plan in 2023.


What you’ll do as a Principal SQL Developer


  • 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.


What we need from you


  • 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.


It would be nice if you had :


  • Certifications in SQL Server or related fields.

  • Experience with cloud-base database solutions.

  • Familiarity with other database technologies.


Security Clearance

You must be eligible for full security clearance. For more information and guidance please visit : https://www.gov.uk/government/publications/united-kingdom-security-vetting-clearance-levels


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


For a full list of our Company benefits please visit our website.


Leonardo is a global high-tech company and one of the key players in Aerospace, Defence and Security

Headquartered in Italy, Leonardo has over 45,000 employees, of which 7,000 are based in the UK.


At Leonardo UK, we believe that a diverse and inclusive work environment unlocks our people's full potential and drives innovation and creativity

We work hard to offer a welcoming, accessible and inclusive place to work for all of our people, creating a culture where everyone can thrive, feel safe and have a sense of belonging and connection.


This is a great opportunity to bring your talents and f

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

Leonardo S.p.A. • West of England

Hybrid
GBP 70,000 - 110,000
Flexible hours
Hybrid working options
Pension scheme
Senior Data Engineer
Senior Data Engineer

Leonardo • Bristol

Hybrid
GBP 70,000 - 110,000
Hybrid working
Bonus scheme
Pension contribution up to 15%
+2
Head of Engineering Projects
Head of Engineering Projects

Leonardo UK Ltd • Luton

Hybrid
GBP 90,000 - 130,000
Pension up to 15% employer contrib.
Hybrid working pattern
Free Coursera/LinkedIn Learning access
+1
Foward Deployed Engineer - All Levels
Foward Deployed Engineer - All Levels

Leonardo • Bristol

Hybrid
GBP 60,000 - 90,000
Time to Recharge: 12 flexi-days/year
Pension scheme up to 15% employer
Mental health support
+2
Foward Deployed Engineer - All Levels
Foward Deployed Engineer - All Levels

Leonardo • City of Edinburgh

Hybrid
GBP 65,000 - 95,000
Time to Recharge: up to 12 flexi-days
Pension scheme with up to 15% employer
Mental health support and networks
+3
Senior Software Engineer
Senior Software Engineer

Leonardo UK Ltd • West of England

Hybrid
GBP 70,000 - 95,000
Flexi-time leave
Pension contribution
Mental health support
+5
Chief Engineer
Chief Engineer

Leonardo S.p.A. • Basildon

Hybrid
GBP 90,000 - 120,000
Time to Recharge
Pension scheme
Mental health support
+3
Senior Software Engineer (C# .NET)
Senior Software Engineer (C# .NET)

Leonardo S.p.A. • Luton

Hybrid
GBP 55,000 - 75,000
Pension scheme
Private healthcare
Flexible working hours
Senior Devops Engineer
Senior Devops Engineer

Leonardo • Bristol

Hybrid
GBP 70,000 - 100,000
Time to Recharge
Pension scheme with employer contrib.
Wellbeing support and networks
+3
Senior Software Engineer (Real Time Embedded)
Senior Software Engineer (Real Time Embedded)

Leonardo • Luton

Hybrid
GBP 65,000 - 90,000
Time to Recharge
Pension scheme
Mental health support
+5