Manager Oracle

Amitesh Tiwari

Phone: +91-959*******

Mail: ************@*****.***

Career Objective

To achieve organizational objective along with career excellence through consistent performance, learning, team engagement and knowledge sharing and to enhance technical and management skills through various roles and responsibilities.

Profile

Working as an apps DBA (principal consultant -Technical Lead) at Accion Labs India Pvt Ltd since Oct 2015.

Worked as an apps DBA and Exadata DBA (senior consultant at CSG International) since dec 2013 till Oct 2015

Worked as an apps DBA (Associate Consultant at ITC Infotech India Ltd) since Aug 2012 till Nov 2013.

Worked as an EXADATA DBA at client side (Oracle India Pvt Ltd) (Associate Consultant at ITC Infotech India Ltd) since Feb 2012 till Aug 2012.

Worked as an IT Analyst with Tata Consultancy Services (TCS) Since October-2006 To Jan 2012

Main area of expertise is working as Oracle Apps DBA on EBS 11i and R12 and Oracle 9i,10g,11g databases

Experience Summary

Good knowledge of apps R12 architecture, applications patching, applications cloning, ad utilities, concurrent managers and requests

Good Knowledge of Oracle Enterprise Manager and Oracle Internet Directory, SSO, discover

Working Knowledge in Exadata Machine Administration (V2/X2-2/X2-8)

Expertise in ESS patching and database bundle patches and in 11gR3 Database and Grid Infrastructure upgrade.

Good Knowledge of Oracle 11g RAC and ASM

Configuring and Supporting Dataguard.

Configuring DG broker and maintaining the databases with dgbroker

Oracle Software Installation, Database creation and Upgradation.

Oracle database Cloning and Patching.

Configuring and using RMAN, User Managed Backup and Recovery.

Using Export/Import utilities and Datapump.

Configuring and using Flashback Features for an Oracle database.

Handling Database Corruption Issues and Troubleshooting Database Performance issues.

Creating/Managing Table Partitions, DB Reorganization, Rebuild, Truncate, Purge and Gather Stats.

Configuring and using Statspack and AWR for oracle database performance tuning.

Checking Backup logs and Alert logs to troubleshoot Oracle errors.

Monitoring Oracle Database Server to ensure proper database Availability,Performance and Capacity and Oracle load, User sessions and Long running operations on the Server.

Managing Database Connectivity, networking and Storage

Monitoring and resolving Lock Conflicts in oracle database.

Basic day-to-day Admin commands Linux/Unix

Monitoring System’s Performance (CPU,Memory,I/O) and Shell Scripting

Technical Strengths & Skills

Operating System

HP-UX UNIX, Linux (RHEL, Novell SUSE), SCO UNIX, Windows 98/XP/2000

Databases

Oracle Database 9i/10g/11g.

Oracle Applications (E-Business-Suite)

Oracle Applications 11i and R12

Languages

SQL, PL/SQL, C, Shell Scripting, HTML

Tools

TOAD 8.0.0.47, ITG Kintana, BMC Remedy, Putty, HP open View, PL/SQL Dev,Citrix,Symantec i3 tool, OEM,RMAN

Onsite Exposure/Certifications

Worked at Hartford Connecticut, (U.S.A) – 06105 for 1.5 months.

Oracle Certified Associate (Developer’s Track).

Oracle Certified Professional (OCP 10g DBA Track)

Oracle 10g: Managing Oracle on Linux Certified Expert

Oracle Database 10g Real Applications Clusters Administrator Certified Expert Certified

Oracle Certified Professional (OCP 11g DBA Track)

Oracle Certified Expert (RAC and Grid Infrastructure 11g)

Work Experience

1)

Role: Oracle Apps DBA

Project: Tier1Inc

Company : : Accion Labs India Pvt Ltd

Period: Oct 2015 – till date

Description: The project is to provide support to around 50 instances using apps 11i and R12 and oracle databases 10g, 11g, 12c with ASM and RAC.

Responsibilities as Oracle Apps DBA:

Ensuring 24*7 continuous EBS and NON EBS Database Stability and Availability

Managing Oracle Application 12.1.3 like request handling, responsibilities, concurrent manager issue, locking issues

Monitoring Concurrent Manager and resolving related issues

AD Utilities (adpatch, adcfgclone, adadmin, adctrl, adautocfg, admrgpch)

Refreshing /Cloning the database and application on demand

