Prashant Pendurkar

Project details- Migrate, Maintain Ebs 12.2.6 with 12c database from on-prem to cloud iaas. Tuning& enhancing database performance. Implement Obiee and physical standby.

Position -Manager

System details-EBS R12.2.6 on RHEL linux with 12c Database RHEL OS . with physical standby database

Company profile: Company is a Fortune 500 company headquartered in Inverness, Colorado. The company specializes in distribution, Value added services relating to electronic components, computer products to industrial and commercial users of electronic components and enterprise computing.

Role: Associate Manager (leading a team of 5 arrow dba’s and 30+ consultants)

Projects-Project 1 :VAS (value added services) - R12.2.5 on linux with 12c database on linux

Project 2: ECS(Enterprise Computing service)-Ebs 12.2.8 on linux with 12.1.0.2 RAC on AIX

Project 3 :GFS (Financial system) -11.5.10.2 on linux with r12c database on AIX

Project Details-

Project-name

Value Added Services Project(Implementation+Support)

Implement Value added services on products bought from its manufacturers.

Position -Associate Manager

System details-EBS R12.2.6 on RHEL linux with 12c RAC Database on RHEL OS with Base English and Spanish language , with SOA(10gAS), OBIEE, OAM, OID

Responsibilities -

Ø Installation and setup/Capacity planning for Ebs R12 with 11g database having 4 middle tiers with PCP.

Ø Implementing Fusion components like IDM, OAM to integrate with EBS using OVD, OIM

Ø Installation of 10g SOA, OBIEE.

Ø Upgrade ebs from R12.1.1 to R12.1.2 to R12.1.3 to R12.2.5

Ø Database upgrade from 11g to 12c to 19c.

Ø Implemented GoldenGate for critical schemas.

Ø Installation and setting up Spanish language

Ø Performance Tuning on Instance level, ebs level.

Ø Weekly study of awr done and sql are tuned manually or using grid.

Ø Sql profiles implemented for Conc programs having sql with bad plans.

Ø Configure & manage RMAN full and incremental backups .

Ø Automate cloning procedures

Ø Coordinate regular tasks like patching, cloning,health checks

Ø Installation of grid control for monitoring.

Ø Scripts put on the server for monitoring , absolutely 0 manual monitoring done…saving dba time.

Enterprise Computing services ECS(Implementation+Support)

Project Details-Bussiness deals with Components and its process right from its suppliers to buyers.

Position -Lead-Oracle Apps Database Administrator

System Detail -

Ebs R12..2.8 on(linux) with 12.1.0.2 database on AIX with RAC & with 11g(SOA, PORTAL, SSO/OID), Markview , Application Express Instances. ,OAM11G, 12c OBIEE, ODI

Responsibilities

Ø Installation and setup/Capacity planning for EBS R12 (on linux) with R12.1.0.2(AIX)

Ø Integration with OAM11g,11g Soa, SSO/OID,Portal, Markview and Application Express.

Ø Cluster & Database upgrade done from 10g to 11g to 12c to 19c.

Ø EBS upgrade 11.5.10.2 to R12.2.6.

Ø Monthly Tuning of various slow performing sql’s using Grid and manual techniques.

Ø Monthly study of Performance reports(awr, nmon,baselines)

Ø Setup of Rman backups for the database using netbackup.

Ø Automate the cloning procedure from RAC to RAC& RAC to non-RAC.

Ø Implement scripts to automate monitoring of the system without any manual intervention.

Ø Device purging strategies to purge data from standard & Custom tables.

Project Details-Financial module to track internals financials.

Position -Lead-Oracle Apps Database Administrator

System details-EBS 11.5.10.2 on Linux with 10gRAC(10.2.0.4) on AIX , with Markview,Solix(3rd party),with 10g Discoverer

Responsibilities

Ø Support Multi tier 11i environment with 10g RAC

Ø Installed and integrated Markview

Ø Monthly Tuning of various slow performing sql’s using Grid and manual techniques.

Ø Implement Spanish, German, French, Chinese,Korean languages

Ø Monthly study of Performance reports(awr, nmon)

Ø Setup of Rman backups for the database using netbackup.

Ø Automate the cloning procedure from Rac to Rac & Rac to non-Rac.

Ø Implement scripts to automate monitoring of the system without any manual intervention.

Ø Device purging strategies to purge data from standard & Custom tables.

Ø Coordinate patching and Code migrations.

Ø Implemented grid Control for a100% automated monitoring and alerting

