Madhav Deshpande Ph #: 224-***-**** Email: ac2cf9@r.postjobfree.com

MADHAV R DESHPANDE

***** ****** ***** ***** ********* CA Ph. # : 224-***-**** e-mail : ac2cf9@r.postjobfree.com Greetings !

I'm writing to apply for the position of Oracle DBA posted on dice.com I have experience of over 25 years is the field of database administration. I believe my experiences and track record make me an excellent fit for this opportunity. During this time I have worked with Financial Institues in US and India. I have lead and managed the Global Teams of the DBAs and provided the organizations the road map for the Databases that met the SLA expectations within the financial budgets. During this period I have directed the team building, deploying and supporting mission critical databases of 7x24x365 availability requirements.

In past I have worked with large consulting / Service incorporations like Oracle Corp. IBM, Accenture, Charles Schwab, Qualcomm etc. Last two years I am working with Genetech Inc.

Over these years I have paid special attention to higher productivity and superior performance of the Business systems that exceeded the critical availability requirements. I also have lead activities keeping the Oracle Databases Versions and Patch Levels uptodate, by reviewing and applying the latest PSU on the enterprise wide databases.I have been doing these activities since Oracle Version 6 until Oracle 12cR2 Aug. 2017 PSU. I am a US Citizen and would not require the Visa sposorhip. Enclosed please find my resume for your consideration. My contact information is as mention below.

Sincerely,

Madhav Deshpande

Mobile Ph. : 224-***-**** Email: ac2cf9@r.postjobfree.com Madhav Deshpande Ph #: 224-***-**** Email: ac2cf9@r.postjobfree.com MADHAV R DESHPANDE

20975 Valley Green Drive Cupertino CA 95014 Ph. # : 224-***-**** e-mail : ac2cf9@r.postjobfree.com Summary:

_ Madhav has more than 29 years of IT Infrastructure experience, off which over 25 years is with relational databases and related products primarily Oracle. Has extensive knowledge of Oracle database architecture and has designed databases for critical enterprise. Has efficiently used the Oracle Enterprise cloud management tools & technologies for the deployment, administration and monitoring of the databases & operating systems. He has supported over 2000 Relational databases starting from Oracle Version 6, all the way until most recent Oracle Version 12c throughout the SDLC. All these years, Madhav has worked with large corporation which includes large consulting, financial, bio-tech and retail corporations in US and India.

Objectives:

Gather the technology requirements and specifications from the clients, businesses partners, and deliver the DBMS Systems that exceed the business requirements. Lead, mentor and manage the DBA teams and Projects. Evaluate the existing systems and define the corporate roadmap for the stable database infrastructure. Define the policies, procedures and standards to deliver for the DBMS systems deployment. Manage the Team deliverables within the ITIL framework. Continuously improve the quality of the services and the stability of the enterprise systems

Education and Professional Certification:

Master of Management Science, Pune University India (06/ 1996) Diploma in Business Management, Pune University India (06/1995) Diploma in Computer Technology, BTE Mumbai India (05/1988) Oracle 11g,10g,9i,8i,8 & 7 Certified DBA

Technical Expertise and Skills:

_ Databases Oracle 12c, 11g, 10g, 9i, 8i, 8, 7 & Oracle Database Aplliance Maximum Availability

Architecture (MAA)

Oracle RAC, Data guard and Oracle Streams, Quest Share Plex, Oracle Goldegate, Oracle ASM

Operating Systems

Red Hat Enterprise Linux, Oracle Enterprise Linux, Sun Solaris, AIX, HP-UX,

Software

Oracle Enterprise Manager Grid Control, Sql*Plus, Oracle Application Server J2EE, Web Cache, iAS, Platinum EPM, HP - Glance Plus, Tivoli, Smart DBA/DB X-ray

Applications

Oracle Applications 11i, Oracle 9iAS, Avalon, BMC Remedy, Vantive, Clarify, Live Link, Oracle Apex

Other Skills

Project Management, ITIL Foundation, Release, Change, Incident, Service Request management,

Madhav Deshpande Ph #: 224-***-**** Email: ac2cf9@r.postjobfree.com Experiences:

Genentech / Roche Inc. South San Francisco, CA

Sr. Oracle DBA, Independent Consultant 09/2015 to Present Roles & Responsibilities:

Applied the latest PSU/DBRU patchs to 3 node Oracle RAC GI & Database homes

2Defined the road map for the Database deployment in the new data center for the organization

Designed, tested, and documented the database migration strategy for over 150 Databases.

Built Oracle RAC databses in with Physical Standby database in oracle 12cR2

Designed, tested, documented and deployed the backup strategy using RMAN

