Oracle Apps DBA
Synopsis
MCA professional with approx 2 years of experience as an Oracle Apps DBA.
Knowledge of DBA as well as Oracle Apps DBA
Currently associated with Orbisecure Technologies Gurgaon as an Oracle Apps DBA
Profficient in activities like Installation, Clonings, Patching, Upgrades, Maintenance etc
Team player with strong analytical, problem solving & organizational abilities.
Skill Sets
Installation of Oracle Apps 11i, R12, Oracle 9i, 10g databases
Oracle Applications cloning. (Single Node, Multi Node)
DB cloning using backup control file
Oracle Apps Architecture
AD Utilities like adpatch, adadmin, adctrl, adconfig, adrelink etc
Patching DB using Opatch
Application patching using adpatch
Database 9i to 10g Upgrade
JDK Upgrade
Developer Upgrade
RUP Upgrade
Invalid objects compilation manually as well as utlrp.sql
Maintaining tablespaces, datafiles, locks etc
Daily health check of DB and Apps
Basic Unix Administration.
SQL PLSQL
ASP .Net Language
Good communication and interpersonal skills.
Career Highlight
1) Orbisecure Technologies Oracle Apps DBA Since 07-June-2010 till 30-April-2012
Key Project Handled
Title : Maintenance Upgrades and Support
Designation : Oracle Apps DBA
Tenure : Since June’10
Responsibilities:
Day-to-Day Oracle DB maintenance and troubleshooting
DB cloning hot backup as well as cold backup
Oracle Apps Single to Single Node, Single to Multi Node, Multi to Multi Node cloning
Oracle Apps 11i , R12 installation
Oracle Apps Database Upgrade from 9i to 10g
Submitting Active Users request as a part of daily health check
Weekly Patching
Tablespace management
Daily health checks
Starting Stopping Oracle Apps services
Starting Stopping OMS & Agents
Managing blackouts
2) Orbisecure Technologies Trainee Since 04-Jan-2010 till 05-June-2010
Undergone 10 weeks training in Oracle Apps DBA . As a part of training learned concepts of Oracle DBA and Oracle Apps DBA. Training included Oracle Apps Architecture, Filesystem APPL_TOP, COMMON_TOP, important env files and scripts, Installation, Patching, Cloning, Daily health check etc.
Academia
MCA (IT) (Lovely Professional University) 2010, Scored 7.29 CGPA
PGDCA (IT) (Khalsa College Amritsar, GNDU University), 2007 scored 62%
Graduation (DAV College Amritsar, GNDU University), 2006 scored 56%
12th from Ashoka Sr. Secondary School, P.S.E.B 2003 scored 58%
10th from Amrit Sr. Secondary School, P.S.E.B 2001 scored 57%
Personal Dossier
Father’s Name : S. Harjit Singh
Date of Birth : 17th October,1985
Martial Status : Single
Languages Known : English, Hindi, Punjabi
Contact No. : +919*********
Email ID : ********.*******@*****.***
Hobbies : Interacting with new people, writing, Listening to music
Current Location : New Delhi
Permanent Address : H 228 , Vikas Puri ,
New Delhi (10008)
I hereby declare that all the information mentioned above is true to the best of my knowledge.
Angadjot Singh