M. Dinesh Sundar

About M. Dinesh Sundar

Having 10+ years of IT experience in Oracle Database Administration and Oracle Application providing 24/7 support for Production and Development of 10g,11g,12c & 19c databases and R12.1.3 and R12.2.4 Application Versions, On different versions of Linux (RHEL,OEL) and sun Solaris.* Software Installations/upgrades: Installed the Oracle Software on various Unix flavours (Linux and Sun Solaris Servers), as well as windows Servers. Additionally upgraded the databases from lower to higher versions like 11g to 12c/18c/19c & 12c to 19c using DBUA including RAC configuration (Single Node & Multi node).Sound Knowledge on Database upgrade using Autoupgrade Method.* Data guard: Posses extensively hand on in configuration and managing of Physical/Active Data Guard/Switchover/Rolling Forward Databases for Disaster Recovery (DR) site* Having good experience on taking export backups using EXPDP and import using IMPDP.* Good Experience on writing shell script for monitoring mount point, RMAN Backups, Duplicate Datafiles etc and schedule in the crontab for automatic run * Performance Optimization: Proficient in enhancing performance, identifying, and addressing database slowdowns, fine-tuning SQL queries, boosting query performance through the utilization of SQL hints, managing blocking, and locking sessions, and handling wait events. Skilled in resolving all performance bottlenecks and optimizing resource usage, including memory and CPU, to achieve optimal system performance.* Having good experience in upgradation and migration of Oracle databases from 12C to 19C versions using DBUA and Autoupgrade method.* Having good experience on oracle database backup and recovery technologies through various methods like ZDLRA,Cohesity,RMAN, cold, hot and EXPDP & IMPDP* Proficient in troubleshooting all oracle database related errors and immediate response to the database alerts* Monitoring Tool: Having hand on experience on OEM cloud control 12c and 13c * Good Experience and understanding of UNIX and Linux operating system commands.* Migration: Good knowledge on same & cross platform database migration using data pump, RMAN and transportable tablespace.* Golden gate: good understanding oracle golden gate unidirectional and bi-directional.* Patching: Extensively hand on oracle database, Grid, OEM Cloud Control Quarterly PSU, CPU and Oracle Apps R12 patching.

Experience

1. Assistant Consultant

   Tata Consultancy Services

   Aug 2024 — Present · Bengaluru, IN

Education

• Sri Vidyalam Mat.HR.Sec.School

  Intermediate, Mathematics and Computer Science

  2006 — 2008

• Vinayaka mission kirupanada enggnerring college

  Bachelor of Engineering (B.E.), Information Technology

  2008 — 2012

Skills

• Html
• Public Speaking
• Photoshop
• Microsoft Word
• Powerpoint
• Microsoft Excel
• Java
• Teamwork
• Social Media
• English
• Microsoft Office
• Oracle Certified Dba
• Research
• Customer Service
• C++
• C