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

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.

This will be a 12 month fixed term contract.