Lead SQL Developer

Leonardo; Basildon; Hybrid; GBP 55,000 - 75,000; Full time

Job summary

Leonardo is seeking a Lead SQL Developer to enhance the performance of the world's largest number plate recognition database supporting UK law enforcement. The role involves performance tuning, troubleshooting, and collaborating with teams to optimize SQL queries, offering a competitive salary and extensive benefits.

Benefits

Pension scheme with up to 10% employer contribution

25 days holidays plus bank holidays

Flexible working options

Employee Assistance Programme

Discounted gym memberships

Private healthcare and dental schemes

Free access to online courses via Coursera

Referral incentives

Bonus scheme for employees

Qualifications

• Strong proficiency with SQL and variations among databases.
• In-depth knowledge of SQL Server performance tuning techniques.
• Experience using SQL Server Profiler and Extended Events.

Responsibilities

• Analyse and optimise SQL Server Databases for performance efficiency.
• Identify and resolve database performance issues.
• Develop and implement best practices for database design and maintenance.

Skills

SQL proficiency

Performance tuning

T-SQL

Database design

Education

Bachelor’s degree in Computer Science

Job description

Leonardo, Basildon, England, United Kingdom

Join or sign in to find your next job

Join to apply for the Lead SQL Developer role at Leonardo

Leonardo, Basildon, England, United Kingdom

1 day ago Be among the first 25 applicants

Join to apply for the Lead SQL Developer role at Leonardo

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 as the largest Microsoft SQL Server instance in the UK.

What You’ll Do As a Principal SQL Developer

1. Performance Tuning: Analyse and optimise SQL Server Databases for performance efficiency. This includes tuning complex queries, indexes, and server configurations.
2. Troubleshooting: Identify and resolve database performance issues. Provide solutions for query optimisation and server tuning.
3. Best Practice Implementation: Develop and implement best practices for database design, tuning, and maintenance.
4. Collaboration: Work closely with customer and development teams to optimise SQL queries and database schemas based on application requirements.
5. Monitoring: Support in implementing database monitoring tools to pre-emptively identify potential issues.
6. Capacity Planning: Assist in capacity planning and resource optimisation for SQL Server environments.
7. Documentation: Create and maintain comprehensive documentation regarding database configuration, optimisations, and best practices.

What We Need From You

You really must have:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Strong proficiency with SQL and its variations 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, including how queries are processed, data is stored, and indexes are utilised.
• Familiarity with clustered SQL setups and architectures for replicating data.
• Knowledge of Locking, Concurrency, Partitioning.
• Experience in configuring SQL Server Resource Governor.
• Experience using SQL Server Profiler and Extended Events.
• Understanding of Database Sharding.
• Understanding of high availability and disaster recovery.
• 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-based database solutions.
• Familiarity with other database technologies.

Security Clearance

You must be eligible for full security clearance. For more information and guidance, please visit: UK Security Vetting 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 offers many opportunities. Benefits include:

• 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: Hybrid options and flexible hours
• 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 options (£500 annual allowance)
• Training: Free access to over 4000 online courses via Coursera
• Referral Incentive: Rewards for successful referrals
• Bonus Scheme: Available for employees at management level and below

For the full list of benefits, please visit our website.

About Leonardo

Leonardo is a global high-tech company specializing in Aerospace, Defence, and Security, headquartered in Italy with over 45,000 employees worldwide, including 7,000 in the UK.

Our Commitment to Diversity and Inclusion

We believe a diverse and inclusive environment fosters innovation and creativity. We strive to create a welcoming, accessible, and inclusive workplace where everyone can thrive, feel safe, and belong.

Location and Contract Details

• Primary Location: GB - Bristol - Coldharbour Lane
• Additional Locations: GB - Basildon (Home Based), GB - Gloucester, GB - London, GB - Southampton
• Contract Type: Permanent
• Hybrid Working: Yes

Additional Information

• Seniority Level: Mid-Senior level
• Employment Type: Full-time
• Job Function: Information Technology
• Industry: Defense and Space Manufacturing

Referrals can increase your chances of interviewing at Leonardo by 2x.

Get notified about new SQL Developer jobs in Basildon, England, United Kingdom.