Lead SQL Developer

Leonardo; Southampton; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading technology company is seeking a Principal SQL Developer to enhance a unique database capability for law enforcement. Responsible for performance tuning and database optimization, applicants should have strong SQL competencies and a Bachelor's degree. This is an opportunity to join a committed organization that values professional development and flexible working arrangements.

Benefits

Award-winning pension scheme

25 days holidays plus bank holidays

Flexible hours with hybrid options

Employee Assistance Programme

Discounted gym memberships

Access to private healthcare

Free access to over 4000 online courses via Coursera

Referral Incentive

Bonus Scheme

Qualifications

• In-depth knowledge of SQL Server performance tuning techniques.
• Experience with clustered SQL setups and data replication architectures.
• Certifications in SQL Server or related fields.

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

T-SQL

Performance Tuning

Database Design

Troubleshooting

Capacity Planning

Education

Bachelor’s degree in Computer Science

Job description

Social network you want to login/join with:

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 in what has been 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 a range of benefits, including awards for our flexible working policies in 2023.

Responsibilities include:

1. Performance Tuning: Analyse and optimise SQL Server databases for performance efficiency, including tuning complex queries, indexes, and server configurations.
2. Troubleshooting: Identify and resolve database performance issues, providing 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 customers and development teams to optimise SQL queries and database schemas based on application requirements.
5. Monitoring: Support the implementation of 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, optimisation, and best practices.

Minimum Qualifications:

• 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 and managing indexes.
• Understanding of SQL Server internal architecture, including query processing, data storage, and index utilisation.
• Experience with clustered SQL setups and data replication architectures.
• Knowledge of locking, concurrency, and 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.
• Certifications in SQL Server or related fields.
• 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

With a company-funded benefits package, a commitment to learning and development, and a flexible approach to working hours focused on employee and customer needs, a career with Leonardo offers numerous 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 upon request.
• Wellbeing: Employee Assistance Programme, mental health support, financial wellbeing support, and various network groups.
• Lifestyle: Discounted gym memberships, cycle-to-work schemes.
• Company-funded benefits: Access to private healthcare, dental schemes, Workplace ISA, Go Green Car Scheme, and technology and lifestyle options (£500 annual allowance).
• Training: Free access to over 4000 online courses via Coursera.
• Referral Incentive: Rewards for successful employee referrals.
• Bonus Scheme: Available for all employees at management level and below.