Mukesh Payghan

Experience

• 

  Capgemini

  Sept 2007 - Mar 2012

  Consultant Oracle DBA

  • Refresh non production database from production database using Hot backup or cold backup• Database and Application tuning to limited Scope such as Analyzing AWR or Stats pack report Query Tuning (using explain plan, ADDM report etc )• Gathering Statistics, Compression of table partitions within Oracle 10gR2.• Shrinking tables in production as per segment advisory reports • Knowledge about RMAN, Datapump , SQL loader • Solving tickets for Baxter Applications on daily basis• Performed activities such as enabling auditing in databases. User managements and other Core DBA activities. • Monitoring alerts (Availability alerts, Tablespace Alerts, Hung Query or Lock related alerts, jobs related alert, backup or refresh failure alerts etc)• Maintaining RAC databases.• Communicating with clients • Solving users queries • Documenting the new processes Show less

• 

  Infosys

  Apr 2012 - Jul 2012

  Technology Analyst

  Worked on Exadata X2

• 

  Capgemini

  Jul 2012 - May 2014

  EXADATA Oracle DBA total 6.6+

  • I have around 6.6 years of experience as ORACLE DBA • I have around 1.7 year of experience in EXADATA Machine Administration• I am Oracle EXADATA Certified • I know Unix shell scripting and windows batch scripting, written many scripts to automate the tasks • I have around 1 year of experience on Nimbus Administration for my project • I have worked on UNIX in Oracle Database using all the utility provided by ORACLE like Data pump etc.* Exadata database bundle patch upgrade • Working with cellci/dcli & cell server configuration • knowledge of OEL , Infiniband Network Switches, cell & grid disk storage. • Attended 5 days Oracle Workshop on Exadata machine administration.• Exadata monitoring and maintenance • RAC databases monitoring and maintenance Show less

• 

  Cognizant Technology Solutions

  May 2014 - May 2016

  Associate Operation Manager
• 

  Tech Mahindra

  Apr 2016 - Sept 2018

  Lead DBA ,Exadata

  Oracle Exadata DMA having 6.5 Years of experience & total 11 years of experience.

• 

  Vodafone

  Sept 2018 - Jul 2021

  DBA Manager

  Oracle Exadata DMA Manager having total 14 years of experience.

• 

  Oracle

  Aug 2021 - now

  Principal Member of Technical Staff

  • Architecting and implementing OS patching and software upgrades for regional OCI components, ensuring a secure and current infrastructure.• Spearheading the installation of new Exadata Machines at customer sites, meticulously debugged installation processes, and rigorously validated infrastructure before customer turnover.• Innovating the system by expanding the functionality of the exaccauto.sh script, enhancing connectivity within the OCI infrastructure.• Maintaining and resolving KVM Guest issues and orchestrating solutions for Exadata Infrastructure nodes' hardware and software challenges.• Safeguarding KVM Guest backups, ensuring they are up-to-date, accurate, and accessible for swift restoration, and promptly rectifying any file system corruptions in Guest VMs.• Investigating and rectifying faulty hardware in Exadata infrastructures, initiating and overseeing hardware service requests, and collaborating with field engineers for expedient hardware replacements.• Directing and facilitating the shutdown and startup of various Exadata infrastructure components during datacenter maintenance operations.• Testing infrastructure patches pre-release, orchestrating and executing quarterly infrastructure maintenance, and adeptly handling patching-related issues.• Analysing OCI workflows critically to detect bugs and operational gaps and proactively propose enhancements for future code implementations.• Composing and continuously refining OCI documentation, issue logs, and operational procedures, utilising tools such as Confluence, Jira, and bug databases.• Strategizing and keeping abreast with software updates for control plane servers, ensuring deployment of the latest versions across all regions and infrastructures. Show less