Data Engineer

Role Overview

We are seeking an experienced Data Engineer Database Engineer DBA to join a largescale financial services technology and data transformation programme

The successful candidate will be responsible for the engineering configuration deployment administration and operational support of enterprise database platforms across both traditional relational database technologies and modern distributed NoSQL environments

This is a handson engineering role requiring strong practical experience with relational database platforms such as Oracle and PostgreSQL together with NoSQL technologies including MongoDB Cassandra and Couchbase Also cloud equivalents of these technologies Candidate must be keen to pick up new technology and learning as required

The role will cover the full database lifecycle including provisioning configuration DDL deployment performance optimization monitoring and database support

A key objective of the role will be to improve the consistency reliability and automation of database deployments The successful candidate will therefore be expected to develop repeatable engineering patterns and automate database activities wherever possible

This is not a traditional Database AdministratorDBA role This role is to work closely with Applications Teams and Data Architects to define and deploy new initiatives to production on whatever database platform is being used Production Support patching and backups are supported outside of this area

The ideal candidate combines strong database engineering and operational experience with an automationfirst mindset and has experience supporting highly available businesscritical systems within financial services banking or similarly regulated enterprise environments

Key Responsibilities

• Configure deploy administer and support enterprise relational and NoSQL database platforms
• Provide engineering and operational support across
• Oracle
• PostgreSQL
• MongoDB
• Cassandra
• Couchbase
• Build configure and maintain database environments across development test staging and production
• Develop automated and repeatable approaches for database provisioning configuration deployment and lifecycle management
• Implement database configuration and infrastructure through code wherever practical reducing manual administration and configuration drift
• Support database deployments through CICD pipelines and automated release processes
• Perform database installation upgrades patching and version management
• Manage database schemas users roles permissions and access controls
• Support database security vulnerability remediation encryption and compliance requirements
• Monitor database availability capacity performance and operational health
• Investigate and resolve database performance issues including

Query performance

• Indexing
• Execution plans
• Locking and contention
• Connection management
• Storage and capacity

Replication performance

• Design and maintain appropriate database monitoring ing and observability
• Support high availability resilience and disaster recovery capabilities
• Configure and test backup restore and recovery processes
• Support replication clustering and distributed database configurations
• Participate in production incident management rootcause analysis and problem management
• Troubleshoot complex database application and infrastructure issues in collaboration with engineering and application teams
• Support application development teams with database connectivity schema deployment query optimisation and databaserelated technical issues
• Work with Data Architects and application architects to ensure database implementations align with agreed data models and architectural standards
• Support database migrations platform upgrades and technology modernisation initiatives
• Develop and maintain database engineering standards operational procedures runbooks and technical documentation
• Identify opportunities to simplify and standardise the database estate through common engineering patterns tooling and automation
• Contribute to capacity planning technology lifecycle management and database platform roadmaps

Required Skills Experience

Technical Skills

• Strong handson database engineering and DBA experience in largescale enterprise environments
• Strong production experience with relational database technologies particularly
• Oracle
• PostgreSQL
• Handson experience with one or more enterprise NoSQL technologies preferabl