Oracle Management

SHIRISH PATIL

PMP, OCP

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

Cell: +1-201-***-****

Highly experienced in Database Administration, Performance Tuning, Database

Design and Architecture, Maintenance, Backup & Recovery, Migration,

Partitioning, Production (24*7) Support, RAC, capacity planning, R&D,

interacting with cross-functional and application development teams for

enterprise wide database solutions.

PROFESSIONAL OVERVIEW

> Around 10 years of IT experience with 8+ years experience DBA, leading

and supporting production (24*7) and various development environments

with multi-terabyte and high-volume multi-million daily transactions OLTP

and OLAP databases.

> Work closely with engineers, development and functional teams, business

product group and peers to understand the business requirements and help

design, develop and implement database solutions that meet the business

needs.

> In-depth knowledge of Oracle Wait Interface, DBA_HIST tables, V$ views

and wait event analysis and highly skilled in performance tuning using

technical and logical approach to fix the root cause.

> Identifying automation opportunities and implement solutions to improve

efficiency, remove dependencies, service reliability and productivity of

the team and ensuring optimum use of available resources.

> In-depth understanding of Oracle architecture and internals and advanced

features like Partitioning, RAC, DataGuard, RAT, AWR, ASH, OEM, CRS,

Transportable Tablespace, Database Refactoring etc.

> Lead and train a team of database administrators on the use of new and

more advanced features of Oracle more effectively.

> Data modeling and designing for multiple applications with evolutionary

change management techniques. Skilled to re-factor existing data models &

databases for performance and scalability.

> Consultative and analytical approach with openness to other's ideas and

flexibility in the determination and consideration of options to achieve

expected results within the triple constraints of Cost, Scope and Time.

> Quick learner, Ambitious, A Team player, highly energetic, Good

Researcher, self-motivated and motivating the whole team, easily

adaptable to new environments.

> Applied knowledge in statistics, data mining, process optimization, data

pattern analysis, trending, probability, capacity planning & forecasting.

Expert in heavy data analysis to identify trends, usage patterns and

forecast systems behavior.

> Work with various application and third party vendors for continuous

support and issue resolution.

> Always eager to learn new concepts, tools and technologies.

Education and CERTIFICATIONS:

> MCA - Masters of Computer Applications

> PMP - Project Management Professional

> OCP - Oracle Certified Professional - 11g, 10g, 9i

Experience

SITEK INC. - Lexington, KY Mar 2008 -

Current

Title: Senior Oracle Database Administrator

Client: Health and Human Services Commission (HHSC), State Of Texas,

Austin, TX

www.hhsc.state.tx.us

Role: Lead DBA

. Managing and administering multiple HHSC databases like TIERS, TLM,

and PORTAL with Oracle 10g RAC.

. Ensuring the compliance with security policies (HIPAA, SOX) and

various HHSC Regulations.

. Designed enterprise wide archival strategy to archive data not needed

by business and prevented unnecessary growth of database. This

improved the online performance by 100%.

. Reorganized and restructured various key entities across the database

using partitioning and transportable tablespace technology for

improving performance in the key areas of the application.

. Authored and modified several crucial maintenance tools to automate

the processes for better productivity of team and efficient use of the

resources.

. Designed the database architecture, ERD's and solutions for various

new initiatives across the enterprise.

. Imparting training and guidance to development and testing teams for

better use of database technologies.

. 24*7 on-call support.

. Identifying areas of improvement in processes and procedures and

providing optimal solutions, defining enterprise wide standards,

policies and procedures.

. Trend analysis, data mining, data pattern analysis and extrapolation

for several critical issues and propagation to represent to management

about the historical performance and future impacts.

. Coordinating with and supporting various third party vendors and other

state agencies, which use HHSC systems and databases.

. Continuous evaluation of the database performance and improving it in

tandem with the several new initiatives and projects being injected

into current HHSC system.

. Interacting with various cross-functional and development teams for

understanding the requirements, evaluating requested changes and

