Company Name

Oracle India Pvt Ltd ( Bangalore )

Job Description

• Responsibilities:
  • Optimize Oracle SQL: Diagnose and resolve individual SQL performance issues (you would need to apply hints, define new indexes, investigate optimiser/environment issues).
  • Early Adopter of Innovation: Explore and adopt new technologies like Oracle 23ai, Autonomous DB, Auto indexing, AI related tools.
  • Analysis and Optimize Oracle BIP Reports: Should be able to help customer to identify performance issues with Oracle BIP reports functionality and sql queries involved with them. 
  • Optional knowledge of various components of BIP reports like Data models, Parameters, LOVs, Flex Fields, Bursting. Should be able to advise customers to use right sql queries as per Oracle best practices and which aids in completing the report optimally.
  • OTBI and BIP reports: Knowledge of  troubleshooting OTBI reports for advising customers to use performance enhancing configuration parameters. 
  Mandatory Skills:

  1. Strong expertise in writing and understanding of Oracle SQL/PLSQL
  2. Functional knowledge of Oracle Fusion Middleware products, Weblogic & Database products.
  3. Interpreting explain plans and able to read AWRs and ASH for identifying SQL query bottle necks.
  4. Ability to interpret explain plans for access path, predicate filtering and high knowledge of joins and orders in table access. 
  5. Advanced knowledge of SQLHC, parallel query knowledge. Should have rich experience in factored / scalar sub-queries and ability to utilise them in sql queries. 
  6. Strong decision making, convincing skills to bring down the complex discussions to closure supported by right arguments and facts.
  7. Understanding of database initialization parameters, logs and traces.
  8. Experience working on complex software development/integration projects
  9. Experience in scripting tool like Unix shell, Python, Perl
  10. Optional hands on troubleshooting Oracle OTBI & BIP report issues and performance related techniques on components like Data models/sets, LOV, parameters , bursting, FF, scheduling. 

   

  Good to Have Skills:

  1. Understanding of AI and Machine learning will be an added advantage.
  2. Oracle SQL performance diagnostic tools like SQLHC
  3. Experience in using monitoring tools like OEM.
  4. Building synthetic test cases.

Job Details

Education Summary

Contact Details