> Markdown version of [/jobs/ext/4652807-sql-database-specialist](https://www.wearedevelopers.com/jobs/ext/4652807-sql-database-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# SQL Database Specialist

- **Company:** Abp
- **Location:** Cardiff, United Kingdom
- **Contract:** Permanent contract
- **Skills:** Computerized Maintenance Management Systems, Databases, Data Infrastructure, Database Design, Disaster Recovery, Failover, IBM Maximo, Key Management, Microsoft SQL Server, Performance Tuning, Runbook, SQL Stored Procedures, SQL Databases, Transact-SQL, Data Logging, System Availability, Database Optimization, Database Mirroring, Infor, Dynamic Data
- **Published:** November 10, 2026
- **Apply:** https://careers.abports.co.uk/talentcommunity/apply/1455640133/?locale=en_GB

## About the Role

Following a recent restructure we're looking to recruit an experienced SQL Administrator to join in a newly created role. You'll be responsible for the design, implementation, administration, and optimisation of ABP's Microsoft SQL Server databases & environments that support our marine platforms. You should have deep technical expertise in SQL Server technologies combined with business acumen to ensure data infrastructure is accessible, performant, reliable, and secure., Hands-on DBA experience with the capacity to take ownership of database management

 - Expertise in Microsoft SQL Server including Installation, configuration, backup/restore, HA/DR, performance tuning, security, replication.

 - Performance Engineering: Execution plan analysis, indexing strategies, statistics maintenance, wait events/DMVs (SQL Server)

 - Communication & Stakeholder Management: Ability to translate complex technical matters into business impact; clear documentation; calm incident leadership.

 - Mainsaver CMMS Experience: Demonstrable experience administering SQL Server databases that support Mainsaver CMMS or similar EAM/CMMS platforms (e.g., IBM Maximo, Infor EAM).

 - Relevant degree or equivalent professional experience.

 - Microsoft SQL Certification

## Description

Operate and continuously improve production and non-production Microsoft SQL Server database environments to agreed SLAs/SLIs (e.g., 99.9%+ availability).

 - Implement and maintain High Availability (HA) and Disaster Recovery (DR) solutions using SQL Server Always On Availability Groups, Failover Cluster Instances (FCI), and database mirroring.

 - Own incident response, root cause analysis, and problem management for SQL Server and Mainsaver CMMS database-related issues; maintain runbooks and on-call readiness.

Backup, Recovery & DR Readiness

 - Define and operate SQL Server backup strategies (full, differential, transaction log), implementing encryption, retention policies, and legal hold requirements.

 - Perform restore 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, and 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 & Compliance

 - Implement least-privilege access control, role-based security models, and SQL Server authentication/authorisation mechanisms.

 - Configure Transparent Data Encryption (TDE), Always Encrypted, TLS connections, and integrate with key management solutions (Azure Key Vault, on-premises HSM).

 - Configure SQL Server Audit and auditing policies; support GDPR and internal policy compliance including logging, retention, dynamic data masking, and row-level security.