Amit Kulkarni

About Amit Kulkarni

Experience with Oracle 12c/11g/10g Installation, Administration, Monitoring, Database Backup 4.8 years of IT Professional experience,with good knowledge of database administration and installation of Oracle 9i, 10g and 11g (11.2.0.1 and 11.2.0.2) on Solaris and Linux platforms.• Acquired proficiency in technical skills like RMAN, Expdp/Exp, Impdp/Imp, OEM, RAC, Performance tuning, Dataguard, Shell Scripting and SQL, PL/SQL.• Proficient in Shell scripting. Expert on DBA daily activities to include schema, user management (creating users, synonyms, privileges, roles, quotas, tables, index, sequence, etc.); space management (tablespace and roll-back segment), monitoring (alert log, memory, disk I/O, CPU, and database connectivity), scheduling jobs, and UNIX Shell scripting Expert on monitoring the performance and tuning of UNIX Servers using TOP, PRSTAT, VMSTAT, IOSTAT, NETSTAT, GLANCE, TOPAS, NMOM, and SAR• Energetic and self-motivated team player/ builder.•Configured and built disaster recovery environment by implementing physical standby database • Performance tunes custom interfaces and conversion programs to meet business objectives. Tuning involved using 10046 level traces, AWR report, ADDM and statspack report analysis to reduce wait times etc.• Expert with different Backup and Recovery strategies, Cloning (using Recovery Manager - RMAN), creating RMAN scripts, Export / Import, DataPump, TTS, and Hot and Cold back-ups

Experience

1. Software Engineer

   Oracle

   Mar 2013 — Present · Bengaluru, IN

   Part of Database memory manageability Team at Oracle Support, supporting Oracle\'s global customers using Oracle Database (RDBMS) products.This included issues related to core RDBMS, Database Hang,ASM and Performance Tuning issue.Troubleshooting Performance issues related to plan stability,instance tuning and sql query rewriteSGA auto tuning, Fine tuning the SGA, Automatic memory management (AMM), automatic shared memory management (ASMM), fragmentation, bugs, leaks, manual tuning of auto tuned parameters.Troubleshooting by Analyzing heapdump, systemstate dump, awr reports, OS watcher, and diagnostic script.Export Import, Datapump troubleshooting, datapump performance improvement.Troubleshooting Sql loader, logminer.Participate Oracle Internal Forum for assisting other support engineers on Memory (ORA-4030/ORA-4031) issues

Education

• BVB Engineering College

  BE

  2005 — 2009

Skills

• High Availability
• Performance Tuning
• Unix Shell Scripting
• Pl/Sql
• Capacity Planning
• Oracle Sql/Psql
• Shell Scripting
• Sybase Adaptive Server
• Perl
• Database Administration
• Sql*Plus
• Oracle Rac
• Oracle
• Unix
• Itil V3 Foundations Certified
• Databases
• Goldengate
• Solaris
• Rman
• Data Guard
• Sql
• Linux