About the job

Job summary

Database Manager

Salary & Grade: SEO, £42,716 - £48,068 (Inner)

Location: Colindale, London, NW9 5EQ

Type and term of contract: Permanent Contract

 

This post is primarily based within the TB Unit and is within the Travel, acute respiratory, zoonoses and emerging infections and Tuberculosis (TARZET) Division of the UKHSA Clinical and Public Health Group based on the Colindale site.

The Database Manager will work under the Database Developer and with the team of scientists in TARZET, led by Principal Scientists and under the direction of the Head of the TB Unit. You will manage and develop key information systems in the TB Unit, including database management of national surveillance of tuberculosis and other mycobacteria of public health importance. You will also contribute to the further development of the information systems, supporting system users across TARZET. You will also work with colleagues in TARZET to introduce a quality management system for Information Governance.

The TB Unit has brought together clinical and scientific leads for Tuberculosis across different Divisions within the Clinical and Public Health Group, and the post holder will work within a fully integrated Unit to forge stronger functional partnerships with colleagues in UKHSA, the NHS and international leads for TB.

Location

The role will be based at the UKHSA Colindale Office, NW9 5EQ and can be worked from this office or the UKHSA office in Canary Wharf under a hybrid working pattern. This can be discussed in more detail at interview stage.

*Please be aware that this role can only be worked from within the UK and not overseas. Relocation expenses are not available.* 

 

Job description

As the Database Manager your main responsibilities will include:

• Manage the database and associated data warehouses of the National Tuberculosis Surveillance (NTBS) system, working under the Database Developer and with the scientists responsible for this database including relevant programming for the maintenance, processing, and preparation of data for analysis.
• Provide support for the development and management of other UKHSA surveillance databases, as required.
• Develop stored procedures and views in SQL Server and utilise tools such as Power BI, Excel Power Query and MS Access needed for the management of the NTBS databases, including checks for data quality and cleaning data fields, identifying duplicates, updating user access settings, and matching.
• Maintain code within GitHub repositories and utilise Jira to manage changes
• Work with a wide range of internal and external teams for the maintenance and improvement of the NTBS system. Teams including and not limited to Cyber Security, Technology Dev Ops, IT, Network, Data Governance, Software Development Unit as well as external providers.
• Provide support in the move to adopt new technologies, including utilising cloud-based infrastructure with Amazon Web Services (AWS)
• Prepare and provide data for reports to external stakeholders, UKHSA and the WHO annual data request.
• Produce and maintain documentation including Standard Operating Procedures (SOPs), risk registers, documentation required for data governance and user guides.
• Contribute to updating the tuberculosis information on the UKHSA website and in response to specific user requests such as Parliamentary questions, working with the scientists within the TB Section.
• Support scientists in communication with nurses and physicians within clinics, staff in HPTs and UKHSA regional offices who are users of the system, about issues concerning data access, data cleaning and matching.

Person specification

It is important through your application and Statement of Suitability of 800 words that you give evidence and examples of proven experience of each of the essential criteria (for full details of all essential criteria please refer to the attached job description):

 

Essential

• Educated to degree level in relevant subject or equivalent level qualification or significant experience of working at a similar level in specialist area
• Experience in complex relational database design and development of stored procedures and views
• Experience of version control management using GitHub or similar tools
• Using computers and database software packages (particularly SQL, Microsoft Access and Excel to an advanced level including the use of Power Query)
• Relevant work experience in data management, analysis and reporting
• Experience of developing Power BI reports or using other business intelligence tools
• Demonstrated experience of co-ordinating projects in complex and challenging environments

 

Desirable

• knowledge of project principles, techniques and tools, such as Prince 2 Foundation and Microsoft Project
• Statistical analysis and programming; using statistical/graphics software packages (SAS/Stata/SPSS/ R)

Benefits

Alongside your salary of £42,716, UK Health Security Agency contributes £11,533 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

Things you need to know

Selection process details

STAGE 1 - APPLICATION & SIFT: 

You will be required to complete an application form. This will be assessed in line with the full list of essential criteria as detailed in the attached job description – please do provide evidence of how you meet this. 

If you are successful at this stage, you will progress to an interview.

STAGE 2 – INTERVIEW 

This post will involve an interview by video via MS Teams.  

As part of the process, candidates will be invited to interview which will involve an in-depth discussion of your previous experience and professional competence in relation to the criteria set out in the Person Specification.  Candidates will also be asked to participate in a session where they will be required to prepare and deliver a 5-minute presentation to the panel.  This will be followed by a question-and-answer segment.  The presentation will be designed to assess each candidate’s experience in line with the requirements of the role.  Full details will be provided prior to the interview.

 

Expected Timeline:

Advert close: 23:55hrs on 22nd December 2023 – unfortunately, late applications will not be considered. Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Shortlist: : Please note that that will be a slight delay in shortlisting your application due to the Christmas and new year period. Shortlisting for this post will take place w/c 1st January 2024

Interviews: w/c 15th January 2024

Please note these dates could be subject to change.  

Feedback will only be provided if you attend an interview or assessment.

Security

Successful candidates must undergo a criminal record check. People working with government assets must complete baseline personnel security standard (opens in new window) checks.

Nationality requirements

This job is broadly open to the following groups:

• UK nationals
• nationals of the Republic of Ireland
• nationals of Commonwealth countries who have the right to work in the UK
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window)
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
• individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements (opens in a new window)

Working for the Civil Service

The Civil Service Code (opens in a new window) sets out the standards of behaviour expected of civil servants.

We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles (opens in a new window). The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.