Overview
In this role you will manage and optimise a secure SQL Server environment within a Defence context, ensuring availability, performance, security and reliable disaster recovery. You will work closely with infrastructure, application and security teams to maintain high-availability databases and automated operational processes. The role is hands-on, requiring expert SQL Server skills and scripting to support mission-critical systems. You will drive resilience and security through monitoring, automation and robust runbooks.
Responsibilities
- Provide day-to-day SQL Server DBA and operational support across production and non-production environments
- Perform database administration, configuration, maintenance and troubleshooting
- Manage backup and recovery, including backup strategies, restores and recovery testing
- Monitor and optimise SQL Server performance, identifying bottlenecks and implementing tuning improvements
- Support and maintain High Availability (HA) solutions and database resilience
- Contribute to Disaster Recovery (DR) planning, testing and implementation
- Implement and maintain database security controls, access management and security automation
- Develop and maintain monitoring, alerting and health-check processes
- Troubleshoot database incidents and provide technical resolution within agreed SLAs
- Develop and maintain T-SQL scripts for administration, automation, reporting and troubleshooting
- Use PowerShell to automate database administration and operational tasks
- Support patching, upgrades, configuration changes and database maintenance activities
- Produce and maintain technical documentation, procedures and operational runbooks
- Work closely with infrastructure, application and security teams to ensure reliable and secure database services
Key requirements
- Active UK DV Clearance - essential
- Strong commercial experience as a SQL Server DBA
- Extensive experience administering Microsoft SQL Server in enterprise environments
- Strong knowledge of backup and recovery strategies and processes
- Proven experience in SQL Server performance tuning and optimisation
- Experience with High Availability and Disaster Recovery technologies and methodologies
- Strong T-SQL development and scripting skills
- Good PowerShell scripting and automation experience
- Experience with database monitoring, alerting and troubleshooting
- Strong understanding of database security, permissions and access controls
- Experience providing operational/production support in a complex IT environment
- Ability to diagnose and resolve complex database incidents and performance issues
- SQL Server DBA in enterprise environments
- Backup and recovery strategies
- Performance tuning and optimisation
- High Availability and Disaster Recovery technologies
- T-SQL development and scripting
- PowerShell scripting and automation
SQL DBA - Security Cleared in Hampshire employer: CBSbutler
Join a dynamic and supportive team as a Senior Workday Consultant in either our Manchester or Inverness offices, where we prioritise employee growth and development. Our collaborative work culture fosters innovation and offers unique opportunities to engage with global enterprise clients on complex HR transformations. Enjoy a competitive benefits package and the chance to mentor junior consultants while working in a vibrant environment that values your expertise.
