Oracle DBA

Jagdish Vasantrao Lad

Mo.: +91-997*******

Email: ***.*******@*****.***

Professional Summary:

Over 2.7 years of experience as an Oracle Database Administrator in production support domain. Having hands on experience in database administration Ability to manage multiple projects for internal and external customers Innovative and creative problem solver, results oriented, has an aptitude for learning.

Skill Summary:

Ability to Work in a 24x7 production environment and provided on-call and day-to-day support.

Understanding the customer’s requirements and preparing requirements specifications.

Experience to Troubleshooting user’s related issues, error on-call basis.

Strong experience with Oracle 10g/11g Installation, Database creations, Administration, Monitoring, Database Backup and Recovery.

Good exposure to database Cloning (i.e. Cold/Hot Backup and RMAN)

Strong experience in logical backup using Data pump and Traditional Exp/Imp.

Experience in User Management, Space Management, tnsnames & Listener Configuration.

Creating and Managing Tablespace, data files, schema objects and users.

Good exposure to RMAN Backup and Recovery techniques.

Experience in oracle database10g/11g Upgradation.

Experience of Implementation and Administration of Oracle Data guard.

Organizational Experience:

Working as Oracle DBA with iWareLogic Technologies Pvt Ltd from January 2012 to Till Date.

Currently working as Oracle DBA on client side Parametric Technology (India) Ltd R&D – Pune.

Professional Certifications:

Oracle 10g Certified Professional (OCP)

Oracle 10g Certified Associate (OCA)

Academic Qualifications

MCM in Information Technology (2009-2011) from Pune University.

Bachelor of Science (2005-2009) from Pune University.

Technical Competencies:

Operating System : Linux, Sun Solaris, Windows XP, Windows Server 2003/2008.

Languages : SQL, UNIX Shell scripting

Database : Oracle RDBMS, 10g and 11g, SQL Server 2008/2012.

Application : Oracle E-Business Suite release 11i, R12.

Database Tools : RMAN, EXP-IMP/Data pump, OEM, Tkprof, AWR, ADDM, Data guard,

OEM, Grid Control.

Software/Tools : Winscp, Putty, VNC viewer, Toad, VM Ware.

Professional Experience:

1. Client : Parametric Technology (India) Ltd R&D – Pune

Role : Oracle DBA

Duration : August- 2012 to Till Date

Environment: Oracle Database 10g/11g, Data Guard, RMAN, Data Pump, Data Guard broker

SQL Server, Sun Solaris, Linux, windows family, Putty, Toad, VNC viewer, MSTSC.

Responsibilities:

As a Database Administrator, overall handling 15th Oracle database instance and SQL server instance.

24x7 support provided and troubleshooting user’s related issue on-call basis and day-to-day support.

Daily monitoring includes checking whether all databases are running, the listener is running.

Checking alert log on a daily basis and troubleshooting various database error/failures.

Managing Tablespaces and Datafiles utilization, creating and Adding space to the data files according to Tablespace growth.

Installation and configuration, Oracle 10g/11g on RHEL 4/5, windows server/windows Xp and Sun Solaris 5.9/5.10.

Extensive use of Data Pump expdp/impdp to clone/refresh Schema, database from Production to Test and Development Environment.

Setup and configured Oracle (Data guard) physical standby database as DR Solution for production database using RMAN create standby database command, also setup Data Guard Broker to manage data guard environment.

Maintained standby databases, in both local and remote locations, for failover purposes.

Experience with ‘graceful’ switchover and switchback between primary to physical standby to snapshot databases using the Data Guard broker.

Performed DB Cloning uses user managed backup and RMAN.

Upgrade Database from 10.2.0.4 to 11.2.0.2 to 11.2.0.4 on production Servers.

Implementing weekly basis report of health check and delete obsolete and old backup from

All database servers.

Implementing monthly basis report list of inactive users to all database servers.

Handling the all user access related activities like assign to grants, privileges, Roles etc.

Automated performing backup script using a combination of full RMAN, incremental and

Data Pump backups.

2. Client : Vyomlabs Pvt Ltd.

Role : Oracle DBA

Duration : Jan-2012 to August- 2012

Environment: Database 10g/11g, Linux, RMAN, Data Guard, EXP/IMP, Windows family, Putty, MSTSC.

Responsibilities:

As a Database Administrator, over all handled 9 Oracle databases.

Daily monitoring includes checking whether all databases are running, the listener is running.

Managed and monitoring includes checking primary and Data guard database are running.

Extensive work experience on oracle Standby environment.

Create the required Tablespace, add new Datafiles, Resize Datafiles, Rename Datafiles as per needed.

Implementing and maintaining database security (create and maintain users, roles and assign privileges).

Refreshing development/test database from production using RMAN duplicate command and Export/Import. This was done so that the latest data is available in the development/test database purpose.

Checking alert log on a daily basis and resolving problems.

Design and implement database backup strategy (hot/cold backup, IMPORT/Export, RMAN).

Installation and creation of Oracle 10g/11g Database Instance.

Weekly basis checks all database server space where backup is scheduled.

Automated performing Logical backup’s script using a combination of EXPORT/IMPORT backups.

Personal Details:

Date of Birth : 27 October 1987

Gender : Male

Marital Status : Single

Passport : Available

Language Known : English, Hindi, Marathi

Contact this candidate