SUMMARY

• Oracle Certified Professional (OCP) 11g and Oracle RAC 11g Expert (OCE)
• Oracle Certified E - Business Suite R12 Applications DBA
• Up-gradation and vanilla Installation of Oracle Apps 11i, R12.1.3, R12.2.3 & R12.2.4
• Installation/setup of Oracle RAC 10g/11g/12c, EBS R12.1.3/R12.2, SOA 10g, AIA 2.5, ODI, OBIEE 11g, OBIA 7.9.6.3, OEM 12c, FMW components.
• Installation and up-gradation of database from 9i to 10g R2, 10g to 11g, 11g to 12c
• Experience in Oracle Applications 11i/R12.1.3 and R12.2 DBA activities like online patching (ADOP), R12.2 cloning process and WebLogic Administration.
• Good database concepts; worked on 8i, 9i, 10g, 11g & 12c RAC, ASM, RMAN
• Good Real Application Cluster (RAC) 10g, 11g, 12c concepts including Cluster Installation and setup.
• Cloning and Patching experience on Apps version 11i, R12.1.3 & R12.2
• Oracle Applications 11i, R12 Platform migration from HP-UX, Linux to IBM AIX and vice-versa.
• Backup and Recovery of the Oracle Databases by RMAN, Data Pump.
• Application’s sysadmin tasks like creating and managing users and their responsibilities
• Automation of complex jobs using Shell scripting creation, edition and cron job setting
• Writing on personal technical blog site www.expertoracle.com to share technical knowledge

TECHNICAL SKILLS

Operating System: HP-UX UNIX, IBM AIX 5.3/6.1, Linux (RHEL v5.6/5.8/6.4, OEL v5/v6, Novell SUSE), SCO UNIX, Solaris 10, Windows 98/XP/Vista/7/8, OEL 5.8 on Exadata/Exalogic

Applications: Oracle Applications versions 11i (11.5.10.2, 11.5.9, 11.5.8), R12.1.1, R12.1.3, R12.2, Oracle Database v8i/9i/10g/11g/12c, RAC 10gR2/11gR2/12c, OBIEE 11.1.1.6/.7 , SQL*PLUS, SQLNet

Languages: SQL, PL/SQL, C, Shell Scripting, HTML

Tools: OEM 11g/12c, TOAD, SQL Developer, ITG Kintana, BMC Remedy, AD tools, Putty, HP open View, HP Chainlink, Noetix, Appworx Application Manager, Dreamweaver CS, Wordpress

PROFESSIONAL EXPERIENCE

Confidential

Oracle Application DBA

Responsibilities:

• Upgrading EBS 11i on Solaris to R12.1.3 on Exa Stack and EBS R12.1.3 on Solaris to R12.2.4 on Exa Stack
• Upgrading Non-RAC Solaris databases to RAC Exadata.
• Database upgrade for EBS 11i/R12 from different lower release to 11.2.0.4
• Online Patching R12.2.3 with ADOP tool, Patching 11i, R12.1.3 with adpatch
• Cloning of R12.2.4 application and the database by using Rapid Clone (Hot backup & RMAN cloning, RAC/ASM, Active database cloning)
• Oracle EBS 11i/R12 Cloning for RAC to RAC, RAC to NON-RAC and RAC ASM to NON-RAC NON-ASM
• Providing 24*7 continuous EBS Application (11i, R12.1.3 & R12.2.4) and Database stability and availability for 35 Production and ~300 Non-Production EBS instances
• Setup and maintenance of OEM 12c
• Oracle Application Sysadmin works (Managing concurrent process, Creation of User, Responsibility, installation of Printer, registration of new application, Monitoring user activity, Profile option setting)
• Supporting/Maintaining ASCP and Demantra instances.
• Supporting Informatica ILM Smart Partitioning and other third party softwares like HP Chainlink, Clearcase, Noetix, Appworx Application Manager etc
• Provided trainings on Oracle EBS / Oracle databases and associated technologies.

Confidential

Oracle Application DBA

Responsibilities:

