Oracle Database

*E-mail: *********@*****.**.**

*Phone: 91-985*******/937*******

Experience Summary

. Oracle Certified Professional with over 4.10 years of Oracle DBA

experience.

. Presently working with "Polaris Financial Technology Ltd." as

Associate consultant.

. Experience of Installation and Administration of oracle 10g and 11g

Release 2 RAC & ASM.

. Strong knowledge of backup and recovery using RMAN, Import/Export,

Expdp-Impdp.

. Performance Tuning of database using AWR, ADDM & ADR

. Capable of learning new technologies quickly, good team player and

good team co-ordination skills

Skills & Competencies

> Installation of Oracle on Linux /IBM-AIX / Sun Solaris / Windows & HP-

UX.

> Upgradations, Migration from oracle 10g to 11g, applying the new

patches.

> Plans and implements backup and recovery of the Oracle database.

> Optimization of existing processes and tools.

> Excellent knowledge of Oracle backup and recovery scenarios.

> Provide second line production support - analyze helpdesk cases,

communicate with production, tool development departments on findings,

possible solutions and fixes.

> Creates and maintains all databases required for development, testing,

education and production usage.

> Performs database re-organizations as required to assist performance

and ensure maximum uptime of the database.

> Administers all database objects, including tables, indexes, views,

sequences, packages and procedures.

> Repair corrupts databases (logical exports and imports, restore from

backups).

> Developed backup & restore strategies for Hot & offline backups.

> Disaster Recovery planning & Implementation DATA GUARD.

> Coordinate the implementation of process controls in the team.

> Troubleshooting of technical problems (process, tool).

> Participate in analysis and optimization of existing database

maintenance processes.

> Measure the performance of a Team and Finding the ways for improving

the performance.

> Excellent knowledge of RMAN & DATAPUMP .

> Installation of Linux, Sun Solaris, Windows & HP-UX

> Creating Shell scripts for database task automization.

Employment History

Company : Qualitat Systems

Period : November-2008 to May-2011.

Company : Techtimers Solutions Pvt. Ltd

Period : May-2011 to May-2012

Company : Polaris financial technology limited

Period : May-2012 to Till Date

Platforms : UNIX, windows, Sun, Linux, HP-UX.

Work Experience

Polaris Software Financial Technology. (Current Company)

Duration: 16 -May-2012 to till date

Current Company Clients

Client : RBI (Reserve Bank of India)

Project : Oracle Database Support

Duration : : may-2012 -- till date

Backend : : Oracle 10g, 11g

Platform : Red hat Enterprise Edition, Solaris, Windows,

HP-UX

Designation : Consultant (Oracle DBA)

I am working with Polaris Financial Technology (RBI Client) as Oracle DBA.

Following are my job and responsibilities:

> Installation of Oracle, Upgradation, Migration, cloning, backup

/recovery, performance Tuning etc. of database.

> DATAGUARD configuration for LOGICAL standby database.

> Setting up user profiles and roles as per the access level of user for

the data and application security

> Verify the entire daily generated file logs / Alerts of all the

processes.

> Create plan of action and log the calls for CMT to (the change

management team)

apply the new tested changes.

> Patches that approved by the RBI.

> Database tuning, reorganization of database objects to improve

performance

> Coordinate with application team to deploy new EAR.

> Coordinate with Development team to apply new, modify pl/sql packages

and other objects for the new processes.

> Check all the Active Alerts services running on production servers.

> Generate the health check reports of the oracle database

> Monitor the tablespaces, instances and other day by day generated

alerts

> Keep tracking on database growth and according to that plan for

storage requirement.

> Perform DR drill activates quarterly.

> Online Help & support to the RBI users.

> Schema refreshment.

Achievements:-

> On-the-Spot Award (RBI - KHARGHAR), 2012

Previous Company Clients and Details

1) Techtimers Solutions Pvt. Ltd. (Last Company)

Duration: 31-May-2011 to 14- MAY-2012

Client : Reliance Communication

Project : Oracle Database Support

Duration : : May 2011 - May-2012

Backend : : Oracle 8i, 9i, 10g

Platform : Sun Solaris, Windows

Designation : Oracle DBA

I have worked at client-site of Reliance communication, different

application vendors and responsible for supporting about 30 oracle

production instances and 2 UAT instances and In the non business hours, two

Roles and Responsibilities:

> Installation of Oracle, Upgradation, Migration, cloning, backup &

recoveries, check the Performance Tuning and work on other oracle

configurations.

> Verify the entire daily upload generated logs and Alerts of processes

of all the processes.

> Verify the entire daily generated file logs / Alerts of all the

processes.

> Patches that approved by the business.

> Coordinate to the team to apply new, modify pl/sql packages and other

objects for the new processes.

> Check all the Active Alerts services running on production servers.

> Generate the health check reports of the oracle database

> Monitor the tablespaces and instances.

> Perform the Database purging activity.

> Supporting 24x7 Production environments.

> Managing database security and creating and assigning appropriate

roles and privileges as required by the application.

2) Qualitat Systems. (Last Company)

Duration: 10-Nov-2008 to 30- MAY-2011

Project : Oracle Database Support

Duration : : Nov-2008 - May-2011

Backend : : Oracle 8i, 9i, 10g

Platform : Sun solaris, Windows

Designation : Oracle DBA

Role and Responsibilities:

> Hot, Cold and logical Backup of Database.

> Backing Up controls file.

> Compilation of invalid objects.

> Relocating Datafiles.

> Resizing Datafiles.

> Database name and DBID changing.

> Checking Alert Log file for errors and making necessary actions to

rectify them.

> Checking Last night backup.

> Checking Alert Log file.

> Monitoring the database growth.

> Killing unwanted user sessions or processes.

> Oracle Export and Import.

> Checking space of mount points.

> Histogram rebuilding on tables and indexes.

> Gathering statistics for table and indexes.

> Database creation on UNIX, SUN.

> Oracle 10g Database patching using OPatch.

> Hands on with Oracle Database Minor Upgrade (Patch set Upgrade).

> Oracle 10g Installation on Windows, REDHAT 4 & 5, SUN Solaris & HP-UX.

Educational Qualifications

> M.Sc. from M.G.M. College, Aurangabad (M.H.)

> B.Sc. from dr. Z. H. Academy, Burhanpur(M.P.)

> H.S.C. from S.V.M. School, Burhanpur (M.P.)

> S.S.C. from S.V.M. School, Burhanpur (M.P.)

Certification Completed

ORACLE 9i DBA Certification: Qualified OCP in June 2009

Personal Details

DOB : 26-02-1986

DATE: - / / Ravindra Zope

[pic]

Contact this candidate