Performance Architect

Job Description

Oracle Health & Analytics PSR team is looking for a hands-on CMTS/Senior Staff Engineer or Solution Architect with deep expertise in database internals, query optimizers, tune dimensional model (Star schema) on Oracle DB, and end-to-end analytics query performance optimizations. This role leads complex design, performance remediation, and modernization initiatives across large-scale, cloud-native enterprise systems. You will partner with product, SRE, data, and application teams to architect resilient, cost-efficient, and high-performance data platforms and services.

If you are passionate about optimizing and architecting high-performance software products, this is your opportunity to make an impact at scale.

• Own database performance engineering across critical services: workload analysis, indexing strategies, optimizer guidance, execution plan analysis, and SQL tuning at scale.
• Diagnose and remediate systemic performance, scalability, and stability issues across RDBMS-backed microservices in distributed/cloud environments.
• Design and evolve data-centric architectures (OLTP/OLAP, hybrid, HTAP) including schema design, partitioning/sharding, caching strategies, data lifecycle and archival, and capacity planning.
• Optimize Analytics and OLTP query performance on Oracle Autonomous DB. Lead deep dives into DB internals (transaction processing, concurrency control, locking/latching, memory management, cost models, statistics management, I/O paths, query execution engines).
• Establish performance baselines, SLAs/SLOs, and end-to-end observability (tracing, metrics, profiling) for data-intensive services.
• Drive optimization for cost, throughput, and latency using load testing, profiling, and systematic benchmarking.
• Provide architectural leadership for cloud deployments (Kubernetes, Docker) with strong attention to security, reliability, and compliance.
• Mentor engineers; review designs and code; set best practices for SQL, schema evolution, migration safety, and production readiness.
• Advise stakeholders and customers in consulting engagements: assessments, roadmaps, PoCs, and incident/postmortem leadership.

Disclaimer:

• Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.
• Range and benefit information provided in this posting are specific to the stated locations only
• US:
  Hiring Range in USD from: $96,800 to $251,600 per annum. May be eligible for bonus, equity, and compensation deferral.
• Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business.
• Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.
• Oracle US offers a comprehensive benefits package which includes the following:

• Medical, dental, and vision insurance, including expert medical opinion
• Short term disability and long term disability
• Life insurance and AD&D
• Supplemental life insurance (Employee/Spouse/Child)
• Health care and dependent care Flexible Spending Accounts
• Pre-tax commuter and parking benefits
• 401(k) Savings and Investment Plan with company match
• Paid time off:
  Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment.
  
  Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
• 11 paid holidays
• Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
• Paid parental leave
• Adoption assistance
• Employee Stock Purchase Plan
• Financial planning and group legal
• Vo…