Manager Data

VINOD A

(Database Admin/DBA)

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

Phone: +91-837*******.

Over 4 years of experience in Oracle Database

Administration, installation, patches, upgrades, migrations, configuration,

database security, table space management,backup and recovery, Cloning,

Tuning, Rman backups, Troubleshooting.

PROFESSIONAL SNAPSHOT

* Oracle Database Administration in a variety of environments like

Linux (Red Hat), and Windows NT/2000/2003.

* Experience in installing, maintaining, upgrading, migrating and

patching Oracle versions 11g/10g/9i.

* Supporting role for Setup Standby database for faster disaster

recovery and Data guard setup for high availability.

* RMAN procedure for backup and recovery and also cloned database

using RMAN Duplicate.

* Managed Oracle databases in High Availability environments using

Failover, Clustering, Data guard and Cloning technologies.

* Experience in clustering and disaster recovery.

* Perform maintenance activities for application like running

statistics manually.

* Migrated database from 9i, 10g to 11g by using Scripts and applied

patches.

* Worked on 10g New Features: Data Pump, Automatic performance and

diagnostics, Flash Back Technology, 10g RMAN's New Features and

Data guard (stand by database).

* Experience in database full Backup (hot and cold), Incomplete

Backup, fail-over, DR methodologies, Data Pump Export/Import, and

Restore procedures.

* Experience in Capacity Planning.

* Performance tuning of Oracle servers, databases.

* Experience in Database creation with RMAN jobs and security

implementations in Oracle..

* Experience in system Monitoring and Database Performance Tuning

using Explain plan, SQL Trace, TK Proof, and AWR.

* Installed 10g Grid agent on servers and configure OEM Grid control.

* Experience in monitoring of systems using Grid control.

* Planned and implemented Disaster Recovery solutions using Oracle

Standby Database/Data guard.

* Executes software installations, database creations and loads.

* Responsible for Data Loading, Security, Performance Monitoring and

Tuning, Capacity planning and Backup and Recovery.

* Experience in trouble shooting Connectivity Issues.

* Monitored production database using AWR and ADDM for Daily or

weekly tuning needs.

* Good experience in Database Creation, Partitions, Setting-up

parameters, Table spaces, Indexes, User Setup, Roles, Security,

Storage and hands on experience in network management.

KEY SKILLS

Technology Tool Name and Versions

Database Oracle 9i/10g/11g.

Tools/Utilities RMAN, TKPROOF, Oracle Grid Control, Data Pump

(Export/Import), OEM, AWR.

Operating Systems Red Hat Linux4/OEL4, UNIX, Win-XP/NT/2003.

EDUCATION

Bachelor of Science (B.Sc) from Sri Venkateswara University, Tirupathi,

Andhra Pradesh in 2009 with Distinction (70%).

PROFESSIONAL EXPERIENCE

Working as a Database Administrator (ORACLE DBA) With NORTHGATE

TECHNOLOGIES from November 2010 to till date.

RELEVENT EXPERIENCE

November 2012-Till Date

Project Perkin Elmer

Environment Oracle 10g Linux.

Database versions Oracle 10g.

Duration Nov 2012 to Till Date

Role Database Administrator.

Project Description:

Perkin Elmer is global leader focused on improving the

health and safety of people and their environment. The company reported

revenue of approximately $2.1 billion in 2013 around 7,500 employees

serving customers in more than 150 countries. Perkin Elmer we are taking

action to ensure the quality of our environment. Perkin transforms

information into actions that improve our safety today and our safety today

and our world tomorrow. It produces the products as cord blood, Flat panel

x-ray detectors, Instruments and s/w informatics.

Perkin Elmer, we are taking action to make people

healthier, our human health business develops research and diagnostic

instrumentation technologies as well as clinical resources.

Roles and Responsibilities:

* Creating database and Tablespaces.

* Creating tables, views and indexes whenever needed.

* Created users and granted appropriate privileges.

* Ensuring Database security by managing users & profile.

* Planning and Performing Cold and Hot Backups.

* Online Database Backup, Archived redo log files and Offline backup.

* Taking the Logical and physical backup of the database regularly.

* Configuring RMAN (Recovery Manager).

* Checking the networking issues.

* Planning and Performing Daily, Weekly and Monthly RMAN Backups.

* Refreshing development/test database from production using

Export/Import, This is done so that the latest data is available in

the development/test database.

* Moving Data between Database using utilities like Export/Import.

* Creation of database links & materialized views.

* Migrating the data from one environment to another environment.

* Enabled the database in archive log mode.

* Resolving the tickets and application team requests.

* Supported the senior DBA in regular DBA activities.

* Cloning of database for testing purposes.

* Troubleshooting problems related to database.

PAST EXPERIENCE

November2010 - September 2012

Project Cdi Corporation

Environment Oracle 10g Linux

Database versions Oracle 10g.

Duration Nov 2010 to Sep 2011.

Role Database Administrator.

Description:

For more than 60 years, CDI Corporation has delivered

engineering and technology solutions and recruitment and staffing

services to leading companies with operations around the world. Our

solutions and technical and professional staffing services allow our

clients to improve productivity, performance and profitability and maximize

their growth potential. We offer a full range of engineering design

services across a variety of industries, including oil gas & chemicals,

aerospace & industrial equipment, infrastructure, and government defense

services. CDI also is a global leader in talent acquisition, managed

program staffing and recruitment process outsourcing. Whether your

objective is to accelerate time-to-market, develop new product innovations

or manage costs by outsourcing non-core functions, CDI gives you the edge

to compete. And win.

Roles and Responsibilities:

* Creating database and table spaces.

* Creating tables, views and indexes whenever needed.

* Created users and granted appropriate privileges.

* Ensuring Database security by managing users & profile.

* Planning and Performing Cold and Hot Backups.

* Online Database Backup, Archived redo log files and Offline backup.

* Taking the Logical and physical backup of the database regularly.

* Willingness to learn new concepts and technology and apply them to

yield successful results.

* Proficient in database administration, production support, space

management, files system management, database security, Unix/Linux

commands.

* Configuring RMAN (Recovery Manager).

* Planning and Performing Daily, Weekly and Monthly RMAN Backups.

* Archival management issues-eg: deleting unnecessary archives using

RMAN.

* Refreshing development/test database from production using

Export/Import, This is done so that the latest data is available in

the development/test database.

* Moving Data between Database using utilities like Export/Import.

* Creation of database links & materialized views.

* Enabled the database in archive log mode.

* Supported the senior DBA in regular DBA activities.

* Recovery strategies include simulation of crash scenarios on the test

system.

* Cloning of database for testing purposes.

* Troubleshooting problems related to database.

* Creating Users with Quota Management.

* Adding / Resizing data files if needed.

* Logical Backup Using Export & Import.

* Export of important tables as regular intervals.

* Monitoring Alert Log files.

* Creating user Profiles.

* Granting specific privileges and roles to the users.

* Knowledge in maintaining table spaces & data files, Control files,

Online Redo log files.

* Taking cold and hot backups.

* Checking networking issues.

* Migrations from one environment to another environment.

* 24x 7 Production database administration, support and monitoring to

ensure a proactive problem recognition and resolution of database

issues.

* Have performed DB, Schema and table level backup using EXP/EXPDP and

IMP/IMPDP.

Contact this candidate