Manager Information Technology

MEGHANA JADHAV

***** ********** **, **** *, Chatsworth, CA-91311 818-***-**** (M) **********@*****.*** Summary

Over 7 years of experience in Oracle database administration

Experience working with Engineering systems such as Exadata and Oracle Data Appliance (ODA) and Oracle Golden Gate.

Extensive Knowledge and hands on experience on database upgrade, designing and managing standby databases, grid upgrade, patching and OEM upgrade to 13c to 12c, managing Golden Gate and Exadata

Self-starter, excellent communicator with multi-tasking skills, as well as able to work professionally and effectively under pressure.

Certification

Six Sigma Green Belt Certified

Oracle Certified Associate (Oracle 10g )

Professional Work Experience

Sr. Database Engineer - Overstock.com Nov 2015-Present

Day to day I am responsible to develop, design and maintain highly available and scalable databases on Engineered systems like Exadata, Oracle Data appliance and RAC on Oracle Linux.

DDL review is important aspect of my job to ensure that all application design and code is produced with proper integrity, security and performance. Perform reviews on the design and code frequently to ensure the site standards are being adhered to and I validate the data model with architecture.

As a 24*7 database administrator for multi terabyte databases I am responsible for monitor the performance of production databases, identify areas where performance needs to be improved and provide fixes/solutions for the performance issues.

Upgraded databases from 11g to 12c, administered the 12c databases.

Recently worked on migrating databases from existing servers to Engineered systems ODA.

Upgraded our high availability Oracle Enterprise Manager from 12c to 13c.

Maintenance of scheduler jobs for various recommendations and loading data from partners, responsible to make sure that job runs successfully every day.

Upgrade Grid software from 11g to 12c and upgraded RAC database from 11g to 12c using manual upgrade method

Support Golden gate and standby database support, backup and recovery

Daily/weekly refresh of production database to dev, test and cloud environment.

Participated in updating the April PSU patch and July PSU patch for 12c databases.

Actively participate in training and documentation for databases support.

Evaluate and research releases of Oracle and its tools, and third party products to ensure that the company is running the products that are most appropriate

Supporting critical databases and meeting development requirement requires difficult decisions regarding best practices that will require analytic thinking to determine when deviations from standards as necessary, and develop plans to correct deviations and technical debt in the future. MEGHANA JADHAV

20734 Devonshire st, Unit A, Chatsworth, CA-91311 818-***-**** (M) **********@*****.*** Programmer analyst/ DBA- IT Dept. California State University, Northridge Feb 2014-Nov 2015

Demonstrated project management experience executing the large scale upgrade project from initiation through implementation and ensured the delivery of upgraded Oracle enterprise management system within project timeline

Upgraded Oracle Enterprise manager cloud control from 11g to 12c using 2 system approach

Created Web-based platform for authoring, managing, and delivering interactive reports and all types of highly formatted documents with Oracle Business Intelligence Publisher (BI Publisher),

Defined and configured monitoring templates, metrics in Oracle grid control 12c

Resolving database issues/alerts from Oracle Enterprise Manager cloud control (OEM) on daily basis

Weekly Data Refresh from Production to Test and Development environments and executing DML as per business change requirements

Maintaining and Troubleshooting the Management Repository for well performance of the OMS application

Patching Oracle Management Service and the repository

Automated routine administrative tasks and synchronize components in our environment utilizing the Job System and Corrective Actions feature of OMS.

Defined and set up Incidence management policies to monitor and resolve service disruptions quickly and efficiently

Implemented database provisioning to facilitate the reliable, automated and scheduled mass deployment of software, applications and platforms to efficiently manage the lifecycle management

Optimizing the Oracle WebLogic server to enhance the performance of the application

Administration and maintenance of two node RAC 11g databases on Oracle Linux and supporting production and non-production RAC databases

Migrating the databases from one host to another to create the test environment for the upgrade and also migrating the database to new ASM storage. DBA Student Assistant IT Dept. California State University, Northridge March 2013-Jan 2014

Maintenance and administration of Oracle Databases and portal applications.

Monitoring and maintaining database using Oracle grid control

Data Refresh from Production to Test and Development environments using RMAN Duplicate Database

