Job Description

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.



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.



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.



Please see the attached Job description and person specification. Available to download at anytime.