Database Architect - PostgreSQL - Banking | Payments

Job Description

\n

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

\n

INSIDE IR35
\n HYBRID WORKING - LONDON

\n

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.

\n

Responsibilities

\n

\n
• Design enterprise PostgreSQL database architecture and schemas.

\n

• Create logical and physical data models and ERDs.

\n

• Design scalable, high-volume OLTP databases.

\n

• Lead database modernisation from Legacy platforms.

\n

• Define partitioning, indexing and performance optimisation strategies.

\n

• Collaborate with Architects, Engineers and Business stakeholders to deliver enterprise data solutions.

\n\n

Essential Skills

\n

\n
• Extensive PostgreSQL database architecture and design experience.

\n

• Strong logical and physical data modelling expertise.

\n

• Enterprise OLTP database design experience.

\n

• AWS Aurora PostgreSQL or similar cloud-native PostgreSQL platforms.

\n

• Database performance tuning, indexing, partitioning and query optimisation.

\n

• Experience with database migration and modernisation programmes.

\n

• Financial Services, Banking or Payments experience.

\n

• Excellent stakeholder engagement and technical documentation skills.

\n\n

Desirable

\n

\n
• Mainframe DB2.

\n

• Payments platforms (Faster Payments, CHAPS, SEPA, International Payments).

\n

• ISO 20022.

\n

• Liquibase or Flyway.

\n

• Java/Spring Boot.

\n

• CloudWatch, Performance Insights and PostgreSQL monitoring.

\n

• Financial Services governance and architecture standards.

\n\n

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.