Data Engineer

Data Engineer

Redhill Full-Time 36000 - 60000 £ / year (est.) No home office possible
S

At a Glance

  • Tasks: Administer and support SQL Servers, ensuring high performance and data integrity.
  • Company: Join a leading healthcare Trust serving 780,000 individuals with diverse services.
  • Benefits: Enjoy flexible working, excellent training, and a supportive work environment focused on wellbeing.
  • Why this job: Be part of a team that values inclusivity and offers opportunities for career growth.
  • Qualifications: Expertise in SQL Server administration and T-SQL required; familiarity with automation scripting is a plus.
  • Other info: Contact Shobadevi Marudamuthu for informal visits or further details.

The predicted salary is between 36000 - 60000 £ per year.

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: smarudamuthu@nhs.net Telephone number: 01737768511 #J-18808-Ljbffr

Data Engineer employer: Surrey and Sussex Healthcare NHS Trust

As a leading local employer in healthcare, we pride ourselves on fostering a diverse and inclusive work environment where every employee feels valued and supported. With approximately 6,000 staff members, we offer excellent training opportunities, flexible working arrangements, and a strong focus on health and wellbeing, ensuring that you can thrive both personally and professionally while making a meaningful impact in the community we serve.
S

Contact Detail:

Surrey and Sussex Healthcare NHS Trust Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Engineer

✨Tip Number 1

Familiarise yourself with the specific SQL Server versions mentioned in the job description, particularly 2016-2023. Having hands-on experience or projects that showcase your skills in these versions will give you an edge.

✨Tip Number 2

Brush up on your performance tuning and query optimisation skills. Be prepared to discuss specific strategies you've implemented in past roles to improve database performance, as this is a key responsibility of the position.

✨Tip Number 3

Gain a solid understanding of high availability solutions like Always On Availability Groups and failover clustering. Being able to articulate your knowledge and any practical experience with these technologies will demonstrate your readiness for the role.

✨Tip Number 4

Connect with current or former employees of the Trust on platforms like LinkedIn. Engaging with them can provide valuable insights into the company culture and expectations, which can help you tailor your approach during interviews.

We think you need these skills to ace Data Engineer

SQL Server Administration
T-SQL Proficiency
Performance Tuning
Query Optimization
Index Management
High Availability Solutions
Disaster Recovery Planning
PowerShell Scripting
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
Database Design
Capacity Planning
Troubleshooting Skills
Security Management
Data Migration

Some tips for your application 🫡

Understand the Role: Read through the job description carefully to understand the specific responsibilities and technical requirements for the Data Engineer position. This will help you tailor your application to highlight relevant skills.

Highlight Relevant Experience: In your CV and cover letter, emphasise your experience with SQL Server administration, performance tuning, and any familiarity with Oracle, MySQL, or Postgres databases. Use specific examples to demonstrate your expertise.

Showcase Technical Skills: Make sure to include your knowledge of T-SQL, PowerShell scripting, and SQL Server Integration Services (SSIS) in your application. Mention any projects where you've implemented high availability solutions or managed database security.

Personalise Your Application: Address your cover letter to the hiring manager, if possible, and express your enthusiasm for the role and the organisation. Mention how your values align with their commitment to inclusivity and support for staff development.

How to prepare for a job interview at Surrey and Sussex Healthcare NHS Trust

✨Showcase Your SQL Expertise

Make sure to highlight your expert knowledge of SQL Server, especially versions 2016-2023. Be prepared to discuss specific experiences with T-SQL, performance tuning, and query optimisation, as these are crucial for the role.

✨Demonstrate Problem-Solving Skills

Prepare examples of how you've troubleshot database issues in the past. Discuss your approach to resolving incidents and fulfilling requests within SLAs, as this will show your ability to manage database-related challenges effectively.

✨Understand High Availability Solutions

Familiarise yourself with high availability solutions like Always On Availability Groups and failover clustering. Be ready to explain how you have implemented or managed these solutions in previous roles, as they are key responsibilities in this position.

✨Communicate with Information Analysts

Since you'll be working alongside Information Analysts, practice explaining technical concepts in a way that's easy to understand. Show that you can analyse their requirements and set up processes to meet their data needs effectively.

Land your dream job quicker with Premium

Your application goes to the top of the list
Personalised CV feedback that lands interviews
Support from real people with tickets
Apply for more jobs in less time with AI support
Go Premium

Money-back if you don't land a job in 6-months

S
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>