Database Technical Lead - Edinburgh, United Kingdom - HM Revenue & Customs

HM Revenue & Customs

Verified Company

Edinburgh, United Kingdom

4 days ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

This is an exciting and challenging role for those looking to deliver technological change against a background of organisational transformation, as well as an opportunity to make a real difference to people's lives by delivering great digital products.

As a Database Technical Lead you will develop and maintain a large number of databases and supporting code/documentation primarily focused on systems related to Borders and Trade.

You'll be building and supporting IDMSX databases on VME as well as having the opportunity to work on other DBMS technologies in physical and cloud based environments that support critical national infrastructure and keep the UK economy and international trade moving.

You'll be part of a larger agile team at the heart of enabling HMRC to move its legacy systems to state of the art cloud based platforms, and leading the efforts of smaller teams of DBA's on project and support work.

We're embarking on a wholesale modernisation of our IT estate so you'll be driving the migration of one of the most complex IT estates in Europe to cutting edge cloud technologies using AWS, MS Azure and other emerging technology stacks.

You'll have opportunities to learn those and other new technologies as they arise and keep your skillset current.

The diversity and complexity of our systems mean you'll always be able to learn something new and we'll support you all the way.

As a DBA you'll have key involvement in development and support on landmark enterprise level projects and programmes from delivering critical Customs and Border changes like EUExit to the Chancellor's schemes, all essential to the continued success of the UK.

The Team:

The CDIO, Borders & Trade database team develops and maintains a large number of databases and supporting code/documentation primarily focused on systems related to Customs and International Trade.

We operate a structure to ensure that we provide skilled resources to enable us to meet the needs of our customers in an Agile way helping to drive high levels of collaboration and innovation.

Guilds provide a permanent organisation construct that are set up to bring together people who share technical, functional and professional skills.

The Guild responsibility will be to define the technical standards and tools that its members will use.

It also ensures that members of the Guild continually improve their skills so that technical skills remain current, are aligned to HMRC/CDIO strategy and in-step with IT industry developments.

Responsibilities

Role Responsibilities as a Database Technical Lead:

The installation, configuration, upgrade, administration, monitoring and maintenance of databases. Providing support for operational databases in production use and for internal or interim purposes such as iterative developments and testing. Improving the performance of databases and the tools and processes for database administration (including automation).
Collect agreed performance statistics. Carrying out agreed database maintenance and administration tasks.
Knowledge of logical database schemata, to investigate problems and collect performance statistics/create reports.
Carrying out routine configuration, installation, and reconfiguration of database and related products. Developing and configuring tools to enable automation of database administration tasks. Identifying problems and issues and recommending corrective actions.
Developing and maintaining procedures and documentation.
Identifying, evaluating and managing the adoption of appropriate database administration tools and processes, including automation.
Contributing to the setting of standards for definition, security and integrity of database objects and ensuring conformance to those standards.
Managing database configuration including installing and upgrading software and maintaining relevant documentation.
Monitoring database activity and resource usage.
Optimising database performance and planning for forecast resource needs.
Mentoring less experienced team members and sharing technical knowledge and best practice as well as line managing a small team.

Person specification

Essential Criteria:

We are looking for people with knowledge and experience of IDMSX database administration, development and support.

You will already have knowledge of:

IDMSX Database administration on VME
Data Dictionary (DDS) administration
Scripting in SCL
COBOL programming
Use of QueryMaster/ALTADATA
Supporting TPMS systems and Application Master code.
Good understanding of backup and recovery strategies
Good communication skills

It is expected that the successful applicant, once suitable to do so, will be required to be on call for which there is the appropriate additional remuneration of Attendance Allowance, on call allowances and overtime payment for callouts.

Desirable Criteria:

Whilst not essential, practical experience in the use of some