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 environment
All applicants must have an unrestricted right to work in the UK as our client will not support visa sponsorship for this role.
