CAREER SUMMARY:

• Having 8 Years of total IT experience in DB2 as a DB2 UDB Administrator, Experience on DB2 utilities, handling production and Development Issues.
• DB2 installations, configurations, patching and upgrades in Production, Q/A, Test and Dev environments
• Experience on DPF environment.
• 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 Servers
• 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

TECHNOLOGY PROFICIENCY:

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

Database: DB2 UDB, SQL Server 2005, Oracle

Reporting Tools: Service Now, PPM

PROJECTS EXPERIENCE:

Confidential, Jersey City, NJ

DB2 DBA

Environment: DB2 V10.5 FP7. 1V9.7 FP 10, Sun solarise, AIX P6, ZLinuxSQL Server 2005, Oracle, IBM Data Stage and Netezza

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 Confidential 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
• Tuning of db and dbm configuration parameters
• Database (DB2 UDB) maintenance and support
• Performance tuning the database for better and faster results
• Providing weekend on call support
• Use the NzAdmin administrative tasks including Genstats Groom, and manage Development
• Perform backup and restore activities

Confidential, Bloomington, IL

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

Confidential

DB2 DBA

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

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
• 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

Confidential

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.