Oracle Apps Database Administrator Resume

SUMMARY:

Overall of 10+ years IT experience in which relevant experience of 6 years of Oracle APPS DBA experience in Software Industry. Having good knowledge in Golden Gate too. Having experience of ITIL concepts as Incident, Problem and Change Management as worked as Incident Manager for 5 years and lead a team of 28 members for global accounts.

TECHNICAL SKILLS:

DATABASES: Oracle 10g and 11g

APPS: Oracle Apps 11i and R12.1.3 and 12.2

OPERATING SYSTEMS: Sun Solaris 9, Red Hat Linux RHEL 5.x, OEL 5.

TOOLS: /UTILITIES: RMAN, OEM 11g/12c, ASM, SQL*Loader, Data Pump, Data GuardPatch Management.

TUNING TOOLS: TKPROF, EXPLAIN PLAN, STATSPACK, AWR

LANGUAGES: SQL, Basic UNIX Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Apps Database Administrator

Environment: EBS R12.1.3,Oracle 11gR2, OEM 12c

Responsibilities:

Providing 24 X 7 Support for client
Applied oracle apps tech stack patches (10.1.2 and 10.1.3)
Application patches using adpatch for resolving AR,AP,PN,GL Issues
Cloned dev, test and stage environments from production by using Rapid Clone.
Performed clone from Prod backup to Test and DEV environment instances for all clients.
Configured Workflow Mailer on different instances.
Setting Profile Options (site level, User level).
Assisting functional and development team on perform action plan regarding SR(tar), provided file version and migrated file from dev/test to Prod.
Securing Oracle Applications by periodically changing Apps and schema passwords
Troubleshooting Patching, Cloning issues
Perform Backup and Recovery on Oracle databases.
Checking Alert Log file for errors and taking appropriate steps to rectify them.
Monitoring of Table spaces based upon alerts.
Maintaining Custom Forms, reports, Programs
Analyzed & Applied CPU patches as per the latest Oracle releases.
Space management by adding and resizing the data files.
Disk space management by enabling cron jobs to clear space of various log files generated by components like Apache, Concurrent Managers.

Confidential

Oracle Apps Administrator

Environment: Oracle APPS 11i & R12, Oracle Database 11g

Responsibilities:

Providing Oracle Applications DBA Support to ensure 24x7.
Worked in Upgrading Oracle Applications from 11.5.10.2 to 12.1.3.
Used AD administration utilities (adpatch, adadmin, adctrl).
Cloning of Oracle Applications using Rapid Clone Utility.
Used FNDCPASS to change passwords
Checking the status of important services like concurrent manager, form server, web server, application listener, database listener etc
Tracking invalid objects, Compiling and validating the invalids
Trouble Shooting both Application and Database issues.
Ensuring successful and periodical backup, Restoration Analyzing the results, debugging of scripts
Relinking and regeneration of application objects using adadmin
Creating users and assigning responsibilities to users.
Creating concurrent managers and assigning work shifts
Checked customizations of patch for patch impact analysis of patch.
Applied patches & done Pre Patch Analysis
Monitored concurrent manager logs
Observing the space management by looking the periodical sizes of the data files and also marking the data files having number of extents.
Regular Monitoring Alert Files on Day to Day Basis.
Worked on database up - gradation from 10g to 11gR2
Worked on Patching.

Confidential

Oracle Apps Administrator

Environment: Oracle APPS 11i & R12, Oracle Database 11g

Responsibilities:

Providing Oracle Applications DBA Support to ensure 24x7.
Used AD administration utilities (adpatch, adadmin, adctrl).
Cloning of Oracle Applications using Rapid Clone Utility.
Used FNDCPASS to change passwords
Checking the status of important services like concurrent manager, form server, web server, application listener, database listener etc
Tracking invalid objects, Compiling and validating the invalids
Trouble Shooting both Application and Database issues.
Ensuring successful and periodical backup, Restoration Analyzing the results, debugging of scripts
Re linking and regeneration of application objects using adadmin
Creating users and assigning responsibilities to users.
Creating concurrent managers and assigning work shifts
Checked customizations of patch for patch impact analysis of patch.
Applied patches & done Pre Patch Analysis
Monitored concurrent manager logs
Monitoring Regular RMAN backups.
Observing the space management by looking the periodical sizes of the data files and also marking the data files having number of extents.
Regular Monitoring Alert Files on Day to Day Basis.