Pradeep Routra

18 years of experience as Sr. Principal.Oracle DBA/Database Project Manager including Implementaiton and 24X7 on call production support using Oracle 19C /12C/10gR2/11g RAC Grid Infrastructure and and High availability Projects along with Oracle cloud Infrastructure (OCI) Managing various database projects ADP US/IDC team that include Production to Test Refresh , Provisioning , Patching , DB Move ( Cross-Region , Cross-Realm , Intra-Cluster , Inter- Cluster) ,DR rebuilt Scale out,DB Reorg, Storage expansion , Capacity planning , Backup /Recovery , ADP agent updates , Database Patching , Grid Infrastructure, 10 Node /12 Node RAC/X-10 implementation Oracle 19C/CRS/ASM, on RAC Environment, EXADATA , OCI ,Fusion Application on Sass . Standby Database implementation Oracle Data Guard, set-up failover and resynchronization using RMAN. Third party Database Replication tools Shareplex/Goldengate using Oracle 10gR2 and 19C. Installation and Configuration of FMW SOA/B2B and IDM on RAC environment . Installation and configuration of Oracle 19C with 8 RAC Node . Single node and Multinode Installation of Oracle E-bisuness suite using shared APPL_TOP /CUSTOM_TOP Concepet. Single Node,Multi node Oracle Application Cloning using Rapid clone technology . Applying Oracle Application patches bug fixing,Security Patches, Minipacks, Familypacks, Maintenance packs patches. Administering multiple instances of Oracle Apps 11.5.10.2 TAR Resolution for bugs reported, OWC. Oracle Applications and Database performance tuning. Working with third party utilities like Shareplex,Noetix and Vertex and Kintana. Database Upgradation 8.1.7.4 to 9.2.0.6. Database Upgradation 9.2.0.6 to 10gR2. Database upgaradtion from 10.2.0.4 to 10.2.0.5 ,11g. Resolving On-Call issues on Database, and Oracle Applications within SLA. Handling backup and recovery issues. Scheduled hotbackup sync-split and cold backups sync-split using Using BCV and EMC Timefinder. Worked with Loadbalancer(Cisco,F5 Big IP) . Setup Oracle Application Webservers multinode enviroment. Database cloning from hotbackup and cold backup. Database monitoring and Tablespace monitoring. Worked on Oracle Application maintenance Failover and failback Server with veritas cluster. Worked on Snapshots, Database links and materialized views. Worked on Unix/Perl shell scripting. Oracle Recovery Manager (RMAN) integration with TSM. Worked in SLA, Escalation plan, Root cause Analysis, Incident report etc. Handling Database alerts from Production Server. Co-ordination with Client and planning for delivery. Installation and configuration Oracle E-business suite 11.5.10.2 on IBM-AIX , Linux . Installation and configuration of 10gR2 RAC ,ASM,Oracle E-business suite 11.5.10.2 Production Support Oracle E-business suite 11.5.10.2 /10gR2/RAC on Linux . Production Support 24X7 ,Oracle Database/FMW and E-Business suite . High Availbility Enviromnet RAC,Standby Database setup using Dataguard

• Oracle 11g RAC and Grid Infrastructure Administration, Oracle
• Oracle GoldenGate using 11g, Oracle
• ITIL V3 Foundation, Oracle
• Advance Business Communication, Oracle USA Inc.
• Team Building, General Electric

Worked as DBA Architect  during  Chicago DC govt cloud DC built and setup Database and Fusion Application .