Database Infrastructure Engineer
Database Infrastructure Engineer
Initial 6 Months.
475 per day. Outside IR35.
Remote UK based.
Potential occasional visits into the Edinburgh or Glasgow office
Our client is looking for a Database Infrastructure Engineer with solid commercial database management and development experience is required to join the Database Development (DD) team and accelerate their move from legacy on-prem databases to new AWS cloud-native solutions but also maintain and support the existing on-prem DB estate that runs on RHEL.
Deploying and managing all their databases using infrastructure-as-code (IaC) tools. For on-prem environments, they utilise Ansible, and for AWS, rely on the AWS Cloud Development Kit (CDK) with TypeScript. Proficiency in both Ansible and cloud deployment tools such as AWS CDK will be crucial for success in this role.
The organisation operates multiple database technologies – MongoDB, Postgres, Aurora Postgres RDS, Oracle, and Informix – and are looking for candidates who can work across all these applications. The team provides DBAAS (Database as a Service) to multiple development teams.
A primary responsibility of the team is developing shared CDK constructs (Typescript) that are utilized by various development teams across the organization for new and migrated databases. Therefore, experience with the AWS Developer toolset (CodePipeline, CodeBuild, CodeCommit, and CloudFormation) is important. These constructs will embody practical standards for database architecture and quality, allowing centralized assurance.
In addition to the listed database technologies – the team is currently involved in rolling out a new centralised backup solution using the CommVault application and for monitoring we utilise the TIG stack (Telegraf, InfluxDB & Grafana). The team Grafana instance is deployed using RedHat OpenShift – so experience with containers would be beneficial.
Main Objectives:
- Major version upgrade of the current on-prem MongoDB Estate
- Major version upgrades to multiple on-prem Postgres databases
- Support development teams with on-prem migrations to AWS RDS
- Help migrate our current on-prem Grafana instance to containers deployed on OpenShift
- Enhance database logging infrastructure with AWS OpenSearch
- Support the Database team with ongoing BAU tasks such as upgrading, patching, automation, and monitoring improvements etc.
- Help with Support Requests raised by our stakeholders
Additional Services:
- Collaborate with colleagues, to define, refine and prioritise the database roadmap and backlog.
- Actively participate in all team events, leading where specialist knowledge is required and supporting the team to improve their process through inspection and adaptation.
- Engage with the wider communities of practice and interest to share knowledge, technique, and experience.
- Knowledge share with other team members as necessary.
- Developing appropriate documentation and artefacts, e.g., data standards, local work instructions.
- Support updating, installing, and testing new versions and upgrades to databases.
- Troubleshooting and resolving database related issues.
- Ensure existing on-prem estate continues to meet service standards until migration to AWS has been completed.
- Ensure CDK constructs embody agreed standards for resiliency, security, and backups, and meet agreed standards for quality.
- Support and deliver the disaster recover assurance of digital services, striving towards a sustainable Recovery Time Objective of 2hrs and Recovery Point objective of zero
Essential Skills
Significant commercial experience with the following technology:Ansible, CDK and AWS Development Tools including CloudFormation, OpenSearch / ElasticSearch, AWS IAM, S3, EC2, RDS, MongoDB, Postgres, SQL, Monitoring solutions (e.g., CloudWatch, Grafana)
Significant and demonstrable experience in the following areas:
- Making excellent quality software with other people.
- Working with business stakeholders, to understand the context and to focus on delivering value
- Design and implementation of solutions using a service-based and serverless architecture.
- Excellent collaboration, communication, and teamwork skills
- Experience working in the Agile delivery models – such as Scrum and/or Kanban frameworks.
- Cloud database monitoring, telemetry, intelligence tools and processes
- Defining infrastructure-as-code
- Testing of disaster recovery procedures
- Data replication and high-availability technology
Desirable Skills
- Experience delivering new software that consumes services from a centralised database management team.
- Commercial experience of the following: Informix, Oracle, Serverless (Lambda), Typescript
Talent International UK Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this opportunity, you accept the T&C’s, Privacy Policy and Disclaimers which can be found at talentinternational.co.uk