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’s 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 instrumental in delivering highest quality Oracle Server products during every major release cycle.
Job Description
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 lab environment (grid of hundreds of servers) mimicking end-to-end high stress scenarios. This simulation effort involves 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), 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 & dimensions of testing.
As a member of this group, you will Learn and Shape the Next-Gen Oracle DB features as they are designed (19c/20c and beyond) and gain experience in 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 testing of all assigned software areas to ensure highest product quality by exposing defects, identifying regressions, and verifying resolutions.
Requires good 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)
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
Strong Oracle Development DBAs (OR) Oracle DB Developers with sound Oracle DB Application Development with 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 with Production Oracle DBA - Administering Large-scale OLTP databases in real world production/Test environment.
Oracle DB/SQL/Application Performance Monitoring/Tuning skills-sets is preferred
Good Knowledge of RDBMS/Oracle DB Architecture, Configuring & Testing Oracle 12c or above
Experience with Oracle Enterprise features like Oracle Cluster-ware, 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.
Interpersonal
Good Verbal and Written communication skills
Self-Motivated and Constant/Quick Learner, Teammate & Attention to detail.
Good Analytical and Problem solving skill-sets
Responsibilities
Detailed Responsibilities
Design & Develop Highly Automated Multi-Tier/Multi-Stack System/Stress Test Suites/Workloads simulating real-world 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.
Review New Functionality/Features in NextGen Oracle DB releases, Develop and Maintain Test Specs/Plans/Methodologies and then Design, and Implement End-to-End Test Suites/Frameworks simulating Real-world production systems.
Implement these developed Test Suites on Cluster/Grids to discover product defects and architectural limitations by exposing defects, identifying regressions, and verifying resolutions
Develop relevant OS/DB/Application Monitoring and Debugging Tools/scripts and integrated into the Live Performing Test-beds.
Log and track product defects (bugs), Collaborating closely with Development teams to resolve problems encountered in these Multi-tier test simulations.
Develop Automation tools, Simulation Apps and Re-usable Framework for efficient System/Stress Testing.
Participate in Product Feature Review, Certification experiments and User Document reviews.
Validate Automation of peer teams.
Life at Oracle and Equal Opportunity
An Oracle career can span industries, roles, Countries and cultures, giving you the opportunity to flourish in new roles and innovate, while blending work life in. Oracle has thrived through 40+ years of change by innovating and operating with integrity while delivering for the top companies in almost every industry.
In order to nurture the talent that makes this happen, we are committed to an inclusive culture that celebrates and values diverse insights and perspectives, a workforce that inspires thought leadership and innovation.
Oracle offers a highly competitive suite of Employee Benefits designed on the principles of parity, consistency, and affordability. The overall package includes certain core elements such as Medical, Life Insurance, access to Retirement Planning, and much more. We also encourage our employees to engage in the culture of giving back to the communities where we live and do business.
At Oracle, we believe that innovation starts with diversity and inclusion and to create the future we need talent from various backgrounds, perspectives, and abilities. We ensure that individuals with disabilities are provided reasonable accommodation to successfully participate in the job application, interview process, and in potential roles to perform crucial job functions.
That’s why we’re committed to creating a workforce where all individuals can do their best work. It’s when everyone’s voice is heard and valued that we’re inspired to go beyond what’s been done before.
Disclaimer: 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.
Which includes being a United States Affirmative Action Employer
https://www.oracle.com/corporate/careers/diversity-inclusion/
About Us
As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s problems. True innovation starts with diverse perspectives and various abilities and backgrounds.
When everyone’s voice is heard, we’re inspired to go beyond what’s been done before. It’s why we’re committed to expanding our inclusive workforce that promotes diverse insights and perspectives.
We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.
Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first 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 calling +1 888 404 2494, option one.
Disclaimer:
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.
* Which includes being a United States Affirmative Action Employer