Oracle DB System/Stress/Performance Test Development Group (VLDB)
Department Name : Database Product Development (PDO-DB-IDC)
Location : Noida, Oracle India Development Center
Department/Group Description
Database Server Group in Product Development Organization is the crown jewel of Oracle Corporation, creating World%26rsquo;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 extremely instrumental in delivering highest quality Oracle Server products
during every major release cycle.
Job Description
SHARP-VLDB / System Test Development group envisions %26amp; architects Large-scale, High load/volume, Massively concurrent multi-tier simulation tools %26amp; Data-Centric applications to emulate real world Enterprise DB
usage scenarios to detect product defects %26amp; 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 %26amp; 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 Windows.x64 and Linux.x64.
Oracle Clusterware/ASM/RAC/ACFS,
Oracle JSON,
Oracle XDB,
Oracle Sharding,
JDBC,
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 –
RAC –
ASM –
HA / Active Data Guard:
Autonomous DB Cloud (ATP and ADW):
Oracle DB In-memory:
Detailed Responsibilities
- Design %26amp; 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.
- Execute 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 Executing 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.
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 %26quot;Oracle Databases on Windows%26quot;
- Strong Windows OS/Architecture understanding (Server Configuration, Networking, File Systems, Process %26amp; Memory Monitoring/Tuning etc). Experience w/ Linux and Solaris is a plus.
- Programming/Scripting skills in one or more of below languages is preferred.
- Scripting – Windows Power-shell or Batch, Perl, Python, REST APIs
- Programming – SQL, PL/SQL, Java/JDBC, C#/ADO.NET/ODP.NET
- 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 %26amp; 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.
Interpersonal
- Good Verbal and Written communication skills
- Self-Motivated and Constant/Quick Learner, Team player %26amp; Attention to detail.
- Good Analytical and Problem solving skill-sets
- Ability to multitask, Positive Attitude and deliver under pressure.
Detailed Description and Job Requirements
Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc.
As a member of the software engineering division, you will assist in defining and developing software for tasks associated with the developing, debugging or designing of software applications or operating systems. Provide technical leadership to other software developers. Specify, design and implement modest changes to existing software architecture to meet changing needs.
Duties and tasks are varied and complex needing independent judgment. Fully competent in own area of expertise. May have project lead role and or supervise lower level personnel. BS or MS degree or equivalent experience relevant to functional area. 4 years of software engineering or related experience.
Source link