Manager Oracle

DHARMESH P PAREKH

* ***** ****** *, ****, DE ****1.

(H) 302-***-****, (C) 201-***-****

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

SUMMARY:

Extensive experience as a lead Oracle DBA/Manager in projects covering OLTP and

•

Warehouse implementations, large and complex databases, Performance Tuning, Systems

Integration, support and upgrades. Solid hands on experience in implementations of Real

Applications Clusters (RAC), High Availability Systems, Highly Scalable database systems,

Backup and Recovery Strategy, Veritas Cluster, Grid Control Implementations and Support of

Mission Critical Systems

Results oriented with experience and proven track record in managing technology and

•

operations teams. Over 12 years of experience with the right balance of management and

technical skills to work effectively in a team and across cross functional groups. Background in

strategic planning, project management, staffing and employee relations. Proven strength in

managing off shore resources, meeting goals and producing results oriented team efforts

through excellent interpersonal, motivational and communicational skills.

Extensive experience in database Migration, Upgrade, Oracle Installations and Patch

•

Application.

Extensive Experience in designing, Implementing and performing Disaster Recovery.

•

Lead efforts to develop and improve procedures for automated proactive monitoring. Identify

•

automation opportunities and implement solutions to improve efficiency, service reliability,

productivity and cost of ownership.

A leader with strong ethics, extraordinary analytical skills and a demonstrated track record of

•

achieving goals with dedication and dependability under tight constraints. Facilitate strong

team organization, demonstrate management skills providing leadership, direction, guidance

and continuity.

Strengths in understanding and analyzing business processes and infrastructure requirements

•

and translating them into technical specifications and Capable of breaking down large projects

to clear and definable sub projects. Direct Project Manager to drive sub projects to

completion

Skillful in partnering, creating and managing business relationships with business clients from

•

various divisions and geographies (local and international) while meeting business

requirements and maintain strong, effective working relationships with coworkers.

Expertise in hiring, training, motivating new employees and building customer relationships.

•

Keen analytical focus with strong research, investigative and problem solving techniques quick

•

recognition of errors and anomalies; excellent math aptitude and abstract conceptualization.

• Managed multiple large scale projects and successfully delivered high profile/priority projects

• Coordinate and drive cross functional project teams, schedule, install, test and deliver

contracted products within scheduled timeline and with a high degree of quality and customer

satisfaction

• Lead/participate in meetings with customers and internal project resources

• Provide continuous feedback on project status and offer constructive options to ensure project

continues to meet original expectations

• Identify resources and/or schedule conflicts and changing of project scope

• Communicate identification and resolution of business/project issues, as well as the

monitoring, tracking and reporting on project deliverables to ensure adherence to project plan.

• Provide work coordination and management for teams of DBAs, including project lead, project

management, task assignment and coordination, and status reporting.

• Provide technical leadership to the DBA team by assisting junior team members and sharing

knowledge and research of tools/techniques, and Oracle features.

• Participate in production on call rotation (one week at a time of 7x24 on call support for

production environments).

• Assist project teams in data modeling and architecting / designing data accesses methods.

•Developed and implemented the strategic roadmap for the use of Oracle and Oracle products.

Defined the set of products and versions to be used in production. Defined the standards,

policies and procedures to be followed.

•Developed and implemented policies, procedures, technical solutions and best practices that

relate to the effective implementation and operation of VLDB/data grid/RAC .

•Promoted consistency, standardization and efficiency within database environment.

•Contribute towards the inventory and metrics management processes to track IM assets.

• Very good understanding of broad range of technologies from systems, storage, networks,

Middleware, ETL and other major application development tools.

Looking to take on senior management role in the next career opportunity. Proven ability to

integrate technical expertise and business knowledge in developing and executing new business

processes.

CERTIFICATIONS:

Oracle Certified Professional (OCP) For Oracle 11G DBA Track

Oracle Certified Professional (OCP) For Oracle 10G DBA Track

Oracle Certified Professional (OCP) For Oracle 9i DBA Track

Oracle Certified Professional (OCP) For Oracle 8i DBA Track

Brain bench Certified Oracle Developer

Brain bench Certified Oracle Programmer

ORACLE SKILL SETS:

Oracle 10g & 11g RAC Design and Implementation.

Oracle Exadata.

Oracle Data guard for Disaster Recovery implementations.

Oracle Streams and Golden Gate for Site to Site Replication.

Oracle Enterprise Manager 10gR2 and 11gR1 Implementation.

Planning and Implementing Upgrades to 10g, 11g.

RMAN Backup and Recovery including cloning strategies.

ASM implementation.

Oracle High Availability Solutions.

