SQL Database Specialist

ABP

Immingham

Hybrid

GBP 60,000 - 90,000

Full time

42 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Contributory pension
Private healthcare
26 days leave
Training academy
Discounts
Employee assistance program

Job summary

ABP is seeking an experienced SQL Administrator to design, implement, and optimise Microsoft SQL Server environments supporting our marine platforms. You will manage HA/DR, backups, performance tuning, and security to ensure availability and compliance.

The role requires collaboration with developers and CMMS admins, experience with Mainsaver CMMS or comparable systems, and a commitment to safe, reliable data infrastructure across UK ports. A hybrid working pattern is available.

Qualifications

  • Hands-on DBA experience with ownership of database management.
  • Expertise in Microsoft SQL Server: installation, configuration, backup/restore, HA/DR, performance tuning, security, replication.
  • Experience with Mainsaver CMMS or similar EAM/CMMS platforms.
  • Ability to translate complex technical matters into business impact and to lead incident response.
  • Relevant degree or equivalent professional experience and Microsoft SQL Certification.

Responsibilities

  • Operate and improve production and non-production SQL Server environments to 99.9%+ availability.
  • Define and maintain HA/DR strategies (Always On, FCI, mirroring).
  • Lead incident response, root-cause analysis and runbook maintenance.
  • Perform backups, encryption, retention and DR tests; document recovery procedures.

Skills

MS SQL Server
HA/DR
Backup/Restore
Performance tuning
Security & Compliance
Mainsaver CMMS
Communication

Education

Relevant degree or equivalent

Tools

Perf Monitor
DMVs
Extended Events
Query Store

Job description

We’re the UK's largest ports operator with a network of 19 ports around Britain. We handle around one quarter of the UK's seaborne trade and contribute £7.5 billion to our economy every year.

It’s a story we’re proud of but it doesn’t end there. We’re transforming our business and embracing the future.

We offer a vast range of roles spanning the UK, all rooted in a culture that welcomes diversity, fosters talent, encourages internal movement and progression, and places safety as our number one priority.

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.

Why should you work for ABP?
  • Have the chance to make a difference in a business critical to UK trade.
  • Work within an exciting, driven, growing business.
  • You can thrive in an inclusive environment where every individual can be themselves and feel respected
  • Receive competitive salary and benefits package
  • Get support for training, personal development and further education
  • Benefit from support and engagement through dedicated management and leadership
Accountabilities
Availability & Reliability
  • 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.
Skills & Experience
  • 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

We offer a competitive salary, contributory pension from day one (Starting at 3% employee contribution with 5% company match), private healthcare and dental, access to our Employee Assistance Program, 26 days annual leave (plus bank holidays – plus the option to purchase additional days), wide range of discounts and cash back with high street and online retailers. We offer an inclusive work environment with an in-house training academy which offers ongoing opportunities to develop your skills.

The role can be based from any of our major port locations with Cardiff, London or Southampton as ideal locations as the preferred location, but we will consider others based on experience. We offer hybrid working arrangements with a 3 day in the office, 2 from home expectation as standard.

Want to see what it’s like to work for the UK’s largest port operator? Our virtual work experience programme gives you an inside look at trade, sustainability, safety, and careers in one of the UK’s most vital indutries-

Additional Information:

When joining ABP you will find an environment that is both welcoming and challenging. We reward our employees well and offer a generous remuneration package, employer pension, private health insurance and a range of other benefits.

Please note that ABP undertake random screening for substance abuse and operate a zero‑tolerance policy. A medical will be required before starting this position also.

We are an equal opportunities employer and we welcome applications from all suitably qualified persons regardless of their background, which helps us to provide a diverse and inclusive working environment.

As part of our recruitment process, all successful candidates will be subject to pre‑employment screening to Baseline Personnel Security Standard (BPSS). Please note your consent will be required and further information on this check can be found using the following link:

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SQL Database Specialist
SQL Database Specialist

Associated British Ports • Hull and East Yorkshire

Hybrid
GBP 65,000 - 90,000
Pension
Private healthcare
Dental
+3
SQL Database Administrator
SQL Database Administrator

Associated British Ports • Hull and East Yorkshire

Hybrid
GBP 45,000 - 65,000
Competitive salary
Pension from day one
Private healthcare
+3
SQL Database Specialist
SQL Database Specialist

Associated British Ports • Greater London

Hybrid
GBP 60,000 - 90,000
Private health insurance
Dental coverage
26 days annual leave
+2
Port Operative
Port Operative

Associated British Ports • Cardiff

On-site
GBP 26,000 - 36,000
Pension from day one
Private healthcare
Employee Assistance Program
+2
Berthing and Landside Planner
Berthing and Landside Planner

Associated British Ports • Hull and East Yorkshire

On-site
GBP 32,000 - 45,000
Contributory pension from day one (8%+
Private healthcare
Employee Assistance Program
+2
Project Engineering Manager
Project Engineering Manager

Associated British Ports • Newport

On-site
GBP 65,000 - 90,000
Private healthcare
Contributory pension
Training academy
+1
Port Operative T2
Port Operative T2

Associated British Ports • Greater Lincolnshire

Remote
GBP 24,000 - 32,000
Contributory pension
Private health insurance
Employee Assistance Programme
+1
Port Operative T2
Port Operative T2

Associated British Ports • Immingham

On-site
GBP 22,000 - 26,000
Competitive salary
Pension from day one
Private healthcare
+2
Mechanical Asset Manager
Mechanical Asset Manager

ABP • Southampton

On-site
GBP 90,000 - 130,000
Pension scheme
Private healthcare
Training academy
Bagging Operator
Bagging Operator

Associated British Ports • Ipswich

On-site
GBP 17,000 - 22,000
Pension (contributory from day one)
Private healthcare
26 days annual leave + holidays
+2