Data Engineer

Surrey and Sussex Healthcare NHS Trust; Redhill; On-site; GBP 40,000 - 60,000; Full time

Job summary

Join a leading local employer as a SQL Server Database Administrator, responsible for administering and maintaining SQL Server environments. You will ensure high availability and performance, supporting Information Analysts with data solutions while developing your skills in a supportive healthcare environment.

Benefits

Access to training opportunities

Flexible working arrangements

Support networks for staff

Emphasis on health and wellbeing

Qualifications

• Expert knowledge of SQL Server (2016-2023) administration.
• Experience with performance tuning and query optimization.
• Strong understanding of high availability solutions.

Responsibilities

• Administer SQL Servers and databases for Trust Data Warehouse.
• Monitor and optimize database performance.
• Manage security, backups, and disaster recovery procedures.

Skills

SQL Server administration

T-SQL

Performance tuning

Query optimization

Index management

PowerShell scripting

SSIS

SSRS

Database security

Data recovery

Job description

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.

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

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.

For further details / informal visits contact: Name: Shobadevi Marudamuthu Job title: Informatics Systems Development Manager Email address: [e-mail] Telephone number: 01737768511