Database Architect

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.