SQL Database Specialist

Associated British Ports

Hull and East Yorkshire

Hybrid

GBP 65,000 - 90,000

Full time

10 days ago

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

Pension
Private healthcare
Dental
Employee Assistance Program
26 days annual leave
Discounts

Job summary

Associated British Ports (ABP) is seeking an experienced SQL Administrator to design, implement, and optimise SQL Server environments supporting our marine platforms. You will ensure high availability, security, and performance while aligning with business needs.

The role offers hybrid working across major port locations with opportunities for training and professional development. You will work with cross-functional teams and Mainsaver CMMS systems, delivering reliable data infrastructure for

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.

Responsibilities

  • Operate and optimise production and non-production SQL Server database environments to agreed SLAs/SLIs.
  • Implement HA/DR using Always On, FCI, and database mirroring.
  • Define backup strategies, encryption, retention, and DR test procedures.

Skills

SQL Server administration
HA/DR
Mainsaver CMMS
T‑SQL / query optimization
Security & GDPR compliance
Stakeholder communication

Education

Bachelor’s degree in Computer Science or related

Tools

SSMS (SQL Server Management Studio)
Mainsaver CMMS
Azure Key Vault

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- https://www.talentxp.co.uk/track/e2e029cd

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: https://www.gov.uk/government/publications/united-kingdom-security-vetting-clearance-levels/national-security-vetting-clearance-levels

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 • Greater London

Hybrid
GBP 60,000 - 90,000
Private health insurance
Dental coverage
26 days annual leave
+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
Berthing and Landside Planner
Berthing and Landside Planner

ABP • Hull and East Yorkshire

On-site
GBP 32,000 - 45,000
Contributory pension from day one (8%+
Private healthcare
Employee Assistance Program
+2
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
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
Shift Technician
Shift Technician

Associated British Ports • Southampton

On-site
GBP 28,000 - 38,000
Pension from day one
Private healthcare
Employee Assistance Program
+1
Mechanical Asset Manager
Mechanical Asset Manager

ABP • Southampton

On-site
GBP 90,000 - 130,000
Pension scheme
Private healthcare
Training academy
Marketing and Sales Operations Manager
Marketing and Sales Operations Manager

Associated British Ports • Southampton

Hybrid
GBP 55,000 - 75,000
Hybrid working pattern
Port Operative T2
Port Operative T2

Associated British Ports • Hull and East Yorkshire

On-site
GBP 26,000 - 34,000
Contributory pension from day one
Private healthcare
Employee Assistance Program
+2