Database Manager – CLS

Social Research Institute

departnent athena award

UCL, Gower Street, London, UK

Overview

  • Posted on: 04th Jan 2022
  • Salary: £45,610 - £53,757 per annum
  • REF: 1881460
  • Closes: 08th February 2022
  • Contract Type: Permanent
  • Hours: Full Time

Duties and Responsibilities

The Centre for Longitudinal Studies is an ESRC Resource Centre. CLS has responsibility for and manages four of Britain’s internationally renowned cohort studies:

1958 National Child Development Study (NCDS)

1970 British Cohort Study (BCS70)

Millennium Cohort Study (MCS)

Next Steps (formerly the Longitudinal Study of Young People in England)

Working with other SQL developers/ Database managers as part of the Database Management Team the role holder is responsible for developing, managing and maintaining the databases that are required to conduct the Centres activities (The Cohort Maintenance & Sample Management, or CMSM databases).

The CMSM databases are currently held on MS SQL Server 2008 R2 with the regular and ad-hoc data processing procedures carried out using T-SQL directly or SQL Server Data Tools / SSIS – SQL Server Integration Services. Having upgraded to MS SQL Server 2014 in summer 2019, a major improvement to the processing procedures is now under design, and your role will play a key part in the design and implementation of this plan.

Within this exciting role you will be required to provide high level technical expertise to the major upgrade to the CMSM Databases, including providing input into the design of the new environment and implementation of change and enable the automation of common database tasks including data ingest, and output, and reporting, by codifying and programming of data base rules.

Key Requirements

You will have a first degree in an IT-related or other relevant discipline, or an equivalent relevant qualification, or equivalent relevant experience together with certification or equivalent relevant experience in any of the following:

MCSE Data Management and Analytics

MCSA SQL Server

MCSA SQL Database Administration

MCSA SQL Database Development

BI Development, Reporting or Data Engineering with Azure

You will also have experience in the use of SQL Server including Structured Query Language, preferably T-SQL, including stored procedures, views, constraints, indexes, functions, triggers, DDL and DML, and Data Extraction, Transformation and Loading (ETL).

Due to the nature of the role and access to data, a DBS check will be carried out.

Further Details

A job description and person specification can be accessed at the bottom of this page.

To apply for the vacancy please click on the Apply Now button below.

If you have any queries regarding the vacancy, please contact Shaadi Shidfar on shaadi.shidfar@ucl.ac.uk.

The UCL Ways of Working for professional services supports colleagues to be successful and happy at UCL through sharing expectations around how we work please see www.ucl.ac.uk/ways-of-working to find out more.

We particularly welcome applications from black and minority ethnic candidates as they are under-represented within UCL at this level.

Closing Date

8 Feb 2022

Latest time for the submission of applications

23:59

Interview date

TBC

Our department holds an Athena SWAN Bronze award, in recognition of our commitment to advancing gender equality.

Any offer of employment will be subject to a Disclosure and Barring Service (DBS) check.

This appointment is subject to UCL Terms and Conditions of Service for Research and Support Staff.

Please use these links to find out more about UCL working life including the benefits we offer and UCL Terms and Conditions related to this job.

Employer Achievements:

company award