• Oracle Applications R12.1.3 installation and configuration.
• EBS database upgrade from 11.1.0.7 to 11.2.0.3
• Real Application Cluster (RAC) 11.2.0.3 and GRID Architecture, setup, Configuration, and Administration with ASM as storage
• Governance, risk management, and compliance (GRC) and CCG installation and configuration
• OEM 12c installation and configuration
• Supporting OAM/OID 11g instances.
• Scheduled and non-scheduled backups of all databases using RMAN
• Weekly Cloning of application and the database by using Rapid Clone (Hot backup & RMAN cloning, active database cloning)
• Application and Database Patch analysis and applying application/language patches
• Daily code migrations to various instances.
• Performance tuning activities related to application/database/concurrent requests
• Oracle Application Sysadmin works (Managing concurrent process, Creation of User, Responsibility, installation of Printer, registration of new application, Monitoring user activity, Profile option setting)
• Oracle UPK setup and configuration work

Confidential

Oracle Application DBA

Responsibilities:

• Oracle Applications R12.1.3 installation and configuration.
• EBS database upgrade from 11.1.0.7 to 11.2.0.3
• Service Orientated Architecture (SOA) 10g installation
• Oracle Data Integrator (ODI), AIA 2.5 with EBS-Retail PIP installation
• UC4 (Appworx) application manager installation and configuration of remote agents
• Scheduled and non-scheduled backups of all databases using RMAN
• Cloning of application and the database by using Rapid Clone
• Application and Database Patch analysis and applying application/language patches

Confidential

Oracle Application DBA

Responsibilities:

• Upgradation of Oracle EBS 11.5.9 to R12.1.3.
• Upgradation of Oracle Database version 9.2.0.7 to 11.2.0.3.
• Migration of Non-RAC Database to RAC
• Migration of Database from Cooked file system to ASM file system
• Migration of complete setup from IBM-AIX to LINUX (RHEL v5.6)
• Cloning of application and the database by using Rapid Clone
• Scheduled and non-scheduled backups of all databases using RMAN
• Application and Database Patch analysis and applying application/language patches

Confidential

Oracle Application DBA

Responsibilities:

• Providing 24*7 continuous EBS Application 11i and Database stability and availability for 3 production and 12 Non production instances, with maximum database size of 1 TB
• Cloning of application and the database by using Rapid Clone (Hot backup & RMAN cloning, RAC, ASM cloning)
• Platform migration of Application EBS 11i and Database 10g from Red Hat Linux/HP-UX to AIX 6.1
• Oracle Apps 11i Baseline Patching
• Application and Database Patch analysis and applying application/language patches on the RAC/Non-RAC Instances and in shared APPL TOP environment
• Oracle Application Sysadmin works (Managing concurrent process, Creation of User, Responsibility, installation of Printer, registration of new application, Monitoring user activity)
• Database Backup and Recovery (RMAN/Export/Import/Data Pump
• Regular performance tuning activities involving database/EBS application.

Confidential

Oracle Application DBA

Responsibilities:

• Providing 24*7 continuous EBS Application (11i) and Database stability and availability for
• 17 Production instances with maximum OLTP database size of 5 TB
• 150+ Non-Prod instances
• Cloning of application 11i and the database by using autoconfig (Hot backup & RMAN cloning, RAC, ASM cloning)
• Application and Database Patch analysis and applying application/language patches on the RAC/Non-RAC Instances and in shared APPL TOP environment
• Upgrading the Database from 9.2.0.7 to 10g R2
• Oracle Application Sysadmin works (Managing concurrent process, Creation of User, Responsibility, installation of Printer, registration of new application, Monitoring user activity, Profile option setting)
• Day to day working with 10g Real Application Cluster (RAC) on ASM
• Database Backup and Recovery (RMAN/Export/Import/Data Pump)
• Migrating DB objects from Test to Production as necessary in Change Management.
• Database Performance monitoring and managing all aspects of Oracle applications and oracle database (space, users, growth, response, throughput, instance performance, Concurrent Manager tuning)
• Troubleshooting forms server, Apache server, Concurrent Manager, Workflow issues

Confidential

Oracle Database Administrator

Responsibilities:

• Database Installation and application of RDBMS Patches
• Month end and quarter end support
• Database administration, managing tablespaces, objects, disk space
• Maintaining archived data on tape
• Performance tuning of the software both in terms of Oracle and the ISBS package itself
• Handling critical situations like server/database crash