Oracle Database Administrator
Wipro Technologies
Total years of experience :2 years, 5 Months
Organization: Wipro Technologies.
Duration: December 2011 - March 2013
Role: Oracle Database Administrator
Responsibilities as an ORACLE DBA
• Refreshed the database for testing purpose.
• Managing Physical Structure of Oracle Database.
• Checking Alert log files to know the types of Bottlenecks recorded during the day.
• Monitoring Table spaces and data files utilization.
• Monitoring database performance and taking corrective actions.
• Allocating system storage and planning future storage requirements for the database.
• Maintaining the archived data on the appropriate storage devices.
• Backing and restoring the database.
• Monitoring database performance and taking corrective actions.
• Creating primary database objects (tables) once application developers have designed an application.
• Planning for backup of the database information.
Significant strengths:
• Good presentation and communication skills to provide support to the customer.
• Ability to work flexibly as team member.
• Dedications with an inner drive to succeed and accomplish goals.
• Ability to perfectly plan and execute the given job to perfection.
Working as Database Administrator with Wipro Technologies. Hyderabad since December 2010 to till March 2013.
PROJECT EXPERIENCE
Client: Ahold USA
Organization: Wipro Technologies.
Duration: November 2010 - September 2011
Role: Oracle Database Administrator
Responsibilities as an ORACLE DBA
• Installing Oracle 10g Server 10.2.0 on Linux/Window NT.
• Administrative work like creating, maintaining users and their roles, password setting, granting privileges.
• Creation of Table spaces and Schema owners.
• Responsible for setting up user environment, Managing Systems & User and Group security.
• Creation of logical and physical objects in the database.
• Creating and adding data files to primary database storage structures.
• Maintaining redo log files, control files, data files and archived log files.
• Database Space Management, which includes creation of Table spaces.
• Gathering Schema Statistics to improve the Performance.
• Utilized Explain plan and Oracle Trace Utility.
• Backed up the databases through cold backup, hot backup for some of the databases.
• Taking Secondary Backups using Export and Loading the data back to the database using Import utility. Load data into database using SQL*loader.
• Provided technical support to developers in tuning SQL Query.
PROJECT EXPERIENCE
Client: Baxter USA
B.E (COMPUTER SCIENCE ENGINEERING) OSMANIA UNIVERSITY ORACLE (DBA)