Job Description
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 1+c/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
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 1+c/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
💡 Quick Summary
Seeking a career-building opportunity? The Oracle EBS Database Administrator | Performance Tuning position is now open for candidates interested in the Database Administrator sector. This role in Bengaluru offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.