Lead SQL Developer

Leonardo; Bristol; On-site; GBP 50,000 - 75,000; Full time

Job summary

Leonardo is seeking a Principal SQL Developer to support a massive number plate recognition database, crucial for UK policing. This role involves optimizing SQL databases, troubleshooting performance issues, and collaborating with teams to enhance database functionalities. A competitive benefits package and flexible working environment are offered.

Benefits

Pension scheme with up to 10% employer contribution

25 days holiday plus bank holidays

Flexible working hours and hybrid options

Employee Assistance Programme

Discounted gym memberships

Private healthcare and dental schemes

Access to over 4,000 online courses via Coursera

Bonus scheme available for all employees

Qualifications

• Strong proficiency with SQL and database systems is essential.
• Experience with cloud-based database solutions is an advantage.
• Certifications in SQL Server or related fields are desirable.

Responsibilities

• Analyze and optimize SQL Server databases for efficiency.
• Identify and resolve database performance issues.
• Develop and enforce best practices for database design.

Skills

SQL

Performance Tuning

T-SQL

Database Monitoring

Troubleshooting

Education

Bachelor’s degree in Computer Science

Tools

SQL Server

SQL Server Profiler

Extended Events

Job description

Social network you want to login/join with:

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:

1. Performance Tuning: Analyze and optimize SQL Server databases for efficiency, including tuning complex queries, indexes, and server configurations.
2. Troubleshooting: Identify and resolve database performance issues, providing solutions for query optimization and server tuning.
3. Best Practice Implementation: Develop and enforce best practices for database design, tuning, and maintenance.
4. Collaboration: Work closely with customers and development teams to optimize SQL queries and database schemas based on application needs.
5. Monitoring: Support the implementation of database monitoring tools to proactively identify potential issues.
6. Capacity Planning: Assist in planning resource requirements and optimizing SQL Server environments.
7. 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.