Programmer Analyst 4-IT

Innovation starts with inclusion at Oracle. We are committed to creating a workplace where all kinds of people can be themselves and do their best work. It s when everyone s voice is heard and valued, that we are inspired to go beyond what s been done before. That s why we need people with diverse backgrounds, beliefs, and abilities to help us create the future, and are proud to be an affirmative-action equal opportunity employer.
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, age, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

Oracle Customer Success Services
As a key member of Oracle Customer Success Services, you will join an international network of experts dedicated to driving customer success through innovation and expertise. Our One Oracle approach ensures you will be part of a team delivering comprehensive, end-to-end services and solutions that accelerate the entire customer journey. Work alongside certified and experienced professionals, gaining exposure to cutting-edge technologies and methodologies, and enhancing your skills and credentials. Engage with a diverse range of customers, managing the full lifecycle of delivery and services, and ensuring each project has a tangible impact. Benefit from robust team support in a collaborative environment that prioritizes teamwork and mutual success. Join us in Oracle Customer Success Services and elevate your career with a company that values innovation, expertise, and customer-centric solutions.

Leading contributor individually and as a team member, providing direction and mentoring to others. Work is non-routine and very complex, involving the application of advanced technical/business skills in area of specialization.

Expertise in Oracle SQL tuning performance and Oracle BI Publisher Developer comprehensive experience in designing, developing, and optimising business intelligence reports.

Career Level - IC4

- Diagnose and resolve individual SQL performance issues (you would need to apply hints, define new indexes, investigate optimiser/environment issues ).

- Diagnose and resolve performance issues with overall database instance (DB configuration, Oracle bugs, Issues injected by Development teams and etc).

- Explore and adopt new technologies, eg Oracle 23ai, Autonomous Transaction Processing, Auto indexing, Frequent statistics and etc.

- Collaborate with Development teams to ensure they are designing solution for optimal performance.

- Should have good knowledge on database initialization parameters.

- Extensive knowledge on data models, parameters, LOVs, bursting of BIP reports

- Working knowledge of OTBI is desired.

- Various scheduling ways of BI reports and performance enhancing configuration parameters.

- Report development using RTF, etext, Excel Templates for BI

To be successful in the role you should be passionate about database performance for which following skills are mandatory

- SQL Tuning

- PL/SQL experience

- Understand DB schema design principles

- Solid understanding of Oracle architecture and internals (RAC, Memory Components, processes)

- Experience with AWR and/or ASH data

- Experience with Shell, Python, Perl or Java

- Working experience/Developing/writting BI Reports in Fusion SaaS

- Troubleshooting BI Reports with respect to sql tuning, configuration. Knowledge of different parameters of BI reports.

- Excellent problem-solving and debugging skills.

- Proficiency in SQL for data retrieval and manipulation.

Supplementary skills:

- Oracle performance diagnostics tools

- Building synthetic test cases

- Experience Used tools like OEM