Upgraded the databases from lower releases to 11gR2 (11.2.0.4) and to Oracle 12c

Set up the database monitoring and notification systems using OEM 13c for 150+ databases

Ensured the SLA objectives are met

Deplyed OEM13c for monitoring of the Enterprise database

Refreshed the databases using expdp/impdp and RMAN Duplicate

Performed dataabse tuning by analyzing the ASH / AWR / ADDM reports

Applied the PSU patches to the Oracle Databases as per the corporate security and auditnig guidelines

Mentor and guide the junior DBAs on the team

Adhere to corporate change management procedures

Provide 7x24x365 support for the enterprise dabase systems to ensure all crtical availability, performance expecteations and overall SLAs are met

Eliminate and any vulanarabilities and fix issues proactively

Installed Oracle Apes 5.x and Upgraded Oracle Apex from lower versions to Apex 5.x Walmart Labs San Bruno, CA

Sr. Oracle DBA, Independent Consultant 05/2015 to 08/2015 Roles & Responsibilities:

Installed Oracle11g Grid Infrastructure and Oracle RDBMS S/W on the 3 node M9000 RAC

Successfully migrated the 22 TB database from Sun M5000 Server running to a 3 node RAC Database on M9000 Server

Set up the 3 node RAC Standby database to for the 3 node RAC Primary database

Identify and eliminate vulnerabilities in the existing set up

Proactively identify and eliminate the performance issues by identifying the AWR/ASH and ADDM reports

Prepare the database for the peak usage and ensure there is enough capacity at all levels in the stack deployed

Insight Global / Walgreens Lincolnshire, IL

Lead Oracle DBA Architect, Independent Consultant 06/2014 to 4/2015 Roles & Responsibilities:

Architect and build 3 database configurations of 2 node Oracle 11.2.0.4 RAC Primary and 2 node Oracle 11.2.0.4 RAC Physical Standby Databases on the Oracle Database Appliance ODA X3-2

Ensure on time and within budget completion & delivery of the projects Madhav Deshpande Ph #: 224-***-**** Email: ac2cf9@r.postjobfree.com

Built the Oracle RAC Physical stand by databases using command line and automated and documented the build, deploy and verify the data-guard set up using Oracle EM 12c

Performed the Oracle RAC System Tests for High Availability for various situations

Provide the L4 Support for the Corporate Oracle DBA Team onshore & Offshore

Mentoring the L1/L2/L3 DBA s on shore and offshore

Designed, Defined, documented the efficient Back-up and recovery policy using EM12c

Set up the database monitoring within OEM 12c framework

Troubleshoot the performance issues on the need basis

Migrated the databases from one datacenter to other as a part of Datacenter migration program

Define, document and adhere to the database standards and security policies

Define the road map for the clients

Identify Oracle new features and deploy them on the need basis after the ROI analysis Gap Inc. Direct / Akraya Inc. San Francisco, CA

Sr. Oracle DBA, Independent Consultant 03/2013 to 11/2013 Roles & Responsibilities:

Support the Hardware platform refresh projects by moving the Oracle RAC databases from Aix to Linux platform

Install & Configure Oracle Database 11g R2 and Grid Infrastructure on 4 node RHEL 6.3 Operating Systems

Design and document the storage lay out for Oracle 11g R2 Databases

Configure Oracle Databases for the Order Management Systems

Closely work with engineering team while reverse engineering the Order Management Systems

Use the Oracle 11g new features such as interval & systems partitioning

Ensure the functional and performance expectations are met by the newly designed system

Provided the L4 Support and mentor the Jr. DBA

Configure the database backups using RMAN

Accenture / BC Forward Cincinnati, OH

Sr. Oracle DBA, Independent Consultant 07/2012 to 02/2013 Roles & Responsibilities:

Set up the standard methods for the on Oracle 11g R2 installation and database configuration on Solaris & Linux platform

Set up the database upgrade process and check list from 10g or older versions to Oracle 11g R2

Reviewed the backup & recovery strategy, identified and documented the processes improvement areas, directed the team deploying the new strategy

Reviewed the Disaster recoverability strategy for the Oracle databases, improved the process by automating using the data-guard broker

Reviewed, Identified & Deployed the Oracle 11g new features such as Active Data- guard, RAT, Flashback databases to achieve the highest ROI return on investments

Deployed Oracle 10g and 11g databases using ASM storage on the EMC, IBM Hitachi storage

Mentored the Jr DBAs on the team at offshore locations Madhav Deshpande Ph #: 224-***-**** Email: ac2cf9@r.postjobfree.com MphasiS – The Hewlett-Packard Company Pune, India

