Your Responsibilities

Responsible for managing and maintaining Lockton’s database SQL estate, ensuring data integrity, security, and availability, while optimising performance and troubleshooting any issues that arise.

• Install, configure, and maintain SQL Server databases.
• Monitor system health and performance to ensure high levels of performance, availability, and security.
• Perform database tuning and optimisation.
• Manage database backup and recovery processes.
• Experience of upgrading SQL versions
• Implement and maintain database security (user roles, permissions, etc.).
• Troubleshoot and resolve database issues.
• Develop and maintain shell scripts for database management.
• Assist with database design and development.
• Provide support for database-related technical issues.
• Collaborate with development teams to ensure database changes align with best practices.
• Capacity Management
• Review, amend, and keep updated all processes and procedures
• Implement recommended changes for all recommendations and security patches in accordance with CAB
• Actively participate in the problem management process, assisting in the identification and resolution of problems before they occur.
• Identify any process improvements and create a Continual Service Improvement (CSI) initiative.
• Incident Management Process, manage the Lockton SQL Incident Queue for incoming Incidents
• Notify Technology Leadership Team / CAB of scheduled and unscheduled downtime for maintenance that may impact them operationally.
• Operational change management
  
  

Qualifications

Requirements:

• Proven experience as a SQL Database Administrator.
• Strong knowledge of SQL Server (2014, 2016, 2017 and later versions).
• Experience with database performance tuning and optimisation.
• Familiarity with backup and recovery processes.
• Understanding of database security best practices.
• Experience with high-availability and disaster recovery options for SQL Server.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork abilities.
• Knowledge of ITIL and industry best practices is a plus.
• Experience with cloud platforms (Azure, AWS) is desirable.
  
  

Preferred Qualifications:

• SQL Server certification (e.g., MCSA, MCSE).
• Experience with other database platforms (e.g., MySQL, Oracle) is a plus.