Amit Kumar Baranwal

Experience

• 

  Hi10 solption

  Apr 2009 - Sept 2010

  Technical support

   work with customers to understand requirements, document the required configuration, and implement that configuration monitoring the database & listener monitoring alert log file and backup log file provide first level it support to the users email support like ms outlook & outlook express sql query tuning

• 

  Iware logic technologies pvt. ltd.

  Dec 2010 - Oct 2013

  Oracle apps database administrator

   handling and creating sr. hands on patching in application and os level. hands on exp. in cloning, data refresh. transforming the database from rollback to undo, resolving prominent errors like ora-01555. managing oracle databases of more than 700 gb monitoring and managing data files, undo segments, other segments and extents. monitoring cold, hot backup scripts of the databases supporting different applications. installation of discoverer. performed database reorganization (reorg) regularly for removing row migrations and fragmentation using export (exp) and import (imp) utilities. taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc. resolving performance issues in team interactions installed oracle 10.2.0(10g)/apps11i/r12/asm on linux, solaris and created customized database. expertise in performing cloning the database using rman, cold/hot backup manually. upgrading database from 10g to 11g. monitoring table spaces for space usage and adding required space whenever it reaches threshold and also monitoring alert log file for errors performed database reorganization (reorg) regularly for removing row migrations and fragmentation using export (exp) and import (imp) utilities. taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc. resolving performance issues in team interactions. incorporating performance measurement tool like tkprof and review tool explain plan. installed oracle 9.2.0 (9i)/10.2.0(10g)/11g on linux and created customized database. expertise in performing cloning the database using rman, cold/hot backup manually. show less

• 

  Tech mahindra

  Oct 2013 - Aug 2016

  Senior database administrator

  oracle apps dba- administering the database security, creating users, granting roles, privileges to users, extending the database storage capacity and optimizing the performances.  handling and creating sr. hands on patching in application and os level. hands on exp. in cloning, data refresh. hands on exp. in database11g migration oel 32 bit to 64 bit oel . transforming the database from rollback to undo, resolving prominent errors like ora-01555. managing oracle databases of more than 700 gb data movement from one tablespace to another tablespace monitoring and managing data files, undo segments, other segments and extents. monitoring hot backup through rman scripts of the databases supporting different applications. taking care of table space related issues like increasing the storage parameter values, resizing the data files, adding new data files etc. maintenance 11g rac database and provide support. apply opatch on rac database as well as standalone database. maintenance and provide support on standby database. resolving performance issues in team interactions. incorporating performance measurement tool like tkprof and review tool explain plan. installed oracle 11.2.0(11g)/apps11i/r12 on linux, solaris and created customized database. expertise in performing cloning the database using rman, cold/hot backup manually. upgraded application 12.0.4 to 12.1.3. upgraded database from 11.2.0.1 to 11.2.0.4 export import have done on database like table,schema etc. monitoring table spaces for space usage and adding required space whenever it reaches threshold and also monitoring alert log file for errors. show less

• 

  Navisite

  Aug 2016 - Jul 2018

  Consultant

  oracle apps dba :-  good knowledge on using datapump and physical backup's like cold and hot backup, restore and recovery at different scenarios. expertise in migration of tablespaces, schemas and huge data across the environments using datapump. expertise in rman backup and recovery, developed weekly strategy for rman incremental backups and weekly tape backups.extensive experience in refreshing core db instance using rman backups. expertise in oracle e-business suite, administering shared appl top parallel concurrent processing . familiar with discoverer, workflow configurations, forms and reports.troubleshooting concurrent manager, apache and discoverer issues. experience on upgradation, maintenance of oracle apps r12.2. expertise in cloning, patching using adop in 12.2 ability to work with and listen to customers/users. capable of self-learning to explore technically. ability to interact with end users, self-motivated, quick learner and team player with good communication skills. performing database/schema level refreshes using expdp/impdp and rman. automated the process of daily schema level refresh from production db to replica db. involved in weekly based refreshes sometimes as requested by customer .refreshes which includes multi node to single node, multi node to multi node, single node to single node, single node to multi node, rac to non-rac, non-rac to rac registered different types of printers and customized the style and drivers to troubleshoot the printing issues for oracle application reports. resolved various problems that occurred while re-linking the application executables and generating report files. done upgradation of jdk and jar file in 11.5.10 and 12.1.3 . providing support and maintenance of dataguard , and done critical recovery .  good exposure of using oracle performance tools like awr/addm, statspack, explain plan, tkprof, sql trace, opatch, exp/imp, expdp/impdp, analyze tables and indexes. show less

• 

  Pathfinder Group

  Aug 2018 - Jul 2019

  Senior oracle database administrator
• 

  LTIMindtree

  Jul 2019 - now

  Dba manager