Principal Software Engineer - Oracle AI DB & Autonomous DB Cloud

Overview

(integral part of Oracle DB Product Development Org @ IDC ) envisions & architects Large-scale, High Load/Volume, Massively concurrent Multi-tier simulation tools & Data-Centric applications to emulate Real-world Autonomous DB Cloud & On-prem scenarios to detect product defects & architectural limitations.

As a member of this group, you will Learn, Shape and Contribute towards these Cutting-Edge Oracle AI Autonomous DB Cloud and On-prem features as they are designed (26ai+) and gain state-of-the-art experience in Managing /Tuning/Debugging VLDBs emulating real-world production and cloud usage scenarios. You would be fully responsible for Designing, Implementing, Maintaining, and Enhancing Test Solution plans, Test Suites/Scripts, and Test methodologies that ensure exhaustive coverage of all these break-through features.

Multi-tier Stress/Integration/System/Performance Cloud/On-prem Test simulations are conducted in a State-of-the-art Cloud environment (grid of hundreds of servers) mimicking end-to-end high stress scenarios. This simulation effort involves complex DB Design (TB of data, Billions of rows, 1000s of tables), Massively concurrent workload/query development (100K transactions per sec, 1000s of queries per hour), Extreme concurrency levels (5000-10000 parallel users) and High Velocity/Volume IOT/Streaming Data Ingestion/Replication cases. The focus is primarily on high-end enterprise customer use-case scenarios (Ex: Bank of America, NYSE, Apple, LinkedIn, Dell, HDFC, SBI etc.) involving Extreme dimensions of Cloud, On-prem and Hybrid Usage with Large Scale, Data-Volume and Velocity.

Specifically, exciting opportunities currently exist to Innovate on our NextGen Oracle Autonomous DB Cloud Features & Services like:

• Oracle Autonomous DB Cloud - Shared and Dedicated Infrastructure (ADB-S/ADB-D)
• Oracle Multitenant DB Features (CDB/PDB with HA/MAA focus)
• Oracle GoldenGate Enterprise Replication and Various HA/MAA Use-cases/Features
• Oracle Cloud Infrastructure (OCI) GoldenGate Service / OCI GG Marketplace
• Oracle Database Migration Service / Zero Downtime Migration
  
  
  

is our Flagship “Fully-Managed and Highly-Automated” NextGen DB Cloud Service, engineered to run natively on Oracle Cloud Infrastructure (OCI, Gen2) and Oracle EXADATA, providing the highest SLAs of Enterprise Cloud Availability, Scalability, Instant & Online Elasticity, Security and Extreme-Performance at lowest cost !

Oracle Autonomous AI-DB supports different Workload Use-cases like:

• Autonomous Transaction Processing (ATP) - Operational and Business OLTP
• Autonomous Data Warehouse (ADW) - DW, Analytics and ML/Data Science
• Autonomous JSON Database - JSON-Centric Cloud Document Service
  
  
  

https://www.oracle.com/autonomous-database/

https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html

https://www.oracle.com/in/autonomous-database/autonomous-data-warehouse/

https://www.oracle.com/in/autonomous-database/autonomous-transaction-processing/

https://www.oracle.com/in/autonomous-database/autonomous-json-database/

Oracle Multitenant DB, HA/MAA :

https://www.oracle.com/database/multitenant/

https://www.oracle.com/database/technologies/high-availability.html

https://www.oracle.com/database/technologies/high-availability/maa.html

https://www.oracle.com/database/technologies/high-availability/dataguard.html

Responsibilities

Detailed Responsibilities

