Job Description

Oracle DB System/Stress/Performance Test Development Group (VLDB)
Department Name : Database Product Development (PDO-DB-IDC)
Group : Autonomous DB Cloud -System/Stress/Performance Test Solutions Development
Location : Oracle India Development Center
Department/Group Description Database Server Group in Product Development Organization is the crown jewel of Oracle Corporation, creating World\xe2\x80\x99s best Database Software technology used by hundreds of thousands of Enterprise, SMB and Cloud customers worldwide. The SHARP-VLDB team (Scalability, High Availability, Reliability, Performance) within the Database Server Product Development division 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 of Oracle Database Server products by Designing, developing and carrying out stress, integration, system and performance tests, which simulate complex real world scenarios on Very Large DBs (VLDB). The team discovers critical product defects and works closely with development groups to resolve them resulting in the highest quality of products before they get released to customers (Cloud and On-Premise) . With over 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 Server products during every major release cycle.


SHARP-VLDB / System Test Development group envisions & architects Large-scale, High load/volume, Massively concurrent multi-tier simulation tools & Data-Centric applications to emulate real world Enterprise DB usage scenarios to detect product defects & architectural limitations. Multi-tier Stress/Integration/System/Performance Test simulations are conducted in a state-of-the-art lab 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 (millions of transactions per sec, 1000s of queries per hour), extreme concurrency levels (5000-10000 parallel users) and boundary/destructive testing. The focus is primarily on high-end enterprise customer use-case scenarios (Ex: Yahoo, Amazon, Apple, LinkedIn, Dell etc.) involving very large & extreme dimensions of testing.

As a member of this group, you will Learn and Shape the Next-Gen/Cutting Edge Oracle DB features as they are designed (19c/20c and beyond) and gain state-of-the-art experience in Managing/Tuning/Debugging VLDBs with thousands of concurrent users simulating real-world production/cloud systems. You will be fully responsible for Designing, Implementing, Maintaining, and Enhancing Test plans, Test Suites/Scripts, and Test methodologies that ensure exhaustive testing of all assigned software areas to ensure highest product quality by exposing defects, identifying regressions, and verifying resolutions. Requires strong interpersonal and technical skills to work effectively and efficiently with development staff and fellow colleagues to identify/debug and resolve software defects.
Specifically, current opportunities exist in projects/features in below Enterprise DB areas with a focus of Oracle Enterprise DBA skill-sets on Linux.x64. Oracle Clusterware/ASM/RAC/ACFS, Oracle JSON, Oracle XDB, Oracle Sharding, Oracle Client products JDBC,ODP.Net , OCI-C , Python/cs_oracle, Node.js ADG (Active Data Guard), Autonomous DB Cloud Services (ATP and ADW CS), EXADATA/Engineered Systems, Oracle In-Memory DB, Oracle NextGen DB Storage Technologies etc.
Grid - https://www.oracle.com/database/technologies/rac/clusterware.html RAC - https://www.oracle.com/database/technologies/rac.html ASM - https://www.oracle.com/database/technologies/rac/asm.html HA / Active Data Guard: https://www.oracle.com/database/technologies/high-availability.html https://www.oracle.com/database/technologies/high-availability/dataguard.html Autonomous DB Cloud (ATP and ADW): https://www.oracle.com/database/autonomous-database.html https://www.oracle.com/database/autonomous-transaction-processing.html https://www.oracle.com/database/data-warehouse.html Oracle DB In-memory: https://www.oracle.com/in/database/technologies/in-memory.html
Qualifications
Technical

• Expert Oracle Development DBAs (OR) Oracle DB Developers with sound Oracle DB Application Development cum DBA Full-Life cycle experience ranging from 5-15 years, with good interest in working with "Oracle Databases on Windows"
• Strong Linux OS/Architecture understanding (Server Configuration, Networking, File Systems, Process & Memory Monitoring/Tuning etc). Experience w/ Windows and Solaris is a plus.
• Programming/Scripting skills in one or more of below languages is preferred.
  • Scripting - Shell, Perl, Python, REST APIs
  • Programming - SQL, PL/SQL, Java/JDBC, C#/ADO.NET/ODP.NET/C/C++
• Sound Experience as Development cum Production Oracle DBA - Administering Large-scale OLTP/Mission critical databases in real world production/Test environment.
• Oracle DB/SQL/Application Performance Monitoring/Tuning/Troubleshooting skills-sets is preferred
• Good Knowledge of RDBMS/Oracle DB Architecture, Configuring & Testing Oracle 12c or above
• Experience with Oracle Enterprise features like Oracle Clusterware, RAC, ASM/ACFS, Data Guard, Multi-tenant DB (CDB/PDB) , DB Upgrade/Migrations, DB Performance Monitoring/Tuning, Logical/Physical Design and Workload Design/development 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
• Ability to multitask, Positive Attitude and deliver under pressure.