designing optimum solutions by catering to business needs.

. Prioritizing and allocating tasks and issues.

Client: Duke Energy, Charlotte, NC

www.duke-energy.com

Role: Database Admin- Lead

. Managed all aspects of database functions to meet the support

requirements of application development and infrastructure teams.

. Accountable for management and support of multiple multi-terabyte

Oracle Financial, PowerPlant and TaxStream databases for Production,

Mock, Conversion, Staging, Training, Development, System Testing,

Performance test, deployment and ensuring the compliance with Security

Policies.

. Projected long-range requirements for database administration and

design in conjunction with Managers.

. Implemented database security guidelines and procedures.

. Created new data warehouse for enterprise reporting, from OLTP system.

. Migrated enterprise reporting systems from business objects to SQL

server SSRS/MSRS.

. Maintained and continuously improved performance of the Star schemas,

materialized views using database technologies like star

transformation and bitmap index.

. Lead the database administration efforts imparted training and

mentored Junior DBA's.

. Ensured the availability, reliability and performance of all the

databases as per the business SLAs.

. Implemented the processes to centralize all DBA scripts and database

object's script to remove duplication and reduce error margin.

. Project management, development of best practices and repeatable

procedures for deploying databases, and day-to-day operational

activities including break-fix, space management, backup and recovery,

cloning.

. Managed large oracle databases servicing OLAP, OLTP and DSS

applications.

. Liaison between Clients, DBA team and various development tracks

(Mock, Conversion, Performance and System Test, Training) and

Production database for all the database related issues.

. Carried out R & D for enhancements.

. Provided direction to the team, setting strategy, managing crisis

situations and Navigating through highly complex problem situations

and meeting customer expectations.

. Generated various reports related to utilization, Space allocation,

refresh schedule, Facts gathering and coordinated cleanup activities

for all the databases and provided them to the management.

GROUPWARE SOLUTIONS INC. - Somerset, NJ Mar 2007 - Mar

2008

Title: Programmer Analyst

Client: Health and Human Services Commission (HHSC), State Of Texas,

Austin, TX www.hhsc.state.tx.us

Role: Sr. Oracle DBA

. Evaluated and approved requested changes by application development

teams.

. Performance tuning of HHSC integrated eligibility database - TIERS.

. Wrote tools for automating various manual processes and also for

generating various management timeliness reports.

. Generated various metrics for usage of database objects and utilized

it to focus on the areas of improvements in the whole system.

. Re-constructed (partitioned) one of the main table which triggered and

controlled task across the database system and that improved the

performance by 50%.

. Implemented archival strategy.

Client: Verizon Wireless www.verizonwireless.com

Sr. Oracle DBA

. Upgraded Production, Development and QA databases from Oracle 9.2.0.5

to Oracle 10.2.0.2.

. Applied Patches on Oracle Server to fix oracle bugs and provided 24*7

on-call production supports.

. Scheduled scripts for the database monitoring, backups, Management

reports, and analyzed indexes in off-peak hours.

. Created and Managed Partitioned Tables using dynamic scripts.

. Effectively used Data Pump and Export/Import utilities for logical

backups, database and table refreshes.

. Set up Backup and Recovery of database using RMAN.

SYNECHRON TECHNOLOGIES, Pune, India Jun 2006 -

Feb 2007

Title: Senior Associate - Software

Client: Mortgage Cadence, Denver, CO www.mortgagecadence.com

Role: Sr. Oracle DBA

. Successfully migrated mortgage financial database from SQL Server to

Oracle by designing matching architecture on Oracle database to match

with existed SQL Server database.

. Accomplished porting of SQL Server (2005/2000) Database to Oracle10gR2

using Oracle Migration Workbench.

. Distributed Redo logs on different disks for major performance gain.

. Extensively used Oracle Enterprise Manager (OEM) Grid Control for

monitoring and administering database.

. Used Data Pump utilities and traditional export import utilities for

logical backup and recovery.

. Supported developers, performed database tuning, scripted database

