PostgreSQL Data Architect (CDC & AWS)

Summary: The PostgreSQL Data Architect role focuses on leading large-scale database modernization and migration projects in AWS, specifically utilizing Change Data Capture (CDC) expertise. The position involves designing enterprise PostgreSQL platforms, integrating real-time data, and managing migrations from DB2 to PostgreSQL while ensuring optimal performance and data integrity. The role is hybrid, requiring 2-3 days on-site in London, and is offered as a 6-12 month contract.

Key Responsibilities:

• Lead large-scale database modernization and migration projects in AWS.
• Design enterprise PostgreSQL platforms and architect real-time data integration.
• Drive DB2 to PostgreSQL migrations while ensuring performance, scalability, and data integrity.
• Implement CDC solutions and manage data modeling, indexing, and partitioning.
• Perform performance tuning and ensure high availability of database systems.
• Oversee schema conversion, validation, and reconciliation processes.
• Utilize Terraform and GitLab CI/CD for deployment and automation.
• Monitor systems using CloudWatch and Grafana.

Key Skills:

• PostgreSQL & AWS (Aurora PostgreSQL) expertise.
• Experience with DB2 to PostgreSQL migration.
• Proficiency in CDC solutions (IBM/Precisely or equivalent).
• Knowledge of Kafka, S3, Python, and SQL.
• Data modeling, indexing, and partitioning skills.
• Performance tuning and high availability experience.
• Schema conversion, validation, and reconciliation capabilities.
• Familiarity with Terraform, GitLab CI/CD, and event-driven architecture (CQRS).
• Experience with CloudWatch and Grafana monitoring.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT