SQL Database Specialist
- Location
- Hull and East Yorkshire, England, United Kingdom
tests and DR failover drills to evidence compliance with RTO/RPO targets; document recovery procedures specific to mission-critical systems including Mainsaver CMMS. Performance Engineering Proactively monitor and tune SQL Server databases: indexing strategies, statistics maintenance, query plan analysis, I/O optimisation, memory configuration, tempdb configuration … connection pooling. Utilise SQL Server Performance Monitor, Dynamic Management Views (DMVs), Extended Events, and Query Store to diagnose and resolve performance bottlenecks. Partner with developers and Mainsaver CMMS administrators to review T-SQL queries, stored procedures, and application integration patterns; promote performance-safe database design. Security, Privacy ...