resume

9
G Pushpa Prakash. [email protected] Contact No: +91-8680006606 OBJECTIVE A Challenging position as an Oracle Database Administrator at a growth-oriented firm, which will allow me to both further utilize my skills, as well as to enhance my knowledge by dedication, hard work and acquire new abilities. SUMMARY 4.9 years of experience in Information Technology as Oracle Database Administrator, and knowledge is system Analysis and Design, Development and Documentation at Various levels. Performed Oracle 10g, 11g software and database installation and upgraded various versions. Designed strategies for performing database backups and recovery. Involved in maintenance and hands on experience in Database installation, backup & Recovery Using RMAN, imp/exp, Datapump, user profile administration, cloning, patching, Upgrade, Dataguard (DR), ASM, Administration with wide range of DB activities. Having knowledge in Real Application Cluster (RAC). Ability to manage multiple tasks in a pressured environment. Proven team player with Strong ability to Multitask, 24/7 on-

Upload: prakash-g

Post on 08-Jan-2017

87 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Resume

G Pushpa Prakash. [email protected] Contact No: +91-8680006606

OBJECTIVE

A Challenging position as an Oracle Database Administrator at a growth-oriented firm,

which will allow me to both further utilize my skills, as well as to enhance my knowledge by

dedication, hard work and acquire new abilities.

SUMMARY

4.9 years of experience in Information Technology as Oracle Database Administrator, and

knowledge is system Analysis and Design, Development and Documentation at Various

levels.

Performed Oracle 10g, 11g software and database installation and upgraded various

versions.

Designed strategies for performing database backups and recovery.

Involved in maintenance and hands on experience in Database installation, backup &

Recovery Using RMAN, imp/exp, Datapump, user profile administration, cloning,

patching, Upgrade, Dataguard (DR), ASM, Administration with wide range of DB

activities.

Having knowledge in Real Application Cluster (RAC).

Ability to manage multiple tasks in a pressured environment.

Proven team player with Strong ability to Multitask, 24/7 on-call production support for database activities.

PROFESSIONAL EXPERIENCE

o ORGANIZATION : TCS ROLE : Oracle Database AdministratorDURATION : JUL 2015 – Till Now

Page 2: Resume

o ORGANIZATION : INFOSYS ( Payroll of ONWARD GROUPS PVT LTD )ROLE : Oracle Database AdministratorDURATION : JAN 2015 – June 2015

o ORGANIZATION : IYANAR INFO TECH PVT LTD, CHENNAIROLE : Oracle Database AdministratorDURATION : FEB 2012 – JAN 2015

QUALIFICATION

MCA (Master of Computer Applications) from R.M.K ENGINEERING COLLEGE -ANNA University, Chennai in 2008-2011 with 74.6%

TECHNICAL SKILLS

RDBMS ORACLE 9I,10G AND 11GR2

KEY SKILLSEXP/IMP,DATAPUMP,DATAGUARD,RAC,RMAN,BACKUP AND RECOVERY,TABLESPACE MAN-AGEMENT AND TUNING

OPERATING SYSTEMS WINDOWS,LINUX,RED HAT LINUX & AIX

DATA TOOLS & UTILITIESPUTTY 0.60, DBCA, NETCA, DB_VERIFY, ASM,STATSPACK, AWR REPORT, EXPLAIN PLAN,TK-PROF,SQL*LODER,XMANAGER

TECHINICAL SKILLS DATABASE , HTML , DB2

ROLES & RESPONSIBILITIES

As a Database Administrator, my primary responsibilities For DOP are:-

Planning for necessary databases, their storage spaces requirements and placing them

for optimum Performance. Making use of OEM for space management, session

management etc..,

Oracle Software Installation, Database Creation, Upgrade Database.

Page 3: Resume

Perform general technical troubleshooting and give consultation to Application Support

Team.

Implementation of DATAGUARD Physical Standby.

Perform Backups (Physical- Cold backup, Logical - Export/Import and Rman.)

Applying oracle recommended CPU and PSU patches.

Enrolling new users and maintaining system security (Profiles), Roles, System and Object

Privileges and managing user quotas.

Monitoring the unwanted User Session and killing them if needed.

Monitor physical and logical backup strategies.

Upgrading database from oracle 10g to 11g

Creation of Clone database for the test database environment using RMAN.

Logical Backup of Databases using Export and Import Utility as well as using Data pump.

