Candidates About

 

Dharmesh P Parekh

AN OVERVIEW

Ä  Over 14 years of experience as Sr Database Manager/Database Architect/Lead Oracle DBA 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.

Ä  Extensive experience with the right balance of management and technical skills to work effectively in a team and across cross functional groups. Proven strength in managing off shore resources, meeting goals and producing results through leadership, direction, guidance, continuity, excellent interpersonal, motivational and communicational skills.

Ä  Extensive experience in RAC Implementations, Database Migration, Database Upgrade, Oracle Installations and Patch Application.

Ä  Extensive Experience in design, implementing and performing Disaster Recovery.

Ä  Extensive Experience in design and implementing High Availability.

Ä  Provide work coordination, technical leadership and management for teams of DBA’s, including project lead, project management, task assignment and coordination.

Ä  Experience in Agile Technology and ITIL technical solutions.

Ä  Participate in production on-call and escalation on-call rotation of 7x24 production environments.

Ä  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.

Ä  Promoted consistency, standardization and efficiency within database environment.

Ä  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, grid/RAC.

Ä  Very good understanding of broad range of technologies from systems, storage, networks, Middleware, ETL and other major application development tools.

Ä  Background in strategic planning, project management, staffing, training and employee relations.

Ä  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.

Ä  Strengths in understanding and analyzing business processes and infrastructure requirements and translating them into technical specifications and capable of breaking down large projects to definable sub-projects.

Ä  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.

Ä  Keen analytical focus with strong research, investigative and problem solving techniques for 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.

Ä  Assist project teams in data modeling and designing data accesses methods.

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

 

CERTIFICATIONS

 

Oracle Certified Professional (OCP) for Oracle 12C, 11G, 10G, 9i, 8i DBA Track

 

Areas of Expertise

 

Excellence Sphere

Ä  Oracle 12c, 11g, 10g RAC and ASM Design and Implementation.

Ä  Oracle Exadata.

Ä  Oracle High Availability Solutions.

Ä  Oracle Data guard for Disaster Recovery implementations and Switchover Maintenance.

Ä  Oracle Streams and Golden Gate for Site to Site Replication.

Ä  Oracle Enterprise Manager 10gR2, 11gR1, 12C Implementation,

Ä  Planning and Implementing Upgrades to 10g, 11g, 12c.

Ä  Data Security, Data encryption- data at rest and in motion.

 

Incident Management / Problem Management / Change Management

Ä Ensuring that the goals of the Incident Management process are achieved, restoring normal service as soon as possible based on customer perspective and within defined SLA, detecting, logging, categorising and prioritising incidents, providing initial Incident Support.

Ä Closing incidents after verification from users, defining and planning separate procedures for major incidents, ensuring adherence to SLA and priority based management.

Ä Resolving problems & issues within set timelines thereby developing the Knowledge Base, ensuring that the issue does not happen again.

 

Business Intelligence & Data Warehousing, ETL

Ä Studying the source systems and process of the existing data warehouse.

Ä Understanding and documenting the user requirements from the users.

Ä Preparing the functional specification document into the Multidimensional Data Model and model into the Star & Snowflakes Schema.

Ä Working with OLAP/Reporting team for the design of the reports and its reconciliation.

Ä Managing overall requirement related to the technology, including technical feasibility study, budget, selection, procurement, upgrade / migration of hardware, software, database and applications.

 

People Management

Ä  Managing team functions viz. manpower planning, recruitment, performance appraisal etc.

Ä  Leading, mentoring & monitoring the performance of team members to ensure higher productivity & efficiency in process operations and meeting of individual & group targets.

Ä  Coordinating and ensuring that meetings / feedback sessions take place on a regular basis, organising regular skill based trainings.

Ä  Help HR and managing retention best employee as long as possible.

Ä  Demonstrative ability to lead people and get results through others. 

Ä  Act as a leader for the performance management process by setting clear performance expectations, Coaching and guiding the team to high levels of performance.

Ä  Be able to engage with staff up to the most senior levels within an organization, and to communicate complex technology in a business centric way.

 

