Oracle EBS Database Administrator - Performance Tuning

Oracle EBS DBA Admin

Location : Bangalore

Experience : 6.0 - 10.0 Years

Must-Have :

- Experience in Oracle DBA

JD :

- End to end responsible for EBS upgrade/cloning/migration from 12.1 to 12.2.

- Team player as Apps DBA team with application and other IT stake holders

- Responsible for installation, upgrades, and administration of (E-Biz and Oracle Database), patches, SR support, database tuning, concurrent manager administration, cloning.

- Performed Apps DBA daily/routine tasks on administration Oracle environments for capacity planning, securing, troubleshooting, performance tuning, and developer support.

- Set up a new clone instance from Prod and Test Environment and provided apps dba related support.

- Provided on-call support 24/7 for mission-critical production databases including database performance monitoring, application-related run-time monitoring.

- Planning and implementing backup solutions.

- Strong knowledge of installation, upgrade, patching and cloning of EBS R12.1 and R12.2.

- Good experience in Oracle 12c databases administration with strong skills in concepts and architecture and hands on experience on Oracle RAC databases.

- Should have good experience in Maintenance and Support and ability to work on Complex Production environments independently.

- Backup and Recovery skills with Data guard implementation, RMAN configuration Setup.

- Strong knowledge in Database Performance and System tune.

- Designed the database structure, created new Oracle Database instance, and provided support for both Test and Prod environment.

- Continuous review of Business-critical Database to proactively identify space issues, performance tuning issues.

- Experienced in tuning of ERP jobs, Batch Job Monitoring, Long Running Concurrent Requests/Requests Sets,

- Jobs time/CPU consuming SQL Queries.

- Analyzed AWR Reports to identify on-going/proactive issues and worked with Primary DBA to resolve the issues in a timely manner to meet the Business SLAs.

- Conducted Performance Review of Oracle Database for business-critical applications with Leadership team.

- Generated AWR reports from Oracle 19c/12c Databases and analyzed the reports for Oracle wait events, time consuming SQL queries, Tablespace growth, database growth.

- Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.

- Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.

- Completed minimized the space related errors in Oracle Databases by conducting month review with

- Senior Management and addresses the space issues proactively
(ref:hirist.com