Purple DriveLead Data Architect - Oracle/Exadata Share San Jose, CA, Scottsdale, AZ PDT - 10092
Overview
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 Responsibilities: Oracle 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 change
Baseline Authority
Define golden data sets and expected results.
Validate correctness of test harness outputs against Oracle baselines. Advisory RoleAdvise 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 concepts
Key Deliverables:
Oracle behavior reference modelSQL signature catalog
Oracle feature dependency report
Migration risk classification
Baseline correctness definitions
