SUMMARY

• 5+ Years of total IT experience as a DB2 LUW Administrator, Experience on DB2 utilities, handling production and Development Issues.
• Involved extensively in Installation and Configuration, upgrading, and troubleshooting DB2 databases.
• Performance tuning and SQL tuning of DEV, TEST and production environments.
• Expertise in using DB2 Movement Utilities like Export, Import and Load
• Experience in installing, restoring and managing systems, databases, tables and indexes and multiple instances of DB2
• Troubleshot day today problems encountered on production, development and test database environment
• Planned and migrated various DB2 AIX databases to Linux environment
• Troubleshooting database issues using db2diag, db2pd, Snapshots and event monitors
• Able to resolve performance issues using various tools
• Strong Shell Scripting experience in Red Hat and SUSE Linux
• Catalog databases and install DB2 Client on application servers
• Build and configure multiple DB2 databases, clustered, non - clustered and virtual environments.
• 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 Linux Servers
• Configured and worked on HADR environment
• Monitored performance statistics, system and database on production.
• Monitored system/database logs for errors and warnings.
• Table space management - Adding, dropping, extending, reducing and resizing table space containers
• Performed redirected restores of databases.
• Monitoring and troubleshooting of databases using db2pd, db2top
• Tuned Instance and database configuration parameters for optimal performance.
• Tuned SQL statements to boost overall database performance.
• Performed database monitoring and tuning through db2top, snapshot and event monitors.
• Performed data management tasks as required loading, restoring, and purging data at the request of clients.
• Backup & Recovery of Database, Online database backup, archived log files and Offline
• Troubleshoot problems related to HADR automatic failover scenarios.
• Implemented DB2 Fix Packs on HADR databases.
• Database restoration from crash recovery, roll-forward recovery, point-in-time recovery
• Granting / revoking various authorizations to different Users/Groups
• Implemented DB2 Security, Locking and Concurrency Control
• Strong collaboration, team building, interpersonal, communication skills wif proficiency at grasping new technical concepts quickly & utilizing the same in a productive manner.
• Solid capabilities managing to work plans and meeting deadlines.
• Providing technical expertise to design most efficient and cost-effective solutions for DB2 based database systems
• 24/7 production support for some database applications

TECHNICAL SKILLS

Operating Systems: LINUX (Red Hat and SUSE) (5 years), UNIX (AIX, Solaris) (4 Years), Windows (5 Years)

Languages: SQL, Shell Scripting, AWK

Application Server: Web sphere, Web Logic, Jboss

Database Tools: Change Data Capture (CDC), Optim Performance Manager, DB2 Performance Expert, Erwin, ER/Studio, Rational Data Architect, DProp, DB2 Replication Center, DB2 connect, and Quest Tools, VERITAS Net Backup, TSM, DB2 Federation, DB2 Query Patroller, DB2 Governor, db2top and db2pd

RDBMS: DB2 UDB LUW on 8.x, 9.x, 10.1 and 10.5, SQL Server and Oracle

PROFESSIONAL EXPERIENCE

Confidential, Westborough, MA

DB2 - DBA

Environment: DB2 V10.5 FP7, V9.7 FP 10, V10.1 FP 5, Sun Solarise, AIX P6, Linux, Oracle, IBM Data Stage and Netezza

Responsibilities:

• Monitor the use of the database to identify opportunities for performance improvements.
• Installed and configured DB2 v9 .7fp5 on Linux, AIX and Windows.
• Migrated DB2 v9.x databases to DB2 V10.1 and 10.5
• Change Management - Schedule change, get approvals, do broadcast and work on change tickets.
• Data refresh at table level and database refreshes across prod/non-prod environments.
• Performance Tuning of all UDB instances - identifying performance degrading factors and taking corrective measures to improve server and query performance.
• The tuning efforts ranged from physical I/O tuning, memory cache optimization, Application Tuning included query optimization and Proper index selectivity.
• Monitor table space growth statistics for the production databases and estimate the size for the month/year by actively participating in Capacity Planning meetings wif users and managements and drew out relevant statistics for upper management to study.
• Creating scripts for scheduling activities like EXPORT, IMPORT and LOAD
• Used Remedy for Change Control/Change Management.
• System crash and hang analysis - collecting stack trace, running db2support and uploading the same to IBM Support to investigate PMR.
• Performed database objects creation and alteration (tables, indexes, views, stored procedures, functions).
• Moving databases from Development to Production after successful completion of application testing.
• Automated or simplified routine tasks such as backups/Reorg/Runstats/binds, purge jobs and replication setup via Perl and shell scripting
• Designed and implemented strategy for running data Reorg/run stats on timely basis for large tables to avoid data fragmentation and improves performance and system throughout.
• Supported developers to write SQL statements and test them before running it in Production environment. Take the backup of the database when restarting the drop.
• Create scripts for Bench mark testing of DB2 servers.
• Administered database, table and table spaces.
• Implemented Backup/Recovery of databases.
• Implemented DB2 Security, Locking and Concurrency Control.
• Database backup and recovering the database at the time of crash.
• Involved in HADR setup, monitoring, rolling up upgrades.
• Created DPF and Range partitioning tables, MQT.
• Generated SQL Statements using DB2LOOK Utility

Confidential

DB2 - DBA

Environment: DB2 UDB V8, V9.1, V9.5 V10.1, V10.5 AIX, Linux, Windows.

Responsibilities:

• Administration DB2 V9.7 databases on LUW platform.
• Installed and configured DB2 v8, v9, v10.1 and v10.5 on Linux, AIX and Windows.
• Database creation and designing.
• Fix pack installation.
• Performed performance tuning and capacity planning using the parameters of DBM configuration file &DB configuration file and various DB snapshots.
• Backup and Recovery and Problem Solving.
• Database migration
• Working and troubleshooting on day-to- day problems via opening and closing tickets.
• Explain and Snapshots, Buffer pools performance optimization, SQL performance evaluation, analysis, and optimization.
• Created and dropped various objects.
• Federation of DB2 databases across the environments.
• Developing the database codes, scripts for databases
• Deploying store procedures for application users.
• Based on the security level granting privileges to users.
• Involved in production/development setup, configuration and support
• Able to resolve performance issues using various tools
• Reverse engineering, schema generation & Complete compare using Erwin tool.
• Monitored backup operations, and schedules manual backups as needed
• Usage of tools like DB2 Load, Import, Export and Reorg, Runstats, Reorg Check, Backup, Restore, Db2move, and Db2look
• Performed Redirect restore.
• Performed Database migration/upgrades between multiple versions.
• Performed Server migration.
• Provide 24/7 On call support on rotational basis.