Post Job Free

Resume

Sign in

Oracle DBA

Location:
Bengaluru, KA, India
Posted:
April 18, 2017

Contact this candidate

Original resume on Jobvertise

Resume:

[pic]

Devaraja J N

Mobile No: +91-998*******

Email: aczuuv@r.postjobfree.com

Objective: To obtain a challenging position in a high quality engineering

environment

Where my resourceful experience and academic skills will

add value to

Organizational Operations.

Skills: Managing Oracle database on different operating system like

HP UNIX, Linux,

Sun Solaris and Windows. Having strong knowledge in

installation,

Configuration, Tuning and Administration of RAC database

and Enterprise

Manager.

Experience Summary

Have over 14 years of focused experience in Administration of Oracle

Databases, Member of Support team, which provides systems and database

consultancy. Have strong exposure in design and optimizing performance of

Production /Stage and Development databases.

Successfully performed the role of database administrator supporting

complete cycle of multiple project implementations - planning, development,

performance tuning, Stand by Database Design, RAC Implementation and

applying patches for bug fixing to Oracle software, Setting operational and

backup/recovery strategies.

Defining Upgrade strategy of Oracle database and Oracle Enterprise Manager

from lower version to higher version (8i to 9i, 9i to 10g and 10g to 11g)

and Upgrade of CRS from 10.2.0.2 to 10.2.0.3 and upgrade of grid from

11.2.0.3 to 11.2.0.4.

EDUCATIONAL QUALIFICATION:

Bachelor of Engineering in Mechanical, B.E [Mech]. From A.I.T

Chickmagalore, India.

Technical Skills:

OS / Environment Unix, Linux, HP-UX, Solaris and

Windows

RDBMS Oracle 8/8i/9i/10g/11g and 12c

Languages SQL, PL/SQL

Tools Toad, Oracle SQL developer

Replication Utility Golden Gate, Veridata

1 Certifications

> Oracle Certified Professional for 10g (OCP)

> Oracle Certified Associate for 9i (OCA)

> ITIL Foundation V3

Training

> Oracle 10g Workshop-I

> Oracle 10g RAC

Achievements

Customer Services Pacesetter Award for Q1 FY10 (EM 10g R4 upgrade) in

Oracle

Received Star of the Quarter award for training the new recruiters in TCS

Achieved top performance band for the financial year 2014-15 in TCS

Oracle RAC DBA Experience

. Installing & configuring Oracle clusterware & Database Software

(Troubleshooting using cluvfy & handling common issues that arise

during installation)

. Worked with customer for different RAC related issue [Split brain, RAC

recovery, ASM, OCR corruptions, Voting disk loss & so on]

. Troubleshoot performance issues for the RAC instances (GC events)

. Backup and Recovery issues related (loss of OCR, Voting Disk and

Oracle clusterware)

. Resolved/Diagnose Node Eviction

. Upgrade of 9i ORACM to 10g and R2 RAC to 11g R2 RAC

. Add or Remove Node from RAC.

. Upgrade of grid from 11.2.0.3 to 11.2.0.4

Oracle DBA Experience

