Job Details
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.
The ideal candidate will have experience in the following areas:
+ 12~15+ years of software engineering or related experience, with significant time in database-intensive systems.
+ Strong communication, analytical, troubleshooting, and problem-solving skills; able to influence across teams and exec stakeholders.
+ Experience in design, implement and tune dimensional model (Star Schema) on Oracle DB. Oracle Analytics semantic modeling concepts.
+ Expertise in Analytics query optimizations (rewrite / tune) on Oracle Autonomous Database (Exadata)
+ Deep expertise in DB internals and optimizers for major RDBMS (e.g., Oracle, MySQL, SQL Server); mastery of SQL tuning and execution plan analysis.
+ Strong understanding of cloud computing and enterprise software architecture (multi-region HA/DR, zero-downtime migration, data governance).
+ Solid experience with solution involving Java/J2EE, Python. C++ to build data-centric services
+ Proficiency with load testing, profiling, and analysis tools in distributed/cloud environments; proven track record resolving performance, scaling, and stability issues.
+ Knowledge of open-source cloud technologies: Kubernetes, Kafka, distributed caching (e.g., Redis), Elasticsearch, big data ecosystems.
+ In-depth knowledge of Linux, containers, virtualization, compute, storage, and networking fundamentals.
+ Bachelor's or Master's degree in Computer Science or Engineering (or equivalent experience ).
**Responsibilities**
Key responsibilities include:
+ 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.
+ Guide microservices design patterns for data access (connection pooling, circuit breaking, retries, idempotency, backpressure).
+ 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:
1. Medical, dental, and vision insurance, including expert medical opinion
2. Short term disability and long term disability
3. Life insurance and AD&D
4. Supplemental life insurance (Employee/Spouse/Child)
5. Health care and dependent care Flexible Spending Accounts
6. Pre-tax commuter and parking benefits
7. 401(k) Savings and Investment Plan with company match
8. 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.
9. 11 paid holidays
10. 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.
11. Paid parental leave
12. Adoption assistance
13. Employee Stock Purchase Plan
14. Financial planning and group legal
15. Voluntary benefits including auto, homeowner and pet insurance
The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.
Career Level - IC5
**About Us**
As a world leader in cloud solutions, Oracle uses tomorrow's technology to tackle today's challenges. We've partnered with industry-leaders in almost every sector-and continue to thrive after 40+ years of change by operating with integrity.
We know that true innovation starts when everyone is empowered to contribute. That's why we're committed to growing an inclusive workforce that promotes opportunities for all.
Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.
We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_mb@oracle.com or by calling +1 888 404 2494 in the United States.
Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans' status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.
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.
The ideal candidate will have experience in the following areas:
+ 12~15+ years of software engineering or related experience, with significant time in database-intensive systems.
+ Strong communication, analytical, troubleshooting, and problem-solving skills; able to influence across teams and exec stakeholders.
+ Experience in design, implement and tune dimensional model (Star Schema) on Oracle DB. Oracle Analytics semantic modeling concepts.
+ Expertise in Analytics query optimizations (rewrite / tune) on Oracle Autonomous Database (Exadata)
+ Deep expertise in DB internals and optimizers for major RDBMS (e.g., Oracle, MySQL, SQL Server); mastery of SQL tuning and execution plan analysis.
+ Strong understanding of cloud computing and enterprise software architecture (multi-region HA/DR, zero-downtime migration, data governance).
+ Solid experience with solution involving Java/J2EE, Python. C++ to build data-centric services
+ Proficiency with load testing, profiling, and analysis tools in distributed/cloud environments; proven track record resolving performance, scaling, and stability issues.
+ Knowledge of open-source cloud technologies: Kubernetes, Kafka, distributed caching (e.g., Redis), Elasticsearch, big data ecosystems.
+ In-depth knowledge of Linux, containers, virtualization, compute, storage, and networking fundamentals.
+ Bachelor's or Master's degree in Computer Science or Engineering (or equivalent experience ).
**Responsibilities**
Key responsibilities include:
+ 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.
+ Guide microservices design patterns for data access (connection pooling, circuit breaking, retries, idempotency, backpressure).
+ 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:
1. Medical, dental, and vision insurance, including expert medical opinion
2. Short term disability and long term disability
3. Life insurance and AD&D
4. Supplemental life insurance (Employee/Spouse/Child)
5. Health care and dependent care Flexible Spending Accounts
6. Pre-tax commuter and parking benefits
7. 401(k) Savings and Investment Plan with company match
8. 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.
9. 11 paid holidays
10. 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.
11. Paid parental leave
12. Adoption assistance
13. Employee Stock Purchase Plan
14. Financial planning and group legal
15. Voluntary benefits including auto, homeowner and pet insurance
The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted.
Career Level - IC5
**About Us**
As a world leader in cloud solutions, Oracle uses tomorrow's technology to tackle today's challenges. We've partnered with industry-leaders in almost every sector-and continue to thrive after 40+ years of change by operating with integrity.
We know that true innovation starts when everyone is empowered to contribute. That's why we're committed to growing an inclusive workforce that promotes opportunities for all.
Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs.
We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing accommodation-request_mb@oracle.com or by calling +1 888 404 2494 in the United States.
Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans' status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.
Job #NLX287209598