Project details-Implement 3rd Party tool Solix for its purging and archiving solution on all the 3 projects

Position -Lead Oracle Apps Database Administrator

System details-Implement 3rd Party tool Solix for its purging and archiving solution on all the 3 projects

Responsibilities

Ø Install and setup Solix.

Ø Initiate and coordinate the archiving of the data

Ø Coordinate the purging of data

Ø Coordinate Functional testing to have valid testing of the purging and archiving.

Ø Have the performance testing after the activity

Project details-100+ Oracle databases integrated for application server , third party tools, various reporting tools for WMS, WEBTECH applications.These databases are the backend to all the Company’s internal websites and HR functioning links.

Position -Lead Oracle Apps Database Administrator

System details-ORACLE 12c,8i, 9i, 10g , 11g databases along with 10g application server and also various weblogic servers

Responsibilities

Ø Install and setup Oracle databases

Ø Performance Tuning proactive and Reactive.

Ø Devicing archiving and purging scripts.

Ø Database upgrades from 8i to 9i to 10g to 11.2.0.2, 11.2.0.3

Client-Oracle Corporation

Position-Oracle Applictions DataBase Administrator

Project -

Working as a DBA, Team member with ON-DEMAND Supporting, Maintaining around 550 Production Environments from US and EUROPE. including Oracle Apps 11i,R12 . Profile Includes Day to Day Apps and DB troubleshooting,Application Performance issues.

Ø Specialization in Troubleshooting any outage or technical issue

Ø Specialization in Performance Tuning issues.

Ø Prepare plan for Secured Socket layer(SSL) implementation

Ø Convertion of Forms Connection mode for performance tuning.

Ø AUTOCONFIG stabilizations and maintaining customizations

Ø Worked on Apache stabilizations projects for customer.

Ø Implementing OATM tablespace Model

Ø Efficient in troubleshooting the issues with Apache,SSWA, forms, Concurrent Manager, and Workflow Mailer.

Ø Periodic Review of Customer Environments analyzing issues faced by them through Service request and giving solutions to ensure long term stablity and Higher Availblity.

Company profile: Clover Tech. is involve support activity in all technologies related to Oracle, like Database and Oracle Applications 11i Forms Reports etc and also in Networking support. I am involved with Clover Technologies as support team member and handling key clients for it. I had also given telephonic support to the client whenever required

Client -Shalina Laboritories

Position -Oracle Apps Database Administrator

Project -15 days period for 11.5.9 to 11.5.10.2 upgrade for its Production/Test system upgrade.

Responsibilities -

Ø Oracle software installation & database creation on UNIX & Windows platforms

Ø Applications upgrade from 11.5.8 to 11.5.10.2 on linux 2.6.9.

Ø Database upgrade from 9.2.0.1 to 10gR1.

Ø Techstack upgrade to IAS1.0.2.2.2

Ø Upgrading developer6i

Ø Applying 11.5.10 Maintaince pack

Ø Dual to Single Node rapid clone done

Client -DSP merill Lynch

Position -Oracle Apps Database Administrator

Project Duration-Support for production application system.

Oct’05 to Mar’06

Responsibilities

Ø Installed 11.5.9 on Windows NT

Ø Applied INDIA LOCALISATION PATCH

Ø Manual clonning done

Ø Patching and maintaining product level to latest patchsets.

Ø Performing db as well application performance monitoring

Ø Raising I-tars for technical issues

Client Kotak Mahindra bank(kalina)

Position -Oracle Apps Database Administrator

Project Duration -.Support for production application systems\

Jan’04 to Oct’05

Responsibilities

Ø Applied INDIA LOCALISATION PATCH Using AD utilities

Ø Ran AD UTILITIES

Ø Manual clonning done

Ø Patching and maintaining product level to latest patchsets.

Ø Performing db as well application performance monitoring

Ø Raising I-tars for technical issues

Company Profile:

The company pioneers in the Cementing Industry with using oracle 10g database in its IT solutions and Workings.One of the Few Cements company with strong iT infrastructure with latest technologies in its IT dept.

Position -Oracle Dba

Ø DB clonning

Ø Patching for IAS.

Company profile: The company is a leading Oracle education teaching partner in Bombay.It has excellence in partnering in teaching of professional courses in Oracle technologies

Position Teaching Executive

Responsibilities

Teaching Oracle 9i (sql & Architecture) to Students ranging from Beginner to Intermdeidtae Level Of knowledge