Engineer Oracle

Tushar Patil

Email: *************@**********.***, Phone: +91-992*******

Experience Summary

I am an Oracle DBA with a total of 8 years of work experience. My main area of experience has

been administrating and Performance Tuning of production database server of various sizes. I

have worked primarily in the domain of Telecomunication,financial services and manufacturing.

My technological forte is Oracle and I am also proficient in Oracle 8i, 9i and 10g,11g.

Project Thesis

Customer Tata Consutancy services (TCS)

Project title Assistant Consultant (Oracle DBA)

Solution Environment HP Unix 11.31,Sun SPRAC Solaris,10g,11gR2,DB Sizes

3TB,18TB

Responsibilities 1)Installation and upgrade Oracle Database Including Single

instance and RAC (4 node cluster)

2)Patch Upgrade (CPU and PSU)

3)Clonning of Database using RMAN and Manual method

4)Database Migration from windows to Sun SPRAC Solaris

platform.

5)Managing RAC,ASM Instances,Add node,remove node

from cluster.

6)Daily health check monitoring for Databases

7)Managing Backup and Recovery using RMAN and

Manual method and tools used for backup are VERITAS Net

Backup and EMC Networker Storage Manager.

8)Managing Exadata server and attended TCS internal

training for Exadata storage server patching webinar to

understand and explore more on Exadata efficinecy.

9)Worked on Oracle utilities like SQL *Loader,NETCA.

10)Managing Performance tuning of very sensitive

databases

11)Co-ordinating with different stakeholders and taking

weekly meetings for highliting the user requirements and

application performance issues.

12)Managing BCP site for DR

13)SLA management and Performance Benchmarking

14)Scalability and Capacity Sizing

Customer IBM India pvt ltd. (Mumbai)

Project title Oracle DBA

Solution Environment Oracle 10gR2 database, AIX P595 version 5.3

Toad for 10g,Pl/sql Developer, Db sizes are 7TB,19TB and 8TB

Responsibilities 1)Maintioning Physical Standby database.

2)Check all the cluster services are up and running

3)Check all the Application servers services are up and

running.

4)Monitoring of long running Queries and suggesting fine

tuning of queries

5)Daily Health Check for all databases

6)Check the DB scheduler running sucessfully

7) Monitoring Server memory usage per Oracle user

(SAR/IOSTAT)

8)Generating 'AWR reports during peak load'

9)RMAN backup,Full Export Backup/Hot Backup

Completion & Monitoring with IBM TIVOLI Storage

Manager

10)Listners Status Check

11)Alert Log check for the any malfunction of the database

12)Database user management

13)Administrating Golden gate

14)Documentation of tasks & procedures

14)Periodic check of undo segments

15)Database Parameter changes as per on going

Customer Bombay dyeing& mfg. Mumbai

Description To Move up the value chain.

To Allign supply chain to optimize logistics costs.

To Improve service levels in line with world standards.

Project title Oracle DBA

Solution Environment Oracle 10g/ 9i Database

Sun Solaris 9/10

Microsoft Windows 2003

Toad for 10g,Pl/sql Developer

Responsibilities Database creation on UNIX and Windows/Linux10

Well versed with 24 x 7 Database, production

environment and Multi server management

Creating Database both manually & using DBCA

Space management and Estimation. Reorganization of

large tables to reduce fragmentation and row chaining, to

improve performance

OS level users Creating Oracle and manage authentication

Assign and manage privileges

Table Partitioning

Good exposure to Manual Backup and Recovery

techniques

Good exposure to RMAN Backup and Recovery

techniques

Minor & major database upgrade, troubleshooting and

database maintenance

Network Trouble Shooting using TNS configuration,

Listener load balancing with and without netca utility.

Cloning from hot and cold backups

Export and Import using data pump

Database Monitoring using DBConsole

Data Guard (Physical Standby Database)

RMAN Cloning for database

Patching RDBMS using Opatch utility

Oracle Database Production Support

Project Title

Organisation Stratemorphics India ltd Mumbai.

Customer Geneva watch group (U.S.A), Texas Instrument (U.S.A)

Description Integrated, multi-user database that minimizes data entry.

Multi-level access control for secure, multi-department usage.

Performing weekly updates update of watches across

Nation and generating EOM (End of Month report).

Analyzing and forecasting requirement, sales, and order of

Company for their clients

Power and flexibility. Information more efficiently effectively.

Role Database Engineer

Solution Environment Oracle 9i Database

HP-UNIX 10,Win2000 Server

Proposed for Standby Database and Testing Server

Resposibilities

Installation issues (New installation, Version upgrade,

Installation of patches)

System Admin issues (lost password, Failed connection,

connection errors, print errors)

Database admin issues (Backup database, import errors,DB

conversions)

Equity Edge admin issue (Create loginpassword, moving

Equity Edge database to other servers).

Responsible for Oracle software implementation and

upgrade.

Responsible for the installation, setup and testing of Oracle

Utilities/tools

Performed Incomplete Time Based Recovery in Production

environment

Designed and Created primary structures such as tables,

views and indexes

Provided regular Database Administration to help

developers and users.

Creation and modification of primary database storage

structures i.e. tablespaces and also creation of database

objects such as table, index, sequence etc

Project Oracle Database Production Support

Organisation Spider systems pvt.ltd Pune.

Customer Idea cellular pune,Sakal papers ltd.

Description To Maintain the historical data and providing software solutions.

Role Database Engineer

Solution Environment Oracle 9i

Microsoft Windows 2003

Toad, SQL Loader

Worked on database level clustering in 10g RAC on

Responsibilities

RHEL4 (Red Hat Linux) enviorment.

Designed Backup and Recovery Strategy, Performing the

daily analysis of Alert log and related trace files, Backup

Through Import/ Export

Responsible for Oracle software implementation and

upgrade

Responsible for the installation, setup and testing of Oracle

Utilities/tools

Oracle Configuration, connectivity and trouble shooting.

Performed for DB tuning using Statspack

Collection of statistics using DBMS_STATS

Performed Incomplete Time Based Recovery in Production

environment

Created Users, created Roles. As part of security granted

and revoked permissions, Audited User accesses. Mirrored

the control file and log member in each log group

Provided regular Database Administration to help

developers and users.

Career Profile

(List the companies you have worked with, recent ones first)

Dates Organization Role

From Dec 2008 to 2010 IBM India pvt. Oracle DBA

(MUMBAI)

From 27th March 2007- Nov Bombay dyeing& mfg. Oracle DBA

2008 Mumbai

Database Engineer

From Jun 2006 to Feb 2007 Stratemorphics India ltd

Mumbai.

Spider systems pvt.ltd Software Engineer

From June 2005 to May

Pune.

2006.

Qualifications

Degree and Date Institute Major and Specialization

B.E(Mechanical) R.M.C.E.T(Mumbai University) Mechanical (2nd class)

H.S.C Y.C jr. college (Maharashtra state) Science (1st class)

Professional Memberships / Certifications

Professional Society / Certification Member Since / Date Certified

OCP May 2007

Training and Education Summary

Program or Course Coverage Dates

Sun Solaris 10.05 SA-1 Jul 2007

Oracle 9i DBA Track Feb 2005

Oracle 10g DBA Track May 2007

Personal Details

Date of Birth <13-03-1982>

Nationality Indian

Marital Status Married

Address B\408,Tyagraj Lokpuram chs.

Pokhran Road 2

Pawar Nagar, Thane west

Mumbai

400610.

Contact this candidate