Database Architect

Job Summary
We are seeking a highly skilled and experienced Database Architect / Tech Lead to
spearhead our database modernization this role you will be the technical
cornerstone of a critical project migrating our enterprise-level legacy Oracle databases to
PostgreSQL. You will design the migration strategy architect the target PostgreSQL
environment and lead a team of database engineers to ensure a seamless secure and zero-
to-minimal downtime transition.
Key Responsibilities
Migration Architecture & Strategy Define the end-to-end migration strategy including
schema conversion data replication and rollback procedures.
Assessment & Schema Conversion Evaluate complex Oracle databases (including
PL/SQL packages stored procedures triggers and views) and refactor them into
optimized PostgreSQL equivalents.
Performance Tuning Architect the PostgreSQL target environment for maximum
performance scalability and high availability (HA); diagnose and resolve complex query
performance issues post-migration.
Technical Leadership Lead mentor and code-review a team of database engineers
and developers providing technical direction throughout the Migration Development Life
Cycle (MDLC).
Tool Utilization & Automation Implement and optimize migration tooling (e.g. AWS
SCT/DMS ora2pg pgdump or custom replication scripts) to automate data pipeline
delivery.
Technology or a related technical field.
Experience 8 years of experience in database engineering/architecture with at least
3 years of hands-on experience leading Oracle to PostgreSQL migration projects.

Deep Oracle Expertise Strong proficiency in Oracle Database (12c/19c) including
advanced PL/SQL RAC Data Guard and Performance Tuning.
Cloud Experience Experience hosting and managing PostgreSQL on cloud platforms
(e.g. AWS RDS/Aurora Azure Database for PostgreSQL or Google Cloud SQL).
Certifications Professional certifications in Oracle PostgreSQL or Cloud Architecture
(AWS/Azure/GCP).
DevOps & Automation Experience with CI/CD pipelines infrastructure as code
(Terraform/Ansible) and shell scripting (Python/Bash) for database automation.
Agile Methodology Experience working in Agile/Scrum environments as a technical
lead.