Lead SQL Developer

Leonardo; London; Hybrid; GBP 60,000 - 85,000; Full time

Job summary

A leading company in the technology sector is seeking a Principal SQL Developer to enhance the performance of the UK's largest SQL Server instance. This crucial role involves optimizing databases, troubleshooting performance issues, and implementing best practices. Candidates should possess a Bachelor's degree, strong SQL skills, and a commitment to excellence and continuous learning.

Benefits

Pension scheme with up to 10% employer contribution

25 days holiday plus bank holidays

Flexible working hours

Employee Assistance Programme for wellbeing

Discounted gym memberships

Company-funded benefits including healthcare

Free online courses access via Coursera

Referral incentives for successful hires

Bonus scheme available

Qualifications

• Experience in optimizing SQL Server databases and complex queries.
• Familiarity with clustered setups and database replication.
• Certifications in SQL Server or related fields.

Responsibilities

• Analyze and optimize SQL Server databases for performance efficiency.
• Identify and resolve database performance issues.
• Collaborate with teams to optimize SQL queries and schemas.

Skills

SQL

T-SQL

Performance tuning

Query optimization

Database design

Capacity planning

High availability

Education

Bachelor’s degree in Computer Science or Information Technology

Tools

SQL Server Profiler

SQL Server Resource Governor

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 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:

1. Performance Tuning: Analyze and optimize 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 optimization 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 optimize 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 optimization for SQL Server environments.
7. 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.