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

Tata Consultancy Services · 5 hours ago

Lead Data Architect (Oracle/Exadata)

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

Tata Consultancy Services is seeking a Lead Data Architect specializing in Oracle and Exadata. The role involves owning the understanding of the existing Oracle Exadata environment, ensuring critical information is preserved during migration, and analyzing various Oracle schemas and SQL semantics.

Business Information SystemsConsultingInformation TechnologyIT Management
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/ASHLarge databasesMigration risk classificationOracle behavior reference modelSQL signature catalogOracle feature dependency reportBaseline correctness definitions

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
BACHELOR OF COMPUTER SCIENCE

Company

Tata Consultancy Services

twittertwittertwitter
Glassdoor3.8
company-logo
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
dateFounded in 1968
location
Mumbai, Maharashtra, IND
people-size10001+ employees
web-link
http://www.tcs.com

H1B Sponsorship

Tata Consultancy Services 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 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)

Funding

Current Stage
Public Company
Total Funding
unknown
2004-08-25IPO

Leadership Team

leader-logo
K. Krithivasan
Chief Executive Officer & Managing Director
linkedin
leader-logo
Aarthi Subramanian
President and Chief Operating Officer

Recent News

Hindu Business Line
Top Business & Market Headlines Today — BL Morning Report, January 14, 2025
2026-01-16
TradingView
India Equities Extend Losses
2026-01-16
IndiaTimes
TCS shares in focus on last day to qualify for Rs 57/share dividend. Check record, payment date
2026-01-16
Company data provided by crunchbase