Job overview

Reporting to the Head of Business Intelligence the Technical Database Administrator (DBA) will act as a senior technical specialist, leading on the design, implementation, and optimisation of the Trust’s on-premise SQL Server Business Intelligence Data Warehouse. The postholder will work closely with the Business Intelligence and Cancer Services teams to support data migration, ingestion, and implementation of SQL queries required for accurate and timely reporting.

You will play a key role in integrating data from multiple clinical and corporate systems, including Oracle Cerner Millennium and the Cancer Management System (CMS), ensuring that all data pipelines are robust, secure, and aligned with NHS standards and governance requirements.

The role is technically hands-on, involving the deployments, configuration, and maintenance of SQL Server databases, storage systems, and related infrastructure. The postholder will apply advanced knowledge of Extract, Transform, Load (ETL) processes, data modelling, performance tuning, and scripting to optimise data workflows and enable high quality analytics, whilst ensuring full compliance with NHS Digital, Information Governance, and industry best practice standards.

Main duties of the job

• The postholder will provide technical leadership across the BI and system 
managers, troubleshooting complex database issues, managing incident 
resolution, and leading root cause analysis to reduce downtime and maintain 
system resilience.

• As a key contributor to the Trust’s ongoing digital transformation, you will play 
a pivotal role in designing and implementing the data architecture and migration 
that underpin analytics and reporting capabilities.

• Design and implement a data management and ingestion framework to support 
operational and analytical reporting requirements.

• Develop, maintain, and optimise logical and physical data models for the BI 
Data Warehouse, ensuring scalability and alignment with NHS data standards.

• Configure, automate, and document SQL server maintenance plans, jobs, and 
ETL processes for seamless data integration across multiple clinical systems 
(e.g. Oracle Cerner Millennium and Cancer Management System).

• Develop automation scripts and tools using PowerShell, Python, or similar 
programming languages to streamline data ingestion, monitoring, and 
maintenance tasks.

• Act as the technical lead for SQL Server databases, providing advanced 
problem solving and root cause analysis for complex incidents and ensuring 
high availability of critical data services.

• Produce technical documentation, highlight reports, and exception reports to 
support governance, audit, and project monitoring requirements.

Working for our organisation

The Princess Alexandra Hospital NHS Trust (PAHT) provides a full range of general  acute, outpatient and diagnostic services at The Princess Alexandra Hospital in Harlow, the Herts and Essex Hospital in Bishop’s Stortford, and St Margaret’s Hospital in Epping. 

We employ 3,500 staff and serve a local population of around 350,000 people living in west Essex and east Hertfordshire, centred on the M11 corridor and the towns of Harlow, Bishop’s Stortford and Epping. Our extended catchment area incorporates a population of up to 500,000 and includes the areas of Hoddesdon, Cheshunt and Broxbourne in Hertfordshire.

Our Values
The Princess Alexandra Promise to our patients as identified by our 3 values which will contribute to improving our patient experiences:
Patient at heart – Always holding the patient and their wellbeing at the centre of our thoughts and efforts

Everyday excellence – Sharing and celebrating our successes, being honest when we get it wrong, giving us the ability to learn from both
Creative collaboration – Knowing strength comes from diversity, we combine our experiences, skills and talents, working together to find new and better ways to care The Trust believes in investing in all our staff and rewarding high standards of care whilst building for excellence and in return we expect our staff to uphold the Trust values to the highest level.