Muthukumar Dhanushkodi

**/* *********,***********,

Thirunagar,

Madurai-625006

Email : acgb51@r.postjobfree.com

Mobile No : +91-860*******, 978-***-****

Objective

To become a highly dynamic IT professional in Database Administration field. Enthusiastic to

carry out challenging projects with competitive schedules, with having up to date knowledge

in latest technologies and the ability to strive hard and exceeds the expectation of the

business.

Professional Summary

An initiative individual with 4+ years of total experience in Retail domain with a

Strong technical expertise in the DB supports activities.

Oracle 10G professional Database Administrator

Experience in administering, tuning and monitoring database using Toad, OEM

Hands-on experience in 24/7 production environments

Expertise in ensuring the business continuity by on-call support.

Hands-on- experience in transitions and knowledge transfer

Familiar in UNIX shell scripting and PL/SQL codes

Responsible, self-starter and quick learner with strong communication skills

Possessing a strong analytical and problem-solving skills

Expertise in Data-Guard & RAC

Handling L1 Tasks in SQL Database Server

Attending day-to-day problems occurring with the production databases and

Taking suitable action

Experience in rapidly learning and analyzing new subject matter, Strong

Analytical and problem solving skills

Work Experience

Organization #1: REDIM Software Technologies, Chennai, India.

Title : Member Technical Staff

Period : February 2008 to July 2009

Project Details:

Project #1 : Casino online Gaming

Title : Casino Gaming Action scripting and Data Maintenance

Domain : Gaming

Period : February 2008 to July 2009

Roles and responsibilities:

Monitoring database growth and proportionate performance.

Monitoring CPU, sessions, process and query behaviors

Monitoring database performance using monitoring tools.

Monitoring alert logs and taking steps to rectify error messages.

Proactively monitored hit ratios on different components of the SGA.

Export/import activities and data loading using SQL Loader.

Analyzing ORA errors in the alerts and fixing them

Scheduling the DBA jobs and data loading

Handled issues regarding locks

Objects maintenance activities such as partitioning large tables into different partitions,

data purging based on data retention policy etc

Incident ticket handling, change and problem managements processes.

Organization #2: TATA Consultancy Services Ltd, Chennai, India.

Title : Oracle Database Administrator

Period : July 2011 to till date

Project #2 : PETCO Animal Supplies, California (USA)

Title : Maintenance and support for oracle 10g/11g databases

Domain : Retail

Period : July 2011 to till date

Roles and responsibilities:

Creating tablespaces and database files based on the OFA model.

Creation and maintenance of DB objects, Sizing database objects for effective space

management and optimal performance.

Monitoring space and index usage. Rebuilding index as required.

Managing database security. Creating and assigning appropriate roles and privileges

to users depending on the user activity.

Performing periodical backups.

Handling issues regarding tablespace and datafiles.

Implemented table partitioning to improve performance and data management.

Performed SQL tuning by using Explain Plan and Tkprof.

Analyzing tables on a regular basis for the Oracle optimizer.

Verifying the integrity of backups

Removing chained rows and Fragmentation in fragmented tables.

Generating AWR Repots and analyzing the database performance.

Performing Database deployment changes.

Installation and configuration of RAC

Adding and deletion of Node in RAC

Written shell scripts to monitor oracle databases that includes alter log, file system

and tablespace

Creation of oracle objects as per application team's request

Solved difficult performance tuning, troubleshooting and administration issues

Designed and developed scripts for DB environment

Creating Database Links from UAT to PROD databases

Mentoring and knowledge transfer to other team members.

Managing users with Quota Maintenance and security by creating roles and profiles

Finding and rectifying fragmentation for tables and indexes

Setup and configured Oracle 9i/10g Physical Standby database (Data Guard) and

performed Switchover using DGMGRL

Worked on roles, granting privileges and profiles

Monitor the database by collecting statistics of instance and files by querying data

dictionary views, SQL trace files and TKPROF, STATSPACK to find ways to improve

the database's performance

Performed logical backups using Export / Import utilities

Recovery of lost objects and data files

Analyze the index if necessary rebuild or Coalesce index to rectify segment

fragmentation

Cloning databases

Generated STATSPACK reports and AWR reports for tuning

Database Growth Estimation

Maintaining all the objects of the database

Recovery of lost objects and data files

Monitoring the database growth, Re-Organization of Tables

Checking the Data Files Consistency using DB Verify utility

Frequent analysis of objects or schemas to improve the speed of the database

Creation of DB Links between Heterogeneous servers(SQL & ORACLE)

Education Details

M.E (Power Systems Engineering) in Thiyagarajar College of Engineering, Madurai -

625006. Passed Out: 2011. CGPA 8.6

B.E Electrical & Electronics Engineering in Kalasalingam College of Engineering,

Srivilliputhur, ANNA University, Tamil Nadu. Passed Out: 2007. Percentage 70%

HSC in Jayaraj Nadar Higher Secondary School, Madurai, Tamil Nadu. Passed Out:

2003. Percentage: 79%

SSLC in Nadar Sarawathi Higher Secondary School, Theni, Tamil Nadu. Passed Out:

2001. Percentage: 90 %

Achivements

Flash Action Scripting Certified Professional

The paper entitled “Generation Expansion Planning Using Minkowski Fuzzy Cluster

Technique” has been accepted for publication and oral presentation at SEMMCO-2010

International Conference on “Swarm, Evolutionary and Memetic Computing” being

conducted by SRM University, Chennai to be held on 16th to 18th December 2010

Software Proficiency

Oracle 9i/10g administration and performance tuning

AIX and Windows servers administration

Backup (Logical and Physical), RMAN and Recovery

Familiar in XML

Familiar in UNIX shell scripting.

Familiar in Flash Action Scripting

Familiar in Export/Import utilities, SQL Loaders, TKPROF and Explain Plan

Personal Information

Sex : Male

Nationality : Indian

Marital Status : Married

Language known : English, Tamil

DOB : 08/11/1985

Declaration

I hereby declare that the details furnished above are true to the best of my knowledge

and belief.

Signature:

Date:

Place: (D.Muthukumar)

Contact this candidate