Recovery of lost objects and data files.

RMAN Backup and recovery strategies.

Checking the Archive log shipping between the Primary and the standby (DR) databases and troubleshooting it by rebuilding the Standby databases.

Conduct knowledge transfer within the team and help team members in understanding the client business and existing systems

Thorough knowledge in Oracle 10g and 11g concepts including DataPump, DataGuard, Flashback Technology, Patching and Upgrading.

PROJECT DETAILS

1.Project Title : CIBC COMPANY : TCSClient : Canadian Imperial Bank of CommerceTechnical Environment : 11g R2, Linux, AIX and Windows Role : Database AdministratorTeam Size : 12 MEMBERS

Responsibilities:

space Issue in AIX.

Page 4: Resume

Tuning Long running query and Recommend to application team.

Taking AWR Report to analysis database.

Managing disk group and files in ASM.

Recovery using RMAN.

Performed regular RMAN backups to safeguard from User errors and Media failures.

Export Schema level from Production database to testing environment using data pump

and exp/imp.

Creation of clone database using RMAN for testing.

Recovery of lost objects and data files.

Monitoring the unwanted User Session and killing them if needed.

Based on project requirement adding Table space and Data files

Refresh Database, schema and Data pump.

Backup database using Rman.

RAC Database Creation in silent mode with 2 node RAC In Non- Prod.

2.Project Title : Deportment of Postal India (DOP)COMPANY : INFOSYSClient : INDIAN GOVERMENT Technical Environment : 11g R2, Linux, AIX and Windows Role : Database AdministratorTeam Size : 12 MEMBERS

Responsibilities:

Creation of Table spaces, data files, users etc., for the project requirement.

Controlling the users operations by limiting the memory spaces and grant the necessary

Roles, privileges and profiles to the users.

Postal Life Insurance (PLI) Migration Process.

Managing Paging space Issue in AIX.

Tuning Long running query and Recommend to application team.

Page 5: Resume

Taking AWR Report to analysis database.

Managing disk group and files in ASM.

Recovery using RMAN.

Performed regular RMAN backups to safeguard from User errors and Media failures.

Export Schema level from Production database to testing environment using data pump

and exp/imp.

Creation of clone database using RMAN for testing.

Recovery of lost objects and data files.

Monitoring the unwanted User Session and killing them if needed.

Based on project requirement adding Table space and Data files

Refresh Database, schema and Data pump.

Backup database using Rman.

RAC Database Creation in silent mode with 2 node RAC In Non- Prod.

3. Project Title : Automated Robot Trading SystemClient : Medway LLC , usa Technical Environment : Oracle 10g and 11g/Windows and Linux Role : Junior Database AdministratorTeam Size : 6 Members

Responsibilities:

Installation & configuration of oracle 11gr2 database.

Creation of Table spaces, data files, users etc., for the project requirement.

Controlling the users operations by limiting the memory spaces and grant the necessary

roles, privileges and profiles to the users.

Upgrading database from oracle 10.2.0.4 to 10.2.0.5 Recovery using RMAN.

Performed regular RMAN backups to safeguard from User errors and Media failures.

Export Schema level from Production database to testing environment using data pump

and exp/imp.

Page 6: Resume

Creation of clone database using RMAN for testing.

Recovery of lost objects and data files.

Monitoring the unwanted User Session and killing them if needed. Based on project requirement adding Table space and Data files

Refresh Database, schema and Data pump.

Backup database using Rman.

4. Project Title : Data Analysis and Interpretation of Stock Exchange Client : Medway LLC, UsaTechnical Environment : Oracle 9i, 10g and 11g / Windows /Red hat Linux Role : Database Administrator Responsibilities:

Provided regular DBA support for the database servers.

Performed hot-backups for the entire database.

Database administration, managing table spaces, objects, disk space.

Creation of oracle users, oracle roles, granting privileges and profiles etc.

Adding new table space based on Requirement.

Checking alert log and trace files for errors.

Upgrading database from Oracle 10.2.0.5 to 11.1.0.6

Logical Backup of Databases using Export and Import Utility. Monitoring the unwanted User Session and killing them if needed. Backup database using Rman. Configured Physical Data guard.

DECLARATION: I, hereby declare that the information furnished above is true to the best of my knowledge.

Place : Regards &Thanks(G.Pushpa Prakash)

Date :