Application of database patches

Monitoring EBS instances and databases through cloud control 12c.

Monitoring database, System performance

Troubleshoot problems with database, CRS, ASM

Handling the issues related to Forms, Web and Report Server.

Rebuilding and troubleshooting dataguard

Agent installation, cloning and patching

Doing monthly healthchecks for EBS and core database and providing recommendations and implementing it for enhanced stability.

2)

Role: Oracle Apps DBA

Project: Denver Data Center management

Company : : CSG International

Period: Dec 2013 – till date

Description: CSG has its own datacentre running ERP and Exadata, The project is to provide support to around 30 instances using apps R12 and oracle 11g on ASM along with exadata.

Responsibilities as Oracle Apps DBA:

Ensuring 24*7 continuous EBS and NON EBS Database Stability and Availability

Managed Oracle Application 12.1.3 like request handling, responsibilities, concurrent manager issue, locking issues

Monitoring Concurrent Manager and resolving related issues

AD Utilities (adpatch, adcfgclone, adadmin, adctrl, adautocfg, admrgpch)

Refreshing /Cloning the database and application on demand

Application of database patches

Create tablespaces, tables, users for custom applications and Maintain user security

Monitoring database, System performance

Troubleshoot problems with database, CRS, ASM

Handling the issues related to Forms, Web and Report Server.

Rebuilding and troubleshooting dataguard

Agent installation, cloning and patching

Supporting SSO, OID.

Shell scripting for alerts as and when required.

3)

Role: Oracle Apps DBA (Production Support)

Project: Sunpower Corporation

Company : : ITC Infotech India Ltd

Period: Aug 2012 – till Nov 2013 (1 years 3 months)

Description: Sunpower corporation deals with energy resources and utilities, The project is to provide apps and core dba support to around 30 instances using apps R12 and oracle 11g on ASM.

Responsibilities as Oracle Apps DBA:

Ensuring 24*7 continuous EBS and NON EBS Database Stability and Availability

Managed Oracle Application 12.1.3 like request handling, responsibilities, concurrent manager issue, locking issues

Monitoring Concurrent Manager and resolving related issues

AD Utilities (adpatch, adcfgclone, adadmin, adctrl, adautocfg, admrgpch)

Refreshing /Cloning the database and application on demand

Application of database patches

Create tablespaces, tables, users for custom applications and Maintain user security

Monitoring database, System performance

Troubleshoot problems with database, CRS, ASM

Handling the issues related to Forms, Web and Report Server.

Rebuilding and troubleshooting dataguard

Agent installation, cloning and patching

Supporting SSO, OID.

Shell scripting for alerts as and when required.

4)

Role: Oracle Exadata DBA

Project: Proctor and Gamble [Working at client side ORACLE India Pvt Ltd]

Company : ITC Infotech India Ltd

Period: Mar 2012 – Aug 2012

Description: P&G has huge Databases set up on Exadata Machines. The project is to provide DBA Implementation and support to more than 50 databases on Exadata box (11g R2) clustered on 11gR2 RAC and providing disaster recovery of clustered system Dataguard.

Responsibilities as an Exadata DBA:

Using Enterprise manager 11g for database administration

Applied database bundle patches in various environment both in rolling as well as non-rolling manner.

Exadata Storage Server patching in various environment both in rolling as well as non-rolling.

11.2.0.3 db and grid upgrade in various environment.

Database and database home Cloning from active database (rman duplicate) and also from binaries from different node.

Standby rebuild in various environment.

Handling database services during Hardware replacement in Exadata Box and disk group management.

Troubleshooting Exadata Database and Storage server issues

Analyzing trace and log files to determine and resolve potential problem areas

Setting up backup policy for the environment (using RMAN).

Performing health checks on Exadata Box

Performing System Administration tasks like creating and monitoring users, assigning, privileges, roles Installing & Performed daily check of alert logs for ORA- errors

Interaction with Oracle Support for technical assistance requests in various severe issue like node reboot, instance termination.

5)

Role: Oracle Apps DBA (Production Support) with EXADATA

Project: The Hartford Financials [Production Support]

Company - Tata Consultancy services (T.C.S)

Period: Nov 2010 – Feb 2012

