DINESH.CH

acxlfr@r.postjobfree.com

+1-732-***-****

Career Summary

Having 8 Years of total IT experience in DB2 as a DB2 LUW Administrator, Experience on DB2 utilities, handling production and Development Issues.

Technical Expertise

EXPERI EXPERIENCE SUMIENCE SUMMARY

DB2 installations, configurations, patching and upgrades in Production, Q/A, Test and Dev environments

Experience on creating the new database and maintaining database objects

Create DB2 database online/offline backups

Experience on creating the new Table Space on DPF environment

Hands on experience in maintaining Table space spaces, Tables in DB2 databases running on LUW platforms

Experience on maintaining Database Manager and Database Configuration Parameters

Expertise in using DB2 Movement Utilities like Export, Import and Load

Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors

Generating DDL using DB2LOOK utility

Catalog databases and install DB2 Client on application servers

Performance tuning by monitoring, taking snapshots

Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database

Installed DB2 V10.5 Fix Pack 7 on AIX, Sun Solaris and Zlinux Servers

Worked on HADR environment

Table space management – Adding, dropping, extending, reducing and resizing table space containers

Backup & Recovery of Database, Online database backup, archived log files and Offline

Granting / revoking various authorizations to different Users/Groups

Implemented DB2 Security, Locking and Concurrency Control

Strong collaboration, team building, interpersonal, communication skills with proficiency

at grasping new technical concepts quickly & utilizing the same in a productive manner.

Technology Proficiency

Operating System : Windows 2003/NT, AIX P6, Sun Spark, Linux

Database : DB2 UDB, SQL Server 2005, Oracle, PL/SQL

Reporting Tools : Service Now, PPM

Projects Experience

Jun’12 to till date

Jersey City, NJ

Title : AIG Property Causality (AIG)

Role : DB2 DBA,

Environment : DB2 V10.5 FP7. 1V9.7 FP 10, Sun solarise, AIX P6, ZLinux,

SQL Server 2005, Oracle, IBM Data Stage and Netezza

Description:

AIG team handles the Property and Causality division of the AIG lnc. AIG – is an American multinational insurance corporation with more than 88 million customers in 130 countries. We manage the huge infrastructure administration support of around 300 applications inclusive of application and database servers. The administration support requires various technologies in database like IBM DB2, Netezza, Sql Server, and Oracle & IBM Data Stage. Hence this support involves client’s critical applications which extend in multiple technologies.

Responsibilities:

Installed the Fix Packs and updated the instances

Installed ESE in database server and data server client installed in Mw servers

Experience on creating the new database and maintaining database objects

SQL Server 2008/2005 and IBM Data stage Administration to Multiple applications of AIG P&C

Experience on Creating the new table Space

Addressing all database server alerts with in SLA

Hands on experience in maintaining Table space spaces, Tables in DB2 databases running on LUW platforms

Experience on maintaining Database Manager and Database Configuration Parameters

Expertise in using DB2 Movement Utilities like Export, Import and Load

Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors

Expertise in running REORGCHK, REORG and RUNSTATS for better performance of the database

Generating DDL using DB2LOOK utility

Daily data refresh from production to QA environment

Performance tuning by monitoring, taking snapshots

Backup & Recovery of Database, Online database backup, archived log files and Offline

Granting / revoking various authorizations to different Users/Groups

Creating Client instances for Application,Data stage and Cogon’s servers and cataloged the

required databases

Resolution of user queries: Resolution for the user queries for all above tasks and application errors which are affected due to database level issues in day to day basis

Automated Redirect restore by using shell script

Database (DB2 UDB) maintenance and support

Performance tuning the database for better and faster results

Providing weekend on call support

Perform backup and restore activities

Jul’11 – Jun‘12

Mumbai, India

Title : National Securities Depository Limited (NSDL)

Role : DB2 DBA

Environ ment : DB2 V9.1 FP 4, V9.5 FP 1, AIX P6, P7, Linux.

Description:

Tax information Network (TIN) – a repository of nationwide tax related information, has been established by National Securities Depository Limited on behalf of income Tax department of India (ITD)

Central Recordkeeping Agency (CRA) –National Securities Depository Limited (NSDL) and the Pension Fund Regulatory and development Authority (PFRDA) have entered into a formal agreement relating to the setting up of a Central Recordkeeping Agency (CRA) for the New Pension System (NPS), CRA is the core infrastructure for the new Pension System and is critical for its successful operationalization.

Responsibilities:

Providing support to System Administration(SA) in database installation, instance Creation and instance upgrade

Tuning of db and dbm configuration parameters

Weekly database size report and table space utilization report

Database (DB2 UDB) maintenance and support

Performance tuning the database for better and faster results

Worked on EXPORT, IMPORT and LOAD utilities, moving Data between servers

Daily and weekly database Maintenance activities such as backup, reorgchk, reorg, run stats and all related activities for OLTP database

Worked on DPF and HADR environment

Table space creation on DPF environment

Table space management – Adding, dropping, extending, reducing and resizing table space containers

Restoring the database as per client requirement on test environment

Stored Procedure compilation and execute privileges to user

Granting & revoking various authorizations to different user/groups

Database monitoring using Snapshots and Event monitoring

Resolution of user queries: Resolution for the user queries for all above tasks and application errors which are affected due to database level issues in day to day basis

Feb’10 to Jul’11

Chennai, India

Title : Bank of America

Role : DB2 - DBA

Environment : DB2 UDB v 9.1, V9.5, AIX, Linux.

Responsibilities:

Create and Manage Servers, instances and databases

View and modify database and database manager configuration parameters

Configure clients and servers connectivity

Perform DB2 Security, control database access, grant/revoke authorities and privileges

Monitored the table space’s growth and added/extended the containers accordingly

Worked with data movement utilities IMPORT, LOAD, and EXPORT

Fulfil/Accomplish with the SLA (Service Level Agreement) to provide an accurate service

delivery

Reorganizing Tables and Indexes for improving performance

Generating DDL using DB2LOOK utility

Enable DB2 event Monitoring and snapshots

Capture and analyze Explain and Visual Explain information

Done Backup (online and offline), Restore and Redirect Restore

Checked the database backup image's integrity using db2ckbkp

Performance tuning the database for better and faster results

Table space management – Adding, dropping, extending, reducing and resizing table space containers

Sending daily and weekly reports and handovers

Sep’08 – Jan‘10

Chennai, India

Title : Info Biz

Role : DB2 - DBA

Environment : Windows xp, Windows 2003, DB2 UDB v 9.1.

Responsibilities:

Tuning of db and dbm configuration parameters

Monitored the table space’s growth and added/extended the containers accordingly

worked with data movement utilities IMPORT, LOAD, and EXPORT

Reorganizing Tables and Indexes for improving performance

Generating DDL using DB2LOOK utility

Done Backup (online and offline), Restore and Redirect Restore

Checked the database backup image's integrity using db2ckbkp

Granting database privileges to the users

Performance tuning the database for better and faster results

Table space management – Adding, dropping, extending, reducing and resizing table space containers

Exporting the data from production and loading it in test boxes

Sending daily and weekly reports and handovers.

Contact this candidate