TECHNICAL SKILLS

 

DATABASES	Oracle 12c,11g/10g/9i/8i/8x/7x, Oracle Exadata 12C, 11g, Teradata 7.0,   SqlServer 2000,2008,2012, MySql 5.x, MS Access, Hadoop
ENGINEERED SYSTEM	Exadata X6-2, X2-2.
OPERATING SYSTEM	RHEL, Sun Solaris, Aix, HP-Unix, Windows 2000/NT/XP, MS-Dos
LANGUAGES	SQL, PL/SQL, C, Shell Scripting, Perl Scripting.
DATABASE /DATA WAREHOUSE TOOLS	Oem grid control 12C,11.1,10.2.x, Oem data control, Sql  Loader, Data   pump, Exp, Imp, Toad, Sql Navigator, Queryman, DBartisan , Data   Junction, Erwin, Exceed, Kea, Informatica, Cognos  power play   7.0,  Cognos  Impromptu 7.0, ILM
APPLICATION SERVERS	Oracle AS Portal, Weblogic
CONFIGURATION,MONITORING	Puppet, Nagios, Ansible
INCIDENT MANAGEMENT	Remedy, Peregrine, Clarify
CLUSTER	Oracle RAC, Veritas Cluster, Microsoft Cluster, Oracle Failsafe
REPLICATION	Oracle Streams, Golden Gate.
BACKUP AND SCHEDULING	EMC Clone, RMAN, Netbackup, TSM, Sql Backtrack 5x/6x, Control M,   Maestro, Autosys, Automate, Cron
HARDWARE	HP EVA 8100, EMC XtremeIO, 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.

 

 

 

 

CAREER RECORD

 

JAIAMBE Corp, DE

Jun 17 – Current

Role: Sr Manager Principal Consultant

Ä  Founder of JAIAMBE Corp providing IT Services and Consulting to organizations and companies.

Ä  Perform detailed analysis to help client choose type of RDBMS, Engineered System, and Cloud Solution.

Ä  Provide and configure HA, DR, Replication, encryption, Data Masking solutions.

Ä  Work with client to project growth, Performance, Sla’s.

Ä  Negotiate licensing and support agreement with oracle.

Environment: Oracle 12.1.0.2,11.2.0.x, Exadata, RAC, Data Guard, Cloud Control, Rman, ZDLRA, Cloud IAAS, Cloud Database as service

 

Sei Investments, PA

Oct 14 – Jun-17

Role: Database Manager Tech Lead

Ä  Involved in vital planning for infrastructure setup.

Ä  Manage team of DBA’s (infra-structure) on site and off site spread across the globe. DBA categorized of Administration, Application, Operation, Production, Change Management, On-call support and performance optimization.

Ä  Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems.

Ä  Implemented Exadata X6-2 Engineered System half rack.

Ä  Defined the Cost saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests.

Ä  Involved actively in technical solutions in bidding proposal for future Business development.

Ä  Managed enterprise-level Oracle database systems, achieving the goal of 99.99% availability at acceptable level of performance.

Ä  Involved actively in technical solution of integrating ovd with ldap for Enterprise User Security.

Ä  Involved actively in design and implementation of Warehouse and reporting solution including Golden Gate.

Ä  Involved in strategic planning, project management, staffing, training and employee relations

Environment: Oracle 12.1.0.2,11.2.0.x/10.2.0.x, Exadata X6-2, RAC 11g/10g, RMAN, Golden Gate, Oracle Grid Control, OID OVD, ILM, MySql 5.x, SQL Server 2012, Linux Red hat 4x,5x,6x , EMC Clone, VPlex, Xbrick.

 

JaiAmbe Corp- client: Laureate Inc, MD

Feb 13 – Oct 14

Role: Database Manager

Ä  Responsible for bringing latest technology in field of Database.

Ä  Manage team of DBA’s on site and off site.

Ä  Ensured team is compliant with regulatory standards and policies.

Ä  Responsible for implementing Golden Gate technology leading to path of all live reporting.

