Oracle Software Developer 4 in Hyderabad, India

Software Developer 4

Preferred Qualifications

We are an engineering team specifically focused on the Performance, Scalability, and Reliability (PSR) aspects of Oracle product lines. Our goal is to achieve highest levels of performance, scalability, reliability, high-availability and serviceability for Oracle’s product lines. Our focus is spread across all products including Fusion Middleware (J2EE), Fusion Apps, Business Intelligence, etc.

The teams in the above mentioned areas cover the following aspects: Performance Analysis and Optimizations, Sizing, Benchmarking, Porting (Platform and Database) and 3rd tier Customer Escalations

Responsibilities

  • Improve the performance and scalability of Fusion platform components and Fusion Applications.

  • Test, debug, and measure the performance of the implemented features, identify the performance and scalability bottlenecks using the relevant profiling tools.

  • Stay current with programming / debugging techniques and relevant development environments

  • Provide technical assistance and develop optimizations to resolve and improve database performance issues that arise during the different phases of performance and scalability testing.

  • Provide timely and accurate work and progress status via the quality system, status reports, and weekly meetings.

Basic Requirements

  • 8-12 years of relevant industry experience BE / B.Tech in Engineering or Science

  • Demonstrated ability to deliver high quality results

  • Attention to details and excellent analytical skills

  • Excellent written and verbal communication and organizational skills

Role Description and Technical Expertise

This role is to measure, analyze and optimize performance in Oracle’s Fusion Applications and Middleware stack. Candidates should have strong analytical skills and expertise in the following areas:

  1. Database Administration
  • Create scripts, tools or utilities for monitoring databases and queries for performance.

  • Knowledge of Data Blocks, Segments, Tablespaces, Data files and Control Files Transaction Management, Schema Objects

  • Database session Tracing and analyzing AWR reports.

  • Actively participate in and contribute to product design and/or product feature discussions and/or meetings within Engineering and with other business units.

  • Resolve architectural and cross-product design issues.

  1. Performance optimization
  • Prototype, test, debug and measure the performance of the suggested improvements

  • Work with Engineering groups to review queries generated by Fusion Applications and suggest rewrites where appropriate for optimal execution.

  • Analyze sources of SQL queries in the Fusion product suite, understand the performance of these queries, review execution plans generated by DBMS and implement changes needed for better query performance.

  • Advanced SQL understanding/ tuning.

  • Prior knowledge of RAC and exadata preferable.

  1. PL/SQL Programming Exposure (Desirable)
  • Be able to demonstrate understanding of PL/SQL Language Syntax and debugging

  • Provide a detailed description of the syntax for a PL/SQL method declaration including exception handling

  • Understand trace Analyzer, PL/SQL profiler

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 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.

Job: Product Development

Location: IN-IN,India-Hyderabad

Job Type: Regular Employee Hire

Organization: Oracle