[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]