CURRICULUM VITAE
Raghavendra SINGH
B.Tech (Electrical Engineering)
Mobile:- +91-945*******
Email :************@*****.***
Total IT Experience: - 1Years 10 Months
Post applied for:- Oracle Apps DBA
Relevant Experience: - 1Years 10 Months
Current Organization: Fusion Techware Pvt. Ltd, Noida
Current Profile: Oracle Apps DBA
Experience & Skill Summary
Having 1 years 10 months of experience in administering various versions of Oracle Database (9i, 10g) and Oracle E-Business Suite (11i) on various Operating Systems like RHEL and Linux.
Installation of Oracle Application 11.5.10.
Cloning of Oracle Applications 11i using Rapid clone from Multi Node to Multi node, Multi Node to Single Node.
Troubleshooting issues during Patching and Cloning of Oracle Application.
Monitoring and Troubleshooting of Apache, Forms, & Jsev related issues.
Oracle Application DBA support, applying patches, mini-packs, family-packs and maintenance packs, CU2 patch, upgrades, multi-tier installations, automatic routines DBA task, periodic refreshes, oracle support dealing with functional, developers and end users.
Generation and Analysis of AWR Reports and Session Trace.
Having good knowledge in database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, cold and hot backup, full backup, incremental and cumulative backup.
Currently Working with Fusion Techware Private Ltd. Noida. (10th July 2010 to till date)
Projects Profile
Project I :
Client : LMCS
Duration : 10th July 2010 to till date
Profile : Oracle DBA/Apps DBA
Oracle Application : Oracle Application 11i (11.5.10.2)
Database : Oracle Database 9i (9.0.1.)
Responsibilities:
Weekly refresh of 11.5.10 environments and R12 environments on 10g databases using Rapid Clone.
Resolving Technical and functional issues in coordination with support.
Troubleshooting errors relating to Forms, Jserv, Apache, and Database.
Status Checks of Oracle Application Services
Coordination with Oracle Support for addressing Issues.
Applying patches on Production and test environments for fixing bugs in the application, performing patch analysis and preparing document before applying patches.
Using AD utilities like Adadmin, adctrl, admrgpch, adrelink, adpatch for maintaining and configuring oracle Application
Performing cloning from production to test instances and dev instances using Rapid Clone.
Configuring the Concurrent Managers efficiently and tuning the concurrent managers.
Interacting with Functional consultants to schedule the concurrent requesting, changing the schedule of the specific request to reduce the load on the system at peak times.
Resetting the passwords using FNDCPASS for apps schema and other users.
Configuration of RMAN backups, Performing restoration, recovery, duplication of databases using RMAN.
Project II :
Client : COA
Duration : 10th July 2010 to till date
Profile : Oracle Apps DBA
Operating System : Linux RHEL 5
Oracle E-Business Suite : Oracle Application 11i (11.5.10.1, 11.5.10.2)
Responsibilities:
Applying the patches in development/test and in production using ad patch and manually.
Taking care of database object, tablespaces, and sessions in oracle applications.
Monitoring the backup schedules, archives etc. Backup taken by the backup team.
Development team request adding in production instance like report forms adding and giving the trace etc in development.
Also taking call from help desk and solving problem as end user log call to help desk.
Registered the Off-cycle products using AD splice during Patch process.
Perform overall health checks on the database at regular intervals to ensure smooth operation.
Verify backups for all databases and take corrective actions for failed backups.
Perform database recovery in the instance based on the Client business requirements.
Create, configure, size and maintain database systems to support applications following Change control process.
Manage and maintain database security and database configuration.
Respond to alerts and submit corrective actions as deemed necessary for change review.
Rectifying Database Locks , Runaway Processes.
Apply database patches and fixes as per Client requirements and vendor recommendations as assigned via Change Request.
Perform database copies (refresh) from one environment to the other and manage all related tasks.
Assume responsibility of all trouble tickets assigned to the Database group via the ticket tracking system, track and report all progress on the issue and details regarding the resolution in the system.
Professional Qualification
Bachelors of Technology degree in “ELECTRICAL ENGINEERING” from Greater Noida Institute of Technology, GR.Noida affiliated to U.P. Technical University (B.Tech.2010 batch) with 61.20%
12th From U.P Board in 2005 with 60.20%.
10th From U.P Board in 2003 with 52%.
Personal Details
Name : Raghavendra Singh
Father’s Name : Mr. I. P. Singh
Mother’s Name : Mrs. Ramvati
Date of Birth : 18th FEB, 1988
REFEREES:
Available upon request.
Place: Noida
Date: (Raghavendra Singh)