Objective :

To excel as a Database Administrator professional through integration of my knowledge, skill sets and continuous learning from new experiences and providing quality and efficient solutions.

Profile Summary :

• Around 3 Years and 3 Months of experience in Oracle Database Administration.
• At present working with Yalamanchili Software Exports Pvt., Ltd., Chennai.
• Experience with oracle 9i and Oracle 10g databases across various operating systems like Linux and solaris.
• Experience in Oracle Installation, maintenance, administration ,creating databases, Backup,Recovery and Tuning skills.
• Attending day-to-day problems occurring with the production databases and taking

suitable actions for troubleshooting.

• Excellent problem solving and analytical skills.
• Have completed Oracle Certification (OCP) in oracle 9i.
• Have completed MBA from Adhi Parasakthi Engineering College , TamilNadu.

Educational Qualification :

M.B.A, (in Marketing & systems)

B.Sc (phy) _ Bachlor of physics

Professional Experience :

Current Employer : Confidential,
Location : Chennai.
Team size : 7
Role : Senior Database Administrator
Domain : Confidential,
Nature of Job : Providing 24x7 support to Production Databases.
Date of Joining : Since May2007
Experience Years : 30 Months

Responsibilities :

General Responsibilities and Database Health Checks :

• Oracle Installtion [GUI and Silent Mode], Database creation and user creation
• Security administration and user management involving assigning roles,Privileges etc.
• Ensure freespace in database which involves adding or resizing database datafiles.
• Providing oracle privileges [DML,DDL] to users whenever required.
• Frequently Performing database health checks by
• By analyzing diagnostic files such as alert log file,background and user trace files.
• By monitoring database wait events.
• By Checking db hit ratio and library cache hit ratios.
• Providing 24x7support to all end users of the applications related to Databases
• Managing disk freespace in database servers.

Responsibilities with Respect to Backup and Recovery:

• Implementing and Managing Database Physical backup using Rman utility
• Performing Online/Hot backup whenever required
• Performing Offline/cold backup whenever required
• Implementing and Managing Logical backups using Export utility
• Creating physical standby database
• Verifying backups using dbverify utility
• Performing Rman and user-managed Complete Recovery when required.
• Performing Rman and user-managed Incomplete recovery when required.
• Knowledge in Flashback Database , Flashback table and Flashback query.
• Knowledge in Data pump utility.
• Moving the database backups to the tape cartridge.
• Managing backups of archived logs and control files.
• Oracle Net configurations [Listener and Tnsnames]

Responsibilities with Respect to Tuning:

• Analyze and Rebuild Index to rectify segment fragmentation.
• Performing any structural changes as required by the development team.
• Dropping and recreating undo tablespace and temporary tablespaces whenever required.
• Creating database links and synonyms in order to access a specific object which is exists in the target database.
• Performed database and SQL tuning and troubleshooting including analyzing traces.
• Rreorganizing tablespaces, tables and indexes.
• Tracing sql queries using sql trace option and anlyse using Tkprof utility.
• Analyzing the execution plan for SQL queries using EXPLAIN PLAN and AUTOTRACE utility and creating necessary indexes to increase the response time.
• Force sql query to use an index using hints in order to increase the response time.
• Monitoring and dropping unused indexes
• Tuning of Memory structures when required like pinning objects permenantly into memory and resizing memory components etc.,
• Creating partitioning tables.
• Manually generating statistics for large segments in oracle 9i.

Experience Related to Oracle Database Migration:

• Having experience in migrating oracle 10g database from linux 32 bit to solaris 64 bit.
• Having experience in Migrating oracle 9i to oracle 10g
• Having experience in applying oracle patches.
• Experience in RAC environment.

Responsibilities with Respect to Solaris::

• Assiging ports and configuring backend applications which includes enabling new services in solaris server.
• Monitoring system performance like Monitoring Ram memory , Swap memory , Cpu utilization and top running process in the system.
• Monitoring disk space in both application,web and database servers and taking suitable actions when required.
• Taking frontend and backend application binary and config files backup.

Previous Experience :

Previous Employer : Confidential,
Location : Chennai.
Team size : 3
Role : Oracle Database Administrator - Trainee
Nature of Job : Providing support to Development Databases.
Date of Joining : Sep2006
Date of Relieving : April2007
Experience Years : 8 Months

Responsibilities :

• Os user creation
• Oracle installation and database creation
• Oracle user creation and assigning roles to the user
• Creating synonyms and dblinks whenever required
• Ensure freespace in database which involves adding or resizing database datafiles.
• Managing disk freespace in database servers.
• Export and Import
• Creating indexes and synonyms
• Performing any structural changes as required by the development team.
• Monitoring server performance like checking ram , swap memories and top processes that are consuming more cpu etc.,