• Design & Develop Highly Automated Multi-Tier/Multi-Stack System/Stress/Performance Test Suites/Solutions simulating End-to-End Real-world Cloud Enterprise Usage scenarios. This may include DB Schema Design/Normalization, Data generation, Load generation and Application/Business Logic programming in Oracle SQL, PL/SQL, Perl/Shell/Python and Java/JDBC/JMS or Python/cx_oracle and REST Clients
• Review New Functionality/Features in NextGen Oracle AI Autonomous/DB releases, Develop and Maintain Test Specs/Plans/Methodologies and then Design, and Implement End-to-End Test Solutions simulating Real-world production Cloud Usage.
• Execute these developed Test Suites on ADB Cloud PODs and On-prem DB Cluster/EXADATA to discover product defects and architectural limitations by exposing defects and regressions and verifying these resolutions.
• Develop Cloud Automation Tools/Frameworks/Solutions to seamlessly orchestrate ADB-S Cloud Full Life-cycle Operations such as Cloud DB Provisioning, Configuring/Scaling, Complex Workload/Traffic generation, Monitoring/Debugging and Upgrading/Patching cases.
• Develop relevant OS/DB/Application Monitoring and Debugging Tools/scripts and integrate them into the Live Cloud Execution PODs.
• Log and track product defects (bugs), Collaborating closely with Development teams to resolve problems encountered in these Multi-tier Cloud test simulations.
• Serve as ADB-S CloudOPs/DevOPs to address various Cloud DB New feature Automation, Test Harness Design/Development and Execution/Monitoring on Cloud PODs.
• Participate in Product Feature Review, Certification experiments and User Document reviews.
• Deploy AI/ML Technologies and Good GenAI Prompt Engineering (LLMs like GPT, Grok, Llama, Gemini etc.) across these various Solution Design/Development/Testing Lifecycle is preferred
  
  
  

• Expert Database/Cloud Solutions Application Development & Automation expertise with exposure to Oracle DB (either On-prem or Cloud) and other Cloud Databases (AWS RDS, Azure SQL etc.) with 8-15 years of relevant Experience.
• Experience with Oracle Cloud/DBaaS Private (Exadata based Multi-tenant deployments) or Public Cloud (DBCS, ExaCS/ExaCC or Autonomous DB Cloud), Amazon AWS or MS Azure and implementing REST-API Client Orchestrations dealing with Cloud hosted Micro-Services Components is a big plus.
• Good Knowledge of RDBMS/Oracle DB Architecture, Configuring & Testing Oracle 19c/23ai Features like Oracle Grid/RAC/ASM, Multi-tenant DB (CDB/PDB), Data Guard (Physical/Logical Standby), Oracle GoldenGate
• Good Programming/Scripting/Automation skills-sets in one or more of below languages is required.
• Scripting - Perl / Shell / Python, Microservices/REST APIs etc.
• Programming - SQL, PL/SQL, Java/JDBC, Python/cx_oracle etc.
• Good understanding of Cloud Web Services/REST Architecture and Client REST-API Programming (via Java/Python/curl)
• Strong Linux/UNIX OS understanding including OS Architecture & Internals (Networking, File Systems, Process/Memory Monitoring/Tuning/Linux Virtualization etc.). Experience w/ Windows is a plus.
• Oracle DB/SQL/Application Performance Monitoring/Tuning/Troubleshooting skills-sets, Logical/Physical Design and Workload Design/development is preferred.
• Experience as a Database Developer (Oracle/other DBs) developing Large-Scale Data-Intensive Cloud Applications (AND) Production Oracle DBA - Administering Large-scale OLTP/DW Mission critical databases is a plus.
• Exposure to Other DBs like MySQL, MS SQL Server, PostgreSQL, MongoDB, Cassandra, Redis etc is a plus.
• Exposure to AI/ML Technologies and Good GenAI via Prompt Engineering (LLMs like GPT, Grok, Llama, Gemini etc.) for AI-Accelerated Solution Design/Development/Testing/Debugging/Triage is preferred
• B.E, M.E./MS in CS/ECE/EE, MCA from Reputed Engineering Colleges preferred.
  
  

• Good Verbal and Written communication skills
• Self-Motivated and Constant/Quick Learner, Team player & Attention to detail
• Good Analytical and Problem solving skill-sets using AI/ML
• Ability to multitask, Positive Attitude and deliver under pressure
  
  
  

Career Level - IC4

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.