Lead Data Architect - Oracle/Exadata
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:
o RAC
o PDBs
o Sharded/partitioned tables
• Interpret:
o Triggers
o Sequences
o Materialized views
o PL/SQL frameworks
• Document implicit behaviors relied on by applications. SQL & Transaction Semantics
• Analyze AWR/ASH and SQL Monitor data to determine:
o Real transaction boundaries
o Locking assumptions
o Concurrency behavior
• Identify Oracle-specific constructs that cannot be replicated directly. Dependency & Risk Identification
• Build the Oracle feature dependency matrix:
o PL/SQL
o Hints
o Optimizer behavior
o Isolation-level dependencies
• Classify:
o Safe-to-migrate
o Requires redesign
o 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:
o Semantic traps
o Hidden coupling
o Oracle behavior apps implicitly depend on
Required Skills & Experience
• 12+ years of deep Oracle experience
• Expert in:
o Exadata internals
o AWR/ASH
o 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
Recommended Jobs
Recruiter (West Coast Hours) – WFH/Remote.
We are seeking a highly detail-oriented and relationship-driven Recruiter to join our team. The ideal candidate excels in communication, talent sourcing, on-boarding coordination and full life cycle r…
Cost Clerk
Job Responsibilities: ~Validate daily receiving after audit ~Removing POs/Items from shipments as needed for validation ~Validate, update and review Receiving Log ~Review log for multiple POs…
MIG Welder
We are seeking a skilled and safety-conscious MIG Welder to join our team in Tolleson. The ideal candidate will be proficient in MIG welding processes and have the ability to read blueprints to fabri…
Quality Coordinator- Warehouse
Requisition Number: 72538 The company built on breakthroughs. Join us. Corning is one of the world’s leading innovators in glass, ceramic, and materials science. From the d…
Maintenance Worker
INDIAN PREFERENCE POLICY: Preference in filling vacancies is given to qualified Indian candidates in accordance with the Indian Preference Act of 1934 (Title 25, USC. Section 472) POSITION: MAINTEN…
Design Engineer
Work location- Phoenix, AZ Job Title- Design Engineer (Aero Engines Externals) & Design & Drafting Engineer Salary- $110k/yr with benefits Experience require- 5-10 years Job Description: …
Structural Design Technician Career Level
Qualifications: Duties and Responsibilities Proficient in the development of 3D structural models based on verbal instructions or rough sketches Produce complete sets of structural pla…
Senior Manager, CX L&D Readiness
About Gusto At Gusto, we're on a mission to grow the small business economy. We handle the hard stuff—like payroll, health insurance, 401(k)s, and HR—so owners can focus on their craft and custo…
Dishwasher
Overview Text “BACON” to 25000 to schedule an interview! Our YOU FIRST Philosophy In addition to no night shifts, ever and our fully chef-curated menu, our #1 priority has always been our…
General Manager (Charley's Cheesesteak)
We are looking for a General Manager for our Charley's Cheesesteaks restaurant in Camp Verde, AZ Responsibilities: Team Leadership: Hire, train, coach, and develop team members. Cr…