PIyush Prakkash

Apps DBA | Cloud Support:

​

Oracle Database:

Installation and Upgradation of Oracle Database of different version 10g, 11g and 12c
Upgraded database from 10g to 11g, 11.2.0.3 to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2
Expertise in RAC database, Cluster Services and Grid
Database Patches ( Critical Patch Update , Patch Set Updates and regular database patches)
RMAN backup strategy in Database (Arch or Full backup)
Analyse DB performance using AWR Report, ADDM Report, Oswathcher logs and fix the performance glitch

Oracle EBS Application :-

Expertise in Installation of Oracle EBS 11i, 12.1.3, 12.2 Version
Specialist in Upgrading the EBS from 11i to 12.1.3 and from 12.1.3 from EBS 12.2.4
Implemented different version of AD and TXK Delta upgrade. From version Delta 5 to Delta 8 and to Delta 10
Extensive knowledge of adop cycle ( Apply, cutover, finalize, fsclone , cleanup)
Perform application tuning
Cloning on multi node of EBS application in different version of EBS (11i, 12.1.3, 12.2.4 )
Expertise in OAM, OIM, OID and SSO Configuration

VCP (ASCP) & Demantra:-

Expertise in Oracle VCP Application v 12.2.4
Integration between Oracle EBS and Oracle VCP
Setup of Oracle VCP and Demantra along with Oracle EBS
Installation,Patching & Cloning

Endeca

Expertise in Oracle Endeca Products 7.5.1
Implementation of different data domains in Endeca
Troubleshooting in Domain ETL Load in Endeca
Backup, export, drop and re-import data domain

Delphix

Specialist in Delphix tool which help to clone or create a new Virtual Database
Delphix tool creates and clone DB of 15TB of data in less than 2 hours

OEM :-

Specialist in OEM 12c and 13c
Implement OEM with Oracle Database
Maintain & monitor different databases in OEM
AWR, ADDM, SQL Tuning using OEM
Expertise in Data Mask Activity using OEM
Masked the sensitive data using Oracle Application Data Model and Oracle Data Definition

Expertise in Oracle Vertex 7.0 Product
Tax Rate Update expertise using Vertex

​​