Oracle Apps

Prashant Pahune

510-***-****, Fremont, CA

Oracle DBA, EBS DBA, Fusion Middleware DBA

********.******@*****.***

IT professional with 12 years of industry experience in Oracle Database Administration 12c/11g/10g/9i/8 and system administration experience in different environments like Linux, HP-UX, AIX, Sun Solaris and Windows.

More than 11 years’ experience as Oracle Apps DBA in installation & implementation of 11i & R12, upgrade, cross platform migration and shell scripting.

Has over 5 years’ experience as Oracle Fusion Middleware DBA in installation & support of Fusion Apps and Fusion Middleware products like Weblogic, SOA Suit, Webcenter, 11g Forms & Reports, OBIA, Discoverer, Primavera, Identity and Access Manager, OTM, etc

Extensive experience in Installation, Migration, Database Upgrade, Backup and Recovery, DR, RMAN, ASM, 10g RAC administration, data pump, performance tuning of Oracle Database.

Expert in Oracle Apps Patching (adpatch and adop), adutilities, autoconfig, sysadmin, parallel concurrent processing, workflow mailer and OAM administration.

Expert in Cloning EBS Application 11.0.3, 11.5.5, 11i, R12 using manual, adclone and rapidclone method.

Working on POC to upgrade oracle Apps 11.5.10.2 to 12.2.5.

Well-versed with routine database management tasks including user, space and resource management and Network connectivity

Experienced in migration of Oracle Apps 11.5.10.2 from HP-UX single node to Linux multi node shared APPL_TOP environment.

Expert in Oracle Apps upgrade from 11.5.10.2 to 12.1.3.

Expert in Installation of Oracle Fusion Applications 11.1.9.2.

Has implemented DMZ, DR in Oracle Apps 11.5.10.2.

Has Implemented RAC ASM to RAC ASM and RAC ASM to Non RAC Non ASM cloning for Oracle Apps 11.5.10.2.

Has experience of upgrading Oracle Discoverer from 10g to 11.1.1.7.

Expert in performance tuning, creating and importing stored outline using SQLT.

Experienced in managing OLTP databases in a 24X7 production environment.

Expert in using tools such as OEM, SQL* Loader, TOAD.

Expert in managing monthly release and production outages.

Worked on Markview Upgrade from 5.1 to 7.1.3.

Experienced in troubleshooting and decision making knowledge on mission critical issues.

Professional Certifications:

Oracle Certified Professional - Oracle9i, 10g, 11g DBA Track.

Oracle E-Business Suite R12 Applications DBA Certified Professional.

Oracle RAC 11g Release 2 and Grid Infrastructure Administrator.

Oracle 12c Implementation Specialist.

Oracle Certified Associate, Oracle WebLogic Server 11g System Administrator

ITIL® V3 Foundation Certified

Technical Skills:

Applications: Oracle Applications release 12.2.5. 12.1.3, 11.5.10.2, 11.5.9, 11.5.8, 11.5.5, 11.0.3 & Fusion Apps 11.1.9.2.

RDBMS: Oracle database 12c/11g/10g/9i/8

Webserver: Oracle web tier, nginx

Fusion Middleware: Weblogic, Forms and Reports, Discoverer, OTM, Primavera, Identity and Access Management, SOA Suit, OBIA

Programming: UNIX/Linux Shell scripting, SQL

Tools and utilities: SQL*Loader, OEM, ADDM, RMAN, SRVCTL, DBCA, Toad, SQL-Developer, RDA, SQLT, Export/Import, Data pump, Clarify, Kintana, Borland, HPSC, etc

Operating Systems: RedHat Linux 2.1, 3, Oracle Enterprise Linux 5.4, UNIX (HP UX 11), Solaris 5.8, MS-WINDOWS XP/2000, MS-WINDOWS NT

Professional Experience:

Skoruz Technologies, Fremont Feb 2016 to Present

Position: Senior Oracle DBA

Responsibilities:

Working on POC to upgrade oracle Apps 11.5.10.2 to 12.2.5.

Completed installation of nginx and created site for static content for one of the internal project.

Working closely with development team to resolve issues they are facing.

Working on shell script writing for automating dba jobs like database recovery while cloning, managing errors in alert log, backup scheduling, etc.

Working on installation of 12c grid infrastructure and RAC.

Completed Apex deployment training from skillbuilders.

Environment: OEL 6.5, centos 6 & 7, nginx, Oracle Apps 11.5.10.2, 12.2.5, Weblogic 12c.

Steria India Limited, Pune Feb 2007 to Jan 2016

Client: British Telecom, UK

Position: Lead Oracle Apps DBA.

Responsibilities:

Managed routine task like cloning, patching, day to day issues of Oracle Apps 12.1.3.

Was Active Member of team who has migrated Oracle Apps 11.5.10.2 from HP-UX 11.11 to OEL 5.4 from single node to multi node with shared APPL_TOP architect.

