Database Architect

Job Summary
We are seeking a highly skilled and experienced Database Architect / Tech Lead to
spearhead our database modernization initiative. In 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, pg_dump, 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.