Principal Software Engineer - Oracle AI DB & Autonomous DB Cloud

SHARP-VLDB / Cloud System Test Solutions/Automation Development group (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:

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

Oracle Autonomous DB – Shared/Server-less 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:

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

Oracle Autonomous Database Cloud:

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

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

 Qualifications

 Technical 

• 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. 

Interpersonal

• 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