G.Pushpa Prakash

acg3dc@r.postjobfree.com Contact No :+91-868*******

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

Having 2.10 years of experience in Oracle Database Administration in IT Industry.

•

Involved in maintenance and hands on experience in Database installation, backup and recovery Using

•

RMAN, imp/exp, datapump, user profile administration, cloning, patching, Upgrade, Dataguard

(DR), administration with wide range of DB activities.

Ability to manage multiple tasks in a pressured environment.

•

PROFESSIONAL EXPERIENCE

Working as an Oracle Database Administrator in Iyanar Info Tech Pvt Ltd Chennai, From

•

Feb’2012 to till date.

QUALIFICATION

M.C.A (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 11g

Key Skills : EXP/IMP, Data pump, Data Guard,

RMAN Backup/Recovery

Operating Systems : Windows, Linux

:

Data Tools & Utilities Putty 0.60, DBCA, NETCA, DB Verify,

Statspack, AWR report, Explain Plan, TK Prof

ROLES & RESPONSIBILITIES

As a Database Administrator, my primary responsibilities are:

Implementation of DATAGUARD Physical Standby.

•

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 Datapump.

•

Recovery of lost objects and datafiles.

•

RMAN Backup and recovery strategies.

•

Recovery using RMAN.

•

Checking the Archive log shipping between the Primary and the standby (DR) databases and

•

troubleshooting it by rebuilding the Standby databases.

Upgarding database from Oracle 10.2.0.4 to 10.2.0.5

•

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 Data Pump, Data Guard,

•

Flashback Technology, Patching and Upgrading.

PROJECT DETAILS

Project Title : Automated Robot Trading System

1.

Technical Environment : Oracle 10g and 11g/Windows and Linux

Role : Database Administrator

Description:

In trading, an Automated Trading Strategy (commonly referred to as a Robot trading system) is a

predefined set of rules which govern the decision making process. Typically, an automated trading strategy

will include the ability to back test a strategy using historical market data. Backtest is the process of running a

predefined set of rules on historical market data in order to obtain hypothetical performance results (what

trades the strategy would have made during the historically tested period). The hypothetical performance

results provide the trader with a confidence that the strategy will make money in the future. Additionally, an

automated trading strategy provides the ability to automatically execute trades based on the predefined rules,

eliminating the need for a trader to be at the computer.

Responsibilities:

Creation of Tablespaces, 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.

Upgarding 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.

•

Creation of clone database using RMAN for testing.

•

Recovery of lost objects and datafiles.

•

Monitoring the unwanted User Session and killing them if needed.

•

Based on project requirement adding Tablespace and Datafiles

•

Refresh Database,schema and Datapump.

•

Backup database using Rman.

•

2. Project Title : Data Analysis and Interpretation of Stock Exchange

Technical Environment : Oracle 9i, 10g and 11g / Windows /Red hat Linux

Role : Database Administrator

Description:

The process of Data Analysis and Interpretation is used to finding the best Stock or Share in the

Market. This can be achieved by Optimization. Users input, modify and report the needed information

to the database through variety of applications, access these databases with pre granted privileges,

different departments and management people to edit and update their information in the production

and the distribution supply chain in real time. Periodic reports are generated by my team to expand the

market and reports sent to client.

Responsibilities:

Provided regular DBA support for the database servers.

•

Performed hot backups for the entire database.

•

Database administration, managing tablespaces, objects, disk space.

•

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

•

Adding new tablespace based on Requirment.

•

Checking alert log and trace files for errors.

•

Upgarding database from Oracle 10g to 11g

•

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 Dataguard.

•

PERSONAL DETAILS

Father's Name : V.Ganesan

DOB : 12th July 1987

Nationality : Indian

Marital Status : Married

Contact this candidate