×
Register Here to Apply for Jobs or Post Jobs. X

Lead Data Architect – Oracle​/Exadata

Job in San Jose, Santa Clara County, California, 95199, USA
Listing for: Purple Drive Technologies LLC
Full Time position
Listed on 2026-01-12
Job specializations:
  • IT/Tech
    Data Engineer, Database Administrator
Salary/Wage Range or Industry Benchmark: 200000 - 250000 USD Yearly USD 200000.00 250000.00 YEAR
Job Description & How to Apply Below

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:
      • RAC
      • PDBs
      • Sharded/partitioned tables
    • Interpret:
      • Triggers
      • Sequences
      • Materialized views
      • PL/SQL frameworks
    • Document implicit behaviors relied on by applications.
  • SQL & Transaction Semantics
    • Analyze AWR/ASH and SQL Monitor data to determine:
      • Real transaction boundaries
      • Locking assumptions
      • Concurrency behavior
    • Identify Oracle‑specific constructs that cannot be replicated directly.
  • Dependency & Risk Identification
    • Build the Oracle feature dependency matrix:
      • PL/SQL
      • Hints
      • Optimizer behavior
      • Isolation‑level dependencies
    • Classify:
      • Safe‑to‑migrate
      • Requires redesign
      • 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:
      • Semantic traps
      • Hidden coupling
      • Oracle behavior apps implicitly depend on
Required Skills & Experience
  • 12 years of deep Oracle experience.
    • Expert in:
      • Exadata internals
      • AWR/ASH
      • 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
#J-18808-Ljbffr
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
 
 
 
Search for further Jobs Here:
(Try combinations for better Results! Or enter less keywords for broader Results)
Location
Increase/decrease your Search Radius (miles)

Job Posting Language
Employment Category
Education (minimum level)
Filters
Education Level
Experience Level (years)
Posted in last:
Salary