PROFESSIONAL SKILLS:

DATABASES Oracle 11g/10g/9i/8i/8x/7x, Oracle Exadata 11g, Teradata 7.0,

SqlServer 2000, MS Access

OPERATING SYSTEM RHEL, Sun Solaris, Aix, HP Unix, Windows 2000/NT/XP, MS Dos

LANGUAGES SQL, PL/SQL, C, Shell Scripting, Perl Scripting.

Oem grid control 12C,11.1,10.2.x, Oem data control, Sql Loader, Data

DATABASE /DATA

pump, Exp, Imp, Toad, Sql Navigator, Queryman, DBartisan, Data

WAREHOUSE TOOLS

Junction, Erwin, Exceed, Kea, Informatica, Cognos power play

7.0, Cognos Impromptu 7.0

APPLICATION SERVERS Oracle AS Portal, Weblogic

Remedy, Peregrine, Clarify

INCIDENT MANAGEMENT

CLUSTER Oracle RAC, Veritas Cluster, Microsoft Cluster, Oracle Failsafe

RMAN, Netbackup, TSM, Sql Backtrack 5x/6x, Control M,

BACKUP AND

Maestro, Autosys, Automate, Cron

SCHEDULING

HARDWARE HP EVA 8100, MSA 2000, Sun StorEdge 3000/A5200, Sun

E10k/E6000/E5000/E3500/E450/E250/E420R/E220R, Sun

Ultrasparc 450, Aix 570,HP 9000

A180 /D200 /K460 /K570 /N4000 /k220,RP 7400, Compaq

Proliant DL series, Compaq ML series, Proliant 5000, 3000, 2000.

PROFESSIONAL EXPERIENCE

McKesson, PA

Mar 08 Present

Role: Manager/Lead Oracle DBA/Architect

Oversees database administration support for production, development, and test

•

environments to include day to day monitoring and maintenance, problem investigation

and resolution, backup creation and maintenance, SQL and database optimization and

tuning as well as providing technical leadership and leading efforts to research, analyze,

and recommend patches, upgrades, and new technologies surrounding all aspects of data

management using relational databases.

Serve as team liaison to project managers for database administration and system

•

administration services

Worked with architects, engineers, development teams, business product group and peers

•

to understand the business requirements and help design develop and implement

solutions that meet the business needs.

Research and analyze all assigned anomalies to determine root cause – produce, review,

•

track and log all findings and recommendations

• Responsible for designing strategy and moving the production databases between the

data centers from east coast to west coast saving multi million dollars in infrastructure,

timeline.

• Responsible for designing, developing and implementing the backup strategy enterprise

wide using Data Domain Technology comprising of tapeless solution, replication to offsite

for DR, encryption of data at rest and data in motion satisfying corporate security

standards(sox,hipaa) thus saving multi million dollars.

• Responsible for evaluating Oracle Exadata Quarter Rack for bringing it In House.

• Responsible for assessing the infrastructure requirements, provide the cost estimates

using costing model and develop timelines for specified projects.

• Collaborate with platform engineering and storage engineering teams to order the required

hardware, install necessary patches and software to provide innovative solutions such as

RAC and Grid computing.

• Evaluated and brought in house Oracle Grid Control Monitoring thus saving dollar

amounts.

• Responsible for 4 installations of 12c, 11.1, 10.2.x Grid Control Environment.

• Establish and communicate the security guidelines and participate in (SRAs) Security

Risk Assessments.

• Provide technical and management leadership to the consulting and junior staff.

• Providing technical and project leadership for oracle database migration projects to newer

Versions 10g/11g.

• Responsible for road mapping on database versions, upgrades, PSU’s.

• Responsible for 9 rac installations of 11gr2 and 10gR2 2/3/4/6 node on Linux red hat,

creating 15+ rac client production databases, upgrading rac environments (GI,

clusterware, asm, database).

• Responsible for performance tuning in rac environment for queries, services,

interconnects.

• Responsible for restoring rac database as rac/single instance database.

• Responsible for upgrading Oracle Grid Control Environment (oms, agent, repository,

database).

• Responsible for maintaining standard across board, maintain uniform environments

patchset and one off patches.

• Provide status reports on key projects to senior management and make

recommendations to optimize project implementations.

• Responsible for staff planning, Conducting Interviews, Hiring.

• Conducted performance reviews, goal settings, attracting and retaining the best talent.

• Participated in quarterly meetings with Senior Management to discuss technical

infrastructure and market recommendations assisting in the formation of the technology

roadmap.

• Managed change control meetings ensuring that changes to production environments are

validated and thoroughly tested.

