Lead Data Architect - Oracle/Exadata

Purple DriveLead Data Architect - Oracle/ExadataShare San Jose, CA, Scottsdale, AZ PDT - 10092Overview:Role Summary:Own the source-of-truth understanding of the existing Oracle Exadata environment and ensure nothing critical is lost or misinterpreted during migration. This role is about semantic extraction, not defending Oracle.Key ResponsibilitiesOracle System Intelligence• Analyze Oracle schemas across:o RACo PDBso Sharded/partitioned tables• Interpret:o Triggerso Sequenceso Materialized viewso PL/SQL frameworks• Document implicit behaviors relied on by applications. SQL & Transaction Semantics• Analyze AWR/ASH and SQL Monitor data to determine:o Real transaction boundarieso Locking assumptionso Concurrency behavior• Identify Oracle-specific constructs that cannot be replicated directly. Dependency & Risk Identification• Build the Oracle feature dependency matrix:o PL/SQLo Hintso Optimizer behavioro Isolation-level dependencies• Classify:o Safe-to-migrateo Requires redesigno Requires application changeBaseline Authority• Define golden data sets and expected results.• Validate correctness of test harness outputs against Oracle baselines. Advisory Role• Advise Spanner architects on:o Semantic trapso Hidden couplingo Oracle behavior apps implicitly depend onRequired Skills & Experience• 12+ years of deep Oracle experience• Expert in:o Exadata internalso AWR/ASHo SQL tuning at scale• Strong PL/SQL framework knowledge• Experience with very large databases (10s–100s of TB+)• Ability to translate Oracle semantics into neutral architectural conceptsKey Deliverables:• Oracle behavior reference model• SQL signature catalog• Oracle feature dependency report• Migration risk classification• Baseline correctness definitions