Oracle Apps DBA

Ikya Human Capital Solutions Pvt Ltd
  • Bangalore
  • Confidential
  • 6-9 years
  • Views
  • 08 Nov 2017

  • Maintenance, Project/ Program Management IT

  • IT/ Technology - Software/ Services
Job Description

Knowledge of Oracle Apps modules like Order Management, Procurement, Inventory and their related tables Oracle Apps DBA skills Good understanding of tuning Data warehousing using STAR schemas Must have extensive hands on experience in analysing SQLT/AWR/Tkprof Expertise in ASH, AWR, SPA, analyzing 10046 trace, analyzing 10053 trace, SQL Profiles, Oracle Baselines, v tables, x tables, etc Very strong SQL tuning experience using TKPROF and SQL Monitor with in-depth understanding of all optimizer hints and optimizer plans eg nested loops, hash joins, star joins, etc

Job Posted By