Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc.

As a member of the software engineering division, you will take an active role in the definition and evolution of standard practices and procedures. You will be responsible for defining and developing software for tasks associated with the developing, designing and debugging of software applications or operating systems.

Work is non-routine and very complex, involving the application of advanced technical/business skills in area of specialization. Leading contributor individually and as a team member, providing direction and mentoring to others. BS or MS degree or equivalent experience relevant to functional area. 7 years of software engineering or related experience.



Join us if you like to Lead the Oracle Autonomous DB & GoldenGate Cloud Revolution !!
Oracle Database/GoldenGate System/Stress Test Solutions Development Group (SHARP-VLDB) Department : Oracle Database Product Development (PDO-DB-IDC)
Location : Bangalore (Preferred) OR Hyderabad - India Development Center
Job Role : Senior/Lead/Principal Software Developer (IC) Department/Group Description Database Product Development Organization (DB-PDO) is the Crown jewel of Oracle Corporation, creating World\xe2\x80\x99s best Database and Data Management Software Products used by 100s of Thousands of Large Enterprises, SMB and Cloud customers worldwide. 97% FORTUNE GLOBAL 100 enterprises are powered by Oracle DB for their Mission Critical deployments and workloads. We have been constantly innovating for the past 40+ Years to make Oracle DB #1 with a tons of cool features! SHARP-VLDB group ( S calability, H igh A vailability, R eliability, P erformance) within DB-PDO is a well-respected, highly sought after group with a long track record of success. The group focuses on improving Scalability, High availability, Reliability and Performance aspects for core Oracle DB Server (OnPrem), Oracle Autonomous DB Cloud, Oracle GoldenGate and other DB Cloud Services (DBCS, ExaCS, ExaC@C). This is achieved by Designing, Developing and carrying out Stress, Integration, System and Macro-Performance Test Solutions, simulating Complex Real-world Enterprise usage scenarios and leveraging Very Large DBs (VLDB) hosted on Large RAC Clusters, Exadata or Autonomous DB Cloud and OCI. Our group contributes on New Feature Innovations that makes Oracle DB World\xe2\x80\x99s Best Hyper Converged and Open Database. With 200+ dedicated Product Engineers distributed across the globe and working on a single mission, our group has been extremely instrumental in delivering highest quality Oracle DB Server products/cloud services for every major release.
SHARP-VLDB / System Test Solutions Development group envisions & architects Large-scale, High Load/Volume, Massively concurrent Multi-tier simulation tools & Data-Centric applications to emulate Real-world Autonomous DB Cloud usage scenarios to detect product defects & architectural limitations. As a member of this group, you will Learn and Shape the NextGen/Cutting Edge Oracle Autonomous DB & Goldengate Replication Cloud Services & On-prem features, as they are designed (23c+) and gain state-of-the-art experience in Managing /Tuning/Debugging VLDBs emulating real-world/complex production and cloud usage scenarios You would be fully responsible for Designing, Implementing, Maintaining, and Enhancing Cloud Test plans, Test Suites/Solutions, and Test methodologies that ensure exhaustive testing of all assigned Services/features to ensure highest product quality by exposing defects, identifying regressions, and verifying solutions. Requires strong interpersonal and technical skills to work effectively and efficiently with development staff and fellow colleagues to identify/debug and resolve software defects. Multi-tier Stress/Integration/System/Performance Cloud/On-prem Test simulations are conducted in a State-of-the-art Cloud /On-prem environment (grid of hundreds of OCI/On-prem servers) mimicking end-to-end high stress scenarios. This Solution 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 concurrent users/sessions), High Velocity/Volume IOT/Streaming Data Ingestion/Replication etc. 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. You would have the unique opportunity to Innovate, Shape and Impact Futuristic Oracle Autonomous DB Cloud/GoldenGate Technologies like:

• Oracle Autonomous DB Cloud - Shared and Dedicated Infrastructure (ADB-S/ADB-D)

