SUMMARY

• Having 10+ years of experience in Administering Oracle E - Business Suite R12, 11i and also having experience on Oracle Database Administration with Exadata .
• Have a good working knowledge of Oracle Application installation on Linux Platform.
• Have worked on Oracle Application versions like 11.5.9, 11.5.10.2,12.1.3 and 12.2 Instances and Oracle Databases 9i,10g,11g and 12c.
• Worked on R12 upgrades ( 11.5.10.2 to 12.1.3 ) on all DEV, Stage and Production Instances.
• Worked on 12.1.3 to 12.2.4 upgrades.
• Worked on E-Business suite upgrades from 11.5.10.2 to 12.1.3 and 12.2.5. Patching, Cloning and Oracle 11i applications Maintenance activities using ad utilities.
• Successfully implemented R12 Production Upgrade go-live Instance.
• Installed Oracle Warehouse Builder and Oracle Thesarus Management System.
• Worked on Exadata Machines (Quarter RACK, Half Rack, Full RACK), applied PSU Patches and maintained them successfully.
• Worked on Grid Patching.
• Setup, support and manage Oracle E-business Suite applications and databases in production, test and development environments
• Establish and maintain sound backup and recovery policies and procedures using RMAN
• Performed health checks and proactive monitoring using Oracle Enterprise Manager/Grid Control and UNIX shell scripts
• Administering and troubleshooting of 11g Oracle Fusion Middleware products Weblogic, SOA and ADF.
• Applying patches to Oracle Fusion Middleware products SOA, OID, OIM, OAM, and OBIEE.
• Good experience using OEM 12c for Database Performance Monitoring and Tuning.
• Having work experience on Fusion middleware products like WebLogic 11g and SOA installations, deployments.
• Enabled new language Czech on all DEV, stage and Production instances.
• Proactively Developed few shell scripts as per client’s requirement and scheduled them on the cronjobs.
• Worked on ASM, RAC Instances.
• Worked on DMZ’s.
• Performed Reorg of Databases through OATM on all DEV, Stage and Production instances.
• Familiar with Discoverer and Workflow configurations.
• Troubleshootingthe concurrent managers, Apache and Discoverer issues.
• Upgraded Databases from 10g to 12c.
• Worked on rebuilding the DR.
• Provided technical support to development team for database issues .
• Used Oracle Utilities like export/import.
• Done Restorations of Database through Tape and Disk.
• Worked on Oracle Enterprise Manager 12c
• Performed package migrations through Kintana Tool.
• Provided technical support to Development team for database issues.
• Set up and documented standards and policies for database and E-business suite Upgrades.
• For the unusual growth of Sysaux tablespace, prepared a document and a way to reduce the tablespace growth and performed on all the Instances including Production.
• Worked on Oracle Public Cloud Instances used lift and shift, OTD and SSH tunneling applications.
• Worked on Patching, Application cloning, patch analysis, backups, RMAN, restorations (tape, disk).
• Performance monitoring and tuning Applications and Databases on timely basis.
• Continuous review of Business critical Database to proactively identify space issues, performance tuning issues
• Experienced in tuning of ERP jobs, time/CPU consuming SQL Queries
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements

PROFESSIONAL EXPERIENCE

Confidential - Lehi, UT

Oracle Applications DBA - Support

Responsibilities:

• Migration of Oracle Databases into AWS EC2 Instances of versions 12.1.0.2, 11.2.0.4
• Used Transportable tablespaces for migrating Oracle to AWS from Big Endian to Little Endian .
• Troubleshooting the concurrent issues, database issues and performance issues .
• Renewed the Certficates on all the Database, Applications ( E-Business Suite and Weblogic apache ) .
• Involved in Datacenter migration of Oracle Database and Oracle applications, weblogic and Sabrix Instances .
• Building the Development, Stage and Production Instances in Datacentre migration into AWS GP2 .

Environment: EBS R12 with 11gR2 RAC, OEL 6.5, OEL 6.6

Confidential - Ashburn, VA

Oracle Applications DBA - EBS Implementation & Support

Responsibilities:

• Installed Multi-Node E-Business Suite 12.2 release for RAC and NON-RAC databases
• Performed Complete Server Validation which includes validating OS, File Systems, Network and firewall rules
• Maintain 11gR2 Grid Infrastructure for RAC databases
• Upgraded Grid Infrastructure from 11.2.0.3 to 11.2.0.4
• Upgraded RAC Databases from 11.2.0.3 to 11.2.0.4
• Upgraded E-Business Suite from 12.2.3 to 12.2.5
• Memory Management across all the environments.
• Cloning of 12.2 application file system from multi-node to multi-node and to single-node.
• Patch Management using ADOP, OPATCH utilities for Oracle E-Business Suite releases

Environment: EBS R12 with 11gR2 RAC, OEL 6.5, OEL 6.6

Confidential - CA

Lead Oracle Applications DBA

Responsibilities:

• Implemented PCP
• Worked on Exadata hosts ( Half Rack, Full Rack and Quarter Rack )
• Worked on Exa move Activities.
• Worked on E-Business suite upgrades from 11.5.10.2 to 12.1.3 and 12.2.4. Patching, Cloning and Oracle 11i applications Maintenance activities using ad utilities.
• Worked on R12 upgrades ( 11.5.10.2 to 12.1.3 ) on all DEV, Stage and Production Instances
• Worked on 12.1.3 to 12.2.4 upgrades.
• Good experience using OEM 12c for Database Performance Monitoring and Tuning.
• Worked on Oracle Public Cloud Instances.
• Worked on Oracle Enterprise Manager 12c
• Patch Application on all DEV, UAT, QA instances.
• CPU Patching applied on all the DB and application instances on quarterly basis.

Environment: EBS R12.2, 12.1.3 with DB 12C, 11gR2 RAC on Exadata Machines, Red Hat Linux

Confidential

Responsibilities:

• Worked on Exadata hosts ( Half Rack, Full Rack and Quarter Rack )
• Worked on Exa move Activities.
• Applied patches to Oracle Fusion Middleware products SOA, OID, OIM, OAM, OBIEE
• Good experience using OEM 12c for Database Performance Monitoring and Tuning.
• Worked on Oracle Public Cloud Instances.
• Worked on Oracle Enterprise Manager 12c
• Installation & Configuring domains for Fusion Middleware like Weblogic, SOA
• Administering and troubleshooting of 11g Oracle Fusion Middleware products Weblogic, SOA, and ADF
• Performed Pre Patch Analysis on the CPU Patches on all the modules that we have like Database Machines, EBS, SOA, Weblogic, OIM, OAM, OBIEE etc
• Performed CPU Patching on quarterly basis on the Exadata Database Machines, EBS, SOA, Weblogic, OIM, OAM, OBIEE etc

Environment: EBS 12.1.3 with DB 12C, 11gR2 RAC on Exadata Machines, Red Hat Linux

Confidential - Albany, NY

Lead Oracle Applications DBA

Responsibilities:

• Performed R12 upgrades from 11.5.10.2 to 12.1.3
• Installed OFSAA Application on Unix Environment using GUI
• Performed POC for OFSAA versions 7.3 on Exadata and Unix Platforms.
• Worked with Oracle Support for the Installation and Configuration issues on OFSAA.
• Performed patch analysis and applied patches on all DEV, stage and production instances.
• Performed CPU Patching
• Performed Re-orgs on all DEV, stage and production instances through OATM
• Interacted with the Development and resolved many issues proactively
• Performed cloning on 12.1.3 Instances.
• Familiar with merging of patches using admrgpch.
• Performed Database upgrades from 10g to 12c

Environment: EBS 11.5.10.2, 12.1.3 with 11GR2 NON - RAC, Sun Solaris

Confidential

Responsibilities:

• Involved in code migrations
• Patch Application on all DEV, UAT, QA instances.
• Cloning of Oracle E-business suite 12.1.3 using rapidclone.
• Performed sysaux rebuild on all DEV, QA and UAT instances.
• Performing Pre Patch Analysis for all the patches that needs to be applied.
• Changed the Profile options in Site/Responsibility/Application/User Level.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Granting and Revoking Privileges/Roles from Users.
• Changed the configuration Parameters as per the Customer requirement and Bouncing Applications /Database if need.
• Troubleshoot Apache issues.
• Installing required rpms for server configuration.
• Making certain changes in files related to discoverer server.
• Application user creation / responsibilities assignment
• Administering concurrent managers
• Regular system health checkups
• Monitoring alert log and trace files.
• Monitoring Alerts and table space growth proactively.
• Performing regular backups.
• User access control and administration.

Environment: EBS 12.1.3 with 10G NON - RAC, Sun Solaris

Confidential

Team Member

Responsibilities:

• Monitoring the Instance
• Checking the alert logs
• Patch Application on Production as well as Development and test instances.
• Cloning of Oracle E-business suite 11.5.10.2 using rapid clone.
• Concurrent Manager monitoring and administration
• Patch Impact Analysis and patch management.
• Done Kintana Migrations and Sysadmin Activities
• Regular health checkup of database including space management.
• Backup’s including cold, hot and RMAN backup. worked as a part in the upgradation of the Database from 9i to 10g
• Done database restoration from Tape Backup

Environment: EBS 11.5.10.2 with 10G Non RAC, IBM OS and Sun Solaris

Confidential

Team Member

Responsibilities:

• Changed the Profile options in Site/Responsibility/Application/User Level.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Granting and Revoking Privileges/Roles from Users.
• Changed the configuration Parameters as per the Customer requirement and Bouncing Applications /Database if needed.
• Troubleshoot Apache issues.
• Installing required rpms for server configuration.
• Making certain changes in files related to discoverer server.
• Application user creation / responsibilities assignment
• Customization Updates and working on Code promotions
• Administering concurrent managers
• Managing Forms, Report Servers and Web Servers
• Regular system health checkups
• Monitoring alert log and trace files.
• Monitoring Alerts and table space growth proactively.
• Performing regular backup’s.
• User access control and administration.

Environment: EBS 11.5.10.2 with 10G Non RAC, Sun Solaris