Job summary
You will be administering and supporting a range of SQL Servers and databases as part of the Trust Data Warehouse.
This role will include the following duties:
Data capacity planning and monitoring.
Database design.
Performance monitoring, including index maintenance.
Troubleshooting
Configuration and installation
Security, data recovery, and migration.
Occasionally managing Oracle databases, MySQL and/or Postgres databases.
Owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs.
Providing primary DBA support for application databases, including space monitoring and managing security, backup and recovery, performance tuning, and database refresh processes.
You will be working alongside a team of Information Analysts providing them with technical support, analyse and interpret their requirements and specifications and set up appropriate processes to satisfy their data needs.
Main duties of the job
Responsible for maintaining, securing, and optimizing SQL Server database environments while ensuring high availability, performance, and data integrity.
Primary Responsibilities:
Install, configure, and maintain SQL Server instances and related tools across development, testing, and production environments.
Implement and manage database backup and recovery procedures, ensuring RPO/RTO requirements are met.
Monitor database performance and implement optimization strategies using tools like Query Store, Performance Monitor, and SQL Profiler.
Design and implement high availability solutions including Always On Availability Groups, database mirroring, and failover clustering.
Manage security including user access, permissions, and role assignments.
Develop and maintain documentation for database procedures, standards, and configurations.
Technical Requirements:
Expert knowledge of SQL Server (versions 2016-2023) administration and T-SQL.
Experience with performance tuning, query optimization, and index management.
Strong understanding of SQL Server high availability and disaster recovery options.
Familiarity with PowerShell scripting for automation.
Knowledge of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
About us
We are a leading local employer with a diverse workforce of approximately 6,000 staff, dedicated to providing healthcare services to a growing population of around 780,000 individuals.
Our Trust provides both emergency and planned healthcare across East Surrey, North-East West Sussex, and South Croydon - covering towns like Crawley, Horsham, Reigate, and Redhill. Our main hospital, East Surrey in Redhill, offers a full range of acute and specialist services and is also the closest trauma unit to Gatwick Airport. We also provide outpatient, diagnostic, and planned care services at sites including The Earlswood Centre, Caterham Dene Hospital, Oxted Health Centre, Crawley Hospital, and Horsham Hospital.
We are proud to be an inclusive employer, and we work hard to create an environment where everyone feels valued and supported. At our Trust, we strive to be the best place to work and receive care. We are dedicated to supporting you in your current role while helping you grow and develop your career. As part of our team, you will have access to excellent training opportunities, flexible working, dedicated support networks, and a strong emphasis on health and wellbeing to ensure a thriving and positive work environment.
Details
Date posted
26 June 2025
Pay scheme
Agenda for change
Band
Band 7
Salary
£46,148 to £52,809 a year per annum plus high allowance
Contract
Permanent
Working pattern
Full-time
Reference number
326-7294542-AW
Job locations
East Surrey Hospital
Redhill
RH1 5RH
Employer details
Employer name
Surrey and Sussex Healthcare NHS Trust
Address
East Surrey Hospital
Redhill
RH1 5RH
Employer's website
https://surreyandsussex.nhs.uk/ (Opens in a new tab)







Employer contact details
For questions about the job, contact:
Supporting documents
Privacy notice
Surrey and Sussex Healthcare NHS Trust's privacy notice (opens in a new tab)