Associate DBA Resume Profile

OBJECTIVE

Seeking a progressive and strong career as Oracle DBA for challenging and critical environment.
PROFESSIONAL SUMMARY
Worked as an Associate DBA at KPIT Cummins Infosystems Ltd, since Oct 2009.
2 plus years of experience in Database Administration, Backup Recovery of Oracle Database.
Continuous and consistent track record of working on production, staging and development environment involving Oracle RDBMS 9i, 10g and 11g.
Demonstrated ability to handle Oracle DBA activities independently for over 500 databases with size varying from 10GB to 1TB.
Willingness to participate in a highly productive, team-oriented environment.
Comprehensive problem solving abilities, excellent verbal and written communication skills, willingness to learn, team facilitator and hard working.
Possess excellent communication and interpersonal skills and ability to work in a team as well as individually.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Job Title: Associate DBA

Roles and Responsibilities:

Oracle 9i, 10g, 11g Database Administration
Performance Tuning Capacity Monitoring
Manual Backup and Recovery and also by using RMAN
Responsible for Database support to UAT servers , development servers and Production servers 24 7 .
Database Refresh/Cloning from production to development and support databases
Maintaining data integrity and tune database for optimum performance and availability.
Knowledge on CRONTAB job Scheduling, Monitoring Scheduled jobs.
Monitoring resolving Space issues
Performing Refresh activities on weekly basis
Monitoring AWR ADDM reports for resolving the Performance issues
Perform database tuning using Oracle Enterprise Manager, STATSPACK, AWR report and ADDM report
Generated EXECUTION PLAN for Analyzing SQL Statement
Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
Performing file/dump transfer across servers using SFTP and SCP.
Analyzing / Rebuild Indexes to rectify segment fragmentation.
Data loading and unloading through EXPDP/IMPDP and EXP/IMP.
SQL Query tuning/ optimization using indexing and different hints as per developer's requirements.
Create database users, and assign appropriate roles.
Solving error related to space in OS.
Worked extensively on SOX production databases, involved tremendously in regulating the SOX process by creating cronjobs.