Environment: Oracle Exadata, Oracle 11.2.x/11.1.0.x/10.2.0.x/9.2.0.x, RAC 11g/10g, RMAN,

Oracle Grid Control, Shell Scripting, Linux Red hat 4x/5x, Sun Solaris 9, HP UX 10.2/11,

HP EVA, MSA

Wachovia, PA

Jun 07 – Feb 08

Role: Sr Oracle DBA Consultant

• Managed and provided support for oracle databases on various hardware platforms

(Solaris, Aix, Linux) ranging in size from GB's to Terabytes.

• Evaluated maximum availability architecture and implemented data guard solution for

disaster recovery.

• Responsible for benchmarking and providing optimal way of migrating production

rac/non rac databases of Linux 32 bit to Linux 64 bit.

• Responsible for configuration and deployment of oracle 10g RAC solutions on Solaris.

• Responsible from upgrading/migrating 30+ databases to 10204 from 10202 and 9206.

• Performed many 10g Installations on the various platforms and created 10g databases as

required for applications. Upgraded 20+ databases to 10202 and 10203, Applied CPU's and

one off patches as required addressing technical shortfalls (bugs) and security concerns.

• Provide training and technical leadership to Junior Database Administrators.

• Performed analysis of existing implementation and make recommendations to further

improve performance, availability, scalability and take lead in getting those recommendations

implemented.

Environment: Oracle 10204/10203/10202/10201/9208/9206, RAC, RMAN, SQL Backtrack,

SQL, PL/SQL, SQL*Loader, OEM, Toad, Discoverer, Shell Scripting, Net 8, Sun Solaris

10/9/8, Veritas Cluster, Veritas File System, Veritas Volume Manager, Symantec I3

Monitoring, Aix 5.2/5.3, Linux Red hat 4x, Linux Suse 9, Sun E15/10/5K, E450, E420R.

JP Morgan

Chase, DE

Jul 05 – Jun 07

Role: Lead Oracle DBA

• Responsible for designing and implementing complete Disaster Recovery Solution using

DataGuard for more than 30 production databases thus saving multi million dollars.

• Participate and lead in database management sub committees to develop

SOPs & Work Instructions, Security Guidelines and to improve SLA response

time.

• Responsible for accessing infrastructure to validate performance, capacity and

Upgrading the infrastructure there by managing the SLA’s with improved performance.

• Responsible for providing database management and reporting solutions for

business partners.

• Providing leadership and database technical support in implementation of

Applications.

• Provide technical and management leadership to the consulting and junior staff.

• Lead the capacity enhancements and new technology adaptability efforts for utilizing in

house.

• Providing development, test and production maintenance support for validated

and business applications. Ensure standards and security compliance for DBs.

• Proposed, Implemented and documented proof of concept for business applications.

• Performed migration of three 2+tb 9206 databases from Hp platform to Aix platform.

• Responsible for implementing 2 high availability cluster solutions with Veritas Cluster on

Solaris 8.

• Responsible for configuring backups with Veritas Netbackup and Tivoli.

• Responsible for 3 configuration and deployment of RAC solutions on Solaris with and without

Veritas Cluster.

• Performed 30+ Installations of oracle 9i and 10g on various platforms, 80+ Migrations,

• Responsible for performing capacity planning, space forecasting, architecting and designing

the environment.

• Provide training and project leadership to junior database administrators.

Environment: Oracle 10202/9206/9204/8174, RAC, RMAN, SQL, PL/SQL, SQL*Loader,

Oracle grid control, Oracle data control, Shell Scripting, Net 8, Sun Solaris 10/9/8,Veritas

Cluster, Veritas File System, Veritas Volume Manager,HP UX 10.2/11, Aix 5.2/5.3,

Windows NT/2000, Sun, Hp, Aix

All projects from here Down are through my consulting Company Global Data

Management Corp, NY

VerizonWireless, PA

Oct 03 – Jun 05

Role: Lead Oracle DBA Consultant

•Responsible for Creation, Maintenance, Performance tuning, Backup and Recovery of database.

•Designed and implemented the backup and recovery strategy used across the board

•Performed Migration of 8i database to 9i database and application of patches and patch sets,

Moving databases to different server, Refreshing dev/test/qa database with prod database.

•Responsible for Engineering, Reengineering, Logical and Physical design of database.

•Responsible for implementing process to connect to heterogeneous databases like Teradata,

SqlServer from Oracle and implemented automated process for interacting with the same.

•Responsible for administration of cognos Power play and Impromptu.

•Created shell scripts, perl scripts, procedures, functions, packages, triggers for automation.

Environment: Oracle 9i/8i/8.x, Teradata 7.0, RMAN, SQL, PL/SQL, SQL*Loader, OEM, IIS