After Migration implemented cloning methodology from RAC ASM to RAC ASM and RAC ASM to NO RAC NO ASM database.

Successfully implemented and tested DR for Oracle Apps 11.5.10.2.

Implemented Apps password change policy in very complex application of BT which has interface to many other applications via apps user.

Implemented punch-out ssl certificates and also csi keystore certificate for HMRC.

Created new custom top as per client’s requirement.

Implemented housekeeping strategy which was recognized by BT as the best housekeeping activity among all BT vendors.

Worked on POC to upgrade Oracle forms & reports from 6i to 11.1.2.

Completed Discoverer migration and upgrade from 10gAS to FMW 11.1.1.7 with proxy setup independently.

Was managing Oracle Apps 11.0.3 independently even without Oracle Support.

Tested DR for Oracle Apps 11.0.3 and changed SID of it Manually after DR.

Solely member from dba pool who was managing changes end to end, right from raising RFC to production implementation and complete release planning.

Worked on performance tuning issues of Hyperion Database after upgrade to 10gR2.

I was leading team of 4 DBA and managing client escalations if any.

Used to attend weekly client calls to get client requirements, escalation management and providing updates on service impacting issues.

Only member from DBA pool who has upgraded Markview from 5.1 to Markview 7 which is deployed on Weblogic with the help of Markview Functional consultant.

Raising and updating SR and OWC if required with Oracle.

Analyzed and implemented quarterly Oracle CPU.

Worked on Oracle Apps 11.5.9 cloning using rapid clone.

Used clarify for change and incident Management.

Used Kintana and Hudson for deployment.

Performed import/export, schema refreshes from production to test Hyperion servers.

Extensive use of SQLT to tune Fixed Asset queries while its implementation in Oracle Apps 11.5.10.2

Has attend training of MarkView Installation and configuration.

Environment: OEL 5, HP-UX 11.11, MS-WINDOWS XP/2000, MS-WINDOWS NT, Oracle Apps 12.1.3, 11.5.10.2, 11.5.9, 11.5.5, 11.0.3, Discoverer, Weblogic, Markview, Oracle Database 8.1.7, 9.2.0.7, 10.2.0.5, Export/Import, OEM, Shell script, Weblogic, Kintana, Hudson, Clarify, RMAN, SRVCTL, SQLT

Steria India Ltd., Pune Apr 2013 to Jan 2016

Position: Lead Apps DBA and Fusion Middleware DBA.

Responsibilities:

Completed Installation and documentation of Oracle Fusion Apps 11.1.9.2, Oracle R12.2.4, OTM, Primavera, Webcenter, SOA suit and FMW forms & reports 11.2.0.

Applied application patches using adpatch and adop.

Completed Oracle Apps Upgrade from 11.5.10.2 to 12.1.3.

Worked with internal development and functional team to resolve issues faced by them for above products.

Environment: OEL 5, WINDOWS 8, Oracle Apps 11.5.10.2, 12.1.3, 12.2.4, Oracle database 11.2.0, Identity and Access Management, Oracle Fusion Apps, OTM, Primavera, Webcenter, SOA suit and FMW forms & reports 11.2.0

Steria India Limited, Pune Jun 2014 to Sept 2014

Client: Tesco Stores Limited, Welwyn Garden City, UK

Position: Lead Oracle Apps DBA.

Responsibilities:

There were performance issues with sellers’ application. Provided recommendations for performance improvements and for reduction of CEMLI’s with the help of technical solution architect.

Received Super Trooper award for this project.

Environment: Oracle Applications 12.1.3, Oracle Database 11.2.0.4 and Linux 5.

Steria India Limited, Pune Jun 2011 to Mar 2013

Client: Ministry of Justice, Newport, UK

Position: Senior Oracle Apps DBA.

Responsibilities:

Worked on Installation and documentation of Oracle Apps 12.1.3, ECM, Experian, GRCM, OBIEE, Hyperion, ODC, ODDC, OFR, UPK, Webcenter, Weblogic and Apex.

Has written shell scripts for silent installation of Weblogic and RCU.

Has worked on Patch application to resolve various functional and technical issues.

Worked on cloning Oracle e-business suit as per requirement of development team.

Worked with Development and Functional team to resolve their issues.

Environment: Oracle Applications 12.1.3, ECM, Experian, GRCM, OBIEE, Hyperion, ODC, ODDC, OFR, UPK, Webcenter, Weblogic, Apex, Oracle Database 11.2.0.4 and Linux 5, Windows Server 2010.

Spider Systems Pvt. Ltd., Pune Aug 2006 to Feb 2007

Position: Oracle Apps DBA Consultant.

Responsibilities:

Visited Gati Ltd. Secunderabad for Oracle apps database administration.

Member of Oracle Apps 11.5.9 implementation team in Privi Organics Ltd. Mahad

Installed Oracle Apps 11.5.9 in Symbiosis, Hinjewadi Pune.