. Over 14 years of experience in as an Oracle DBA (11g/10g/9i/8i/8.0.x/

in Production and Development environment.

. Worked in 24x7 production environment and provided on-call and day-to-

day support.

. Strong trouble shooting, problem solving, analytical and design

skills.

. Expertise in Oracle Enterprise Manager (OEM), TOAD.

. Experience in Physical Standby Database Design.

. Expertise in handling Very Large Database (VLDB) and OLTP environment.

. Experience in Migration of Oracle 7.x to Oracle 8.x to Oracle 8i to

Oracle 9i

. Expertise in Performance tuning the production database towards

optimal performance based on the changes in the database storage

structures due to application change requirements. Monitoring and

optimizing the performance of the Database through Database Tuning -

Tuning Applications, Tuning Memory, Tuning Disk Usage, Tuning OS

. Experience in Oracle 9i/8i/8.x- Installation, Migration and

implemented new features.

. Experience in capacity planning, space management, database

upgrades/migration

. Experience in handling clustered databases using VCS technology

. Expert in ORACLE Database Administration including

planning/implementing backup/recovery strategies using RMAN and

without RMAN

. Expertise in installation and configuration of Oracle and large

databases on Unix Operating System.

. Good knowledge of UNIX Administrator for the Linux, Sun Solaris

. Creating and maintaining logins, synonyms and access privileges using

roles, controlling access to the database using operating system and

Oracle security features.

PROFESSIONAL EXPERIENCE

Hewlett Packard Enterprise Feb 2016 to till date

Client:

British Petroleum

Roles and Responsibilities

. As a Sr. Database Administrator, I am Responsible for administration

of all Oracle Databases.

. Upgraded 10.2.0.4 databases to 11g R2

. Upgrade of grid from 11.2.0.3 to 11.2.0.4

. Involved in environment setup and Installation of Oracle Golden Gate

. Implemented Flashback Database on Physical Standby Databases which

saved rebuilding of standby databases after application testing.

. Advanced Backup and Recovery using Oracle's RMAN utility

. Mentor other DBAs.

. Ongoing proactive database-level performance tuning, with a good

working knowledge of Oracle internals.

. Changes were made dynamically whenever possible to fulfil high-

availability requirements.

. Enforced need of regular data purging processes from production,

design and development, to deployment.

. Implemented and maintained Oracle 10g/11g Data Guard/standby databases

for fail-over purposes.

. Create and maintain materialized views.

. Implementing and maintaining database security (create and maintain

users, roles and assign privileges)

. Database tuning, Application Tuning & performance monitoring. Fine

tuning Initialization parameters, I/O, Memory and Operating System

kernel parameters.

. Managed appropriate use of freespace within tablespaces, reclaimed

space whenever possible. Reorganized tables and indexes within

databases when needed.

. Monitored the production Oracle alert logs for database errors.

. Monitored system resource availability and responded to system memory

and data issues.

. Upgraded Standby database from 11.2.0.3 to 11.2.0.4

. Applied Bug Fixing patched on 12c databases.

. Expert with OEM Grid Control.

. Installed Veridata to ensure consistency of the data.

. Setup golden gate replication for BI reporting.

. Fixing Golden gate issues.

. Golden gate patching for any bug fixes.

. DB Switchover involving Golden gate.

. DB migration from standalone to RAC along with Golden gate.

. Performance tuning of Golden gate replicat processes.

. Configured Golden Gate Veridata for validating data sync between

source and target db's.

Tata Consultancy Services APR 2011 to Jan 2016

Client AGCS -

Allianz Global Corporate &

Specialty

Duration: Jun 2015 to

Jan 2016

Roles and Responsibilities

. As a SME Database Administrator, I am responsible for Administration

of over 600 databases

. Upgrade of Database from 10g to 11g

. Installation of RAC and Managing RAC Environment efficiently

. Expertise in Performance tuning the production database towards

optimal performance based on the changes in the database storage

structures due to application change requirements. Monitoring and

optimizing the performance of the Database through Database Tuning -

Tuning Applications, Tuning Memory, and Tuning Disk Usage.

. Expertise in OEM

. Actively working with other teams for Server Consolidation & Database

Consolidation

Project 2

APR 2011 to May 2015

Client:

PriceWaterHouseCoopers US

. As a SME Database Administrator, I am responsible for Administration

of over 600 databases

. Installing and Configuring Oracle Clusterware & Database Software

. Manage RAC environment for Day to Day Administration.

. Resolved & Diagnose Node eviction issues.

. Experience in handling the clustered databases using Veritas Cluster

on Solaris

. Planned and Supported Complete life cycle of the projects for database

upgrades

From 9.2.0.8 to 10.2.0.4 on Solaris and Windows Platforms

. Planned and Supported Complete life cycle of the projects for database

upgrades from 10.2.0.4 to 11.2.0.3 on Solaris and Windows Platforms

. Handled Database Tuning, Application tuning, Maintaining

documentation, Capacity Planning database and prepared RCAs

. Expertise in Backup and Recovery Using RMAN utility

. Planned, documented and Supported Quarterly DR activities

. Troubleshooting several production issues and handled generic ORA

errors

. Planned, documented and implemented database migration

. Train the new recruiters

Mind Tree Limited.

Dec 2010 to Apr 2011

Client:

AIRCELL - Chicago

Database: 11g Rel 1

. Managing RAC Databases

. Installation and Creation of Database.

. Maintaining the ASM Disks.

. Managing OEM used for monitoring Production Databases.

. Managing Oracle Intelligent Agent.

. Support to different activities to adhere timeline for the business

. Worked with the Metalink Support to resolve the issue.

Oracle India Pvt Ltd

Oct 2006 to Dec 2010

Database:

Oracle 10g RAC, 9i RAC

Roles & Responsibilities

. Managing RAC databases

. Installation and configuration of RAC Databases

. Applied CRS Bundle Patch and RAC Stabilization fix.

. Upgrading of CRS from 10.2.0.2 to 10.2.0.3

. Installation and configuration of Enterprise Manager

. Upgrading of database from 9i to 10g

. Upgrading of OEM from 10.2.0.2 to 10.2.0.4

. Installation and up gradation of Intelligent Agent

. Did Patch Analysis and applied CPU Patches

. Responsible for creating back ports for bug fixes

. Worked with DEV team to resolve the issue.

. Tuned the database to meet optimal performance

. Support to different activities to adhere timeline for the business

IBM Global Services India Ltd

July 2005 to Oct 2006

Client Capital One -

Richmond

Capital One is a financial Services industry in U.S. They are into Credit

Cards, Auto Loans, Savings, Home Loans, and Health Care Finance & Insurance

Business.

The Job involved Trouble Shooting and Providing Support to the above

clients.

Roles & Responsibilities

. Pro-active monitoring of database health

. Managing oracle database on Production and dev environment

. Monitoring of trace and alert log files

. Review and update the Operating system and databases with the latest

patches as and when released.

. On-call DBA support

. Monitoring backup logs and taking corrective action

. Used Peregrine & HP Service Desk as problem & change management tools

. Responsible for 99.99 % database uptime.

. Responsible for successful completion of hot and cold backup jobs.

. Support to different activities adhere timeline for the business.

. Reconstruction of fragmented table.

. Supporting end User and resolving the problem.

. Worked as part of a team and provide 24x7 supports.

Metro C & C India (P) Ltd

Apr 2005 to July 05

Client

Metro Group

Roles & Responsibilities

. Administration of Database, Set Up the environment for development

teams,

. Pro-active monitoring of database health

. 24/7 Database support

. Monitor Production and development Database

. Pro-active database tuning

. Design/review and implementation of backup and recovery policies

for existing

N-Spire Technologies Inc.

Bangalore

Duration: Jan 2003 to Mar 2005

Responsibilities

Oracle Software Installation on Unix/Windows Operating System.

Users Maintenance.

Tablespace Creation and adding of datafiles as per requirement

Monitoring the Health of the databases and alert log monitoring

Schema Refresh using exp/imp utilities.

1

2 Contact Details

2 Passport Number M9671317

3 Contact Address #386, 6th B Cross, 4th Main,

Health Layout,

Annapoorneshwari

Nagar,

Bangalore - 560

091.

Karnataka - India

[Devaraja.J.N]



Contact this candidate