SUMMARY

• 11+ years of experience as Oracle database/Apps Administrator.
• Working in a Complex and Critical Environment with over 700 ERP/Non ERP instances in Confidential Project. Part of DBA operations team handling production life - cycle instances.
• Involved in complete lifecycle of planning, design and development, Implementation and Support of different Oracle Applications and products.

TECHNICAL SKILLS

• Applications/RDBMS: Oracle Applications 11i/R12 & Oracle RAC DB 9i, 10g, 11g,12c
• Application T echnology: Oracle iAS, Weblogic, OTM.
• Languages/OS: Shell Scripting, SQL, Linux, Solaris, Windows, VMs
• Tools: Remedy, Oracle Enterprise Manager
• NoSQL: Good knowledge on MongoDB

PROFESSIONAL EXPERIENCE

Oracle Apps DBA

Confidential

Responsibilities:

• Primary DBA for Supply Chain and Order Management IT databases in Confidential . (Over 30 prod instances)
• Worked on R12.2.5 Oracle Applications upgrade from R12.1.3 .
• Installed patches using ADOP utility.
• Troubleshooting concurrent manager issues,Concurrent program running long,Workflow mailer issues on various occasions.
• Experienced in the use of RapidClone, Autoconfig and AD utilities and high availability techniques in Oracle EBS environments.
• Deploying Application EAR on Weblogic environments.
• Worked on multiple Oracle 12c RAC Database upgrades with latest PSU patches applied(In-place upgrades)
• Providing Oncall/Production support for high priority databases. Provide technical assistance and guidance to team members.
• Responsible for fixing all monitoring Oracle database alerts configured via Oracle Enterprise Manager (OEM).
• Responsible and currently working on Upgrading all Cisco 11G databases to Oracle 12.1.0.2 alongwith DR .
• Applying of one-off patches,bug-fixex,PSU patches according to Cisco standards and also involves working with Oracle metalink SR’s for any ora- errors reported as part of Daily Monitoring.
• Migrated few of the critical schemas from 11G database onto newly configured Oracle 12c Database using RMAN Partial backup and restoration technique.
• Doing POC for Oracle 12c In-Memory feature.
• Handling Physical DR Resiliency testing with Application team as part of Quarterly Testing.
• Debug/fix production issues related to Concurrent requests/programs.
• Monitoring and Housekeeping of Production, test and development Instances.
• Troubleshooting problems with web server, web listener, forms server, and concurrent managers, and database.
• Configure, maintain and perform Oracle database Backup activities (RMAN and traditional methods)
• Maintain Oracle Data Guard and disaster recovery instances, Switchover/Failover Administration.
• Performing on multiple occasions of Physical Standby lag or missing archives using RMAN incremental backup and restore from source to target.
• Perform database recovery (table, schema, database recovery) in Production instances.
• Reviewing of change requests (including configuration changes, patch management, proactive and preventive maintenance).

Oracle Global Services Delivery(GSD)

Confidential

Responsibilities:

• Installation and configuration of Oracle Databases,Oracle Applications.
• Patching and upgrade of Oracle databases,Oracle Applications.
• Clone of Oracle applications including DMZ setup from Production to Non-prod envs.
• Cloning of Oracle databases from Production to Non Production servers.
• Database Upgradations from 9i to 10g.
• Exposure of RAC Environment.
• Develop Scripts to Automate Functions and Processes.
• Checking connectivity issues.
• Monitoring all services of the Oracle Databases and ensuring its proper functioning.
• Basic Unix Shell scripting for daily monitoring checks.
• Taking and Restoring Database backups.
• Applying Bug fixes as per Oracle recommendations for the ora- errors as part of SR.
• Applying CPU’s,PSU patches to Oracle databases.

Oracle Apps DBA

Confidential

Responsibilities:

• Providing 24X7 Support to Cardinal Databases (Pyxis servers mainly Oracle Application Database). Configured Alerts on day to day tasks which will alert in case of any issues on email.
• Cloning and Patching of Oracle database.
• Daily Validation of Hot Backups as part of Daily Tasks.
• Creation of Objects, Schemas on Production and Non Production databases.
• Handling of ora- errors by raising an SR with oracle and applying Bug fixes as per Oracle udpates.
• Applying of CPU patches to Oracle databases.

Oracle Apps DBA

Confidential

Responsibilities:

• Providing Datacenter Support 24X7 by Monitoring Production Databases of sizes 25Gb, 50Gb, 30Gb and 250Gb.
• Major role was to SQL Tune the custom SQL/PLSQL code by identifying the time consuming queries from the Production Database.
• Upgraded Database from Oracle 9.2.0.6 to 9.2.0.7.
• User management like Creation of Users,granting of Privileges,creation and assigning of Roles,Creation of Profiles.
• Tablespace creation, addition of Datafiles, resizing of datafiles and space monitoring as part of Monthly,Quarterly growth.
• Logical backup of users, tables and import of users, tables to TEST environment as per requirement.
• Hot backup, cold backup of Servers.
• Restoring and refreshing the TEST and DEVELOPMENT servers.
• Assisting Developers in Tuning Procedure, Packages to Improve the perfomance of the Applications.
• Migration of Procedures, Packages, creation of triggers.
• Cloning of Production to Non Production servers.
• Raising SR with Oracle for ora-600/7445 errors to understand the impact on databases and if any bugfixes to be applied on Production databases.
• Recovered the tables data which was deleted accidentally using Logminer utility.

Solution Environment: UNIX, Oracle Apps 11.0.3/11i/R12.1.3/R12.2.5, Oracle iAS 10g,Oracle FM11g, Oracle DB 9i/10g/11g/12c

Tools: UNIX Shell Scripting, SQL.