Senior Manager - Database Engineering
CurrentLeading devOps & DBA team of experienced Engineers at ADP India. Primary responsibilities includes maintenance of EBS Applications of size over 60 TB with modules like OTC, Oracle Financials, Incentive compensations and Mobile Apps. Major responsibilities includes:• Production support of Oracle EBS applications R12.X with a database of over 60TB• EBS DB upgrades from 11g to 12c and then to 19c (19.3,19.8,19.10 and 19.11)• DB UTL_FILE migration to DB 19c• Successful EBS upgrades R12.1.3 to R12.2.10• Maintenance of 12 DEV/QA instances with the same database size.• Implementation of Oracle iReceivables using DMZ for external users• Application of quarterly security patches, including Application of Oracle Critical Patch Upgrades (CPUs) and PSUs.• Implementation of table compression to reduce the size• Re-Org of Oracle ERP/non-ERP databases • Implementation of SOA Gateway and integrated with the EBS rel 12.2• Oracle APEX upgrades from 5.1 to 18.2 and later 21.2• Automation of code release using Ansible and Jenkins• Event Driven automation tool to self heal the incidents• Handling all the infrastructure configuration changes as per the requirements