SUMMARY

• Having 10+ years of experience as an Oracle Apps DBA & Core DBA for Production & support Projects.
• Experience in Installation, Up - gradation, Cloning and Recovery of Oracle E-Business suite in RAC (ASM) and Non RAC (ASM). Applications administration from 11.5.10.2, R12.1.x and R12.2.5, Oracle Database 10.2.0.x, 11.2.0.x & 12.1.0.2
• Good Upgrade experience from 11.5.10.2 to 12.2.5.
• Strong knowledge on R12.2 online Patching
• Strong Trouble Shooting skill for R12.2 issue like fs clone, prepare online patching and application issues
• Good experience in environment setup and installation of Oracle database and Oracle golden gate.
• Successfully worked on the data replication between operational and analytical enterprise system using Oracle Golden Gate.
• Installing & upgrading Oracle Database from 10g to 11g (10.2.0.4 /11.2.0.2 ).
• Experience in Workflow Administration, Configuration and troubleshooting of workflow issues.
• Good support knowledge on RAC environment (10g, 11g).
• Strong knowledge of administration processes and controls to meet security and compliance audit requirements for SOX.
• Knowledge on Weblogic 10x & 11g, weblogic Setup, experience on domain creation.
• Experience in managing large databases with sizes over 25 TB.
• Installed taxing software VERTEX on Weblogic Server 10.3.6.
• Archiving and Purging Production using SOLIX.
• Building Subset databases using SOLIX for Testing & Development teams.
• Expert in managing monthly release and production outages.
• Oracle Demantra install, and support
• Deployed various WAR, EAR, JAR applications in Domain and clustered environments.
• Server log and Domain log monitoring, application deployment and performance tuning of Weblogic.
• Setting the JVM parameters like maximum and minimum heap size in Weblogic startup scripts.
• Experience in Installation, Configuration and Administration of WebLogic Application Server.
• Experience in deploying J2EE components on WebLogic Application Server.
• Oracle applications Cloning using Rapid Clone.
• Patching oracle application using adpatch.
• Defining and managing Concurrent managers and Concurrent processes.
• Experience in configuring Parallel Concurrent Processing.
• System Administration tasks like creation and maintenance of Users, Responsibilities and Menus etc.
• Purging and monitoring log files time to time.
• Implementing and maintaining Database Security (create and maintain users and roles, assign privileges).
• Perform backups like cold, hot and logical backup & scheduled according to requirements.
• Managed Complete/Incomplete recovery.
• Database Refreshing, Database Cloning using RMAN and user managed backups
• Backup and Recovery using RMAN.
• Tuning of Database using SQL Trace, Explain Plan, AWR report etc.
• Multiplexing of control files.
• Enable/Disable of Archive log on production database.
• Import/Export at all levels.
• Patching the database on various versions.
• Troubleshooting various issues related to Apache, JServ and Concurrent Processing
• Analyse & Rebuild index to rectify segment fragmentation.

TECHNICAL SKILLS

Operating Systems: Linux-OEL-6x, 10x,HP-UX11ix, AIX5xWindows 2000, Windows 95/98

Languages: SQL, PL/SQL

Databases: Oracle 9i/10g/11g/12c

ERP: Oracle Applications 11i/R12

Tools: & Utilities: 10g Enterprise Manager, Export/Import, Recovery Manager (RMAN), Toad

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. Oracle Apps DBA

Environment: Oracle 11.2.0.4/12 c, Oracle Apps 11.5.10.2,12.2.5, FMW 12c and 11g (WebLogic/SOA/OSB/OHS)

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to R12.2.5.
• Installing & upgrading Oracle Database from 10g to 11g (10.2.0.4 /11.2.0.2 ).
• Expertise in Web logic 11g Administration and Installation.
• Responsible in DBA Activities, Supporting Production, Prod, Dev and Test Environments.
• Strong knowledge on R12.2 online Patching
• Good Knowledge on Golden Gate replication Services.
• Installation, Administration and maintenance of OFM 11g (Oracle Fusion Middleware).
• Extensive experience in installation, configuration Oracle cluster ware CRS 11g.
• Patching and Cloning Oracle Applications.
• Extensively worked on Oracle Applications AD Utilities.
• System Administration tasks like creation and maintenance of Users, Responsibilities.
• Applying one-off patches on RAC cluster ware and RDBMS Oracle Home.
• Scheduling jobs in Crontab for logical, RMAN and cold Backup’s and Monitoring Alerts.
• Resolved the view log/out files issues of concurrent requests.
• Monitoring and configuring OEM alerts.
• Tracing and Debugging the applications and Concurrent programs.
• Purging unwanted request output and log files
• Setup and Install 11gR2 Grid Infrastructure for RAC databases
• Monitoring space related alerts and adding space or deleting old files.
• Experience in Data base refreshing, replication, reorganization and database migration.
• Troubleshoot invalid and unusable objects, Gather schema statistics.
• Successfully implemented, documented the environment to Oracle 11g.

Confidential, Santa Monica, CA

Oracle Apps DBA

Environment: Oracle E-Business Suite 11i and R12.

Responsibilities:

• Responsible in DBA Activities, Supporting Production, Prod, Dev and Test Environments.
• Installation, Administration and maintenance of OFM 11g (Oracle Fusion Middleware).
• Extensive experience in installation, configuration Oracle cluster ware CRS 11g.
• Deploying different applications like WAR files, EJB jars files and enterprise application archives (EAR) on Weblogic.
• Patching and Cloning Oracle Applications.
• Working on EBS R12 integration with OAM for SSO.
• System Administration tasks like creation and maintenance of Users, Responsibilities.
• Applying patches and performing ad activities and troubleshoot several worker issues.
• Applying one-off patches on RAC cluster ware and RDBMS Oracle Home.
• Oracle Demantra install, upgrade configuration and support
• Scheduling jobs in Crontab for logical, RMAN and cold Backup’s and Monitoring Alerts.
• Resolved the view log/out files issues of concurrent requests.
• Monitoring and configuring OEM alerts.
• Migrating the databases and schemas.
• Tracing and Debugging the applications and Concurrent programs.
• Purging unwanted request output and log files
• Use of FNDCPASS utility
• Monitoring space related alerts and adding space or deleting old files.
• Experience in Data base refreshing, replication, reorganization and database migration.
• Troubleshoot invalid and unusable objects, Gather schema statistics.
• Successfully implemented, documented the environment to Oracle 11g.

Confidential, Glendale, CA

Oracle Apps DBA

Environment: Oracle E-Business Suite 11i and R12.

Responsibilities:

• Responsible in DBA Activities, Supporting Production, Development and Test Environments.
• Web logic & OBIEE 11g installation & Configuration Support.
• Patching and Cloning Oracle Applications.
• Extensively worked on Oracle Applications AD Utilities.
• System Administration tasks like creation and maintenance of Users, Responsibilities.
• Applying patches and performing ad activities and troubleshoot several worker issues.
• Scheduling jobs in Crontab for logical, RMAN and cold Backup’s and Monitoring Alerts.
• Resolved the view log/out files issues of concurrent requests.
• Oracle Demantra install, upgrade configuration and support
• Purging unwanted request output and log files
• Use of FNDCPASS utility
• Monitoring space related alerts and adding space or deleting old files.
• Experience in Data base refreshing, replication, reorganization and database migration.
• Troubleshoot invalid and unusable objects, Gather schema statistics.

Confidential

Oracle Apps DBA

Environment: Oracle E-Business Suite 11i and R12.

Responsibilities:

• Involved in DBA Activities, Supporting Development and Test Environments.
• Patching and Cloning Oracle Applications.
• Extensively worked on Oracle Applications AD Utilities.
• System Administration tasks like creation and maintenance of Users, Responsibilities.
• Applying patches and performing ad activities and troubleshoot several worker issues.
• Scheduling jobs in Crontab for logical, RMAN and cold Backup’s and Monitoring Alerts.
• Resolved the view log/out files issues of concurrent requests.
• Purging unwanted request output and log files
• Use of FNDCPASS utility
• Monitoring space related alerts and adding space or deleting old files.
• Experience in Data base refreshing, replication, reorganization and database migration.
• Troubleshoot invalid and unusable objects, Gather schema statistics.

Confidential, San Jose, California

Oracle Apps DBA

Environment: Oracle E-Business Suite 11i and R12.

Responsibilities:

• Experience in Installation, Configuration and Administration of WebLogic Application Server.
• Experience in deploying J2EE components on WebLogic Application Server.
• Involved in DBA Activities, Supporting Development and Test Environments.
• Extensively worked on Oracle Applications AD Utilities.
• Applying Database patches using OPatch utility.
• Managed system configuration using autoconfig.
• Performed Application admin tasks using ADADMIN utility.
• Troubleshooting various issues related to Apache, JServ and Concurrent Processing
• Applying patches and performing ad activities and troubleshoot several worker issues.
• Handling Top/High Incident on priority as per the Process.
• Tracing and Debugging the applications and Concurrent Programs.
• Resolved the view log/out files issues of concurrent requests.
• Application user creation/responsibilities assignment.
• Resolving locks, killing inactive sessions if necessary.
• Troubleshooting several user issues like apps login issues.
• Monitoring space related alerts and adding space or deleting old files.
• Tracing the alert log file for “ORA” messages, Monitoring database growth to ensure smooth functioning of database.
• Experience in Data base refreshing, replication, reorganization and database migration.
• Troubleshoot invalid and unusable objects, Gather schema statistics.
• Trouble shooting the issues/errors and doing RCA for the issues/errors.

Confidential

Oracle Apps DBA

Environment: Oracle E-Business Suite 11i and R12.

Responsibilities:

• Involved in DBA Activities, Supporting Development and Test Environments.
• Good knowledge on Oracle Applications AD Utilities.
• Applying patches and performing ad activities and troubleshoot several worker issues.
• Analyzing the tickets and communicating with Business users for understanding the requirements.
• Handling Top/High Incident on priority as per the Process.
• Resolved the view log/out files issues of concurrent requests.
• Application user creation/responsibilities assignment.
• Resolving locks, killing inactive sessions if necessary.
• Troubleshooting several user issues like apps login issues.
• Monitor the server load, accessibility and other issues.
• Monitoring space related alerts and adding space or deleting old files.
• Experience in Data base refreshing, replication, reorganization and database migration.
• Troubleshoot invalid and unusable objects, Gather schema statistics.