Visited TATA TOYO recover database on Windows NT corrupted by Dr. Watson error and SAP Database patch-set up-gradation from 9.2.0.4 to 9.2.0.7.

Supported various clients of SSPL such as Thermax, Honeywell, KPCL, PTC, eGain, EBZ, Rucha Industries, Cosmo films, Spicer India Ltd., Approva pvt. Ltd., DaimlerChrysler India Pvt. Ltd., Pune Cantonment Board, Indian card clothing Co. Ltd., DGP Hinoday to address issues related to Database & Application.

Environment: RHEL 3, Solaris 5.8, Windows NT, Oracle Apps 11.5.9, Oracle Database 9i, 8.1.7, RMAN, TOAD.

Spider Systems Pvt. Ltd., Pune Jul 2005 to Aug 2006

Client: TACO – IPD, Hinjewadi, Pune

Position: Oracle Apps DBA Consultant

Responsibilities:

Implemented Oracle applications cloning process using rapidclone.

Worked on sysadmin activities like creating menus and attaching it to responsibility, defining users, creating program for customize reports.

Printer management using Webmin

Weekly hot Backup on Ultrium using Tivoli.

Restoration and recovery of hot backup on weekly basis. Database cloning using this hot backup.

Rebuilding of Indexes, running cmclean.sql, deleting trace files and trimming of logs after cold backup.

Raising and handling SR with Oracle.

Monitoring of alert log and size of tablespaces (resizing or adding new data file if required), compressing and moving archives, Purging requests and all and etc.

Activities completed:

Upgraded India localization patchset from IN60105D2 to IN60106.

Operating system migration from Linux A.S. 2.1 to Linux A.S. 3.0.

Single node to Dual Node Migration of Oracle Apps.

Changed the Domain name of Server using autoconfig and editcontext.

RMAN Implementation for Tivoli.

Installation of Linux AS 3.0.

Application of 9.2.0.7 database patch set.

Environment: Linux AS 2.1, 3.0, Oracle Apps 11.5.9, Oracle Database 9.2.0.7, Statspack, RMAN, Tivoli, India Localization

Spider Systems Pvt. Ltd., Pune Mar 2005 to Jun 2005

Client: Idea Cellular Ltd, Pune

Position: Oracle Apps DBA Consultant

Responsibilities:

Performed routine maintenance activities such as checking alert log and taking relevant action.

Performed routine sysadmin tasks such as creating and managing users, defining and attaching responsibilities

Database cloning.

Raising and handling SR.

Applying the patches to resolve Bugs.

Environment: HP-UX 11i, Oracle Apps 11.0.3 and Oracle Database 8.1.7

Spider Systems Pvt. Ltd., Pune 18 June 2005 to 21 June 2005 and 11 May 2005 to 21 May 2005

Client: GATI Ltd, Secunderabad

Position: Oracle Apps DBA Consultant

Responsibilities:

Performed Oracle Apps Database upgrade of production instance from 8.1.7 to 9.2.0.6.

Addressed connectivity issues between different remote databases cropped up after Database upgrade by creating DB Links.

Applied patches to fix issues after database up-gradation.

Performed cloning of Oracle Apps 11.5.9 using Rapid Cloning before starting upgrade of test database.

Environment: Solaris 5.8, Oracle Apps 11.5.8 and Oracle Database 9.2.0.6, 8.1.7

Spider systems Pvt. Ltd., Pune Jan 2005 to Mar 2005

Position: Oracle Apps DBA

Responsibilities:

Was responsible for managing more than 20 training Oracle apps 11.5.9 servers.

Performed installation of Discoverer, Forms and reports, Toad, 9i Client on Client Computers of trainees.

Completed installation of 11.5.9 (vision demo) on Linux AS 3.0

Worked to resolve issues faced by of trainees.

Environment: Linux AS 3.0, Oracle Apps 11.5.9, Oracle Database 9.2.0.3, Toad.

Spider Systems Pvt. Ltd., Pune Jun 2004 to Jan. 2005

Client: Deepak Nitrite Ltd., Pune

Position: Oracle DBA

Responsibilities:

Worked on routine activities like creating and managing tablespace, rollback segments, Data files, Creating and managing users, granting privileges and roles.

Worked on routine monitoring activities like checking of all the log files and trace files on regular basis.

Environment: sco-unix open server 5.5 and Oracle 7.3.4

Education:

Bachelor of Engineering from Nagpur University, India. 2004

PG Diploma in Information Technology from Symbiosis Center for Distance Learning, Pune.

Completed basic German language course.

Achievements:

Received Super Trooper Award for Tesco Project.

Received star performer and Pat on Back awards in Steria.

Four Times selected as a Fast tracker employee in Steria for years 10-11, 11-12, 13-14 and 14-15.

Consistent A and A+ rank in Steria.

Received Black belt certificate from Centre for Leadership Development.

Contact this candidate