Oracle Customer Service

Yugandhar, M

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

+91-959******* (Cell)

EXPERIENCE SUMMARY:

Have over 7 years of focused experience in IT industry in various fields like banking, insurance, financial, retail and manufacturing. Extensive experience in relational database design, analysis, modelling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as Oracle DBA with RAC; Software Installations, Automated Backup Implementation, Tuning Oracle 9I/10g/11g/12C on Unix. Involved with architect group in designing the logical and physical model of the databases.

ORGANISATIONAL EXPERIENCE

Currently working in Cognizant technology solutions (CTS) in Bangalore April2016 to till date

Worked for Larsen& Toubro InfoTech Ltd in Bangalore Mar-2015 to Mar-2016.

Worked for Wipro Technologies in Bangalore Jul-2014 to 30-Dec-2014.

Worked for MphasiS Limited in Chennai from Oct-2012to Jun-2014.

Worked for Tech Mahindra ltd in Pune from April -2011 to Oct-2012.

Worked Netvinyas SoftwarePvtLtd in from Bangalore May-2009 to Mar-2011.

ACADEMIC QUALIFICATIONS

M.C.A: Master Computer Application, SCSVMV University, Kanchpuram, 2009

CERITICATIONS

11g OCPCertifiedProfessionals.

ITIL Certified Professionals.

TECHNICAL COMPETENCIES

RDBMS :Oracle: 9i,10g,11g,12c,

Operating Systems : UNIX (Solaris, HP-UX),Linux

Languages : SQL, PL/SQL

Utilities : RMAN, Export & Import, Dataguard, AWR,ADDM,Lsnrctl, Data Pump.

Tools:Sqlplus, Putty and B.M.CRemedy ticket tool, ServiceCenter, SR tool and B.M.C Petrol monitoring tool, OEM 10G, 11G, 12C,

Program High-end Technologies:Dataguard, ASM & RAC.

PROJECT EXPERIENCE

Client : British Gas

Company : Cognizant technology Solutions (CTS)

Role : Oracle DBA (Team Lead)

Period : April- 2016 to till date

Platform : Oracle11gr2, 12C, Unix, Sun Solaris, Golden Gate, Exadata

Description:

Mark Hodges. As a Board member of Centrica plc, Mark leads Energy Supply and Services in the UK and Ireland, and is also responsible for its global Connected Home business. Under Mark's leadership,British Gas is focused on delivering excellent customer service, keeping costs down, and driving growth through innovation

Responsibilities

Configured OS, Raw devices, Oracle CRS software, Oracle Binaries for ASM & RDBMS Instance.

Administering OCR & VD in Real application clusters

Created RAC database using ASM instance.

Management of daily routine Oracle RAC activities like services relocation, Node Eviction, health verification of the Cluster ware services etc.

Configure ASM instances and create disk groups with raid 1+0 and also Raid 0.

Administration and Maintenance of Oracle Dataguard- Physical Standby database.

Applying patches to databases whenever required and Quadratically applying CPU patches.

Upgraded database version from 10g to 11g

Cloning database for Production, Development and Testing purpose using RMAN utility.

Performing Backup, Restore and Recovery using RMAN when required.

To make the Duplicate Clone production database to Test database using RMAN

Performing daily incremental backups and weekly backups.

Tested, Documented and Migrated production Database to cluster production Database.

Creating and managing storage allocation for Database objects such as tables, Indexes, Partitions,Mviews, DB Links.

Database/Table/Schema refresh - Refresh of Test/Training/Development DBs from Production using Oracle 10g datapump.

Installing / configuring the oracle software on different servers.

Monitoring/checking alert log files, user trace files and background trace files.

Client : CBS Corporation

Company : L & T infotech Limited

Role : Oracle DBA

Period : Mar 2015 to Mar-2016

Platform : Oracle11gr2,10g, Unix, Sun Solares

Description:

CBS Corporation is an American mass media corporation focused on commercial broadcasting, publishing, and television production, with most of its operations in the United States

Responsibilities

Configured OS, Raw devices, Oracle CRS software, Oracle Binaries for ASM & RDBMS Instance.

Administering OCR & VD in Real application clusters

Created RAC database using ASM instance.

Management of daily routine Oracle RAC activities like services relocation, Node Eviction, health verification of the Cluster ware services etc.

