Principal Software Engineer - AI DB & Autonomous DB Cloud

Position: Principal Software Engineer - Oracle AI DB & Autonomous DB Cloud
Job Description

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  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, Linked In, 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 Next Gen  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 Golden Gate Enterprise Replication and Various HA/MAA Use-cases/Features
Oracle Cloud Infrastructure (OCI) Golden Gate Service / OCI GG Marketplace
Oracle Database Migration Service / Zero Downtime Migration

Oracle Autonomous DB – Shared/Server-less  is our Flagship 'Fully-Managed and Highly-Automated' Next Gen 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

Oracle Autonomous Database Cloud:

Oracle Multitenant DB, HA/MAA :

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/ and REST Clients
Review New Functionality/Features in Next Gen 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 Cloud

OPs/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…