Oracle Apps Dba Consultant Resume
0/5 (Submit Your Rating)
OBJECTIVE
- With the knowledge in the field of Database coupled with my expertise on Oracle Applications DBA seek a long - term career in the field of Oracle Applications Database management systems in a professional organization.
SUMMARY
- Experience in Confidential Pvt Ltd, India that occupies a significant position in IT industries with IT support and Engineering Solutions.
- Having Around 4.5 years of experience in IT industry.
- Having around 3 years of experience as ORACLE APPS DBA.
- Having around 1.5 years of Web development experience using PHP and MySQL Database.
- Having around 3 years of oracle application DBA industry experience under support in UNIX environment and oracle E-Business suite 11i applications consisting of multi-tier architecture.
- Working experience and Maintenance of installed Oracle Apps Rel 11.5.10 suite and Troubleshooting and exposure to R12 E-business suite (12.1.3).
- Cloning of Oracle Application & Database to create new Test & Development Environments.
- Good experience in using AD utilities like adamin, adpatch, autoconfig, adctrl etc. and admin scripts. and Maintaining application System and Database using these
- Applied various types of application Patches using ad patch and also localization patches via indpatch.pl
- Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
- Performed system administrator responsibility tasks such as creating or assigning Responsibilities to users.
- Fair knowledge of RMAN Database Cloning/Refresh, Hot backup & cold backup & recovery.
- Monitoring the application System with Oracle Application Manager.
- Monitoring and Updating Oracle SR activities and perform recommended Oracle action plan for Sev1 & Sev2 priority.
- Working experience of databases such as Oracle 9i & 10g and 11g.
- Applying database patches (O PATCH).
- Knowledge of User and Table space management, indexes, creation and granting Privileges, Roles, Profiling, Authentication to users.
- Performing day-to-day database administration tasks like Monitoring & take appropriate action on Table space usage, checking alert log, and application logs & trace files, monitoring disk usage, Table/index analyze jobs, database backup logs, Inactive form/database sessions, DB Locks monitoring etc.
- Knowledge of UNIX Commands.
TECHNICAL SKILLS
EBS: 11i (11.5.10) and R12 (12.1.3) E-business suite.
Database: Oracle 9i /10g and 11g, MySQL
Programming Languages: MY-SQL,PHP
OS Platform: Linux, AIX, Solaris Windows (XP, 2007 and 2008)
PROFESSIONAL EXPERIENCE
Confidential
Oracle Apps DBA Consultant
Responsibilities:
- Oracle application support - Maintenance of installed Oracle Apps 11.5.10 suite and Troubleshooting and exposure to R12 E-business suite.
- Database support - database support including trouble shooting of the cause of unexpected functioning.
- Also creating and providing access to database objects.
- Also raising change requests to get necessary approval for change before activity and performing the same in instances.
Confidential
Project Engineer
Responsibilities:
- Involved in Installation of Oracle E-Business Suite R12 & 11.5.10.2 on Linux Platform.
- Cloning the Oracle Apps instances from prod to test by using Rapid Clone process
- Resolving issues related to Concurrent manager and login problems.
- Performing Patch analysis, downloading patches and applying patches by using Auto Patch (adpatch).
- Reducing the patch time using features like defaults file, merge patch.
- Applied the patches like one-off patches, mini patches, family patches, CPU patches.
- Resolving the Errors by analyzing the log files and error descriptions.
- Proactively monitoring the Application health checks and taking preventive action as required.
- Applied RDBMS patches by using Opatch.
- Debugging the Apache issues by using Apache configuration & log files.
- Performed Database cloning from Production database to test database.
- Monitoring and resolving Database & Apps listener and tns issues.
- Knowledge in creating the Users, Responsibilities & registering the forms and Concurrent programs.
- Tracing the User session, Concurrent program and Form session as per requirement or request mail.