Apply Now
Details
Reference number
Salary
Civil Service Pension with an average employer contribution of 27%
Job grade
Contract type
Type of role
Working pattern
Number of jobs available
Contents
Location
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
£11,533 towards you being a member of the Civil Service Defined Benefit Pension scheme.
Find out what benefits a Civil Service Pension provides.
- Learning and development tailored to your role
- An environment with flexible working options
- A culture encouraging inclusion and diversity
- A Civil Service pension with an average employer contribution of 27%
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 candidates 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
Nationality requirements
Working for the Civil Service
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).
Apply and further information
You may want to save a copy for your records.
Contact point for applicants
Job contact :
- Name : Gurkamal Bhambra
- Email : UKHSA.recruitment@reed.com
Recruitment team
- Email : UKHSA.recruitment@reed.com