Database Architect - PostgreSQL - Banking | Payments

A leading financial services organisation is looking for an experienced Senior PostgreSQL Database Architect to join a major enterprise payments transformation programme.

INSIDE IR35
HYBRID WORKING - LONDON

This is not a traditional DBA role. We're looking for someone who can design enterprise-scale PostgreSQL database solutions from first principles, creating logical and physical data models, scalable schemas and high-performance OLTP databases for mission-critical payment systems.

Responsibilities

• Design enterprise PostgreSQL database architecture and schemas.
• Create logical and physical data models and ERDs.
• Design scalable, high-volume OLTP databases.
• Lead database modernisation from Legacy platforms.
• Define partitioning, indexing and performance optimisation strategies.
• Collaborate with Architects, Engineers and Business stakeholders to deliver enterprise data solutions.

Essential Skills

• Extensive PostgreSQL database architecture and design experience.
• Strong logical and physical data modelling expertise.
• Enterprise OLTP database design experience.
• AWS Aurora PostgreSQL or similar cloud-native PostgreSQL platforms.
• Database performance tuning, indexing, partitioning and query optimisation.
• Experience with database migration and modernisation programmes.
• Financial Services, Banking or Payments experience.
• Excellent stakeholder engagement and technical documentation skills.

Desirable

• Mainframe DB2.
• Payments platforms (Faster Payments, CHAPS, SEPA, International Payments).
• ISO 20022.
• Liquibase or Flyway.
• Java/Spring Boot.
• CloudWatch, Performance Insights and PostgreSQL monitoring.
• Financial Services governance and architecture standards.

This is an excellent opportunity to shape the architecture of a large-scale cloud-native payments platform while working on a high-profile enterprise transformation programme with a strong likelihood of extension.