Oracle Project
Resume:
G.Pushpa Prakash
************@*****.*** 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