Configure ASM instances and create disk groups with raid 1+0 and also Raid 0.

Administration and Maintenance of Oracle Dataguard- Physical Standby database.

Applying patches to databases whenever required and Quadratically applying CPU patches.

Upgraded database version from 10g to 11g

Cloning database for Production, Development and Testing purpose using RMAN utility.

Performing Backup, Restore and Recovery using RMAN when required.

To make the Duplicate Clone production database to Test database using RMAN

Performing daily incremental backups and weekly backups.

Tested, Documented and Migrated production Database to cluster production Database.

Creating and managing storage allocation for Database objects such as tables, Indexes, Partitions,Mviews, DB Links.

Database/Table/Schema refresh - Refresh of Test/Training/Development DBs from Production using Oracle 10g datapump.

Installing / configuring the oracle software on different servers.

Monitoring/checking alert log files, user trace files and background trace files.

Creation of users, Roles and grant Privileges to the users according to client policy.

Monitoring user sessions and take appropriate action to kill inactive sessions

Client : ERICSSON

Project : Netops Policy Manager

Company : Wipro Technologies

Role : Oracle DBA

Period : July -2014 to Dec-2014

Platform : Oracle11gr2,10g, Unix, Sun Solares

Description:

Understand the motivation behind the NetOp Policy Manager

Discuss the role that NPM plays in a customer network.

List the NPM components and describe how they communicate.

Understand how the NPM works with the SE or SMS to implement value-added services.

Appreciate the importance of node configuration to the NPM system

Responsibilities

Configured OS, Raw devices, Oracle CRS software, Oracle Binaries for ASM & RDBMS Instance.

Administering OCR & VD in Real application clusters

Created RAC database using ASM instance.

Management of daily routine Oracle RAC activities like services relocation, Node Eviction, health verification of the Cluster ware services etc.

Configure ASM instances and create disk groups with raid 1+0 and also Raid 0.

Administration and Maintenance of Oracle Dataguard- Physical Standby database.

Applying patches to databases whenever required and Quadratically applying CPU patches.

Upgraded database version from 10g to 11g

Cloning database for Production, Development and Testing purpose using RMAN utility.

Performing Backup, Restore and Recovery using RMAN when required.

To make the Duplicate Clone production database to Test database using RMAN

Performing daily incremental backups and weekly backups.

Tested, Documented and Migrated production Database to cluster production Database.

Creating and managing storage allocation for Database objects such as tables, Indexes, Partitions,Mviews, DB Links.

Database/Table/Schema refresh - Refresh of Test/Training/Development DBs from Production using Oracle 10g datapump.

Installing / configuring the oracle software on different servers.

Monitoring/checking alert log files, user trace files and background trace files.

Creation of users, Roles and grant Privileges to the users according to client policy.

Monitoring user sessions and take appropriate action to kill inactive sessions.

Company : Mphasis Limited

Role : Oracle DBA

Period : Aug-2013 to June-2014

Platform : Oracle11gr2,10g, Unix

Description:

All goods brought into the customs territory of the EU, regardless of their final destination, shall be covered by an ENS, hence it will apply for all cargo discharging in an EU port (including transshipment cargo) as well as FROB cargo (Foreign Cargo Remaining on Board). For Maersk Line, we will indicate on all your Bookings Confirmation if the destination or the routineyour shipment is booked under has any ENS Advanced Manifest requirements involved.

Responsibilities

As an Oracle Database Administrator, my primary roles and responsibilities involved

Installation of Oracle on UNIX (Solaris, HP-UX), Linux, AIX.

Configured 2 nodes clusters in Linux servers on112gr2

Configured 4 nodes clusters in Linux servers on 112gr2

Configured 6 nodes clusters in Linux servers on 112gr2

Creating the Rac databases.

Backing up of OCR and Voting Disk.

ation and configuration of RAC.

Creating the databases.

Monitoring space related issues of (data files, table spaces, Disk adding in ASM).

Create tablespace Adding and resize data files.

Create the database links.

Upgradation and Patches Installation.

Database refresh by using expdp and impdp.

Written shell scripts to monitor oracle databases that includes alter log, file system and tablespace.

Generate the AWR,ADDM Reports.

Creation of oracle objects as per application team's request.

Provided technical assistance to vendors in development and implementation of applications.

Solved difficult performance tuning, troubleshooting and administration issues

