About this role
Salary: £50,000 - 60,000 per year
Requirements: Experience in high volume, real time transactional environments with high concurrency and uptime requirements (e.g. logistics, e-commerce, financial systems)Strong hands-on SQL Server DBA experience in a production environmentAdvanced SQL skills including DML (complex queries, stored procedures, CTEs, window functions) and DDL (schema design, indexing strategies, triggers)Deep understanding of query performance tuning, execution plans, and indexingKnowledge of locking, blocking, and deadlocksExperience with performance monitoring tools (Profiler, Extended Events, DMVs)Knowledge of SQL Server Agent and automationExperience with SSAS and SSRSStrong understanding of database security and access controlExperience managing backups, restores, and maintenance plansKnowledge of High Availability and Disaster Recovery solutions and business continuity planningFamiliarity with MySQL and cloud based managed database services (e.g. AWS RDS, Azure SQL)Exposure to data warehousing and ETL processes, including supporting reporting and analytics workloadsExperience supporting business intelligence (BI), reporting, and dashboarding solutions, including Microsoft Power BIExposure to modern analytics and AI assisted business intelligence capabilities within platforms such as Microsoft Power BI, Microsoft Copilot, or cloud AI/ML servicesExperience with monitoring tools Responsibilities: Write, optimise, and maintain SQL code to support business and operational systemsDevelop and enhance stored procedures, views, functions, and advanced query constructs (including CTEs and window functions)Design and maintain database schema using DDL, including tables, indexes, constraints, and triggersEnsure data integrity, consistency, and quality across all systemsSupport developers and analysts with efficient and scalable data access patternsMonitor and proactively improve database performance across live environmentsIdentify and resolve performance bottlenecks using execution plans, query analysis, and index/statistics optimisationManage and optimise transactions, locking, blocking, and deadlocksConduct real-time troubleshooting of performance issues impacting operationsUse tools such as SQL Profiler and Extended Events to diagnose performance issuesInvestigate and resolve production incidents and perform root cause analysisManage database security, including users, roles, and permissionsEnsure adherence to security best practices, data protection standards, and compliance requirementsSupport SQL Server BI capabilities, including SSAS (cube preparation) and SSRS (report development and maintenance)Create, manage, and monitor SQL Server Agent jobsAutomate routine database operations, including backups and maintenance tasksImplement and maintain database maintenance activities, including index and performance optimisationSupport capacity planning and scalability improvementsDesign, manage, and test backup, restore, and disaster recovery processesPerform database server administration, including installation, configuration, patching, upgrades, and storage management Technologies: AIAWSAzureBusiness IntelligenceCloudCopilotETLSupportMySQLNetworkPower BISQLSecuritySSAS More:
We are The APC, the UKs largest independent parcel delivery network, with more than 90 locations nationwide and millions of parcels delivered every month. Headquartered in Cannock, we operate in a fast paced, high-volume environment where reliability, clarity, and continuous improvement are essential. This is a hands-on Database Administrator role focused on day-to-day database operations, performance optimisation, and continuous improvement. The role is remote, with one day working from Cannock per month, and is based in hybrid remote in Cannock WS11 8AA. The advertised pay is up to £60,000 per year.
last updated 38 week of 2026