Lead Data Architect (Oracle/Exadata) jobs in United States
cer-icon
Apply on Employer Site
company-logo

NuStar Technologies · 2 days ago

Lead Data Architect (Oracle/Exadata)

positionSan Jose, CA
timeFull-time
remoteOnsite
senioritySenior Level, Lead/Staff
money$120K/yr - $130K/yr
date12+ years exp

NuStar Technologies is seeking a Lead Data Architect specializing in Oracle/Exadata. This role involves owning the understanding of the Oracle Exadata environment and ensuring accurate migration processes, alongside analyzing and interpreting complex Oracle schemas and SQL transaction semantics.

AnalyticsConsultingEnterprise Resource Planning (ERP)IT ManagementStaffing Agency
check
H1B Sponsor Likelynote

Responsibilities

Own the source-of-truth understanding of the existing Oracle Exadata environment and ensure nothing critical is lost or misinterpreted during migration
Analyze Oracle schemas across:
RAC
PDBs
Sharded/partitioned tables
Interpret:
Triggers
Sequences
Materialized views
PL/SQL frameworks
Document implicit behaviors relied on by applications
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
Build the Oracle feature dependency matrix:
PL/SQL
Hints
Optimizer behavior
Isolation-level dependencies
Classify:
Safe-to-migrate
Requires redesign
Requires application change
Define golden data sets and expected results
Validate correctness of test harness outputs against Oracle baselines
Advise Spanner architects on:
Semantic traps
Hidden coupling
Oracle behavior apps implicitly depend on

Qualification

Oracle ExadataSQL tuningPL/SQL frameworksAWR/ASH analysisLarge databasesMigration risk classificationSemantic extractionDependency identificationOracle behavior reference model

Required

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

Company

NuStar Technologies

twittertwitter
company-logo
NuStar Technologies provides staffing, recruiting, cloud enablement, ERP implementation, analytics, web solution, and managed services.
dateFounded in 2013
location
Edison, New Jersey, USA
people-size11-50 employees
web-link
https://nustartech.com

H1B Sponsorship

NuStar Technologies has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (1)
2023 (3)
2022 (1)
2020 (3)

Funding

Current Stage
Early Stage
Company data provided by crunchbase