Senior SQL Database Engineer

Pacific Life Re

Manor Park

On-site

GBP 90,000 - 135,000

Full time

3 days 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

Job summary

Pacific Life Re is seeking an experienced Senior SQL Database Engineer to take technical ownership of the Microsoft SQL Server estate supporting its global business. The role spans engineering standards, resilience, security and ongoing maturity of the SQL capability across regions and teams.

You will work with Infrastructure, Application, Actuarial, Data, Security and Architecture teams to define and implement a standard operating model, automate routine tasks and drive modernisation through

Qualifications

  • Extensive experience with Microsoft SQL Server in large enterprise environments.
  • Practical knowledge of PostgreSQL environments alongside SQL Server as primary expertise.
  • Strong SQL performance tuning: indexing, queries, memory, CPU, I/O.
  • Scripting and automation, ideally PowerShell and T-SQL.

Responsibilities

  • Own the SQL estate health, stability, performance, resilience and lifecycle.
  • Define and govern SQL engineering standards and deployment patterns.
  • Develop the technical roadmap for the SQL estate and modernisation.
  • Proactively monitor, optimise and capacity-plan SQL Server environments.
  • Lead incident analysis and remediation for SQL incidents and problems.

Skills

Microsoft SQL Server
PostgreSQL
SQL performance tuning
PowerShell
T-SQL
Disaster recovery

Tools

Veeam
ServiceNow
CMDB
Monitoring platforms

Job description

We are seeking an experienced Senior SQL Database Engineer to take technical ownership of the Microsoft SQL Server estate supporting Pacific Life Re's global business.

SQL is an important component of PL Re's technology landscape, supporting actuarial, pricing, research and operational workloads alongside business‑critical applications and services across our international locations. The environment spans multiple regions and integrates with a wider infrastructure ecosystem covering compute, storage, backup, monitoring, security and disaster recovery.

This role is broader than traditional database administration. The successful candidate will own, engineer and mature the SQL capability, establishing consistent engineering standards, improving resilience and operational maturity, reducing technical debt and ensuring the estate remains secure, performant, recoverable and supportable.

The role will provide deep technical expertise across Microsoft SQL Server while working closely with Infrastructure, Application, Actuarial, Data, Security, Architecture, Service Management and enterprise Pacific Life teams. The successful candidate will also define and develop the future operating model for database services across PL Re, building on the foundations established through the SQL Target Operating Model and moving the capability towards a more standardised, automated and proactive engineering service.

Key Duties
  • Act as the primary technical owner and subject matter expert for the PL Re database estate, with particular responsibility for Microsoft SQL Server and supporting PostgreSQL environments taking accountable for its health, stability, performance, resilience, security and lifecycle, while continuing to mature the SQL service and Target Operating Model.
  • Define, maintain and govern SQL engineering standards covering builds, configuration, database design, storage, security, resilience, backup, monitoring and support, establishing standard build patterns and reusable engineering practices.
  • Develop and maintain the technical roadmap for the SQL estate, proactively addressing lifecycle risk, technical debt, end‑of‑life technology and opportunities to simplify, consolidate and modernise.
  • Proactively monitor and optimise SQL Server performance across databases, queries, indexing, memory, CPU, storage and I/O, while managing capacity, growth trends and future requirements.
  • Own SQL backup, restore and recovery requirements, including retention, recoverability and routine validation, and define and test recovery procedures aligned with application recovery objectives and business continuity requirements, including disaster recovery exercises.
  • Ensure SQL services are secure and compliant with PL Re and Pacific Life Technology Risk requirements, including patching, vulnerability remediation, hardening, role‑based access, least privilege, service accounts, privileged access and appropriate audit evidence.
  • Develop proactive monitoring, alerting and service‑health measures covering availability, performance, capacity, backups and other critical database indicators.
  • Provide advanced technical support for complex SQL incidents and problems, leading root‑cause analysis and driving permanent remediation for significant or recurring issues.
  • Provide SQL engineering expertise to infrastructure and application initiatives from initial design through implementation and transition to BAU, including migrations, upgrades, platform refreshes and major releases.
  • Work closely with Infrastructure Engineering on compute, storage, networking, backup, monitoring and other platform dependencies, including technical validation before and after significant changes.
  • Partner with actuarial, pricing, research, operational, application and data teams to translate database requirements into secure, resilient, performant and supportable solutions, advising on database design, performance, security, migrations and other specialist database activities.
  • Maintain an accurate inventory of SQL servers, instances and databases, including ownership, lifecycle and relationships to applications and services, with appropriate representation within configuration and asset‑management processes.
  • Develop automation for routine DBA activities including provisioning, configuration, maintenance, health checks and reporting, while maintaining clear technical standards, documentation and operational runbooks to reduce manual intervention and dependency on individuals.
  • Build effective relationships with Pacific Life enterprise teams, third‑party partners and PL Re stakeholders to align standards, share good practice and establish a sustainable global support model, driving continual improvement through automation, observability and proactive management of risk, performance and resilience.
  • Strong commercial experience administering and engineering Microsoft SQL Server in complex enterprise environments.
  • Practical experience administering and supporting PostgreSQL environments, with Microsoft SQL Server remaining the primary area of technical expertise.
  • Deep knowledge of SQL Server installation, configuration, upgrades, patching and lifecycle management.
  • Strong SQL performance tuning and troubleshooting capability, including indexing, execution plans, locking and blocking, memory, CPU, disk I/O and query optimisation.
  • Strong understanding of SQL Server backup, restore and recovery technologies and practices.
  • Experience designing and supporting highly available and resilient SQL environments.
  • Strong knowledge of SQL Server security, authentication, permissions, service accounts and privileged access.
  • Strong experience of database migrations and platform or infrastructure change.
  • Experience managing database capacity, storage and performance.
  • Strong scripting and automation capability, ideally using PowerShell and T‑SQL.
  • Experience operating database environments under formal Incident, Problem and Change Management processes.
  • Experience supporting critical production systems and participating in major incident and root‑cause analysis.
  • Strong technical documentation skills and experience developing operational procedures and runbooks.
  • Ability to work effectively across infrastructure, application, architecture, security and service‑management disciplines.
  • Strong communication skills with the ability to translate detailed technical issues into clear risks, options and recommendations.
  • Demonstrable ability to take ownership of a technical service and improve its maturity, rather than simply administer an existing environment.
  • Experience with SQL Server running on virtualised or private‑cloud infrastructure.
  • Experience supporting SQL workloads through infrastructure migrations or hypervisor and platform transformation.
