Database Architect
10 Years
Singapore
Full-Time
Responsibilities
- Lead assessment of all Oracle databases for migration to Postgres.
- Define target Postgres architecture, including HA, scalability, and DR strategies.
- Drive schema transformation, data profiling, and conversion approach definition.
- Recommend the appropriate commercial/open‑source Postgres distribution.
- Conduct workshops to explain DB architecture decisions and impacts.
- Provide guidance to application, migration, and testing teams on DB–related topics.
Primary Skills
- 10+ years of experience in enterprise database architecture and administration.
- Expert‑level proficiency in PostgreSQL, including tuning and optimization.
- Strong experience with Oracle → Postgres schema, datatype, and code conversion.
- Expertise in designing HA/DR setups—replication, failover, clustering.
- Proficiency with HVR (Fivetran) for real‑time data replication and migration pipelines.
- Expertise in Google AlloyDB on-premises implementations.
- Strong skills in workload analysis, capacity planning, and performance diagnostics.
- Experience with migration tools, and data validation methods.
- Ability to evaluate and recommend Postgres distributions.
- Strong documentation and stakeholder‑communication skills.
Share with someone awesome