Senior SQL Platform Engineer: Automation & Resilience

Pacific Life

Greater London

On-site

GBP 90,000 - 130,000

Full time

11 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Private medical insurance
Life Insurance
Pension contributions
Gym membership subsidy
Cycle to Work

Job summary

Pacific Life Re is seeking a Senior SQL Database Engineer to own and mature the SQL capability across a global estate. The role focuses on SQL Server and PostgreSQL, driving standards, security, resilience and proactive operational maturity across multiple regions.

You will partner with infrastructure, actuarial, data and application teams to deliver secure, performant database solutions and a future operating model for database services.

Qualifications

  • 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.

Responsibilities

  • 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.

Skills

SQL Server
PostgreSQL
Performance tuning
Backup & recovery
Security
Automation
T-SQL
PowerShell
Migration experience
Incident management

Tools

Veeam
ServiceNow
CMDB tooling

Job description

Pacific Life Re is seeking a Senior SQL Database Engineer to own and mature the SQL capability across a global estate. The role focuses on SQL Server and PostgreSQL, driving standards, security, resilience and proactive operational maturity across multiple regions.

You will partner with infrastructure, actuarial, data and application teams to deliver secure, performant database solutions and a future operating model for database services.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
Senior SQL Platform Engineer

Pacific Life Re • Manor Park

On-site
GBP 90,000 - 130,000
Lead SQL Platform Engineer — SQL Server & PostgreSQL
Lead SQL Platform Engineer — SQL Server & PostgreSQL

Pacific Life Re • Manor Park

On-site
GBP 90,000 - 130,000
Senior Database Automation Engineer
Senior Database Automation Engineer

Pnc Bank • Birmingham

On-site
GBP 98,000 - 144,000
Senior Database Automation & Platform Engineer
Senior Database Automation & Platform Engineer

Pnc Bank • Birmingham

On-site
GBP 65,000 - 120,000
Health insurance
401(k) with match
Stock purchase plan
+1
Senior Database Engineer – Hybrid, Automation & Resilience
Senior Database Engineer – Hybrid, Automation & Resilience

SBS Skipton Building Society • Skipton

Hybrid
GBP 70,000 - 110,000
Annual discretionary bonus
Hybrid working
Private medical insurance
+3
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 Data Architect & High-Availability Leader
Senior SQL Data Architect & High-Availability Leader

Peninsula • Greater London

On-site
GBP 90,000 - 130,000
Senior Actuarial Systems Testing Lead
Senior Actuarial Systems Testing Lead

Pacific Life • Greater London

Hybrid
GBP 85,000 - 120,000
Comprehensive private insurance for员工及
Group Life Insurance coverage 9x basic
Subsidized gym membership
+2