Resolving database issues/alerts from Oracle Enterprise Manager (OEM) on daily basis and observation regarding space management providing on-fly solutions to have database healthy and running.

SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN and monitor the database performance on daily basis.

Creating and Rebuilding Indexes and optimizing the code to improve the performance. Sr Database Administrator- Wipro Technology Services May 2011-Feb 2012

Proposed and implemented strategies to enhance processes, procedures, systems, metrics, and productivity in day to day database administration operation

Worked on administration, configuration, migration and patching databases MEGHANA JADHAV

20734 Devonshire st, Unit A, Chatsworth, CA-91311 818-***-**** (M) **********@*****.***

Worked closely with application developers to design the databases

Maintained and configured databases monitoring tools like OEM (oracle enterprise manager).

Worked on creating/modifying primary database storage structures (table spaces) after application developers have designed an application, logical backup, troubleshooting the errors and scheduling the routine activities.

Transferred data objects using utilities such as export/import and datapump utilities for schema backup and schema refresh

Monitored database lock and resolved the lock contention and Improved the database performance by analyzing AWR and ADDM reports

Monitored database usage trends for storage, CPU and memory. Track and report to management.

Involved in creating mappings using Informatica Power Center Database Administrator - Reliance Communication May 2009-May 2011

Worked on six-sigma implementation at the Internet data center involved in root cause analysis, change management, Customer segmentation, data collection and data cleansing and compliance analysis

At Internet data center I was responsible for managing Oracle databases for all the managed database services

I was responsible for designing, creating and managing the Standby databases

24*7 on call rotation to support critical production databases

Troubleshoot and document the database errors and follow-up with Oracle support Graduate Engineer Trainee - Reliance Communication March 2008-May 2009

At Internet Data Center I was responsible for the data analysis of the business processes and implementation of six sigma methodologies as a part of the process improvement.

Decomposing high-level business and user requirements into functional requirements specified in an appropriate level of detail suitable for use by those who must base their work on the requirements

Defined objectives and goals, suggesting KPI’s as per the business requirement

Worked on measuring the KPI, reporting and sustainability efforts for continual improvement

Worked with internal database to build and optimize the report to target various markets and customer segments

Organized, coordinated and managed small to medium size work efforts and/or projects

Worked with Senior Management to report on operations key performance indicators and help identify areas of improvement

Developed customer segmentation and used statistical techniques to drive business strategy

Implemented efficient reporting standards to ensure thorough analysis and collection of data

Analyzed change management and ongoing operational requirements in order to realize the real benefits of the initiative

Performed root cause analysis to identify solutions that address the true source of issues and gaps

Contributed to the overall maturity of the function through designing of tools/templates and by providing education to peers and key customers.

MEGHANA JADHAV

20734 Devonshire st, Unit A, Chatsworth, CA-91311 818-***-**** (M) **********@*****.*** Academic Projects

Statistical Significance testing- Credit Spread and Market Risk in the Indian debt market Key Skills: Statistical Significance testing

Tools and Technologies: Microsoft Excel, Minitab

The objective is find the correlation between the various factors influencing AAA rated corporate bond spreads over government bonds in India. The basis of the study is an analysis of trends in spreads over the past decade, its correlation with the macroeconomic scenario, and related factors like inflation, GDP, liquidity in the market

Economic analysis of LAUSD transportation

Key Skills: Recovery period analysis, benefit to cost analysis, replacement analysis, economic analysis Tools and Technologies: Microsoft Excel

This report presents engineering economic analysis of replacing 400 LAUSD conventional school buses to CNG buses. Based on this economic analysis, the scope is extended to larger scale. Report presents how the transformation affects smog level, environmental spending and gas usage.

Process improvement of Catapult using six sigma methodologies Key Skills: ANOVA, Process improvement, FMEA analysis Tools and Technologies: Minitab

Reduced the variation and improved the shooting distance to 75.76 2inches inches which is the desired value of the customer.

Lean application to the Information Technology process Key Skills: Lean methodologies, 5S

Studied and designed the lean methodologies for information technology service delivery unit. Education

Masters in Industrial Engineering, December, 2013

California State University, Northridge

Bachelor in Engineering (Electronics and Tele-Communications) August 2007 India

Contact this candidate