Novia Infotech · 16 hours ago
Lead Data Architect
San Jose, CA
Contract
Hybrid
Lead/Staff
12+ years expNovia Infotech is seeking a Lead Data Architect focused on Oracle and Exadata with a primary responsibility of ensuring semantic accuracy and dependency integrity during modernization and migration programs. The role involves technical architecture centered on extracting and translating Oracle semantics into cloud-neutral constructs while providing governance and baseline authority for migration efforts.
Information Technology & Services
Responsibilities
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
Qualification
Required
12+ Years of experience (10+ Years)
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)
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
Analyze and translate: Triggers, Sequences, Materialized Views, PL/SQL frameworks, Optimizer hints
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
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
Strong stakeholder communication & presentation abilities
Independent ownership mentality
Analytical and semantic-first architecture mindset
Ability to translate complex DB behavior into neutral architectural concepts
Preferred
Local Candidates Preferred
Hybrid/Onsite Evaluation Required
Company
Novia Infotech
At Novia Infotech, we’re more than just a service provider — we’re your partner in professional growth.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase