Database Specialist

NHS; Coventry; Hybrid; GBP 35,000 - 55,000; Full time

Job summary

The NHS Counter Fraud Authority is seeking a Database Specialist to support data warehouse development and maintenance. This role involves collaborating with existing specialists, ensuring data integrity, and contributing to major projects in a dynamic environment. Ideal candidates will have significant experience in database administration and a strong background in SQL and data management.

Qualifications

• Significant experience in database administration.
• Extensive knowledge of SQL query language.
• Experience in managing large-scale data warehouses.

Responsibilities

• Collaborate to develop and manage the data warehouse.
• Engage in routine maintenance and complex problem-solving.
• Ensure accurate data integration from diverse sources.

Skills

Database Administration

SQL

Problem-Solving

Attention to Detail

Agile Methodologies

Education

Degree in Information Technology or related field

Tools

Oracle Databases

SQL Server

MySQL

Oracle Enterprise Manager

Toad

Job description

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 organization. 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 organization. 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. Optimize 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.

Job responsibilities

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

Person Specification

Knowledge and Experience

• 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 organization.
• Extensive knowledge of SQL query language.
• Understanding and proficiency in MS Office Program suite and other relevant tools.
• Experience in detecting fraud using data warehousing techniques.

Specialist Knowledge

• Extensive knowledge of Oracle Databases 19c and above, SQL Server 2019 and above, MySQL 5.6 and above, Data marts (particularly 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 in any of the following areas: Relational Databases, Linux, OLAP.

Qualifications

• Degree or equivalent in an Information Technology or related field, or significant equivalent experience.

Communication Skills

• Good communication and interpersonal skills.

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975, and a submission for Disclosure to the Disclosure and Barring Service (DBS) will be required to check for any previous criminal convictions.

Full-time, flexible working, home, or remote working options available.