Candidates About

 

Kailash Hingorani 

PROFESSIONAL SUMMARY:

·         Problem solver with over 20 years of experience in Information Technology with increasing responsibilities.

·         5+ years in IT Vendor Management - managing all aspects of the vendor relationship.

·         Over 15 years, as a hands-on Oracle DBA and Team lead managing Global teams.

·         Excellent communication skills and proven expertise in Project Management.

·         Utilized a variety of tools and technologies like Jira, BMC-Remedy, Service Now (SNOW) for workflow management, ticketing and change control

 

Strengths include:

 

Evaluation and database migration to AWS (Amazon Web Services) – SaaS / IaaS on EC2

DBaaS evaluation / implementation on EXADATA

Project Management across technologies and utilizing global teams including a combination of in-house and vendor resources.

Installation, Upgrading, Migration of Oracle Database with file systems and ASM

Create and maintain Standby database for maximum availability using Data Guard.

Administering and managing production (365x24x7) support including Global team.

SDLC (Software Development Life Cycle)

Experience with ITIL / ITSM process including change control/management, RCA, Incident management

Expertise with Oracle tools / products including (ASM/ OEM/ RMAN/ OWM/ ASMCMD)

Performance tuning both at SQL and Infrastructure layer using SQL Trace, AWR etc.

Technical Documentation

Working knowledge of SQL Server

Experienced with all flavors of Unix / Linux and Windows

 

 

 

PROFESSIONAL EXPERIENCE

 

Bank of America, March, 2017 to current

Sr. Oracle DBA

Creating solutions to optimize Database migration for the purpose of exiting a Data center, taking into account, overall timelines and business requirements for testing, resources (physical and technical) etc.

This includes technical solutions as well as time management and resources.

Databases include Primary and Standby (Data Guard) utilizing file system storage and raw devices via ASM.

Data center migration using RMAN to build standby creating dual standby environment to ensure minimal down time.

Engaging with team evaluating local DBaaS solution using 12c PDB’s, supporting application team for code migration and engaging in development lifecycle using Agile and Waterfall methods.

Day to day activities include performance tuning of SQL using Trace file and AWR for analysis, RMAN backup and recovery as needed, database refreshes (full using RMAN and partial via DataPump), standby (Data Guard) maintenance etc.

Participating in change management process to implement production change controls.

Internal auditor to validate Netback setup and policy per business requirements, also Internal auditor for tracking utilization of Advanced compression feature (this is a licensed product), and removing the same from all supported databases. This includes tracking/ identifying all occurrences of this feature and putting in place a plan for its removal and execution of the plan.

Architecting / Implementing the overall solution to capture data from Oracle Cloud (RDBMS 12c), via Golden Gate (12c) onto multiple on - premise (RDBMS 11g / 12c) database targets, including typical trail files for a 24 hour period expected to reach 1TB in size, the replicat / target location is on premise and pulling data from Oracle cloud services via the SaaS model. Installed GG server on a standalone VM and configured to support multiple targets.

 

 

Stifel Nicholas Co. November 2016 to February, 2017

Sr. Oracle DBA

Creating and standardizing processes for code deployment on Oracle 11g (Windows and Linux)

Creating a Migration plan for moving Oracle from Linux + ASM to Windows OS

Testing upgrade to 12c (Application is not certified for 12c, testing to identify state)

Database refresh (duplication) / Schema refresh

Performance tuning for ‘bad’ sql.

 

Anthem February, 2016 to November 2016

Sr. Oracle DBA – Enterprise Security

• Creating and standardizing processes for access management on a variety of platforms including Oracle (11g and 12c primarily PDB), Unix/Linux (Primarily AIX and Redhat with some HP Unix) and Sybase using scripting methods of Batch, Shell and SQL

• Automating processes within the ticketing system, SNOW (Service Now), to streamline access controls for Oracle, Unix/Linux and Sybase

• Written scripts (PL/SQL and BATCH) to extract data from Asset management repository to validate against live CI’s

 

 

 

Mercy Healthcare     Oct 2015 to February 2016

Sr. Vendor Relations Specialist

• Managing relationship with Healthcare vendors like GE, Provation, EPIC along with traditional IT vendors like Oracle, IBM, TIBCO and specialty vendors like SPOK, American Messaging, Alfresco etc. to assure comprehensive optimization in pricing & SLA's.

