Postgres Data Architect

7 Days Old

Job Details Role / Job Title: Postgres Data Architect with CDC Skills Work Location: 250 Bishopsgate, London, UK Office Presence (Hybrid): 2 days per week The Role PostgreSQL Data Architect with strong hands-on experience in Change Data Capture (CDC). The candidate will design and implement robust data migration strategies, ensuring seamless integration between legacy systems and modern cloud-based architectures. Responsibilities Architect CDC Pipelines: Design and optimize Change Data Capture workflows (IBM CDC or equivalent), including subscription design, bookmarks, resync, and replay strategies
Cloud Migration & Hosting: Lead PostgreSQL migration from on-premises/mainframe to cloud platforms (AWS Aurora preferred), ensuring performance, security, and scalability
Integration & ETL Pipelines: Build robust pipelines using CDC Kafka/S3 Aurora with UPSERT/MERGE patterns; guarantee idempotency, ordering, and reliable delivery
Data Encoding & Validation: Manage EBCDIC UTF-8 conversions, packed decimal/binary numeric, and validate transformations with automated test suites
Cutover & Governance: Execute dual-run validations, reconciliation (counts, checksums), rollback strategies, and ensure compliance with masking, encryption, and IAM policies
Performance & Observability: Monitor lag, throughput, and error rates; develop dashboards (CloudWatch/Grafana) and operational runbooks for proactive alerting
Automation & Tooling: Utilize schema conversion tools, IaC (Terraform), CI/CD pipelines (GitLab), and AWS services (Glue, Athena, Redshift) for downstream analytics
Data Modelling & Conversion (Good to have): Transform Db2 schemas to Aurora PostgreSQL; design logical/physical models, enforce referential integrity, and apply best practices for normalization/denormalization
Your Profile Essential Skills / Knowledge / Experience Strong hands-on experience with PostgreSQL (Aurora preferred) and advanced data modelling
Expertise in CDC tools (IBM CDC or similar) and data migration strategies
Proven experience in PostgreSQL cloud hosting and migration
Proficiency in ETL/ELT pipelines, Kafka, and AWS ecosystem
Solid understanding of data encoding, transformation, and validation techniques
Familiarity with IaC, CI/CD, and observability frameworks
Excellent problem-solving and communication skills
Desirable Skills / Knowledge / Experience Mainframe Modernization

TPBN1_UKTJ
Apply
Location:
London
Salary:
From £500 to £550 per day
Job Type:
FullTime
Category:
IT

We found some similar jobs based on your search