Job Description

• Deliver RHEL8 Postgres build
• Deliver improved automated Postgres build and install
• Migrate the current MongoDB estate from 3.X to 4.4
• Capture replication lag in Postgres alerting
• Collaborate with colleagues, including the Product Manager, to define, refine and prioritise the database roadmap and backlog
• Continued development and support of the organisations database platforms in line with the product and architecture roadmaps, including but not limited to:
• Ensuring appropriate access controls are in place, monitored and adhered to
• Managing, monitoring and improving performance of databases to meet user needs
• Collaboratively assisting with the re-platforming/re-development of existing applications
• Conceptually designing new databases and database changes
• Collaboratively supporting data modelling activities
• Reviewing designs to meet system storage requirements
• Updating, installing and testing new versions and upgrades to databases
• Developing appropriate documentation and artefacts, e.g. data standards, local work instructions
• Developing, managing and testing back-up and recovery plans
• Ensuring storage and archiving procedures function correctly
• Requirement for database administration services
• Planning capacity
• Troubleshooting and resolving database related issues
• Actively participating in all team events, leading where specialist knowledge is required, and supporting the team to improve their process through inspection and adaptation
• Actively participating in all relevant communities of practice and governance

Essential
Significant and demonstrable commercial experience in the following areas:

• Database security and tuning
• Postgres and associated extensions
• repmgr
• pglogical
• Barman
• PostGIS
• pgbadger
• pgbouncer

Other database products, including:

• MS SQL
• Informix
• Oracle
• MongoDB
• Large-scale data and database migration projects
• Data replication and high-availability technology
• Configuration and testing of disaster recovery procedures
• Database monitoring, using Telegraf, InfluxDB and Grafana
• GIT
• RHEL
• Ansible
• Bash
• Python

Desirable
Commercial experience of the following:

• Working in Agile delivery models
• Working in a cross-functional DevOps environment
• AWS including Aurora/Postgres and RDS
• Geospatial data and GIS
• Log monitoring with Elasticsearch, Fluentd and Kibana

Required Knowledge, Skills, and Abilities