Oracle Software Developer 4 in Hyderabad, India
Software Developer 4
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
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.
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:
- 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.
- 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.
- 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
Job Type: Regular Employee Hire