Location: Cannock, Staffordshire
Salary: £50,000 - £60,000
Summary:
Our client is seeking an experienced Senior Database Administrator (DBA) to support and optimise mission-critical SQL Server environments across a fast-paced, high-volume operational business. This hands-on role focuses on database performance, security, scalability, and continuous improvement, ensuring systems remain reliable and efficient in real-time transactional environments.
Key Responsibilities:
Write, optimise, and maintain SQL code supporting operational and business systems
Develop and enhance stored procedures, views, functions, CTEs, and window functions
Design and maintain database schemas, including tables, indexes, triggers, and constraints
Ensure data integrity, consistency, and quality across all database systems
Support developers and analysts with scalable and efficient data access solutions
Monitor, troubleshoot, and improve database performance across live environments
Analyse execution plans and optimise queries, indexing, and statistics
Resolve locking, blocking, and deadlock issues within transactional systems
Investigate and resolve production database incidents and conduct root cause analysis
Use tools such as SQL Profiler, Extended Events, and DMVs for diagnostics and monitoring
Manage database security, including permissions, users, and access controls
Support SQL Server BI tools including SSAS and SSRS
Create and maintain SQL Server Agent jobs and automate routine maintenance tasks
Implement backup, restore, disaster recovery, and maintenance strategies
Support database server administration including patching, upgrades, and configuration
Assist with capacity planning, scalability improvements, and business continuity initiatives
Key Skills/Experience:
Strong hands-on experience as a SQL Server DBA in production environments
Experience supporting high-volume, real-time transactional systems with high availability requirements
Advanced SQL expertise including DML, DDL, stored procedures, CTEs, window functions, indexing, and schema design
Strong understanding of query optimisation, execution plans, and database performance tuning
Experience troubleshooting locking, blocking, and deadlock issues
Knowledge of SQL Server monitoring and diagnostic tools including Profiler, Extended Events, and DMVs
Experience with SQL Server Agent automation and maintenance planning
Working knowledge of SSAS and SSRS
Strong understanding of database security, permissions, and access management
Experience managing backups, restores, and disaster recovery processes
Exposure to High Availability and Disaster Recovery (HADR) solutions
Familiarity with MySQL and cloud database platforms such as AWS RDS or Azure SQL
Experience supporting BI, reporting, and analytics solutions including Power BI
Exposure to data warehousing, ETL processes, and modern AI-assisted analytics tools
Excellent problem-solving skills with the ability to work in a fast-paced operational environmentProcessing Your Data
Bis Henderson Recruitment is a leading provider of recruitment, interim management and consultancy services to the supply chain and logistics industry. Should you respond to this advertisement we may store your CV and contact details and will process this data for recruitment purposes only. Should we process your data, then we will always tell you that we are doing so.
Please visit our website to read our Privacy Policy in full, in this Policy you will find information about our compliance with the UK General Data Protection Regulations.
All applicants must have an unrestricted right to work in the UK as our client will not support visa sponsorship for this role