Senior DBA/Architect - Banking - London - Payments - Postgres SQL

We are looking for a highly experienced Senior Database Architect/Senior PostgreSQL DBA to join a large-scale payments modernisation programme within a leading financial services organisation. This role will play a key part in transforming a critical payments platform, helping to migrate from Legacy Mainframe DB2 technology to a modern cloud-based PostgreSQL environment. You will provide technical leadership around database architecture, performance, migration strategy and data integrity, ensuring the platform is secure, scalable and capable of supporting high-volume transactional workloads.Location: Hybrid - 3 days per week in the office Contract: Initial 6 months (likely extension) IR35: Inside IR35 Key responsibilities include: Lead the design and architecture of enterprise PostgreSQL databases supporting mission-critical payment platforms. Review, optimise and improve logical and physical data models across complex transactional systems. Define migration strategies from Legacy Mainframe DB2 databases to cloud-native PostgreSQL environments. Analyse existing schemas, stored procedures, batch processing and data flows to support phased migration. Ensure data integrity, auditability and reconciliation throughout migration and transformation activities. Drive database performance optimisation through query tuning, indexing strategies, partitioning and workload analysis. Design highly available database solutions covering replication, backup, disaster recovery and failover. ..... full job details .....