Description: The Hartford Financial Services Group, Inc., through its subsidiaries, provides insurance and financial services in the United States and internationally. The company engages in life, and property and casualty insurance businesses. The company was founded in 1810 and is headquartered in Hartford, Connecticut. The project is to provide DBA support to more than 500 databases of Oracle 9i on HP-UX11 and Oracle 10g on Sun Solaris 10, EBS 11i and R12 Instances and file systems like RAW and Cooked and other high availability technologies like RAC and Dataguard, and Exadata Machines.

Responsibilities as Oracle DBA:

Managing oracle databases with regards to Availability,Performance and Capacity

Using Enterprise manager 11g for database administration

Applied database bundle patches in various environment both in rolling as well as non-rolling manner.

Exadata Storage Server patching in various environment both in rolling as well as non-rolling.

11.2.0.3 db and grid upgrade in various environment.

Database and database home Cloning from active database (rman duplicate) and also from binaries from different node.

Standby rebuild in various environment.

Implementing data security by managing Roles and Privileges

Handling database errors,user errors and Database Corruption issues

Developing Backup and Recovery strategies

Managing and Scheduling Cron Jobs

SQL Query tuning for development team

Schema refresh for testing using Export/Import utility on periodic basis

Performing Online redefinition of tables for production database as per customer’s need and Table Reorg on periodic basis to eliminate fragmentation as well as Tablespace Consolidation and Index Rebuild for better management of application data.

Analyzing the database on a periodic basis

Using Symantec i3 tool and oracle grid for monitoring oracle databases

Using BMC remedy on incidents and change management with strict SLA.

6)

Role: Oracle DBA (Implementation and Support) and Oracle Apps L2 support.

Project: Alcoa OPEX NADC OFFSHORE

Company : Tata Consultancy services (T.C.S)

Period: Dec 2006 to Apr 2010

Description: ALCOA (Aluminium Company of America) is the world’s leading producer of primary aluminium, fabricated aluminium, and alumina and is active in all major aspects of the industry. The company has 129,000 employees in 42 countries. The project is to provide DBA support to more than 100 NON EBS instances that uses Oracle 9i and Oracle 10g as database, and file systems like ASM, RAW and Cooked and other technologies like 10RAC, Dataguard.

Responsibilities as Oracle DBA:

Checking prerequisites for database setup on servers

Software Installation on freshly identified Linux Servers

Creating Databases well designed according to customers requirement

Configuring Flashback for production databases

Upgrading Oracle databases from 9i to 10g and 11g

Configuring database to use Oracle Managed Files (OMF).

Oracle network configuration (listener and tnsnames) and RMAN Configuration for Backup and Recovery of Oracle databases

Database Migration across Servers and database decommissioning

Remediating squirrel scan reports for turning over Oracle databases to Support DBA and Creating WRA(work request agreement) for the project wherein I worked as a SPA (Single Point Of Accountability).

Handling Disaster Recovery scenarios

Awards / Achievements & others

Client appreciation award in project assignment (ALCOA) for outstanding effort in decommissioning EBS instances in OLTP, OAPS, GDW areas in North America, South America and Europe regions.

Awarded “TCS GEMS” two times while working at TCS.

Participated in cultural events at ANTARANGNI-2004, cultural fest of IIT KANPUR

in Technical Paper Session on the topic “Programming Languages- Fuel of Software Engines” in annual Technical Fest of IIT Delhi, TRYST 2005 (17-20FEB 05).

Worked as Organizer in national level technical and sports fest held in our institute “EFFULGENCE-2005” and “TVARAN-2005”.

Worked as Senior Executive of sports council,Cultural Council,Foronix(Electronics forum) of K.N.I.T Sultanpur

Qualification

2002 - 2006 – B.Tech in Electronics Engineering from Kamla Nehru Institute of Technology (KNIT), Sultanpur with 63.7%.

Professional Training

Oracle Certified Professional (OCP), Oracle University, Feb-10.

Oracle Real Application Cluster (RAC) TCS-Kolkata, Jan-09

Initial Learning Program (Software Engineering, DBMS, RDBMS, UNIX etc.), TCS-Kolkata Oct-06

Entry Level Foreign Language Learning German (Preliminary), TCS-Kolkata Oct-06

Training on Core Java conducted by CDAC (Jul,2005)

Personal Information

Gender : Male

Marital Status : married

Nationality : Indian

Permanent address : 2B/172, M.I.G, Avas Vikas Colony, Harpur, Ballia, Pin - 277001

Passport No. : J6831512

Interests : Reading Novels and Writing poems.

Contact this candidate