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.