PROFESSIONAL SUMMARY

• Over 8 years of professional experience in IT in the areas of Oracle Applications DBA, Oracle database administration, Oracle RAC DBA, Oracle 10g Application server administration, Oracle Golden gate, Oracle Enterprise Manager OEM , OAM Oracle Access Manager , Oracle discoverer administration.
• Knowledge on Oracle Real Application Clusters RAC , Golden Gate.
• Installation of databases such as Oracle 9i, Oracle 10g, Oracle 11g on WinNT/2000, Linux,IBM-AIX and Solaris.
• Installation of Oracle Apps11i R12 single/multi node on Unix Environments.
• Implementation of two nodes Oracle RAC on Linux with ASM.
• Involved in Oracle Apps 11.5.5/11.5.8/11.5.10/12.0.4/12.1 administration. It includes cloning, patching, troubleshooting technical issues on the Application server, Concurrent manager setup and administration, installing oracle applications.
• Involved in Implementing High availability oracle applications R12 using PCP Parallel concurrent Processing , 11g RAC and Data guard.
• Involved in Oracle database 10g/11g RAC administration on OCFS, ASM file systems.
• Experience in Oracle Applications upgrade from 11.5.10 to R12 and preserving the customizations
• Implementation of setting up the Oracle Data Guard in Oracle Applications R12 and 11i for disaster recovery.
• Implemented the SSO integration with Oracle Apps using Microsoft Active Directory at DC level
• Up gradation of Oracle Apps 11.5.10.2 to Oracle Apps R12.0.4 and Oracle Apps 12.0.4 to 12.1.1.
• Up gradation of Oracle databases from 9i to 10g and 10g to 11gR2.
• Installation of standalone Oracle 10g/11g Grid control and configure the alerts to monitor databases
• Implementation of DMZ server on 11.5.10.2 and R12.
• Experience in sharing the Application tier file system in oracle E-Business suite 11i shared APPLTOP .
• Sysadmin, Cloning, Patch application and concurrent manager activities on Apps 11i and R12 environment.
• Experience in implementing hot backup for Oracle 8i and Oracle 9i. Experience in backup and recovery on Oracle 8i/9i/9i RAC.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery RMAN
• Providing 24 7 support and maintenance of critical E-business suite production instances along with standalone Oracle production database which are being used by various application like Oracle EPM Hyperion ,Oracle Demantra and Oracle Agile.
• Monitoring of the all the above mentioned production and test instances through Oracle 10g/11g/12c grid control including Oracle E-business suite instances.
• Worked on 24/7 high availability environments.

SKILL SET

PROFESSIONAL EXPERIENCE

Confidential

Role : Team Lead, Senior Oracle Applications DBA and Oracle DBA,MSSQL DBA

Environment: Oracle Applications 11.5.10, 12.1.3, Oracle 9i/10g/11g/12c, Oracle Enterprise Manager11g and Oracle Grid cloud control 12c.

Responsibilities:

• Upgraded Oracle Applications from 11.5.10 to 12.1.3 preserving the customizations.
• Involved in Cloning and patching of oracle applications R12.
• Support and maintain Troubleshoot problems with Apache, concurrent manager, Jserv processes and various oracle application environments.
• Applying patches on Oracle E-Business suite instances to resolve application related issues like HR, Payroll and Irecruitment issues.
• RMAN cloning for the database refresh.
• Involved in SYSADMIN activities like creation of users, assigning responsibilities and administering concurrent managers.
• RMAN cloning for the database refresh.
• Performed Database Upgrade from 10.2.0.4 to 11.2.0.2
• Performed Database Upgrade from 11.2.0.3 to 12.2.0.1
• Installed and Configured Oracle grid 12c Control.
• Involved in the strategy and planning of database application for future releases.
• Involved in capacity planning and physical and logical database design
• Performance tuning of queries which is taking long time to complete.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms
• Creating tablespaces and planning the location of data, monitoring the table space growth periodically.
• Database recovery, moving data files to different locations.
• Monitoring the scheduled backups, check the backups in case of failures
• Refreshing Clone Oracle Database for testing and implementation.
• Checking the Data files Consistency using DB verify utility.
• Taking Cold Backups.
• Export/Import of Tables, Users and Databases.
• Involved the required DBA activities for Database, Application and Interaction with Oracle Developers to assist them in troubleshooting their problems.
• SQL Loader.
• Resolving issues involved with reports, concurrent managers, requests and printers
• Performed database administration and user/security management. Resolve issues related to client/server connections.
• Tuned the slow running concurrent requests and defined concurrent managers.
• Performed feasibility study and recommend pros/cons for high availability configuration including design and implementation.
• Performed Oracle E-Business environment administration and management using ad tools such as adadmin, adautocfg, adpatch, adctrl, adsplice
• Customizing autoconfig templates according to the environment requirements.
• Running autoconfig, setting up DMZ, Discoverer, Oracle Sysadmin activities and other maintenance activities
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration
• Worked on multi-node RAC DB and multi-node Mid-tier Apps.
• Performance tuning on DB and Applications.
• Complete documentation on DBA activities

