Oracle Management

DIVESH JAIN

Mobile: +91-965******* / E-Mail: ***********@*****.***

JOB OBJECTIVE

Seeking assignments in Database Administration- ORACLE with an organization of high repute, preferably IT sector

PROFILE SUMMARY

More than Four years of experience in Information Technology as Oracle Database Administrator.

Performed Oracle 9i/10g/11g software and database installation and upgraded various versions.

Experience in administering, tuning and monitoring database using Toad, OEM.

Designed strategies for performing database backups and recovery.

Debugging with procedures, Function, Triggers, Packages and other PL/SQL objects.

Strong interpersonal, time management and organizational skills. Proven team player with strong ability to multitask.

24x7 on-call Production support for database activities.

Adept in implementation of software applications efficiently.

An effective communicator with good presentation and analytical skills.

CORE COMPETENCIES

Database administration Troubleshooting Database Management

Test Simulation Requirement Management Software Implementation

ORGANISATIONAL EXPERIENCE

1. Sep’16 – till date Fujitsu Consulting India pvt ltd

Client: Fujitsu Consulting India

Period: Sep’16 – till date

Role: Technical Consultant

Responsibilities:

Installing new Oracle client in Virtual Machine

Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.

Automated hot backups using a combination of incremental, differential and full RMAN backups.

Export/Import of oracle databases.

Tracing, troubleshooting with database performance and tuning issues.

Maintaining archive data on appropriate storage devices.

PSU patches on the database.

Troubleshooting Dataguard.

2. Aug’15 – Sep’16 HCL Comnet ltd

Client: National Informatics Centre

Project: National Data Centre

Period: Aug’15 – till date

Role: Specialist

Responsibilities:

Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.

Automated hot backups using a combination of incremental, differential and full RMAN backups.

Export/Import of oracle databases.

Tracing, troubleshooting with database performance and tuning issues.

Installing new Oracle client in Virtual Machine

Analyzing and validating database objects.

Maintaining archive data on appropriate storage devices.

Database Refresh, Cloning.

PSU patches on the database.

Troubleshooting Dataguard.

3. Apr’14 – Aug’15 Net Connect Pvt ltd, Noida

Client: IBM India Pvt Ltd

Project: Bharti Airtel Data Centre, Noida

Period: Apr’14 – Aug’15

Role: Oracle Database Administrator

Responsibilities:

Supporting more than 200 instances.

Experience in providing Shift-based support to maintain all Databases up running in Production Environment.

Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.

Export/Import of oracle databases.

Automated hot backups using a combination of incremental, differential and full RMAN backups.

Maintaining archive data on appropriate storage devices.

Tracing, troubleshooting with database performance and tuning issues.

Analyzing and validating database objects.

Allocating system storage and planning future storage requirements for the database.

Database Refresh, Cloning.

PSU patches on the database

Troubleshooting Dataguard.

4. Oct’10 – Nov’12 IAP Company Pvt. Ltd, Gurgaon

Client: National Informatics Centre

Period: Oct’10 to Nov’12

Details The project is running in all consumer court across India.

Responsibilities:

Responsible to train the DCDRF officials about the CONFONET Application.

Export/Import of oracle databases.

Handled setup configuration, implementation and monitored the application

Maintained database backup and volumes

Implemented, managed and troubleshot local area network in the organization

Managed installation of the new version of the software application

Maintained proper procedure and infrastructure for timely backups of specified critical systems

CERTIFICATION

Oracle 10g SQL Expert Certified

Oracle 10g OCA Certified

Oracle 11g OCA Certified

IT SKILLS

Well versed with:

oDatabase: Oracle 9i, Oracle 10g, Oracle 11g

oOracle Enterprise Manager: 10g, 12c

oOperating Systems: IBM AIX, UNIX, Windows Server, Sun Solaris

ACHIEVEMENTS

Received Certificate from:

oSQL STAR, Delhi for participating in ORACLE DBA Program

oORACLE for participating in Workshop

EDUCATION

2012 PGDBM (System) from IMT -CDL, Ghaziabad

2010 B.Tech (Computer Science & Engineering) from Jind Institute of Engineering & Technology, Kurukshetra University

2006 12th from V.V.D.A.V. Public School, New Delhi (CBSE Board)

2004 10th from V.V.D.A.V. Public School, New Delhi (CBSE Board)

PERSONAL DETAILS

Date of Birth: 5th October, 1988

Address: C-18, Manav Apartment, Sector-9, Rohini, New Delhi - 110085

Languages Known: Hindi and English

Divesh Jain

Contact this candidate