Senior Database Administrator

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 systemsDevelop and enhance stored procedures, views, functions, CTEs, and window functionsDesign and maintain database schemas, including tables, indexes, triggers, and constraintsEnsure data integrity, consistency, and quality across all database systemsSupport developers and analysts with scalable and efficient data access solutionsMonitor, troubleshoot, and improve database performance across live environmentsAnalyse execution plans and optimise queries, indexing, and statisticsResolve locking, blocking, and deadlock issues within transactional systemsInvestigate and resolve production database incidents and conduct root cause analysisUse tools such as SQL Profiler, Extended Events, and DMVs for diagnostics and monitoringManage database security, including permissions, users, and access controlsSupport SQL Server BI tools including SSAS and SSRSCreate and maintain SQL Server Agent jobs and automate routine maintenance tasksImplement ..... full job details .....