• Oracle MultiTenant DB Features (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
  

Oracle Autonomous Database Cloud (both Shared & Dedicated) 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/
Oracle GoldenGate Replication & GoldenGate Cloud Service https://www.oracle.com/integration/goldengate/ https://www.oracle.com/in/integration/goldengate/features/ https://docs.oracle.com/en/cloud/paas/goldengate-service/druyg/index.html#articletitle https://www.oracle.com/database/zero-downtime-migration/ https://www.oracle.com/in/cloud/database-migration/
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, Build and Develop Highly Automated Multi-Tier/Multi-Stack System/Stress Test Solutions/Workloads simulating real-world Enterprise Usage scenarios. This may include DB Schema Design/Normalization, Data/Workload generation, GoldenGate Replication Topology Design/Implementations and some Application/Business Logic Development in Oracle SQL, PL-SQL, Shell/Python , Java/JDBC or Python/cx_oracle and REST Clients
• Review New Functionality/Features in NextGen Oracle DB, Autonomous DB Cloud and Oracle GoldenGate releases and Develop/Enhance Test Plans/Methodologies and Design/Implement End-to-End Test Solutions/Frameworks/Harness simulating Real-world Enterprise/Cloud Usage
• Design, Implement, Debug and Performance tune Large-Scale, High-velocity Complex Multi-Master/Active-Active Replication Topologies/Pipelines between Oracle DB, Autonomous DB Cloud and other Heterogeneous DBs
• Execute these developed Real-world Test Solutions on ADB PODs and Emulated DB Cluster/Grids to discover product defects, architectural limitations and regressions and verifying product fixes for these problems
• Develop relevant OS/DB/GG/Application Monitoring and Debugging Tools/scripts and integrate them into the Live Cloud/Test Execution beds.
• Log and track product defects (bugs), Collaborating closely with Development teams to resolve problems encountered in these Multi-tier System/Stress Test simulations.
• Develop Automation tools, Simulation Apps, Re-usable Frameworks & Harness for efficient System/Stress Testing. Participate in Product Feature Review, Certification experiments and User Document reviews.

Qualifications Technical

• Expert Oracle Design/Development/Principal DBAs cum Oracle DB Developers with 8-16 years experience.
• Experience with Oracle DB Enterprise features like Oracle Grid/RAC/ASM, DataGuard (Physical/Logical Standby), Oracle GoldenGate and Multi-tenant DB (CDB/PDB) , is required.
• Good Hands-on Expertise of Oracle GoldenGate Replication , Design/Build/Debug High Velocity GG Replication Pipelines/Topologies between Oracle and Non-Oracle DBs (Active-Active, Multi-Master), GG Performance Tuning and deploying GG for Zero Downtime/Online Migration are essential skill-sets
• Sound Experience as Development cum Production Oracle DBA - Administering Large-scale OLTP/DW Mission critical databases in real world production/Test environment.
• Experience with Oracle DB Public Cloud (DBCS, ExaCS/ExaCC or Autonomous DB Cloud), AWS-RDS or AzureSQL stack and implementing Goldengate Replication for Data
• Integration/Migration between On-Prem and Cloud Oracle DBs is a big plus.
• 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/GG/SQL/Application Performance Monitoring/Tuning/Troubleshooting skills-sets, Logical/Physical Design and Workload Design/development is preferred.
• Exposure to Other DBs like MySQL, MS SQLServer, PostGreSQL, MongoDB, Cassandra, Redis etc is a plus.
• Good Knowledge of RDBMS/Oracle DB Architecture, Configuring & Testing Oracle 19c Features.
• Programming/Scripting & Automation skills in one or more of the below specified languages is needed.
  • Scripting - Shell / Perl / Python
  • Programming - SQL, PL/SQL, Java/JDBC, Python/cx_oracle, Microservices/REST APIs
• 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
• Ability to multitask, Positive Attitude and deliver under pressure