Ä  Managing and providing technical leadership to DBA team.

Ä  Architect end to end migration of high profile external facing revenue earning database system from one Hardware to another with minimal downtime thus saving dollar amount.

Ä  Responsible for building DR environments using Data Guard.

Ä  Involved in Design of etl, Data warehouse, and BI studying of source system till end reporting.

Ä  Responsible for Building 2 and 4 Node 11gr2 external facing RAC environments.

Ä  Worked on bringing Hadoop in house and utilize for different applications.

Environment: Oracle 11.2.x/11.1.0.x/10.2.0.x, RAC 11g/10g, Banner, Backboard, RMAN, Golden Gate, Oracle Grid Control, Shell Scripting, Hadoop, SQL server 2012, Linux Red hat 4x/5x,6x ,HP EVA

 

Infosys- client: AstraZeneca, DE

Oct 12 – Feb 13

Role: Lead Database Manager

Took up very challenging short term consulting role as Database Manager to lead team to successful migration of Data center comprising of 500+ Prod, Preprod, UAT,QA databases.

Ä  Leading migration project of migrating Servers, database and application from one data center to other.

Ä  Lead the team for migration effort successfully completing migration well below project timeline.

Ä  Managed team functions viz. manpower planning, recruitment, performance appraisal.

Ä  Lead meetings with the Clients, Stack Holders and managing the expectations.

Environment: Oracle 11.2.x/10.2.0.x/9.2.0.x, RAC 11g/10g, RMAN, Shell Scripting, Linux Red hat 4x/5x, Solaris, HP EVA

 

JaiAmbe Corp - client: McKesson, PA

Mar 08 – Oct 12

Role:  Lead Oracle DBA Consultant

Ä  Responsible for designing strategy 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 assessing the infrastructure requirements, provide the cost estimates using costing model and develop timelines for specified projects.

Ä  Worked with 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.

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

Ä  Evaluated and brought in house Oracle Grid Control Monitoring thus saving dollar amounts.

Ä  Providing technical and project leadership for oracle database migration projects to newer Versions 10g/11g.

Ä  Responsible for preparing upgrade document for Oracle Grid Control Environment (oms, agent, database).

Ä  Responsible for maintaining standard across board, maintain uniform environments patch set and one off patches.

Ä  Provide status reports on key projects to senior management and make recommendations to optimize project implementations.

Ä  Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap.

Ä  Establish and communicate the security guidelines and participate in Security Risk Assessments.

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

Ä  Research and analyze all assigned anomalies to determine root cause – produce, review, track and log all findings and recommendations.

Ä  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.

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

Ä  Responsible for road map of database versions, upgrades, PSU’s.

Ä  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.

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

Ä  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 staff planning, Conducting Interviews, Hiring, conducting performance reviews, goal settings, attracting and retaining the best talent.

Ä  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, SQL Server 2008, Linux Red hat 4x/5x, Sun Solaris 9, HP-UX 10.2/11, HP EVA, MSA

 

Wachovia, PA

Jun 07 – Feb 08

Role: Sr Database Architect Consultant

Ä  Evaluated maximum availability architecture and implemented data guard solution for Disaster recovery.

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

Ä  Responsible for creating document for upgrading/migrating 30+ databases to 10204 from 10202 and 9206.

Ä  Provided 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.

Ä  Responsible for evaluating and addressing technical shortfalls (bugs) and security concerns.

Ä  Responsible for creating High Level Design from requirements.

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: Database Management Lead

Ä  Responsible for designing and implementing complete Disaster Recovery Solution using

Disk replication and standby database for more than 30 production databases thus saving multi million dollars.

Ä  Responsible for design of backups with Veritas Netbackup and Tivoli and lead prototype efforts.

Ä  Responsible for performing capacity planning, space forecasting, architecting and designing the environment.

Ä  Participate and lead in database management sub-committees to develop

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

Ä  Responsible for design and deployment of 3 RAC solutions on Solaris with and without Veritas Cluster.

Ä  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 consulting and junior staff.