Desirable
  • Experience designing, implementing, troubleshooting and supporting highly available database platforms.
  • Capable of troubleshooting issues that cross database, application, operating system, storage, network and clustering
  • Experience with enterprise backup and recovery platforms such as Veeam.
  • Experience with enterprise monitoring and observability platforms.
  • Experience with ServiceNow and mature IT Service Management environments.
  • Experience of database discovery, configuration management and CMDB integration.
  • Experience supporting actuarial, financial‑services or other highly data‑intensive workloads.
  • Familiarity with public‑cloud database services and hybrid database architectures.
  • Awareness of other database technologies such as Oracle would be beneficial.
Working For Pacific Life Re

Every person in our global team is valued for the unique qualities they bring to our business and we seek to build their expertise and support their individual ambitions at every step. Of course, we take our work seriously and we know our team can operate under great pressure. We work hard and thrive on achievement, but we also know how to have fun and relax too. We regularly host a range of team building days to strengthen our team's connection with each other and reflect on their successes.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior SQL Database Engineer
Senior SQL Database Engineer

Pacific Life • Greater London

On-site
GBP 90,000 - 130,000
Private medical insurance
Life Insurance
Pension contributions
+2
Senior SQL Database Engineer
Senior SQL Database Engineer

Pacific Life Re • Greater London

On-site
GBP 70,000 - 110,000
25 days annual leave
Private medical insurance
Group life insurance
+3
Senior SQL Platform Engineer - Global, Automated
Senior SQL Platform Engineer - Global, Automated

Pacific Life Re • Manor Park

On-site
GBP 90,000 - 135,000
Senior SQL Platform Engineer
Senior SQL Platform Engineer

Pacific Life Re • Greater London

On-site
GBP 70,000 - 110,000
25 days annual leave
Private medical insurance
Group life insurance
+3
Senior SQL Platform Engineer: Automation & Resilience
Senior SQL Platform Engineer: Automation & Resilience

Pacific Life • Greater London

On-site
GBP 90,000 - 130,000
Private medical insurance
Life Insurance
Pension contributions
+2
Senior SQL Platform Engineer
Senior SQL Platform Engineer

Pacific Life Re • Manor Park

On-site
GBP 90,000 - 130,000
Senior Business Analyst
Senior Business Analyst

Pacific Life Re • Greater London

On-site
GBP 65,000 - 90,000
25 days annual leave
Private healthcare
Pension contributions
+2
Senior Service Design & Transition Analyst
Senior Service Design & Transition Analyst

Pacific Life Re • Greater London

Hybrid
GBP 70,000 - 100,000
25 days annual leave
Adoption leave
Fertility leave
+11
Senior Technical Business Analyst – Data
Senior Technical Business Analyst – Data

Pacific Life Re • Greater London

On-site
GBP 70,000 - 95,000
Private healthcare
Group Life Insurance
25 days annual leave
Manager, Corporate Actuarial, Actuarial Analytics & Insights (S&R)
Manager, Corporate Actuarial, Actuarial Analytics & Insights (S&R)

Pacific Life Re • Greater London

Hybrid
GBP 90,000 - 125,000
25 days annual leave
Private health insurance
Group life insurance
+2