alerts and monitoring scripts.

. Tuned Oracle memory parameters for better performance.

. Successfully done database software management (patch and version

management) and Case management with oracle technical support.

. Provided PL/SQL Support to PL/SQL Development team.

. Assisted the Manager of the Client Production DBAs in project

implementation analysis, Identifying Oracle Database architecture

requirements, Unix Server requirement, Data Storage requirements and

resources estimation, Interviewing, Hiring process.

. Lead and coordinated across technical teams, including client team

members, and subcontractors.

S1 SERVICES (I) PVT LTD. - Pune, India Apr 2005 -

Jun 2006

Title: Software Engineer

Client: FRS, Brussels, Belgium www.frsglobal.com

Role: Database Administrator and Programmer

. Was accountable for database administration of production and

development database on Oracle 10G, Oracle RAC using Grid control,

setting up data guard/standby for disaster recovery and high

availability.

. Performance Tuning of Database and SQL queries for better response time.

. Managed large scale financial oracle deployments, databases servicing

OLTP and DSS financial applications.

. Developed stored procedures, triggers etc.

. Monitored disk space, performance and data loading applications.

. Successfully done Job scheduling for database backups.

. Executed export/import to refresh databases and schemas effectively.

. Designed and created databases for several critical financial banking

regulatory reporting applications called PARAMS.

. Was Liaison for database support to internal data warehousing and data

mapping tool called Financial Analytics.

. Lead the 24*7 on-call production supports and actively participated in

training sessions.

EFFECTIVE TELESERVICES, Gandhinagar, India Sep 2004 -

Mar 2005

Title: Operations Support Specialist

Client: Etech Inc., Nacogdoches, TX www.etechinc.com

Role: Sr. Oracle DBA and Programmer

. Designed and created database for different in-house applications.

. Network administration for oracle connectivity from different client

machines.

. Interacted with application development teams to guide them for writing

efficient SQL queries.

. Managed backup and recovery of the databases using RMAN efficiently

. Successfully performed vital role for writing and tuning SQL Queries

and PL/SQL code for the applications.

. Gathered Requirements for database designing from internal departments

and external partners.

. Managed oracle deployments and large oracle databases servicing OLTP

and DSS applications.

. Created and maintained Oracle database instance, database design,

database performance monitoring and tuning, PL/SQL analysis and

coding, Unix/Linux shell script, and data modeling throughout

application development life cycle.

. Coordinated meetings across technical teams including development,

testing, and DBA teams.

. Lead DBA team to include creating objectives and given yearly review.

THE VISION SOFTWARES, Gandhinagar, India Jun

2000 - Aug 2004

www.thevisionsoftwares.com

Title: Assistant Programmer and System Analyst

. Involved in all phases of database development, from requirements

assessment to QA/QC, design and support in SDLC.

. Analyzed requirement and developed SRS, Identified different modules

for product and defined processes.

. Developed Data-Flow-Diagrams and Entity-Relationship Diagram and

designed database from scratch.

. Designed database and implemented database strategies.

. Developed application modules adhere to the system requirement

specifications.

. Received solid understanding of oracle internal architecture and done

Performance tuning of database and SQL's.

. Designed and implemented enterprise backup and recovery strategies for

Database.

. Imparted training to the Junior DBAs and new team members.

Tools and technologies:

Databases : Oracle 11g/10g/ 9i/ 8i, Sql Server 2005/2000

OS : Solaris, Linux, UNIX, AIX

Tools & Utilities : AWR, ASH, RAT, Datapump, OEM, CRS, RAC, ASM,

RMAN, Dataguard, Toad, Sql Loader,

Pl/Sql Developer, Transportable Tablespace, Partitioning,

OMWB, VMWare, BMC Remedy,

HP/ Mercury ITG & Quality Center, SharePoint, Precise I3, MS

Excel, MS Project

Case Tools : ERWin, Rational Software Architect, MS VISIO, UML, ERD, DFD

Contact this candidate