Sr. Project & Operations Manager DBA Team 03/2011 to 03/2012 Roles & Responsibilities:

Set up the process to shortlist, interview and rate the candidates according to project specific requirements

Provide the SME service to the Oracle DBA Teams supporting global clients running Oracle databases from Version 7 through 11gR2

Work within the ITIL frame work and follow the change / Problem / Release management processes

Ensure that SLA/ SLA are exceeded in most cases

Direct the Oracle DBA Teams supporting the databases of 7x24x365 nature with 99.99% Uptime requirements, handle the on call support and escalations

Mentor the Junior Oracle DBA members

Advise and direct the team in preparing various documentations such as Standards, procedures RCA (Root Cause Analysis) etc.

Educate the teams on policies and procedures while doing the work within the ITIL frame work

Oversee technical support of all database technologies including monitoring, reporting, quarterly patching, troubleshooting and change deployment IBM Global Business Services Div. Pune, India

Sr. Oracle DBA Manager 08/2009 to 03/2011

Roles & Responsibilities:

Built the team of 14 Oracle database administrators

Mentor the Oracle DBA team

Guided the team setting up the proactive monitoring of the 100+ Oracle 10g and 11g databases

Direct the team on the database migrations from Oracle 9i to 10g or 11g

Guided the team following best practices for Oracle deploying and supporting databases, defining the policies and ensure the policies and standards are maintained

Automate the DBA tasks

Directed the team to Identify, document and eliminate the vulnerabilities in the systems deployed to achieve higher reliability

Promote, support and advocate the company policies to the team from time to time

Supported Global clients of IBM

Mentored team on deploying the PSU patches to Oracle database successfully Work with the Plan & Execute on, plan and communicate about the various projects and initiatives as defined by the business, manage the team of DBA's around deliverables and provide guidance and support

Oracle Corporation North America Consulting Cupertino, CA Sr. Principal Consultant 10/2007 to 04/2009

Roles & Responsibilities:

Installed and configured Oracle 11g /10g CRS, ASM and database software on Linux / Solaris / HP UX or Oracle Enterprise Linux Operating System.

Set up Oracle Streams, Identified and resolved the issues with bi-directional streams configurations at the client set ups

Madhav Deshpande Ph #: 224-***-**** Email: ac2cf9@r.postjobfree.com

Led the migration project of migrating Oracle 9i / BaaN IV databases from HP UX 11 to Solaris 10 and Oracle 10gR2

Performed cross platform migrations of Oracle 9i Data warehouse database from AIX to Oracle 10g database running on Solaris 10 Server using cross platform transportable Tablespaces

Identified, tested, and certified the most efficient migration path of using Transportable Database for the OLTP databases which had over half million objects

Documented the process and trained the junior DBAs on the migration process.

Oversaw the migration of about 10 other databases and helped the team to succeed

Used RMAN to clone / duplicate the Oracle 10g and Oracle11g databases

Identified and resolved the performance issues at the client databases

Prepared and presented a power point presentation various technical subjects Charles Schwab & Co. San Francisco, CA

Sr. Staff DBA 06/2002 to 10/2007

Role & Responsibilities:

Deployed Daylight savings patches for over 1700 Oracle software installations.

Changed the backup strategyfrom Old Hot backups to RMAN for the 500+ databases

Prepared and presented the corporate DBMS roadmap for next 5 years.

Organized the Brown Bag Event for 15 internal customers/Business partners. Presented the ROI and technical edge benefits to the internal customers and senior management

Defined and maintained the standards for database deployments, encouraged team to adhere to them. Built the tool to generate the violations/deviations from predefined standards

Defined the policies and procedures to serve the customers within the ITIL framework

Tracked and monitored the changes, incidents and service requests handled by team in the BMC Remedy databases

Oversaw and directed the Oracle 10g database migration project and migrated over 250 Oracle databases to the new stack

Installed and certified two node Oracle 10g R2 RAC databases on Linux / Solaris operating system using VERITAS (/Symantec’s) SFRAC 4.x or 5.x

Designed, Engineered and Implemented the Oracle HIGH AVAILABILITY databases using Data guard and Oracle 10g / 9i RAC databases for various applications such as DW / OLTP on RHEL 4.0, 64-bit and Solaris 2.9 OS

Performed the capacity planning for the databases and added nodes to the RAC databases to make the a 2 node RAC database; a 4 node RAC database to accommodate the growing needs

Managed the production support of 7x24x365 nature for over 150 Oracle Production Databases

Configured Oracle Streams between an Oracle 9i RAC and Oracle 10g RAC database to share the data

Built Oracle 10g RAC Databases on VERITAS Storage Foundation on Linux and Solaris platform

Contact this candidate