Job Description
Location: Cannock, StaffordshireSalary: £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 environment
Processing 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.