Lead Application Database
DEVESH Gupta
sEM
SH-*01, Shastri Nagar, Ghaziabad PROFESSIONAL SKILLS
U.P.- 201002
Tel : +91-801*******
Leadership qualities. Trust in team not in Distinct. Maintain
Email : acqg37@r.postjobfree.com
healthy relationship with Client/Third Party Vendors.
Clear Communication and Goals Oriented person.
Installation of Oracle Apps11i/R12 (single/multi node) on
Linux, HP-UX, Sun Solaris, IBM-AIX.
ABOUT ME
Sysadmin, Cloning, Patch application activities on Apps 11i
and R12 environment.
Database level patching on Linux, IBM-AIX, HP-UX and Sun
I am having 11+ years of experience in Oracle
Apps DBA. Solaris.
Troubleshooting, Upgradation and Migration.
Worked on 24/7 high availability environments.
Currently I am working as DBA Lead since last
Database Cloning.
11 months. I am managing 4 DBA associates
Application Cloning
team. Also I am managing Third Party -
Good in shell scripting
Vendors. Recently I had done Go-Live for
Installation of Oracle 10gR2, 11gR1 and 11gR2 RAC
one of the entity which brought lot of
Implementation OBIEE, Informatica, DAC and BIAPPS
confidence in me.
Implementation of Disaster Recovery site for Application
Received accolades from Senior Management. and Database.
I am good in Technical, Managing
team members, Dealing with
Client/Third Party Vendors.
I believe in maintaining strong relationship
with my colleagues, Seniors as well as client.
PROFESSIONAL SUMMARY
Currently employed with Petrofac Information Services Pvt Ltd Chennai since January
COMPANY NAME– JOB TITLE TRANSSYSSOLUTIONS Pvt. Ltd. Chennai from January
2013. Earlier I was with
LOCATION – Start December 2012. Prior – 01/01/2009 associated with CALSOFT (INATECH) Pvt. Ltd.
2011 to date / End date 01/01/2001 to it I was
A brief descriptionrom October 2009 to December 2010. My association with SATYAM COMPUTER
Chennai f of your achievements in that job
SERVICES Pvt. Ltd. Hyderabad was from April 2006 to September 2009. I’ve started my
Lorem ipsum dolor sitSamet, consectetur adipiscing elit. EtiamNovember 20 03 Donecarch 2006. These
carrier with PIDER SYSTEMS Pvt. Ltd. Pune in vel egestas nulla. till M
vestibulum dapibus mi at venenatis. Integer volutpat lacinia convallis
organizations are mainly into development, Implementation and support.
List of clients handled and the activities performed (November 2003 - till date)
COMMON TASKS PERFORM AT EACH CLIENT
s
System administration functions like creating users, creating responsibilities and menus.
Server Administration, system backups and Space Management..
Coordinating with Oracle support for logging tar and knowledge based search to find solution
to the problems that is occurring in the live server and while applying patches (tar, Bug
search, User forum participation).
Cloning (Database & Application) from PROD to NON-PROD instances (RAC and NON RAC
both).
Daily Health Check.
PROFESSIONAL EXPERIENCE
Petrofac Information Services Pvt. Ltd., Chennai
Senior Consultant
This project involving multi-node architecture where 2 nodes for Application (12.1.2), 2 nodes
for DMZ and 2 nodes for Oracle Database RAC (11.1.0.7) running on IBM-AIX 6.1. Since last 11
months I am working as DBA Lead and managing 4 members DBA Team, also Dealing with third Party
Vendors.
Selected Accomplishments:
Currently involved in 11gR1 to 12c RAC Database Upgrade and 12.1.2 to 12.1.3 Application
upgrade.
Managed team off-site DBAs across global locations. DBA categorized of Administration,
Application, Production, Operation, Change Management, On -call support and Optimization.
Defined Policy/Standards and process for the database chan ges migration model flow drafted for
the production.
Working and Managing third party Vendors.
Had done Go-Live (UAE entity) successfully. Involved in Server capacity planning, Load Testing,
Application Performance, etc…
Maintenance of installed Oracle Applications Release 12.1.2 suite and Troubleshooting.
Implement Automated Daily Checklist in HTML format which server the data dynamically.
Working on Shell script.
Installed OEM 11g agent for 64 bit AIX operating system.
Created new RAC instances.
Worked on Database RAC upgrade from 11gR1 to 11gR2
Applied HRMS RUP 5 and RUP 7 patches
Implemented OEM 12c cloud
Maintaining Hyperion, BPEL and Siebel Databases
Implemented automated cloning using shell script
Implemented SVN tool for Version Control
Implemented OBIA with Informatica and DAC
Implemented TDP (Tivoli Data Protection)
Transsyssolutions Pvt. Ltd., Chennai
Consultant
This project involved single node architecture where Application (12.1.1) and Oracle Database
(11.1.0.7) running on Oracle Linux.
Selected Accomplishments:
Implemented single node Application server 12.1.1 with Database 11gR1.
Installed Discoverer 10g tool and Integrated with E-Business suite Application 12.1.1.
Implemented OBIEE 11g with Informatica, DAC and BIAPPS.
Installed 11.5.10.2 on Ubuntu Linux.
Installed and Configured of OATS.
Maintenance of installed Oracle Applications Release 12.1.1 suite and Troubleshooting
Al-Bahar, Sharjah
Project Lead
This project involved multi-node architecture where 1 node for Application (12.1.2), 1 node for
DMZ and 1 node for Oracle Database(11.1.0.7) running on Oracle Linux.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 12.1.2 suite and Troubleshooting.
Camair-Co Pvt. Ltd., Camerron
Project Lead
This project involved single node architecture where Application (12.1.3) and Oracle Database
(11.1.0.7) running on Oracle Linux.
Selected Accomplishments:
Implemented of single node Application server 12.1.3 with Database 11gR1 on PROD and TEST
instances.
Maintenance of installed Oracle Applications Release 12.1.3 suite and Troubleshooting.
Implemented RMAN backup policy without Recovery Catalog.
Had done Hot Cloning using RMAN duplicate database feature.
Dubai Duty Free (DDF), Dubai
Project Lead
This project involved two nodes architecture where 1 node for Application (12.1.3) and 1 node
for Oracle Database (11.2.0.4) running on IBM-AIX 5.3.
Selected Accomplishments:
Upgraded E-Business Suite Application from 11.5.10.2 to 12.1.3.
Upgraded Database from 9.2.0.6 to 11.2.0.4.
Converted Tablespaces from OAF to OATM.
Maintenance of installed Oracle Applications Release 12.1.3 suite and Troubleshooting.
Al-Essa Group, Kuwait
Project Lead
This project involved two nodes architecture where 1 node for Application (11.5.10.2) and 1
node for Oracle Database (11.2.0.4) running on RHEL 5.
Selected Accomplishments:
Upgrade Oracle Database from 9.2.0.6 to 11.2.0.2.
Maintenance of installed Oracle Applications Release 11.5.10.2 suite and Troubleshooting.
Abu Dabhi Tawteen Council (ADTC), Abu Dabhi
Project Lead
This project involved two nodes architecture where 1 node for Application (12.1.3) and 1 node
for Oracle Database (10.2.0.4) running on RHEL 5.
Selected Accomplishments:
Upgrade E-Business Suite Application from 12.0.6 to 12.1.3.
Maintenance of installed Oracle Applications Release 12.1.3 suite and Troubleshooting.
Implemented RMAN backup policy without Recovery Catalog.
Had Done Hot Cloning using RMAN duplicate database feature.
Masdar (Future Energy Company), Abu Dabhi
Project Lead
This project involved multi-node architecture where 2 nodes for Application (12.1.3) and 2
nodes for Oracle Database RAC (11.1.0.7) running on Sun Solaris.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 12.1.3 suite and Troubleshooting.
Maintenance EDMS (Electronic Document Management System) Database which is running on
oracle 11.2.0.2.
Domino Pvt. Ltd., UK
Project Lead
This project involved multi-node architecture where 2 nodes for Application (11.5.10.2), 2
nodes for DMZ and 2 nodes for Oracle Database RAC (10.2.0.4) and 12.0.6 Application (specific for
Supply and Chain planning) running on RHEL 5.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 11.5.10.2 and 12.0.6 suite and
Troubleshooting.
Converted database from 32 bit to 64 bit.
Installed OEM 10g agent for 64 bit Linux operating system.
Created new RAC instances.
Moved the Application server from RHEL4 to RHEL5
Applied latest patch set level in 11.5.10.2 like ATG_PF.RUP.7, AD.I.7
Moved Production database from RHEL4 to RHEL5 64 bit
HSC, UK
Project Lead
This project involved multi-node architecture where 1 node for Application (11.5.9), 1 node for
DMZ and 1 node for Oracle Database (9.2.0.6) running on HP-UNIX. Later we upgraded the Application
& DMZ with SSL from 11.5.9 to 12.1.3 & Database from 9.2.0.6 to 11.2.0.4 and migrated to Oracle
Linux.
Selected Accomplishments:
Upgraded E-Business Suite Application from 11.5.9 to 12.1.3.
Upgraded Database from 9.2.0.6 to 11.2.0.4.
Upgraded DMZ from 11.5.9 to 12.1.3 with SSL.
Migrated Application and Database from HP-UX to Oracle Linux.
Converted tablespaces from OAF to OATM.
Maintenance of installed Oracle Applications Release 11.5.9 and 12.1.3 suite and
Troubleshooting.
Rochefort Technology Limited (RTL), UK
Project Lead
This project involved only 1 database node (10.2.0.2) running on Oracle Linux.
Selected Accomplishments:
Implemented RMAN backup policy without Recovery Catalog.
Had Done Hot Cloning using RMAN duplicate database feature.
WoodGroup, UK
Project Lead
This project involved two nodes architecture where 1 node for Application (11.5.10.2) and 1
node for Oracle Database (10.2.0.4) running on Oracle Linux.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 11.5.10.2 suite and Troubleshooting.
Buy As You View Limited (BAYV), UK
Project Lead
This project involved two nodes architecture where 1 node for Application (11.5.10.2) and 1
node for Oracle Database (10.2.0.4) running on Oracle Linux.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 11.5.10.2 suite and Troubleshooting.
Greater Amman Municipality, Jordan
Oracle Application DBA
This project involved single node architecture where 1 node for oracle Application (12.1.1) and
1 node for Oracle Database (11.1.0.7) running on HP-UX 11.31.
Selected Accomplishments:
Implemented of single node Application server 12.1.1 with Database 11gR1 on Test and Vis ion
instances.
Fullerton-Securities, Gurgaon
Oracle Application DBA
This project involved two nodes architecture where one node for Oracle Application (11.5.10.2)
and 1 node for Oracle Database (9.2.0.6) running on IBM-AIX 5.3.
Selected Accomplishments:
Implemented single node two instances (Test and Development) where Application server
11.5.10.2 with Database 9.2.0.6.
Satyam Computer Services Pvt. Ltd., Hyderabad
Oracle Application DBA
This project involved two nodes architecture where one node for Oracle Application (11.5.10.2)
and 1 node for Oracle Database (10.2.0.3) running on Oracle Linux.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 11.5.10.2 and 12.0.4 suite and
Troubleshooting.
Implemented two node Application server 11.5.10.2 with one node Database server 10.2.0.3 .
Implemented DMZ.
Bank of Ghana, South Africa
Oracle Application DBA
This project involved two nodes architecture where one node for Oracle Application (11.5.10.2)
and 1 node for Oracle Database (10.2.0.3) running on HP-UX.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 11.5.10.2 suite and Troubleshooting.
Implemented OS Clustering between Database nodes.
Implemented Disaster Recovery site for the Database and Application.
Kuwait Oil Tanker Co (KOTC), Kuwait
Oracle Application DBA
This project involved multi-node architecture where 2 nodes of application (11.5.10.2) and 1
node of Database (10.2.0.3) running on Sun Solaris.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 11.5.10.2 suite and Troubleshooting.
Implemented two node Application server 11.5.10.2 with one node Database server 10.2.0.3 on
PROD instance.
Had done Go-Live in April successfully.
Implemented Parallel Concurrurent Processing.
Implemented Hardware Load Balancing.
Implemented Disaster Recovery for the Database.
Configured Shared file system.
Activities had done like Export/Imports, Database monitoring, File system check,
troubleshooting, etc.
Avago Technologies, Singapore
Oracle Application DBA
This project involved multi-node architecture where 6 nodes of application (11.5.10.2) and 4
nodes of RAC Database (10.1.0.5) running on Oracle Linux and HP -UX.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 11.5.10.2 suite and Troubleshooting.
24X7 online support to the development team.
Supported RAC on PROD instances.
Implemented of RAC on NON-PROD instances.
Refreshed non-production instance on regular basis.
Implemented Parallel Concurrurent Processing.
Configured Shared file system.
Activities performed like Export/Imports, Database monitoring, File system check,
troubleshooting, etc.
RAC to Single Node Cloning with ASM.
Spider Systems Pvt. Ltd., Pune
Oracle DBA/Apps DBA
This project involved two nodes architecture where 1 node for Oracle Application (11.5.9) and 1
node for Oracle Database (9.2.0.4) running on Oracle Linux.
Selected Accomplishments:
Installed 11.5.9 on NT and Linux.
Installed Oracle 9i on different client sites.
Installed Developer/2000, workflow on different client sites.
Started and shut down instances.
Troubleshooting.
Space Management.
Tata Auto Plastics, Pune
Oracle Application DBA
This project involved two nodes architecture where 1 node for Oracle Application (11.5.9) and 1
node for Oracle Database (9.2.0.4) running on Oracle Linux.
Selected Accomplishments:
Maintenance of installed Oracle Applications Release 11.5.9 suite and Troubleshooting.
Troubleshooting.
Database administration of production and test instances.
Space management.
Performed database backup and recovery procedures and routine maintenance activities.
Deepak Nitrite Limited, Pune
Oracle DBA
This project involved single node Database architecture where 1 node for Oracle Database
(9.2.0.4) running on Linux.
Selected Accomplishments:
Regular Observation of logs files and traces files.
Space management
Development of proper backup and recovery strategies
Creation of Tablespace, users and granting, revoking roles to them, as and when required.
EDUCATION
C.C.S UNIVERSITY, Meerut
Bachelor of Commerce, 2002
ADDITIONAL INFORMATION
In house training of ORACLE 11i Apps DBA at Spider Systems Private Limited.
In house training of ORACLE 9i DBA at Spider Systems Private Limited.
Attended Leadership Program in Petrofac Information Services Pvt. Ltd.
Awarded in 2007 from Avago client for cloning (completed 2 clonings in 1 day).
AREAS OF EXPERTISE
WORK PROFESSIONAL
APPS DBA LEADERSHIP
CORE DBA COMMUNICATION
RAC
TEAM WORK
TROUBLESHOOING
U TING
T PGRADE & MIGRATE
PERSONAL DETAILS
DATE OF BIRTH AUGUST 28, 1981
SEX MALE
MARITAL STATUS Married
LANGUAGE KNOWN ENGLISH, HINDI & PUNJABI