Leonardo, Southampton, England, United Kingdom
Join or sign in to find your next job
Join to apply for the Lead SQL Developer role at Leonardo
Leonardo, Southampton, England, United Kingdom
1 day ago Be among the first 25 applicants
Join to apply for the Lead SQL Developer role at Leonardo
Get AI-powered advice on this job and more exclusive features.
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.
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 closely with customer and development teams to optimise SQL queries and database schemas based on application requirements.
* Monitoring: Support in implementing database monitoring tools 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
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, such as how SQL Server queries are processed, data is stored, and indexes are utilised.
* 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.
* Knowledge 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, please visit: UK Security Vetting Levels
Life at Leonardo
We offer a funded benefits package, commitment to learning and development, and flexible working hours focused on employee and customer needs. A career with Leonardo offers many opportunities for growth and development.
* Pension: Up to 10% employer contribution.
* Holidays: 25 days plus bank holidays, with options to buy/sell leave and accrue up to 12 flexi days annually.
* Flexible Working: Hybrid options available.
* Wellbeing: Employee Assistance Programme, mental health support, financial wellbeing support, and employee networks.
* 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: 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 full details of our benefits, visit our website.
Leonardo is a global high-tech company in Aerospace, Defence, and Security, headquartered in Italy with over 45,000 employees worldwide, including 7,000 in the UK.
We value diversity and inclusion, fostering a welcoming and accessible environment for all employees.
This is an excellent opportunity to contribute your talents and grow with Leonardo. Join us to develop your skills and advance your career.
Location and Employment 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
Other Information
* Seniority Level: Mid-Senior level
* Employment Type: Full-time
* Job Function: Information Technology
* Industries: Defense and Space Manufacturing
#J-18808-Ljbffr