Priyadarshan Suke
Contact-095********
E-mail: *******@*****.***
ORACLE APPS DBA
SUMMARY :
. 5 Years of total IT experience.
. 5 Years of Experience as Oracle Apps DBA.
. Experience in Installation of Oracle Apps 11.5.10.2/12.0.0/12.1.1 on
Linux platforms.
. Experience in Upgradation of Oracle Apps 12.0.0 to 12.0.2 on Linux
platforms.
. Experience in Upgradation of Oracle Database 11.1.0.6 to 11.1.0.7 on
Linux x86-64.
. Experience in Oracle 10.1.2 Discoverer Installation & Integration with
Oracle EBS 11.5.10.2.
. Configuring workflow notification mailer in 12.1.1.
. Experience in Cloning on Linux platform using Rapidclone.
. Experience in Patching on Linux platform.
. Experience in Installation of Oracle 10.2.0.1 on RHEL4 platforms.
. Experience in Installation of Oracle 11gR2 on RHEL4 32 bit.
. Experience in Installation of Oracle Enterprises Manager on Windows XP
platforms.
. Experience in Hot/Cold backup/Restore.
. Experience in Troubleshooting of Oracle Apps 11.5.10.2/12.0.0/12.1.1
on Linux platforms.
. Experience in Troubleshooting of Oracle 9.2.0.3/10.2.0.2/11.1.0.6
. Experience in using Data Protector and Oracle Secure Backup (OSB) tools
for backup and restore.
. Providing 24x7 supports for Oracle Application 11.5.10.2/12.0.4/12.1.1.
. Experience in supports for Oracle Database 10.2.0.2 RAC.
EDUCATION :
B.E. in Mechanical Engineering with first class in 2004 year from Nagpur
University, Maharashtra.
TECHNICAL SKILLS :
Oracle Apps Versions 11.5.7, 11.5.9, 11.5.10.2, 12.0.2, 12.0.4, 12.1.1
Database Tools Oracle Enterprise Manager, RMAN, SQL*Plus, Toad 8.3,
Putty, Secure CRT.
Databases: Oracle 8.1.7.3/ 9.2.0.6 /
10.2.0.2/10.2.0.4/11.1.0.6/11.1.0.7
Middleware Oracle AS 10g R2
Life Cycle Expertise Application Administration, Database Administration,
Tuning, Support & Implementation.
Language C, C++, PL/SQL
OS/Environment RHEL, HP UX, IBM AIX 5.3.
Current Employment Details :
Titan Technology Partner India Pvt. Ltd. Pune from September 2007 to
August 2010.
Previous Employment Details :
Infogain Systems Pvt. Ltd. (previously Spider Systems India Pvt. Ltd.)
Pune from July 2005 to September 2007
Priyadarshan Suke
Cell-095********
E-mail: *******@*****.***
PROFESSIONAL EXPERIENCE :
PROJECT DETAILS :
Project Name TTP Technology India Pvt. Ltd.
1. Client Ingram Digital Group (US).
Project Customer has a Oracle Financials, HRMS 12.0.4
Description setup on Linux 4.0
Oracle Apps Health Checks for 12.0.4 on Linux
platform.
Created users, menu, and responsibilities.
Space management, troubleshooting, Monitoring.
Running Gathered schema Statistics programs for
different schema's for performance improvement.
Application cloning on single-node systems using
Rapidclone.
Changing Apps, Sysadmin and Oracle user's password
using FNDCPASS utility.
Patched 12.0.2 Single-node installation on RHEL4.
Backup using Manual method, Export/Import and
RMAN.
Regular Monitoring Alert Files on Day to Day Basis
Generating Performance and Tuning reports on
Oracle 10.2.0.2.
Assisted in restoration and recovery of data with
Oracle 10.2.0.2.
Creating Database Links.
Created users for development purpose and granted
privileges.
Experience in Database Refresh.
Experience in using ad utility.
Troubleshooting Apache and Forms related issues.
Adding and Resizing datafile for performance.
Experience in DataInstall.
Experience in applying hrglobal patch.
2. Client Colonial Bank Group (US)
Project Customer has a Oracle HRMS 11.5.10.2 setup on
Description Linux 4.0
Oracle Apps Health Checks for 11.5.10.2 on RHEL4.
Created users, menu, and responsibilities.
Space management, troubleshooting, Monitoring.
Running Gathered schema Statistics programs for
different schema's for performance improvement.
Application cloning on dual-node systems using
Rapidclone.
Changing Apps, Sysadmin and Oracle user's password
using FNDCPASS utility.
Patched 11.5.10.2 Dual-node and DMZ-node
installation on RHEL 4.0.
Backup using Manual method, Export/Import and
RMAN.
Backup/Restore using Oracle Secure Backup.
Regular Monitoring Alert Files on Day to Day Basis
Generating Performance and Tuning reports on
Oracle 10.2.0.2.
Assisted in restoration and recovery of data with
Oracle 10.2.0.2.
Creating Database Links.
Experience in Workflow Notification.
Changed DBID and DBNAME using nid utility.
Experience in Quantum Vertex Update.
Applied Database patch using Opatch utility.
Created users for development purpose and granted
privileges.
Experience in Database Refresh.
Experience in using ad utility.
Troubleshooting Apache and Forms related issues.
Printer setup for Oracle Application 11.5.10.2.
Optimizing the SQL's for maximum performance by
using TKPROF and EXPLAIN PLAN.
Adding and Resizing datafile for performance.
Experience in applying hrglobal patch.
Experience in handling SEV 1 issues.
Applied CPU patches for 11.5.10.2 Dual-node
Installations.
3. Client Advanced Drainage System (US).
Project Customer has a Oracle Application 11.5.10.2 setup
Description on Linux
Oracle Apps Health Checks for 11.5.10.2 on RHEL4.
Created users, menu, and responsibilities.
Space management, troubleshooting, Monitoring.
Running Gathered schema Statistics programs for
different schema's for performance improvement.
Application cloning on dual-node systems using
Rapidclone.
Changing Apps, Sysadmin and Oracle user's password
using FNDCPASS utility.
Patched 11.5.10.2 Dual-node and DMZ-node
installation on RHEL 4.0.
Backup using Manual method, Export/Import and
RMAN.
Backup/Restore using Data Protector.
Migrations using STAD utility.
Regular Monitoring Alert Files on Day to Day Basis
Generating Performance and Tuning reports on
Oracle 10.2.0.4.
Assisted in restoration and recovery of data with
Oracle 10.2.0.4.
Experience in workflow notification mailer setup
in oracle apps for 12.1.1.
Experience in Quantum Vertex Update.
Applied Database patch using Opatch utility.
Created users for development purpose and granted
privileges.
Experience in Installation of 12.1.1 on RHEL5.
Experience in using ad utility.
Patched 11.5.10.2 Single-Node and Dual-node
installation on RHEL 4.0.
Troubleshooting Apache and Forms related issues.
Printer setup for Oracle Application 12.1.1.
Optimizing the SQL's for maximum performance by
using TKPROF and EXPLAIN PLAN.
Analyze the tables and rebuild the indexes
whenever needed to improve the performance of the
reports.
Adding and Resizing datafile for performance.
Experience in TechStack upgrade to JRK6 and
Developer patchset 19.
Experience in applying hrglobal patch.
Experience in implementing DMZ on 12.1.1.
Experience in implementing shared APPL_TOP on
12.1.1.
Experience in implementing Parallel Concurrent
Processing (PCP) on 11.5.10.2/12.1.1.
5. Client Alpha Media Group (US)
Project Customer has a Oracle Financials, HRMS 12.0.4
Description setup on Linux 4.0
Oracle Apps Health Checks for 12.0.4 on Linux
platform.
Created users, menu, and responsibilities.
Space management, troubleshooting, Monitoring.
Running Gathered schema Statistics programs for
different schema's for performance improvement.
Changing Apps, Sysadmin and Oracle user's password
using FNDCPASS utility.
Backup using Manual method, Export/Import and
RMAN.
Regular Monitoring Alert Files on Day to Day Basis
Generating Performance and Tuning reports on
Oracle 10.2.0.4.
Assisted in restoration and recovery of data with
Oracle 10.2.0.4.
Cloned 12.0.2 on single-node systems using
Rapidclone.
Experience in using ad utility.
Patched 12.0.2 Single-Node installation on RHEL
4.0.
Experience in Installation of Oracle 11gR2 on
RHEL4 32 bit.
Troubleshooting Apache and Forms related issues.
Adding and Resizing datafile for performance.
6. Client Albemarle (US)
Project Customer has a Oracle Financials, HRMS 12.1.1
Description setup on RHEL5.
Oracle Apps Health Checks for 12.1.1 on Linux
platform.
Created users, menu, and responsibilities.
Space management, troubleshooting, Monitoring.
Running Gathered schema Statistics programs for
different schema's for performance improvement.
Application cloning on dual-node systems using
Rapidclone.
Changing Apps, Sysadmin and Oracle user's password
using FNDCPASS utility.
Patched 12.1.1 Dual-node and DMZ-node installation
on RHEL5.
Backup using Manual method, Export/Import and
RMAN.
Regular Monitoring Alert Files on Day to Day Basis
Creating Database Links.
Experience in configuring workflow notification.
Experience in Quantum Vertex Update.
Applied Database patch using Opatch utility.
Created users for development purpose and granted
privileges.
Cloned 12.1.1 on single/dual node systems using
Rapidclone.
Experience in using ad utility.
Patched 12.1.1 single/dual node installation on
RHEL5.
Creating and Rebuilding of indexes for
performance.
Troubleshooting Apache and Forms related issues.
Printer setup for Oracle Application 12.1.1.
Adding and Resizing datafile for performance.
Experience in applying hrglobal patch.
Experience in implementing DMZ on 12.1.1.
Experience in implementing Parallel Concurrent
Processing (PCP).
Project Name Infogain Systems Pvt. Ltd.
1. Client Tata Honeywell India.
Project Customer has a Oracle Financials, HRMS 11.5.10.2
Description setup on Linux.
Oracle Apps Health Checks for 11.5.10.2 on Linux
platform.
Space management, troubleshooting, Monitoring.
Running Gathered schema Statistics programs for
different schema's for performance improvement.
Application cloning on dual-node systems using
Rapidclone.
Changing Apps, Sysadmin and Oracle user's
password using FNDCPASS utility.
Patched 11.5.10.2 Dual-node and DMZ-node
installation on RHEL 4.0.
Backup using Manual method, Export/Import and
RMAN.
Regular Monitoring Alert Files on Day to Day
Basis
Generating Performance and Tuning reports on
Oracle 10.2.0.2.
Assisted in restoration and recovery of data
with Oracle 10.2.0.2.
Applied Database patch using Opatch utility.
Created users for development purpose and
granted privileges.
Experience in using ad utility.
Troubleshooting Apache and Forms related issues.
Adding and Resizing datafile for performance.
Experience in handling SEV 1 issues.
2. Client Gujarat Ambuja Cement India (Mumbai).
Project Database - RAC 10.2.0.2 on IBM AIX 5.3.
Description
PERSONAL PROFILE :
Date of Birth 10th Sep 1980
Sex Male
Nationality Indian
Marital Status Single
Hobbies Surfing Net, Reading Books, Listening music,
Travelling.
Passport No. J1107710 Date of Expiry:17/10/2020