Sr Oracle DBA
Resume:
RESUME
Akila Narayanan *****.****@*****.***
PROFESSIONAL OBJECTIVE:
To work with zest and carve out a career where new ideas and views are welcome and to potentially grow with the organization.
SUMMARY:
1. Currently working as Oracle Apps Database Administrator at Wipro Technologies Limited, Chennai (India).
2. Total experience of 36 Months as on January 2011.
3. Experience in installation, support, maintenance, patching, upgrade technical support of oracle database and application including RAC environment.
4. Experience in supporting multiple projects simultaneously (Flex Model)
COURSE INSTITUTION BOARD / UNIVERSITY YEAR OF COMPLETION MARKS%
B.E CSE Karpagam College of Engineering Anna University 2007 80.4*
XII B.V.B
M. H.S.S State Board 2003 86.5
X B.V.B
M. H.S.S Matriculation Board 2001 83.09
Key strengths :
1. Installation, 11g, 10g, 9i.
2. Worked on upgrade from 9i to 10g and 10g to 11g (RAC and NON RAC) ,
3. Database level Performance Tuning.
4. Standby database maintenance.
5. RMAN backups and restoration.
6. Patching Oracle applications/databases
7. Cloning single node and multi node databases.
8. Have undergone 3 months of full fledged training in SAP and SAP Basis.
9. Have undergone training in 11gR2 new features from Oracle.
Professional Experience:
Company worked for : Wipro Technologies Limited
Duration : From : December 2007 To Date: Till now
Worked As : Database Administrator in “Enterprise Application Solutions (EAS)” domain
Project Details
Project 1 :
Company Profile: Leading semiconductors Manufacturing Firm.
Location: Singapore
Instances Supported 45 (RAC/Non-RAC instances: Both PROD and Non-PROD)
Role Oracle Apps DBA
Platform and Tools : Linux, HPUX, Window NT, Oracle Application 11.1.10.2(RAC) Database 10.1.0.5 (RAC),
Oracle Enterprise Manager, Wallet Manager, Toad, Kintana, Win SCP, Win CVS, PL-SQL Developer, Informix
Project and Role Description:
• Applying patches and bring the production to the user specific requirement after testing in iteration.
• Cloning the production for development, testing and patching instances via RMAN.
• Monitoring all the alerts, alert-log, concurrent processes, tablespace management, AWR report, listener status, locks, workflow mailer, and other maintenance tasks.
• Resolving CPU space management issues, locks and wait events.
• Major activities include re-building indexes, de-fragmentation for major tables, Applying Critical Patch Updates, Compiling invalids, recreating temporary tablespace, creating users and enrolling defined responsibilities if automated process failed, SSL certificate renewal, Configuration of EM Alerts, File system housekeeping, taxware update, ModelN service related issues, Shared services related issues, checking and applying archive logs in DR standby databases, generating reports explaining the overall performance of the system every 15 days.
• Installed 10G AS and worked on installation/integration of SABRIX taxware with 10G AS
• Installed 11.1.0.6 CRS, ASM and DB in 3 node RAC configuration and upgraded it to 11.1.0.7
• Installed 10.2.0.4 CRS, 10.1.0.5 ASM and DB in 4 node RAC configuration in OVM enabled server and restored the DB from RMAN backup.
• Working on issues faced by application users and providing support 24/7
Project 2:
Company Profile Leading Retail Stores Brand
Location Brazil, US
Instances Supported 4 (Production-2, Non-Production-2)
Role Oracle Apps DBA
Platform and Tools : Sun Solaris SPARC 8, Oracle database 9.2.0.6, Appworx, Allocation, Retek
System (RMS and RDW), Remedy, Filezilla (scp tool), Win CVS.
Project and Role Description:
• Taking Cold backup, Restoring objects from tape backup.
• Monitoring all the alerts, alert-log, tablespace management, listener status, locks, and other maintenance tasks.
• Resolving CPU usage/space management issues locks and wait events.
• Major activities include re-building indexes, de-fragmentation of tablespace, Compiling invalids, recreating temporary tablespace, restoring tables from backup, creating users and enrolling defined responsibilities, managing Appworx and Allocation services, server housekeeping generating monthly reports explaining the overall performance of the system.
• Working on issues faced by application users and providing support 24/7.
Project 3:
Company Profile Leading Retail Stores
Location US, Canada
Instances Supported 3 (Production: DB & Application, Test :DB & Application, Development :DB & Application Essbase : 1 Server)
Role Oracle Apps DBA
Platform and Tools : HPUX, Oracle Application 11.5.10, database 9.2.0.6, Next Desk, Win SCP
Project and Role Description:
• Applying patches and bring the production to the user specific requirement after testing in iteration.
• Refreshing development and testing database from production.
• Monitoring all the alerts, alert-log, concurrent processes tablespace management, statspack report, listener status, locks, workflow mailer and other maintenance tasks.
• Resolving CPU space management issues, locks and wait events.
• Major activities include re-building indexes, Compiling invalids, recreating temporary tablespace, creating users, user alert notification for SOX audits and enrolling defined responsibilities, generating weekly reports explaining the overall performance of the system.
• Working on issues faced by application users and providing support 24/7.
Project 4:
Company Profile Renowned Chain of Supermarkets
Location Dubai
Instances Supported 15 (Production-7,Non-Production-8)
Role Oracle Apps DBA
Platform and Tools : Sun Solaris SPARC 9, Oracle Application 11.5.10.2, Oracle Database 9.2.0.6/10.2.0.3, Win SCP.
Project and Role Description:
• Applying patches and bring the production to the user specific requirement after testing in iteration.
• Cloning the production for development and testing using RMAN.
• Monitoring all the alerts, alert-log, tablespace management, listener status, locks, workflow mailer and other maintenance tasks.
• Resolving CPU space management issues, locks and wait events.
• Major activities include re-building indexes, tablespace de-fragmentation, Compiling invalids, recreating temporary tablespace, creating users and enrolling defined responsibilities, generating monthly reports explaining the overall performance of the system.
ACHIEVEMENTS:
• Awarded “Feather in My Cap“Award - For handling incidents in Avago with zero escalations & for constant co-ordination & effort in working with other teams, apart from regular services to other Flex DBA projects.
• Been a part of client’s project's Yearly Audit calls & activities; Awarded "Feather in My Cap" award - For successfully completing the Client Company’s AUDIT.
• Been awarded by client for commitment shown towards their storage migration activity and being a part in making that project a success.
• Been appreciated by the client for successful up gradation and on time delivery of their instances from 10g to 11gR2.
• Client appreciations across all projects handled for providing effective, prompt resolution for production issues and overall project handling
PERSONAL DETAILS:
Name : Akila Narayanan
Date of Birth : 22nd December 1985
Gender : Female
Father’s Name : V.Narayanan
Spouse’s Name : Karthik Balan
Contact address: No: 11/3, Seven Hills Apts, 3rd Street, Rangarajapuram, Kodambakkam, Chennai -600024
Contact Email : *****.****@*****.***
DECLARTION
I, Akila Narayanan, hereby declare that the information furnished above is true to the best of my knowledge and belief.
Akila Narayanan
Contact this candidate