Database Administrator

4 weeks ago


London, United Kingdom UK Export Finance Full time
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) .

  • London, Greater London, United Kingdom WSN Full time

    Job Title: Database AdministratorWSN is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for ensuring the smooth operation of our databases, including database health checks, performance efficiencies, security, database maintenance and patching, backup, restore and recovery, space management,...


  • London, Greater London, United Kingdom WSN Full time

    Job Title: Database AdministratorWSN is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for ensuring the smooth operation of our databases, including database health checks, performance efficiencies, security, database maintenance and patching, backup, restore and recovery, space management,...


  • London, Greater London, United Kingdom UK Export Finance Full time

    Job Title: Database AdministratorUK Export Finance is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, implementing, and maintaining our database systems to ensure data integrity, security, and performance.Key Responsibilities:Design and implement database schemas and objects to...


  • London, Greater London, United Kingdom UK Export Finance Full time

    Job Title: Database AdministratorUK Export Finance is seeking a skilled Database Administrator to join our team. As a Database Administrator, you will be responsible for designing, implementing, and maintaining our database systems to ensure data integrity, security, and performance.Key Responsibilities:Design and implement database schemas and objects to...


  • London, Greater London, United Kingdom TransPerfect Full time

    Database Administrator Job DescriptionAt TransPerfect, we're seeking a skilled Database Administrator to join our team. As a key member of our database team, you'll work closely with senior developers to design, test, and implement our department's databases.Key Responsibilities:Manage database locking, process blocking, and performance tuningOptimize, test,...


  • London, Greater London, United Kingdom TransPerfect Full time

    Database Administrator Job DescriptionAt TransPerfect, we're seeking a skilled Database Administrator to join our team. As a key member of our database team, you'll work closely with senior developers to design, test, and implement our department's databases.Key Responsibilities:Manage database locking, process blocking, and performance tuningOptimize, test,...


  • London, Greater London, United Kingdom Hamilton Barnes Associates Limited Full time

    Database Administrator OpportunityHiring for a skilled Database Administrator to work with our client's team on a 6-month contract. The ideal candidate will be SC Cleared and have a strong background in managing and administering various database management systems (DBMS).Key Responsibilities:Install, configure, and administer database management systems...


  • London, Greater London, United Kingdom Hamilton Barnes Associates Limited Full time

    Database Administrator OpportunityHiring for a skilled Database Administrator to work with our client's team on a 6-month contract. The ideal candidate will be SC Cleared and have a strong background in managing and administering various database management systems (DBMS).Key Responsibilities:Install, configure, and administer database management systems...


  • London, Greater London, United Kingdom ersg Ltd Full time

    Job Title: Oracle / SQL Database AdministratorJob Summary:We are seeking an experienced Oracle / SQL Database Administrator to join our IT team at ersg Ltd. The successful candidate will be responsible for the maintenance and support of our company databases, ensuring they are running smoothly and efficiently.Key Responsibilities:Proactively maintain and...


  • London, Greater London, United Kingdom ersg Ltd Full time

    Job Title: Oracle / SQL Database AdministratorJob Summary:We are seeking an experienced Oracle / SQL Database Administrator to join our IT team at ersg Ltd. The successful candidate will be responsible for the maintenance and support of our company databases, ensuring they are running smoothly and efficiently.Key Responsibilities:Proactively maintain and...


  • London, Greater London, United Kingdom Opus Recruitment Solutions Ltd Full time

    Database Administrator Job DescriptionWe are seeking a skilled Database Administrator to manage and optimize Dynamics 365 databases, ensuring efficient data storage, retrieval, and integration with Azure Data Warehouse.Key Responsibilities:Database Administration:Manage, configure, and maintain Dynamics 365 databases, ensuring optimal performance and...


  • London, Greater London, United Kingdom Paymentology Full time

    Job Title: Database AdministratorAt Paymentology, we are seeking a highly skilled Database Administrator to join our team. As a key member of our technical team, you will be responsible for ensuring the integrity and performance of our mission-critical databases.Key Responsibilities:Design and optimize database schemas to improve performance and...


  • London, Greater London, United Kingdom Paymentology Full time

    Job Title: Database AdministratorAt Paymentology, we are seeking a highly skilled Database Administrator to join our team. As a key member of our technical team, you will be responsible for ensuring the integrity and performance of our mission-critical databases.Key Responsibilities:Design and optimize database schemas to improve performance and...


  • London, Greater London, United Kingdom hireful. Full time

    Database Officer RoleWe are seeking a skilled Database Officer to join our team at Hireful. as a Database Administrator, you will play a crucial role in supporting and contributing to database operations, ensuring all income received is accurately and promptly processed, and maintaining the database to ensure data quality.Key ResponsibilitiesSupport database...


  • London, Greater London, United Kingdom ERSG Holdings Ltd Full time

    Job Title: Database AdministratorJob Summary:We are seeking a skilled Database Administrator to join our IT team at ERSG Holdings Ltd. The successful candidate will be responsible for delivering support of IT services for approximately 1200 business users, customers, and IT staff worldwide.Key Responsibilities:Provide technical advice and guidance to...


  • London, Greater London, United Kingdom EasyWeb Agency Full time

    Database Officer - Raiser's EdgeEasyWeb Agency is seeking a skilled Database Officer to support and contribute to database operations, ensuring all income received is accurately and promptly processed. The successful candidate will have experience of Raiser's Edge and Import-o-matic database to an advanced level, as well as strong database administration...


  • London, Greater London, United Kingdom Paymentology Full time

    Job SummaryWe are seeking a highly skilled Database Administrator to join our team at Paymentology. As a key member of our technical team, you will be responsible for designing, optimizing, and maintaining our mission-critical databases to support our continued growth and success.Key ResponsibilitiesPartner with our development team to design and optimize...


  • London, Greater London, United Kingdom Dns Info Ltd Full time

    Job Title: Database AdminRole Summary:We are seeking a skilled Database Admin to join our team at Dns Info Ltd. The successful candidate will be responsible for the administration and maintenance of our Ingres database servers.Key Responsibilities:Administer and maintain Ingres database servers in production and test environments.Ensure backup and recovery...


  • London, Greater London, United Kingdom Dns Info Ltd Full time

    Job Title: Database AdminRole Summary:We are seeking a skilled Database Admin to join our team at Dns Info Ltd. The successful candidate will be responsible for the administration and maintenance of our Ingres database servers.Key Responsibilities:Administer and maintain Ingres database servers in production and test environments.Ensure backup and recovery...

  • Database Administrator

    5 months ago


    London, United Kingdom Opus Recruitment Solutions Full time

    **Database Administrator - MySQL** **£70,000 - £100,000** **UK Based - Hybrid - 1-2 days onsite per month **I an working with a client who provides a smart payment platform for customers across the globe. They specialise in reducing risk with their in-house technology, freeing their clients to focus on their core business strategies! They are looking for...