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.
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.
Job responsibilities
For further information regarding the role please read the attached job description and person specification.
Person Specification
Criteria
* Evidence of a good standard of written English appropriate to the role
* A complete and accurate application
* Suitability for role evidenced in supporting statement
* Evidence of essential experience for role
* Meet the essential education/qualifications required for the role
* Hold the necessary mandatory professional/clinical registration
* Evidence of the Trust values and behaviours
* Evidence of any other essential criteria outlined in the person specification
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
£46,148 to £52,809 a yearper annum plus high allowance
#J-18808-Ljbffr