Company : Mphasis Limited

Project Title :eMgero

Client : SHABRE HOLDING

Role : Oracle DBA

Period : Oct-2012 to Aug-2014

Platform : Oracle 10g/11gr2, UNIX

Description

Sabre Holdings Corporation provides technology solutions to travel and tourism industry in the United States and internationally. It offers data-driven business. Worldwide Headquarters. Sabre Holdings Corp. 3150 Sabre Drive Southlake.

Responsibilities

As an Oracle Database Administrator, my primary roles and responsibilities involved

Installation of Oracle on UNIX (Solaris, HP-UX), Linux, AIX.

Configured 2 nodes clusters in Linux servers on112gr2

Configured 4 nodes clusters in Linux servers on 112gr2

Configured 6 nodes clusters in Linux servers on 112gr2

Creating theRac databases.

Backing up of OCR and Voting Disk.

Monitoring space related issues of (data files, table spaces, Disk adding in ASM).

Oracle client installation on version 10.2.0.3 to 11.2.0.3.

Installation and configuration of RAC.

Creating the databases.

Monitoring space related issues of (data files, table spaces, Disk adding in ASM).

Create tablespace Adding and resize data files.

Upgradation and Patches Installation.

Database refresh by using expdp and impdp.

Written shell scripts to monitor oracle databases that includes alter log, file system and tablespace.

Generate the AWR,ADDM Reports.

Creation of oracle objects as per application team's request.

Provided technical assistance to vendors in development and implementation of applications.

Company : Tech Mahindra Limited

Project Title : MOS1 ODBA

Client : AT & T

Role : Oracle DBA

Period : Apr-2011 to Sep-2012

Platform : Oracle 10g/11gr2, UNIX

Description

AT&T Inc. is an American multinational telecommunications corporation, headquartered at Whitacre Tower in downtown Dallas, Texas. AT&T is the largest

Responsibilities:

Configured OS, Raw devices, Oracle CRS software, Oracle Binaries for ASM & RDBMS Instance.

Administering OCR & VD in Real application clusters

Created RAC database using ASM instance.

Management of daily routine Oracle RAC activities like services relocation, Node Eviction, health verification of the Cluster ware services etc.

Configure ASM instances and create disk groups with raid 1+0 and also Raid 0.

Administration and Maintenance of Oracle Dataguard- Physical Standby database.

Applying patches to databases whenever required and Quadratically applying CPU patches.

Upgraded database version from 10g to 11g

Migrated the database version from 10.2.0.2 to 10.2.0.4

Cloning database for Production, Development and Testing purpose using RMAN utility.

Performing Backup, Restore and Recovery using RMAN when required.

Cross-checking the backups of Databases to validate the backups.

Performing daily incremental backups and weekly backups.

Tested, Documented and Migrated production Database to cluster production Database.

Creating and managing storage allocation for Database objects such as tables, Indexes, Partitions,Mviews, DB Links.

Database/Table/Schema refresh - Refresh of Test/Training/Development DBs from Production using Oracle 10g datapump.

Rebuild and analyze the indexes and statistics of all users Schema.

Installing / configuring the oracle software on different servers.

Monitoring/checking alert log files, user trace files and background trace files.

Creation of users, Roles and grant Privileges to the users according to client policy

Company : Netvinyas software Pvt.Ltd

Project Title : SCM (supply chain management products)

Client : Botree Software International pvt.Ltd

Role : Jr Oracle DBA

Period : May-2009 to Mar-2011

Platform : Oracle 10g/11g, UNIX

Description

Supply chain management (SCM) is the management of the flow of goods. It includes the movement and storage of raw materials, work-in-process inventory.

Responsibilities

Installation of Oracle 9i, 10g, 11g on UNIX (Solaris, HP-UX), Linux, platform.

Oracle client installation with version 10.2.0.3 to 11.2.0.3.

Create the tablespace and add & resize datafiles.

Applying CPU Patches by using bugs.

Upgradation and Patches Installation.

Create the database links.

Creation of oracle Roles, Granting Privileges and Profiles etc.

Check Alert Log errors and make necessary actions to rectify them.

Database refresh by using export and import Source database to Target database.

Troubleshoot database performance issue using Automated Workload Repository (AWR).

Monitor the database by collecting statistics using SQL trace.

Performing Hot Backups and Cold Backups.

Contact this candidate