Praveenkumar Kumar

Praveenkumar Kumar

Trainee

Followers of Praveenkumar Kumar44 followers
location of Praveenkumar KumarChennai, Tamil Nadu, India

Connect with Praveenkumar Kumar to Send Message

Connect

Connect with Praveenkumar Kumar to Send Message

Connect
  • Timeline

  • About me

    Oracle Apps DBA | E-business suite | Fusion middleware | Oracle cloud data management specialist

  • Education

    • Panimalar Institute Of Management Studies And Computer Science

      2007 - 2010
      Master of Computer Applications - MCA Computer Programming, Specific Applications
  • 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
  • Licenses & Certifications

    • Oracle Cloud Platform Data Management 2020 Certified Specialist

      Oracle
      Apr 2021
      View certificate certificate