Prasanth C Email & Phone Number

Over 14+ years of IT experience as an Oracle DBA on a variety of UNIX (Solaris, Linux,AIX), Windows platforms with Oracle 9i/10g/11g/12c. Currently working on Linux, SunOS,AIX.Significant experience in Banking, Insurance and Manufacturing applications.Experience in implementing and managing high availability features like Real Application Clusters (RAC), Data Guard, Streams and worked extensively in OLTP and OLAP environment under Sun Solaris, Oracle Enterprise Linux and Red Hat Linux.Extensive experience in supporting very large and mission critical Oracle databases size over 15+ TB.Installation, Configuration and Administration of Oracle10g/11g RAC.Over 5+ years of experience on RAC database administration.Good experience in administrating Data Guard using Data Guard Broker.Used EXPDP/IMPDP (Data pump) to full export backup and also to accomplish table level and full database de-fragmentation.Creating tablespaces and planning the location of data, index, undo tablespaces & redo log files and control files.Proficient in SQL, Query/application tuning using optimizer hints, Explain plan, SQL trace.Used STATSPACK (Oracle 9i)/AWR for Database Monitoring and Database Performance.Created table partitions to improve performance and data management.Experience with managing undo tablespaces to avoid “Snapshot too old” error.Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently. Experienced in designing, developing, scheduling and monitoring UNIX shell scripts to administer all the environments.Extensive use of Crontab in UNIX environment for scheduling routine tasks.Extensively involved in Database Cloning manually as well as using RMAN.Configuration of Oracle Enterprise Manager 12c (OEM) to monitor database and report on events as defined by the DBA group.Installed and configured oracle agent 12c for database monitoring and incident reporting.