Amit Kumar Bhatnagar Email & Phone Number

India

Gurgaon, Haryana, India

• Installation of Oracle9i/10g/11g/12c server and creation of database on linux/Windows/Sun Solaris. • Planning, Estimation of the size of the database and configuring the database.• Implement & maintain database security (create & maintain users & role, assign privileges).• Backup & recovery of database and database objects (Using Data Pump/exp-imp, Hot backup, Cold Backup, RMAN backups).• Monitor database for availability and performance optimization.• Resolving performance bottlenecks by using Sql Tuning & application tuning with the help of AWR reports & ADDM reports and Sql Automatic Tuning.• Configuration of Enterprise Manager Control Oracle13c databases for setup database monitoring and availability. • To build the new environment as per the requirement provided by requestors for the Dev/Testing by using sevrals backup/restore techniques i.e. (rman duplicate, export/import, hotbackup, cold backup, Rman duplicate, Rman active cloning).• Applied oracle PSU patches and upgrade oracle database server according the requirement (10g/11g/12c versions).• Written shell scripts for monitoring database, analyzing schema/objects, RMAN cloning, periodical backups, housekeeping trace and log files and scheduled them through unix crontab.• Troubleshooting & maintenance of database includes rebuilding indexes, tablespace sizing, renaming datafiles, redo sizing, analyzing schemas/objects, creation of core schemas, monitoring sessions, managing database users.• Proactive monitoring of system performance, file system storage using Unix utilities sar, vmstat, psstat, top and iostat etc. • Setup a digester recovery solution by using oracle physical standby setup.• Installation and troubleshooting oracle RAC of three nodes RAC database.• Configuring oracle services to maintain workload of client connection consumption and to optimize high performance.• Configured TAF to provide high availability to maintain business without any interruption.

Gurgaon, India

Noida Area, India

• Working as a shift lead where prime assurance is running delivery without any escalation/issue.• Handling critical issue severity1/2 calls.• Focus in order to proving RCA on problem tickets generated with reference of sev1/2 calls. • CPU and bug fix patching on all supported oracle version in order to resolve security vulnerability.• Analyze and resolve performance bottlenecks of database with the help of AWR reports & ADDM reports.• Monitor database for availability and performance optimization.• Resolving bottlenecks using Sql Tuning & application tuning.• Backup & recovery of database and database objects (Using 10g Data Pump/exp-imp, Hot backup, Cold Backup, RMAN backups).• Proactive monitoring of system performance, file system storage using Unix utilities sar, vmstat, psstat, top and iostat etc. • Installation of Oracle Agent and Configuration of Enterprise Manager Control of upgraded Oracle10g databases for monitoring and troubleshooting.

Bangalore

Responsibilities:• Installation of Oracle9i/10g/11g server and creation of database on several o/s. • Planning, Estimation of the size of the database and configuring the database.• Implement & maintain database security (create & maintain users & role, assign privileges).• Oracle Net Configuration on client machine for oracle database server.• Backup & recovery of database and database objects (Using 10g Data Pump/exp-imp, Hot backup, Cold Backup, RMAN backups).• Analyze and resolve performance bottlenecks of database with the help of AWR reports & ADDM reports.• To build the new environment as per the requirement provided by requestors for the Dev/Testing by using several backup/restore techniques i.e (rman, export/import, hotbackup, cold backup).• Applying oracle cpu/psu patches and upgrade oracle database server according the requirement (10g/11g versions).• Written shell scripts for monitoring database, analyzing schema/objects, RMAN cloning, periodical backups, hosekeeping trace and log files and scheduled them through unix crontab.• Troubleshooting & maintenance of database includes rebuilding indexes, tablespace sizing, renaming datafiles, redo sizing, analyzing schemas/objects, creation of core schemas, monitoring sessions, managing database users.• Tuning for I/O contention, memory contention, row migration and chaining etc.• Proactive monitoring of system performance, file system storage using Unix utilities glance, sar, vmstat, psstat, top and iostat etc. • Setup a digester recovery solution by using oracle physical/logical data guard setup.• Installation and troubleshooting oracle RAC of three nodes RAC database.• Configuring oracle services in order to maintain workload of client connection consumption and to optimize high performance.• Configured TAF to provide high availability in order to maintain business without any interruption.

Pune Area, India

Responsibilities:• Installation of Oracle 10g/11g server and creation database. • Managing Tablespace and Datafiles: storage management, sizing the database objects monitoring file Systems and tablespace growth.• Database Cloning for testing and development purpose.• Implement & maintain database security (create & maintain users & role, assign privileges).• Configuring Client machine for Oracle Server.• Backup & recovery of database and database objects (Using 10g Data Pump, Hot backup, Cold Backup, RMAN backups).• • Analyze and resolve bottlenecks through AWR reports & ADDM reports.• Configuration of Enterprise Manager Control for upgraded Oracle10g databases for monitoring and troubleshooting.• Resolving bottlenecks using SQL tuning & Application Tuning. • Performance Analyze Using the Oracle tools TKPROF, SQLTRACE and Explain Plan.• Creation of shell scripts for monitoring database, analyzing schema/objects, RMAN cloning, Periodical backups and executing them through unix crontab.• Database Troubleshooting and Monitoring includes Oracle errors, Capacity Check, Monitoring sessions, Managing Database Users, Managing Schema Objects etc.• Database Troubleshooting and Monitoring includes Oracle errors, Capacity Check, Monitoring sessions, Managing Database Users, Managing Schema Objects etc.• Monitoring system health (Disk space monitoring, CPU Utilization, Memory Utilization).