Oracle Apps DBA Consultant Resume

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

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:

Provided 24/7 Production and Test/Dev instances Support in shifts
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.
Monitoring (Health checks) - performing health checks on daily basis with the help of monitoring with OEM and tool like big-brother and team quest as well as directly checking on the server through back end.
Ticketing Track: Keeping the track of changes requested by client using ticketing tool (Remedy ticketing tool). 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.
Code migrations
Cloning the Oracle Apps instances from prod to test by using Rapid Clone process
Resolving issues related to Concurrent manager and login problems.
Worked with various Oracle Applications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, AutoPatch, f60gen, CONCSUB etc.
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.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship