H*B Status: Holding H*B Approved Petition

Professional Summary

Total IT experience – 8.5 years, 8.3 years’ experience in DB2 LUW Physical Database Administration in both SAP and Non-SAP platforms

IBM Certified Database Associate - DB2 Universal Database V8.1 Family in 2008

Certified in IBM Information Management DB2 Technical Professional in 2009

7.3 years’ experience in leading and managing teams in DBA field.

Good communication skills, interpersonal skills, self-motivated, quick learner, team player.

Skill Set: Technical

RDBMS

IBM DB2 LUW v10.x, v9.x and v8.2, Oracle 11g, INGRES 9.2

Programming Languages

UNIX Shell Scripting

Operating System

IBM AIX 5.3, Red Hat Enterprise Linux (RHEL) 5.x, 6.x

Hardware

Intel x86_64, IBM pSeries

DBA Tools

SAP DBA Cockpit, DB2 Command Centre, INGRES VDBA, Squirrel,

Data Replication/Data Warehousing Tools

IBM InfoSphere Change Data Capture (CDC) v6.5, IBM InfoSphere Data Replication (IIDR) v10.2, v11.3.x

ITSM Tools

ARS Remedy v5, Service Now, Citrix, VMWare, ESM ticketing tool

Storage

XtremeIO, SAN, NAS, DataDomain, IBM TSM, EMC, NetBackup

Domain Experience

Life Sciences and Healthcare, Entertainment, Retail, Government

Skill Set: Functional

Effort and Capacity Planning, Design, implementation, maintenance and change management of DB2 LUW Databases

Expertise in SAP-DB2 LUW System Refresh/Copybacks

Expertise in DB version migration and Fix Pack upgrade in Non-partitioned/Partitioned databases in both SAP/Non-SAP landscapes

Design, implementation of DB2 High Availability and Disaster Recovery (HADR) with single and multiple Standby Databases

Experience in DB2 v10.5 advanced features, e.g. Adaptive Compression, Table movement, Online conversion using DB6CONV

Experience in IBM Tivoli Storage Automation (TSA) Multi-platform (MP) setup using Private/Public Network to automate DB failover and application rerouting

Knowledge in Automated Client Reroute (ACR)

Experience in HACMP Clustering with DB2

Experience and expertise in SAP Business Object (BO) Database design, implementation and Configuration

Experience in SAP BW Database Physical to Logical Partition movement

Database Performance Tuning

Expertise in Database backup and recovery for DMS/Automatic Storage Databases with DB backup restore method and DB snapshot/BCV split/clone/etc. recovery.

Develop, manage, enhance and automate DB2 pro-active monitoring and health checking

Expertise in Database Troubleshooting

Expertise in UNIX Shell Scripting

Data replication among different RDBMS (DB2 to Oracle) using IBM InfoSphere CDC and IIDR

Experience in configuration, tuning, job management and troubleshooting of issues associated with CDC and IIDR, expertise in version upgrade and patch update of CDC and IIDR

Exposure to Oracle 11g (stop/start of listener/db, create/drop user/schema, privilege granting, adding/resizing/monitoring of tablespace, monitoring backups, taking RMAN backup, etc.

Professional Certifications

Professional Certification

Date Certified

IBM Information Management DB2 Technical Professional v2

December, 2009

IBM Certified Database Associate – DB2 Universal Database V8.1 Family

September, 2008

Organization Summary

Organization

Period

IBM India Pvt. Ltd.

03-Oct-2011 – Present

Tata Consultancy Services Ltd.

07-Nov-2007 – 16-Sep-2011

Assignments

Organization

Project

Period

Role

IBM India Pvt. Ltd.

Eli Lilly

Oct 2011 - Present

SAP-DB2 LUW DBA Tech Lead

Neptune Orient Lines (NOL)

Apr 2013 – Jun 2013

SME on SAP-DB2 LUW HADR Implementation

Disney ADM

Feb 2013 – Apr 2013

SME on SAP-DB2 LUW performance tuning and scripting for HADR monitoring.

Mead Johnson

Feb 2013 – Apr 2013

SME on SAP-DB2 LUW performance tuning

Smyth Toys

Jan 2013 – Feb 2013

SME on SAP-DB2 LUW version upgrade and Fix Pack patching

Tata Consultancy Services Ltd.

West Bengal e-District

Nov 2009 – Sep 2011

INGRES DBA Team Lead

Jharkhand e-District

Nov 2009 – Sep 2011

DB2 DBA Team Lead

Ministry of Corporate Affairs (MCA21)

Jan 2008 – Nov 2009

DB2 DBA Team Lead

Achievements

Organization

Major Highlights

IBM India Pvt. Ltd.

Awarded “Manager’s Choice Award” for “Putting the Client First” in 2015, 2014

Awarded “Orion Award” for exemplary contribution towards eminence and excellence in team performance in 2013

Awarded “Think Connect” for individual excellence in performance in 2012

Reduced manual DBA effort by 20-40% through automation of DB2 pro-active monitoring using custom scripts and tools.

Publication of these tools in the IBM Asset Hub and IBM Account Growth Program

Got client appreciation for showing leadership, innovation and value addition.

Significant contribution on DB2 to the IBM GBS-GD TAC AAO Community

Recognition as SME regarding DB2 related consulting

Tata Consultancy Services Ltd.

Reduced DB Recovery time during BCP Drill by 50% through developing a new DB2 method of bringing the DB up at DR site.

Improved Reporting DB refreshing time by 60% using DB2 Flash Copy method

Successfully handled and led the DB team during a real life Disaster Recovery

Led the DBA team successfully through Production Go-Live.

Achieved 100% client satisfaction index on DBA related activities

Academic Qualifications

Degree and Date

Institute/University

Major and Specialization

B. Tech in 2007

Institute of Engineering & Management, West Bengal University of Technology

Computer Science & Engineering

Personal Details

Date of Birth

29-07-1984

Nationality

Indian

Passport Details

Name as on passport

Relationship

Passport Number

Date of Issue

Expiry Date

Place of Issue

Amit Kumar Sanyal

Self

G0899919

11-April-2007

10-April-2017

Kolkata

Contact this candidate