Lead Data Architect – Oracle/Exadata/Exadata (Migration & Semantic Extraction Focus) for San Jose, CA or Scottsdale, AZ (Hybrid/Onsite Evaluation Required, Local Candidates Preferred

Role: Lead Data Architect – Oracle/Exadata/Exadata (Migration & Semantic Extraction Focus)

Location : San Jose, CA or Scottsdale, AZ (Hybrid/Onsite Evaluation Required, Local Candidates Preferred)
Duration: 12 months
Experience Required: 12+ Years (10+ Years)
Primary Skills: Oracle, Exadata (Exadata), PL/SQL, AWR/ASH, SQL Tuning at Scale

 

Niche: Oracle/Exadata/Exadata, Exadata Migration & Exadata Intelligence

Must-Have Technical Expertise:

Oracle & Exadata Intelligence:

• Deep knowledge of Exadata internals (storage servers, InfiniBand, Smart Scan, cell offload, optimizer behavior, partitioning, and optimizer behavior, etc.)
• Analyze Oracle environments including:
• RAC (Real Application Clusters)
• PDBs (Pluggable Databases)
• Partitioned & sharded tables (10s–100s TB+ scale)

SQL & Transaction Semantics at Scale:

• Workload and semantic analysis using:
• AWR (Automatic Workload Repository)
• ASH (Active Session History)
• SQL Monitor / SQL Monitor
• Identify:
• True transaction boundaries
• Locking & concurrency assumptions
• Isolation-level dependencies
• Oracle-specific semantics that cannot be replicated directly

Database Constructs & Behavioral Mapping:

Analyze and translate:

• Triggers
• Sequences
• Materialized Views
• PL/SQL frameworks
• Optimizer hints

Migration Governance & Baseline Authority:

• Build Oracle feature dependency matrix
• Classify migration readiness:
• Safe-to-Migrate
• Requires Redesign
• Requires Application Change
• Define golden data sets and expected results
• Validate test harness outputs against Oracle baselines
• Advise target-state architects (e.g., Google Spanner) on:
• Semantic traps
• Hidden coupling
• Implicit Oracle behaviors relied on by applications

Key Responsibilities (Polished):

• Perform Oracle schema intelligence extraction and documentation
• Identify and mitigate migration risk, feature coupling, and semantic gaps
• Create baseline correctness definitions for migrated workloads
• Maintain golden expected result authority
• Produce semantic reference models, catalogs, and risk classification reports
• Lead architecture discussions across infra, DB, and product teams
• Provide neutral architectural translations of Oracle behavior
• Act as a trusted technical advisor for database modernization programs
• Ensure zero misinterpretation of existing system semantics

Key Deliverables:

• Oracle Behavior Reference Model
• SQL Signature & Semantic Catalog
• Oracle Feature Dependency Report
• Migration Risk Classification
• Baseline Correctness Definitions
• Golden Data Validation Sets

Soft Skills:

• Strong stakeholder communication & presentation abilities
• Independent ownership mentality
• Analytical and semantic-first architecture mindset
• Ability to translate complex DB behavior into neutral architectural concepts

--

Thanks & Regards

               Bindiya Dhamija
                 Technical Recruiter

                 www.noviainfotech.com

                 bindiya.d@noviainfotech.com

--
You received this message because you are subscribed to the Google Groups "NoviaJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to noviajobs+unsubscribe@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/noviajobs/CABaWOR%3D1%3DBeu6kiUmfE0tGrQMF3-DpsrtUj%2Bw4TkVKK092L45Q%40mail.gmail.com.