Lead Data Architect OracleExadata

San Jose, CA - USA

Monthly Salary: Not Disclosed

Posted on: 21 hours ago

Vacancies: 1 Vacancy

Job Summary

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 RAC
o PDBs
o Sharded/partitioned tables

Interpret:
o Triggers
o Sequences
o Materialized views
o 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 boundaries
o Locking assumptions
o Concurrency behavior

Identify Oracle-specific constructs that cannot be replicated directly. Dependency & Risk Identification

Build the Oracle feature dependency matrix:
o PL/SQL
o Hints
o Optimizer behavior
o Isolation-level dependencies

Classify:
o Safe-to-migrate
o Requires redesign
o Requires application change

Baseline 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 traps
o Hidden coupling
o Oracle behavior apps implicitly depend on

Required Skills & Experience

12 years of deep Oracle experience
Expert in:
o Exadata internals
o AWR/ASH
o 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 model
SQL signature catalog
Oracle feature dependency report
Migration risk classification
Baseline correctness definitions

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...