Professional Experience Summary

Having **+ years of experience in Administering Oracle E-Business Suite R12, 11i and also having experience on Oracle Database Administration with Exadata .

Previously worked with ORACLE Corporation, GENPACT, Tata Consultancy Services .

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.

Troubleshooting the 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

Education:

Bachelor of Technology, Computer Sciences, JNTU.

Professional Membership /Certification

Professional Society / Certification

Member Since / Date Certified

OCA in 10G

2007 May

OCA Oracle Web logic Server 11G System Administrator

2014 Feb

Client : Century Link ( Virginia )

Environment : EBS R12 with 11gR2 RAC

Operating Systems : OEL 6.5, OEL 6.6

Role : Oracle Applications DBA - EBS Implementation & Support

Duration : May 2017 – Till Date

Description:

CenturyLink (NYSE: CTL) is a global communications, hosting, cloud and IT services company enabling millions of customers to transform their businesses and their lives through innovative technology solutions. CenturyLink offers network and data systems management, Big Data analytics and IT consulting, and operates more than 55 data centers in North America, Europe and Asia. The company provides broadband, voice, video, data and managed services over a robust 250,000-route-mile U.S. fiber network and a 300,000-route-mile international transport network .

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

Organization : ORACLE Corporation

Client : Rochester Institute of Technology

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

Operating Systems : Red Hat Linux

Role : Lead Oracle Applications DBA

Duration : Dec 2015 – Mar 2017

Description:

Rochester Institute of Technology is a private doctoral university within the town of Henrietta in the Rochester, New York metropolitan area. RIT is composed of nine academic colleges, including National Technical Institute for the Deaf .

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.

Organization : ORACLE Corporation

Client : Merck & Co, and Rochester Institute of Technology(California)

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

Operating Systems : Red Hat Linux

Role : Lead Oracle Applications DBA

Duration : Dec 2014 – Dec 2015.

Description:

Merck & Co. stays competitive by making timely acquisitions, taking part in joint ventures with other major pharmaceutical players and continually researching to create the next blockbuster drug.Merck & Co.Merck employs 69,000 people. Its pharmaceutical division creates products like Singulair (for asthma) and NuvaRing (for birth control).

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

Organization : GENPACT

Client : Commercial Finance ( GE )

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

Operating Systems : Sun Solaris

Role : Lead Oracle Applications DBA

Duration : Jun 2011 To Nov 2014

Description :

GE Commercial Finance was a unit of GE Capital (one of five major operating divisions of General Electric). As part of GE Capital, it offers products such as revolving lines of credit, floorplan finance, equipment leasing of various forms, real estate services, and car fleet management. The industries served include healthcare, manufacturing, fleet management, communications, construction, energy, aviation, infrastructure and equipment, as well as many others. Operations of GE Commercial Finance were eventually merged directly into GE Capital.

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

Organization : GENPACT

Client : Vetco Gray ( GE Oil and Gas)

Environment : EBS 12.1.3 with 10G NON - RAC

Operating Systems : Sun Solaris

Role : Team Member

Duration : Sep 2010 To May 2011

Description:

GE Oil & Gas offers VetcoGray equipment and services for onshore and offshore drilling and production. With over a century of experience in the oil and gas industry, VetcoGray can offer, through a single interface, customized or standardized solutions to meet the needs of any drilling and production project from concept to full production. The product offering covers the spectrum from single well onshore drilling projects to multiple well deepwater facilities and subsea production systems.

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.

Organization : TATA CONSULTANCY SERVICES

Client : Ingersoll Rand - Ireland

Environment : EBS 11.5.10.2 with 10G Non RAC

Operating Systems : IBM OS and Sun Solaris

Role : Team Member

Duration : Dec 2007 to Sep 2010

Description:

Ingersoll Rand is composed of a diverse array of business and market-leading brands serving customers in global commercial, industrial and residential markets.

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

Organization : TATA CONSULTANCY SERVICES

Client : Earth Tech, USA ( New Jersey )

Environment : EBS 11.5.10.2 with 10G Non RAC

Operating Systems : Sun Solaris

Role : Team Member

Duration : Jan 2007 To Nov 2007

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.

Appreciations from Client

Received appreciation mails from the clients for R12 upgrade go-live.

Received appreciation mails for proactively handling a major production crash

Prepared a sysaux rebuild doc which saved more than 50% free space and the same was used across all our environments and received appreciation.

Contact this candidate