• Primarily focused on managing and negotiating Professional services SOW's for new projects.

 

Monsanto             May 2007 - August 2015

Lead Oracle DBA

·         Single point of contact between OCMS (Oracle Consulting Managed services) and the business customer, for supporting the EXADATA environment since October, 2011, starting off with migration and consolidation of 22 Oracle databases from disparate environments into one EXADATA database, this is an enterprise solution utilizing Golden Gate for data replication.

·         Implemented database migration to AWS (NON-IP data only)

·         Evaluation EC2 (Elastic Compute) to cater to scalable infrastructure in support of development lifecycle during migration to AWS

·         Technical Project lead for LCM (Life Cycle Management) project to migrate multiple databases from Hp Unix to AIX.

·         Led the effort for internal tracking of un-planned outages (RCA) to proactively address risk scenarios and prevent future outages. This is done across environments.

·         Supporting application team in their development cycle using both Agile and Waterfall methodologies.

·         Executed the project for converting databases to start using UTF8 characterset, this is a pre-requisite for any database that might be dealing with non-English language characters and essential in a GLOBAL environment. This was done to enable merging of SAP and non-SAP data.

·         Technical Project lead for creation of a Data Warehouse utilizing Oracle Streams as an Enterprise wide solution in a downstream environment

·         Tuning SQL and database as needed to facilitate code enhancements.

·         Created the procedure and scripts required to clone database (Production to non-prod), including reverse engineering the user roles and privileges and re-instating. This is done using RMAN.

 

 

Charter Communication St. Louis, MO Employee                  Jan 2006 –May 2007

Sr. Oracle DBA

• Single point of contact for the only RED level Oracle database in the organization (Business crucial database on BCV’s)

• Responsible for planning and implementation of plan to physically relocate 600 GB production database used for change control, using standby database solution for minimum downtime

• In house DBA for testing DSS migration from 8.1.7 and 9i database to 10g (over 1.5 TB), Migration plan included new server using SunOS and Oracle 10g. includes testing and implementation of new features for flashback recovery, automatic SGA etc.

• Cloning database using RMAN, OMS

• Setting up OMS monitoring for databases including tablespace usage, instance outage, listener outage, filesystem utilization, scheduled jobs etc.

 

 

 

Paulo Products, St. Louis MO, Employee               June2003-Dec2005

Systems Specialist / Oracle DBA III

• Solely responsible for Design & Creation of Data Warehouse system to improve data availability / reporting capability for top management enhancing decision making capability, this involves extraction of data from an Oracle database, transformation and load into a star schema.

• Extraction of data from SQL Server and upload into Oracle for reporting purposes

 

Technosoft, MI            June2001-April 2003

State of New Hampshire, Concord, NH 

Senior Data Architect and Implementation Lead for VLDB / Oracle DBA

•          Headed the team for implementing Data Warehouse solution for State of New Hampshire

•          Created the Technical Documentation / Requirements for initiating project

•          Designed and set up the Oracle Database for Data Warehouse using Oracle 8.1.7 (8i)

•          Developed the Data Warehouse using SQL plus & Unix Shell scripts for ETL purpose

•          ETL executed using source data from DB2 targeted into Oracle

•          Designed front-end in Access for BI

•          Metadata at columnar level

•          Completed the overall knowledge transfer to the client

Environment Oracle 8.1.7 (8i), HP Unix, ERWIN 4.0, Access, Cognos

 

 

Achievements

Conducted Training Programs for various premier Computer Training Organizations like: -

CDAC, Concourse, Datapro, NIIT, CCIT from June ’87 thru September ‘93

 

Organized and Conducted several Training Programs for:-

Origin Infotek (A software consultancy), Infomatics (A software consultancy), Hindustan Petrochemicals Limited, Rubber Products India Limited, Cable Corporation of India Limited, Premier Automobiles Limited, Shriram Fertilizers and Chemicals, Shipping Corporation of India, Howmedica (A part of PFIZER)

 

Education & Certification

• Certification in SQL Server 2005

• Certification in System Administration from JDE/PeopleSoft – USA

• Certification in Cognos, from Cognos – USA.

• Certification Advanced Oracle 8 DBA with focus on Parallel Servers and

• Bachelor’s Degree in Business Commerce Amravati-India