Confidential

Role : Team Lead, Senior Oracle Applications DBA and Oracle DBA

Environment: Oracle E-business suite ERP 11.0.3/R12.1.1 and R12.1.3 instance with Multi node Application with 8.1.7.4 database/11g 11.1.0.7 and 11.2.0.3 databases

• Oracle E-business suite HRMS 11.5.10.2/R12.1.3 instance with Multi node applications along with 11.1.0.7 database also having the external web server on Linux DMZ server for iRecruitment.
• 8 Non- Production Instances for development,QA and UAT for ERP.
• 4 Non- Production Instances for development and testing for HRMS.
• Round robin DNS Load balancer for ERP form server.
• RMAN tape backups twice weekly full and rest of the day's incremental backups along with Archive backups with the 35 days retention period.

Responsibilities:

• Maintenance of installed Oracle Applications Release 12 suite of 3 node RAC 3 node Application TOP environment and Troubleshooting.
• Performed the cloning of Production instance for Test and Dev environment using Oracle Rapid Clone method.
• Participate in a team to maintain support multiple oracle databases and applications in high availability 24X7 heterogeneous environment
• Installed and configured the entire production database on Oracle Configuration Manager OCM in the current environment.
• Maintenance of installed 10g AS Components.
• Sysadmin, Database cloning, Patch applying, Alerts, concurrent manager and other Apps DBA functions
• Checking the concurrent manager and concurrent related activities and troubleshoot them.
• Applying latest releases of the RDBMS patches using OPatch utility from Oracle on Production and test instance to resolve few technical challenges issues.
• Perform Online Offline backups using RMAN/User Managed.
• Managing RAC nodes.
• Performance tuning Explain plan, SQL Tracing, AWR, ASH and STATSPACK .
• Defining standards for Database documentation, creating documentation of the database environment
• Troubleshooting Performance issues as reported by Clients.
• Restored and Recovered database, for missing datafiles.
• Sysadmin, Database cloning, Patch applying, Alerts, concurrent manager and other Apps DBA functions
• Checking the concurrent manager and concurrent related activities and troubleshoot them.
• Cloning of production instance on regular basis using with hot backup of database.
• Performed Oracle E-Business environment administration and management using ad tools such as adadmin, adautocfg, adpatch, adctrl, adsplice
• Backup maintenance and scheduling from Grid control.
• Implemented the monitoring scripts and setting up the alerts at Grid level.
• Preparing the Install plan/Blackout plan for Data fixes, code migrations Maintenance activities on production environments.
• Daily Monitoring I.e Health check
• Performance Tuning and tuned the complex SQL query.
• System administration functions like creating users, creating responsibilities, menus and scheduling jobs
• Space management.
• Provided 24/7 Apps DBA support and worked in the shifts
• Coordinating with Oracle support for logging tar and knowledge based search to find solution to the problems that are occurring in the live server and while applying patches tar, Bug search, and User forum participation .

Confidential

Role : Team member, Oracle Applications DBA and Oracle DBA

Environment: Oracle applications 11.5.10.2, Oracle 9i/10g, Oracle 10g/9iOAS, Solaris 9, Red Hat Enterprise Linux 4, HP-UX 11.2, RAC, Windows 2003, Grid Control, TOAD, and SQL developer.

• Cloning the production system to the target test system.
• Applying patches and solved patch related issues.
• Nightly therapeutic reboot of the production system.
• Maintaining hot backups, cold backups, and logical backups.
• Enrolling users, assigning roles and profiles, maintaining system by monitoring user access to the database.
• Managing primary database structures, resolving space and performance issues.
• Involved in SYSADMIN activities like creation of users, assigning responsibilities and administering concurrent managers.
• Applying latest releases of the RDBMS patches using OPatch utility from Oracle on Production and test instance to resolve few technical challenges issues.
• Performed the cloning of Production instance for Test and Dev environment using Oracle Rapid Clone method.
• Participate in a team to maintain support multiple oracle databases and applications in high availability 24X7 heterogeneous environment
• Applying Oracle patches using Opatch utility
• Configuring oracle 11g physical stand-by database for critical application
• Configuring RMAN backup
• Analyzing database growth and providing storage requirements whenever requested.
• Upgrade the databases from 10.2.0.x to 10.2.0.4 and apply PSU 4 and PSU 10

Oracle Applications R12 Installations:

• Installed Oracle applications R12 12.1.1 on Linux platform with multi user and multi node.

iRecruitment module implementation:

• Implemented and supporting of iRecruitment module on Oracle HRMS E-business suite instance. Also configured Resume mirror setups with the iRecruitment