Database Administrator
UK Export Finance
Apply before 11:55 pm on Sunday 13th October 2024
Details
Reference number
Salary
London - £46,085-£57,685
Job grade
Contract type
Business area
Type of role
Working pattern
Number of jobs available
Contents
Location
About the job
Job summary
Job description
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
Essential
Qualifications
- 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)
Desirable
Qualifications
- 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
• 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
- 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
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 Suitability
- 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?
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
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).
Diversity and Inclusion
Apply and further information
Contact point for applicants
Job contact :
- Name : UKEF Recruitment Team
- Email : recruitment2@ukexportfinance.gov.uk
Recruitment team
- Email : Recruitment2@ukexportfinance.gov.uk