Praveenkumar Kumar

Experience

• 

  Wipro

  Jan 2011 - Aug 2011

  Trainee

  Underwent 1 month of Core DBA training from July 2011 to Aug 2011.Underwent 6 months of training from Feb 2011 to June 2011. Training consisted of below : Oracle SQL Oracle PL/SQLOracle FormsOracle ReportsSupply Chain Management Functional Training (Oracle E-business Suite)Unix Shell ScriptingOracle Apps Technical

• 

  Wipro

  Oct 2011 - now

  • Upgraded and migrated E-Business application database from 11g on Solaris to 19c on Linux.• Designed and architected tech plan for procurement of new servers for the 19c upgrade of more than 80 databases. • Lead Oracle Applications DBA for a production 6TB FIN&Procurement instance.• Upgraded E-Business Suite application from 12.1.3 to 12.2.6 single-handedly with the minimum possible downtime.• Upgraded various databases from 11g to 12c.• Upgraded EBS 12.2.8 vision instance from 12c to 19c on Oracle Cloud Infrastructure• Handled performance monitoring and troubleshooting of Production Oracle E-Business Suite, Databases, Oracle Application Server, Concurrent Manager, Forms Server, and Report Server.• Established new databases and provided support for production and development databases.• Performed application installation, performance and memory tuning, server and database monitoring, configuration, and troubleshooting.• Evaluated server and instance architecture, hardware, system specifications, and capacity planning.• Supported multiple clients with various oracle Application releases, RAC and Non RAC Databases on 11g with Application releases 12.1 and 12.2• Implemented the Shared APPL_TOP on the Application Tier, Load Balancing, Failover, Parallel Concurrent Processing (PCP), DMZ and external access to the self-service nodes.• Prepared an efficient cloning strategy to clone EBS database/application based on the server capacity and client needs.• Configured TDE for EBS databases using tablespace encryption method.• Involved in DR Exercise for multiple accounts, also in real time DR scenarios. Met the RTO and RPO in every DR exercise so far.• Improved the efficiency of cloning by more than 50% by parallelizing possible things such as FTP, rman restore. Created scripts to automate the FTP and cloning.• Automated various process that are frequent, day-to-day tasks and that are standard in nature.• Configured Workflow IMAP and SMTP for Procurement. Show less • Lead Oracle Applications DBA for a production 6TB FIN&Procurement instance.• Upgraded E-Business Suite application from 12.1.3 to 12.2.6 single-handedly with the minimum possible downtime.• Upgraded various databases from 11g to 12c.• Upgraded EBS 12.2.8 vision instance from 12c to 19c on Oracle Cloud Infrastructure• Handled performance monitoring and troubleshooting of Production Oracle E-Business Suite, Databases, Oracle Application Server, Concurrent Manager, Forms Server, and Report Server.• Established new databases and provided support for production and development databases.• Performed application installation, performance and memory tuning, server and database monitoring, configuration, and troubleshooting.• Evaluated server and instance architecture, hardware, system specifications, and capacity planning.• Supported multiple clients with various oracle Application releases, RAC and Non RAC Databases on 11g with Application releases 12.1 and 12.2• Implemented the Shared APPL_TOP on the Application Tier, Load Balancing, Failover, Parallel Concurrent Processing (PCP), DMZ and external access to the self-service nodes.• Prepared an efficient cloning strategy to clone EBS database/application based on the server capacity and client needs.• Configured TDE for EBS databases using tablespace encryption method.• Involved in DR Exercise for multiple accounts, also in real time DR scenarios. Met the RTO and RPO in every DR exercise so far.• Improved the efficiency of cloning by more than 50% by parallelizing possible things such as FTP, rman restore. Created scripts to automate the FTP and cloning.• Automated various process that are frequent, day-to-day tasks and that are standard in nature.• Configured Workflow IMAP and SMTP for Procurement.• Setup TLS configuration for the EBS application, configured punchouts for procurement from external vendors.• Setup DMZ for iSupplier. Show less

  • Lead Consultant

    Jun 2021 - now

  • Senior Database Administrator

    Oct 2011 - May 2021