Database Specialist

NHS; London; Hybrid; GBP 46,000 - 53,000; Full time

Job summary

The NHS Counter Fraud Authority seeks a skilled Database Specialist to join their team in London. This role involves managing a data warehouse, ensuring data integrity, and supporting major projects. Ideal candidates will have significant experience in database administration and a strong knowledge of various database systems.

Qualifications

• Significant experience as a Database Administrator or similar.
• Extensive knowledge of SQL and Enterprise Database Systems.
• Experience with Oracle management tools and database tuning.

Responsibilities

• Develop and manage the data warehouse.
• Ensure accurate data integration from diverse sources.
• Support database structure design and implementation.

Skills

Database Administration

Problem Solving

Attention to Detail

Communication

Education

Degree in IT or related field

Tools

Oracle Databases

SQL Server

MySQL

Data Integration Tools

Job description

Job summary

The NHS Counter Fraud Authority (NHSCFA) is the national body responsible for all matters relating to the prevention, detection, and investigation of economic crime across the NHS. Further information about our work and annual plan for delivering this is available on our website.

We are excited to offer an opportunity for an enthusiastic, skilled, and experienced Database Specialist to join our dynamic team. In this pivotal role, you will collaborate with an existing Database Specialist to support business-as-usual activities and play a crucial role in the development and maintenance of our data warehouse. This position is essential in providing foundational support to our data engineers and ensuring the integrity and availability of data across the organisation. This role is ideal for someone who thrives in a fast-paced, innovative environment and is keen to contribute to major projects that impact the entire organisation. If you are looking to make a significant impact and advance your career in database administration, we would love to hear from you.

NPPV3 is required for this role.

Potential applicants can contact Jamie Pearson at [e-mail] for an informal chat if you have any questions regarding the role.

We reserve the right to close this vacancy before the advertised closing date should we receive a significant number of applications.

Interviews will be held on 19th June 2025.

Main duties of the job

1. Collaborate with an existing Database Specialist to develop and manage our data warehouse.
2. Engage in both routine maintenance and complex problem-solving related to database management.
3. Ensure data from diverse sources is accurately integrated and maintained within the system.
4. Support the design and implementation of database structures that meet business requirements and align with industry best practices.
5. Contribute to the continuous improvement of our database strategies, incorporating agile methodologies to adapt to changing needs.
6. Optimise the environment to enhance performance and efficiency.

About us

We have offices based in Coventry, Newcastle, and London and offer flexible, hybrid, office, and home-based working. In addition to the advertised salary, working in the London area will attract a High-Cost Area Supplement where appropriate. The NHSCFA values and respects the diversity of its employees and aims to recruit a workforce which reflects our diverse communities. We welcome applications irrespective of people's age, disability, gender, race or ethnicity, religion or belief, sexual orientation, or other personal circumstances. We have policies and procedures in place to ensure that all applicants are treated fairly and consistently at every stage of the recruitment process, including an invitation to the first stage of the selection process and consideration of reasonable adjustments for people who have a disability. If you are applying to undertake this role on a secondment basis, you should have agreement to being released from your current role in principle, prior to submitting an application form. When you apply for this role, you will be redirected to our recruitment system TRAC. The NHSCFA does not hold a sponsor license in respect of skilled worker visas and so is unable to employ candidates requiring sponsorship.

Details

Date posted: 22 May 2025

Pay scheme: Agenda for change

Band: Band 7

Salary: £46,148 to £52,809 a year

Contract: Fixed term

Duration: 10 months

Working pattern: Full-time, Flexible working, Home or remote working

Reference number: 076-ATH-CFA033-A

Job locations: 7th Floor, 10 South Colonnade, London, E14 4PU

Job description

Job responsibilities

• Proven experience in database administration, with a strong background in managing large-scale data warehouses.
• Expertise in a variety of database management systems and technologies.
• Experience in managing diverse data types across multiple platforms.
• Agile and flexible approach to manage multiple priorities and adapt to new challenges and changes.
• Excellent problem-solving skills and attention to detail.
• Please see full Job Description and Person Specification

Person Specification

Knowledge and Experience - Essential

• Significant experience as a Database Administrator / Engineer or similar.
• Extensive knowledge of Enterprise Database Systems, Data Warehouse Tools, techniques, and infrastructure within a public or private sector organisation.
• Extensive knowledge of SQL query language.
• Understanding and Proficiency in MS Office Program suite and others as required.

Knowledge and Experience - Desirable

• Experience in detecting fraud using data warehousing techniques.

Specialist Knowledge - Essential

• Demonstrate extensive knowledge in the following areas: Oracle Databases 19c and above, SQL Server 2019 and above, MySQL 5.6 and above, Data marts (star schema design), Meta-data XML & JSON, SQL, Data integration tools and techniques.
• Knowledge of Data protection issues.
• Experience with Oracle management tools including Oracle enterprise manager and Toad (or similar).
• Experience of database tuning, process automation, and delivery mechanisms e.g., query plans, indexing.

Knowledge and Experience - Desirable

• Knowledge in Relational Databases, Linux, OLAP.

Qualifications - Essential

• Degree or equivalent in an IT or related field or significant equivalent experience.

Qualifications - Desirable

• Accredited Counter Fraud Specialist

Communication Skills - Essential

• Good communication and interpersonal skills.

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and requires a DBS check for any criminal convictions.