Devarshi Joshi

Experience

• 

  Cognizant Technology Solutions

  Dec 2011 - May 2015

  Oracle Apps DBA

   Experience in Administering Oracle E-Business Suite 11.5.10, R, R12.1.3, Oracle Database 10gR2, 11g. Extensive experience in supporting and managing production instances and Oracle Applications environments of varied complexity. Extensive experience in troubleshooting Oracle Applications performance related issues, Concurrent manager issues. Cloning of Oracle Applications from Multi Node to Multi node, Multi Node to Single Node from Production to Test/Dev instances. Worked on monitoring and troubleshooting of Apache, Forms, Concurrent manager servers, Networking and database related issues. Extensive experience in working with adutilities: adctrl, autoconfig, adpatch, adadmin, etc. Experience in Patching, Cloning, and Monitoring of Oracle Applications on regular basis. Working with Oracle Support, Analysis and management of Oracle problems/defects using SRs and or Metalink with Oracle Corporation and installation of patches. Various sysadmin functions like administer concurrent managers, defining users, request sets and submitting requests. Hands on experience on Kintana a package migration tool which guarantees version complaisance and clearcase server used for file migration. Writing automated crons on unix servers to automate mount point monitoring and clearing. I wrote cronjobs for prod/non prod environment in Unix(HP UX/IBM AIX). Monitoring server alerts and taking care of critical alerts/ communicating with relevant teams to take care of alerts. Closely interacting with customer on the execution plans, schedules and quick turnarounds. Performed overall health checks on the Database/Applications at regular intervals to ensure smooth operation. Handling day-to-day problems with high level of interaction with users through phone/email. Solving the user problems and migration of Changes to Test and Production using Incidents and Change Control’s. Show less

• 

  Infosys

  May 2015 - now

  Senior Oracle core and Apps DBA

   Maintained and troubleshoot several issues occurred to client in 12.1.3. Applying Patches on DB & Applications using OPatch & adpatch. Cloning/Refresh of test instances from production (application & database). Patching Activities like CPU, DB and Application patches. Logging SR and coordination with oracle support for bugs and patches. Troubleshooting Performance issue on Concurrent requests. Monitoring the Concurrent Manager & troubleshooting problems, viewing the log/out files for resolved the issues of concurrent requests. Troubleshooting the Application System which includes login problems, and regenerating application components and file system (forms, reports, menus and jar files) relinking executables and database problems. Day to day system activities ranging from DB & Application performance monitoring, OS health status Space management and maintenance at DB and OS levels. Monitoring all backups and troubleshooting on the failure backups. Built New Test, Development, SIT, UAT & Production Instances Monitoring tablespaces running short of free space, resizing or add datafiles Performed front end sysadmin activities like user management, profile management, configure managers, conc Requests, request groups etc Performing patch analysis and application of patches for resolving performance and bug issues. Worked on dB link issues.  Database error monitoring Managing Concurrent Processing/Managers Well versed in all AD utilities Monitoring Database and troubleshooting performance issue through OEM . Worked on Code migration as per Cummins Process.  Worked on Demantra Rebuilt activities over weekend. Show less

• 

  Emerson

  Jul 2019 - now

  Lead Engineer Oracle dba