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.
We are looking for a forward thinking individual with strong SQL capabilities. In return, we offer our, having wonthe Best Flexible Working Policy Award, Best Flexible Benefits Strategy and Best Flexible Benefits Plan in 2023.
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 closes with customer and development teams to optimise SQL queries and database schemas based on application requirements.
5. Monitoring : Support in implementing database monitoring tool 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.
8. Bachelor’s degree in Computer Science, Information Technology or a related field.
9. Strong proficiency with SQL and its variation among popular databases
10. In-depth knowledge of SQL Server performance tuning techniques
11. Proficiency in T-SQL, including writing and optimising queries, Index Management
12. Ability to plan resource requirements from high level specifications
13. Understanding of Database Engine Internals, i.e. Understanding of SQL Servers internal architecture, including how queries are processed, how data is stored and how indexes are utilised
14. Familiar with clustered SQL setups and architectures for replicating data
15. Knowledge of Locking, Concurrency Partitioning
16. Experience in configuring SQL Server Resource Governor
17. Experience in using SQL Server Profiler and Extended Events
18. Understanding of Database Sharding
19. Understanding of high availability and disaster recover
20. Proficient understanding of database structures, theories and best practices.
21. Certifications in SQL Server or related fields
22. Experience with cloud-base database solutions
23. Familiarity with other database technologies
Security Clearance
:
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 has never offered as many opportunities or been more accessible to as many people.
24. Pension: Award winning pension scheme (up to 10% employer contribution)
25. Holidays: 25 days plus bank holidays, option to buy/sell leave and to accrue up to 12 additional flexi leave days per year
26. Flexible Working: Flexible hours with hybrid working options. For part time opportunities, please talk to us
27. Wellbeing: Employee Assistance Programme, access to Mental Health support, Financial wellbeing support, network groups (Enable, Pride, Equalise, Reservists, Carers)
28. Lifestyle: Discounted Gym membership, Cycle to work scheme
29. Company funded flexible benefits: Access to private healthcare, dental schemes, Workplace ISA, Go Green Car Scheme, technology and lifestyle options (£500 annual allowance)
30. Training: Free access to more than 4000 online courses via Coursera
31. Referral Incentive: You can earn a reward for successfully referring a friend or family member
32. Bonus: Scheme in place for all employees at management level and below