Database Administrator

UKEF is committed to be a more customer-centric organisation, making it easier for customers to deal with us, offering improved response times, quicker decision-making and improved case-processing. To enable this, UKEF is committed to using digital as a primary means for managing relationships with a wider range of stakeholders. Focusing on developing end-to-end services that meet user need and enable business outcomes, this is an exciting new role showing the growth and drive of UKEFs digital ambition.

This role requires you to install and configure DBMS, manage database schemas and objects, implement security policies, monitor performance and tuning parameters, manage user access and permissions and perform general maintenance tasks.

Person specification
EssentialQualifications

• Graduate level education or relevant professional experience. (A)
• Evidence of continuing professional development. (A)

Knowledge

• Good knowledge of Azure Cloud Computing. (A, I)
• Good knowledge of Data architectures including Data warehouses and relational databases and Data modelling techniques. ( A, I)
• Knowledge of database Backup/Recovery techniques, including database clustering techniques on varied database technologies. ( A, I)
• Knowledge of management of dimensional models, SQL scripting. ( A, I)

Skills/Ability

• Communicating between the technical and non-technical:
  • You can communicate effectively with technical and non-technical stakeholders.

(Skill level: working) (A, I)

• Data integration design:
  • You can understand the concepts and principles of data modelling.
  • You can produce relevant data models across multiple subject areas.
  • You can reverse-engineer data models from a live system.
  • You can understand industry-recognised data modelling patterns and standards, and when to apply them.
  • You can compare and align different data models.

(Skill level: practitioner) (A, I)

• Metadata management:
  • You can design an appropriate metadata repository and present changes to existing metadata repositories.
  • You can understand a range of tools for storing and working with metadata.

(Skill level: practitioner) (A, I)

• Problem resolution:
  • You can respond to problems in databases, data processes, data products and services as they occur.
  • You can initiate actions, monitor services and identify trends to resolve problems.
  • You can determine the appropriate remedy and assist with its implementation, and with preventative measures.

(Skill level: working) (A, I)



All skill levels are In relation to Data engineer - Government Digital and Data Profession Capability Framework (ddat-capability-framework.service.gov.uk)
Experience

• Experience in the following disciplines:
• Experience using Azure Cloud Computing, including Azure Managed Instance, Azure Data Lakes, and Azure SQL.
• Experience using MSSQL stack.
• Efficient and conformant Database Design skills.
• Knowledge and experience of SQL Server Optimisation techniques.
• Experience in Troubleshooting SQL Servers.
• In-depth experience in developing and running a data warehouse, tasks including tracking data changes, migration, archiving and monitoring data systems.
• Experience using Agile methodologies, including Scrum or Kanban. (A, I)

DesirableQualifications

• Relevant Microsoft Data related qualification. (A)

Knowledge

• Familiarity with tools like Jira and Kanban boards. ( A)

Experience

• Experience of working in the financial services sector. (A)
• Experience with Automation and DevOps. (A, I)

Qualifications
Graduate level education or relevant professional experience.
Evidence of continuing professional development.

Behaviours

We'll assess you against these behaviours during the selection process:

• Managing a Quality Service
• Delivering at Pace
• Working Together

Technical skills

We'll assess you against these technical skills during the selection process:

• Technical Questions in relation to the role

Benefits

Alongside your salary of 43,890, UK Export Finance contributes 12,714 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 employer contribution of 28.97%

Things you need to know

Selection process details

This vacancy is using Success Profiles (opens in a new window) , and will assess your Behaviours, Experience and Technical skills.

All applications will be sifted against our essential criteria outlined in the personal specification.

• Qualifications
• Statement of suitability - you should fully articulate in 500 words how you meet the essential criteria outlined in the person specification within the Information Pack.
• Technical Questions -

How do you approach designing and managing database schemas and objects? How do you collaborate with data engineers to design efficient databases? Can you provide an example of a complex schema you have worked on? What steps do you take to secure a database? Can you share an experience where you implemented security measures and ensured compliance with regulations like GDPR?
Due to the nature of the post we will also be incorporating the Government Digital, Data & Technology (DDaT) Capability Framework to assess candidates that we would expect to be working across the areas and levels highlighted against the role description of a Senior Data Engineer.

For the initial sift your application will be evaluated against :
Experience - Application and Statement of SuitabilityTechnical Questions:

• How do you approach designing and managing database schemas and objects? How do you collaborate with data engineers to design efficient databases? Can you provide an example of a complex schema you have worked on?

• What steps do you take to secure a database? Can you share an experience where you implemented security measures and ensured compliance with regulations like GDPR?

In the event of a large number of applications, there will be a pre-sift on the following technical questions:

• How do you approach designing and managing database schemas and objects? How do you collaborate with data engineers to design efficient databases? Can you provide an example of a complex schema you have worked on?

• What steps do you take to secure a database? Can you share an experience where you implemented security measures and ensured compliance with regulations like GDPR?

If you are successful following the sift stage, you will be invited to an initial interview; this will include the following assessment:
Behaviours/ Strengths /Experience - a formal panel interview where you will be interviewed across all three behaviours highlighted in Appendix 1. Technical Questions in relation to the role
Details of interview panel members will be e-mailed to all successful candidates who are invited for interview.

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

Security

Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window) .

See our vetting charter (opens in a new window) .

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.

The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.

Diversity and Inclusion
The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window) .

Location: London, GB

Posted Date: 10/8/2024