5.0, Cognos Power Play 7.0, Cognos Impromptu 7.0, Perl Scripting, Shell Scripting, Net 8,

Sun Solaris 2.7/2.6, Veritas Cluster, Veritas File System, Veritas Volume Manager, HP UX

10.2/11, Windows NT/2000, Sun Enterprise Server E5000, E450, E420R, HP K 570/220,

Compaq DL Series, ML Series.

Capital

One, VA

Oct 02 – Sep 03

Role: Sr Oracle DBA

•Responsible for Production and Application Support of 24X7 databases.

•Responsible for logical and physical design and reengineering of database.

•Responsible for application and database tuning, creating and testing backup and recovery

procedures.

•Implemented Oracle data guard solution and worked in RAC environment.

•Extensively used 9i features omf’s, Undo Management, Online table redefinition, Resumable,

Auto space management, multiple block size, External tables, Resumable backup and

restores.

•Responsible for capacity planning, performance management and hardware enhancement.

•Responsible for incident management and resolution, reactive and proactive problem

management, contingency planning and change control system, root cause analysis.

Environment: Oracle 9i/8i/8.x, RMAN, SQL, PL/SQL, SQL*Loader, OEM, Oracle 9IAS,

Weblogic 5.1, Java, J2EE, Perl Scripting, Shell Scripting, Peoplesoft 8.1, Brio, Net 8, Sun

Solaris 2.7/2.6, Veritas Cluster, Veritas File System, Veritas Volume Manager, HP UX

10.2/11, Sun Enterprise Server E6000, E420R, HP N 4000, K570, K460 Windows NT/2000.

Intel, AZ

Feb 02 – Sep 02

Role: Oracle/Data warehouse DBA

•Responsible for Database Engineering.

•Implemented the block corruption detection and repair policy using Block media recovery.

•Responsible for troubleshooting and tuning of all aspects of database.

•Responsible for backup and recovery of the database using resumable backup and restore.

•Responsible for maintaining Oracle failsafe and Microsoft cluster.

•Capacity planning for new boxes by gathering the data from present boxes using sar, iostat,

vmstat.

•Participated in deciding the Raid level and calculating the stripe size for the raid 0+1.

•Cloning the test database with the production database.

•Created shell scripts, procedures, functions, packages, triggers for automation.

•Responsible for Installation of oracle server, OEM and applying patch set.

Environment: Oracle 9i/8i/8.x, RMAN, SQL, PL/SQL, SQL*Loader, Advanced Replication,

Perl Scripting, Shell Scripting, Brio, Net 8, OEM, Data Junction, Sun Solaris 2.7/2.6, HP

UX 10.2,11, Sun Enterprise Server E5000, E220R, HP RP 7400, HP 9000 D200/A180/K460,

Compaq Proliant DL 360/380, Windows NT/95/2000.

Ewanted

.com, CA

Nov 99 – Dec 01

Role: Oracle/Data warehouse DBA

•Responsible for Production and Application Support of 24X7 databases.

•Responsible for Production Support of the Oracle Apps 11i database.

•Responsible for the Backup, Recovery, Maintenance and Tuning all aspects of the database.

•Responsible for migration of data from SQL Server to the Oracle database.

•Implemented Recovery managed standby database.

•Responsible for oracle server installation, migrations, applying the patch set, Installation and

Configuration of OEM for paging and email notification.

•Written shell scripts to automate the processes.

•Implemented replication between the test databases.

•Involved in preparation of ETL Specifications and writing Algorithms for the ETL, design and

development of the data extraction, cleansing and loading into the atomic warehouse and data

aggregation and extraction from the warehouse into the data marts on a periodic basis.

•Maintenance of Informatica Server and Created Session and Batches.

•Involved in sizing and creation of database objects based on future expansion.

Environment: Oracle 8i/8.x/7x, RMAN, SQL Server 7, SQL, PL/SQL, Sql Loader, OEM,

Erwin, Informatica, Power Mart 4.6/power center 1.6, Net 8, Cognos power play, Cognos

Impromptu, Java, Weblogic, Shell Scripting, Forms 6I/5.0/4.5, Reports 6I/3.0/2.5, Data

Junction, Oracle Applications 11i, Sun Solaris 2.7/2.6, Veritas Cluster, Veritas File

System, Veritas Volume Manager, Sun Enterprise Servers E6000/E5000/E3500/E450/250,

Windows NT/95/2000

EDUCATION:

Bachelor in Engineering from Institution of Engineers, India 1992

Diploma in Engineering from K.J.Somaiya Polytechnic, Bombay, India 1988

Contact this candidate