SUMMARY

• I have around 8 years of Demonstrated skills in DB2 LUW database administration as Production Support, Implementation, Maintenance, and Security, gained experience in Installation, Administration, and Planning of DB2 databases on various platforms like AIX, Sun Solaris, LINUX, and Windows.
• I have experience working with DB2 HACMP Clustering, DB2 HADR setup with HACMP/TSA/VCS, SQL replication and Q replication, developing procedures for database Backup/Recovery in production environments.
• Also, I have basic experience in Unix Shell scripting and Oracle.
• I have Willingness and ability to quickly adapt to new environments and learn new technologies.
• Hands on experience on DB2 V8.x, V9.x, V10. x.
• Designed, created, and maintained DB2 database objects.
• Created and maintained DDL for all DB2 databases.
• Basic Knowledge on ORACLE.
• Automating repetitive task. Identified user catalog errors that was keeping DB2 RESTORE SYSTEM from working correctly.
• Experience on End to End implementation of Q Replication and SQL replication.
• Migrating the DB servers from existing VCS cluster to TSA Cluster.
• Apply the db2 patches by using zero down time Approach.
• Developed Custom scripts for controlling MQ and Q - apply using TSA cluster.
• Hands on experience in Database partition feature.
• Involved in flash copy recovery for databases in huge size.
• Strong knowledge in Database Physical Support and Design
• Hands on experience on DB Backup and Recovery strategies.
• Hands on experience of Cloning/Data refresh from Production to Development/UAT environments.
• Hands on experience in Migrating Databases from DB2 V8 to V9.x and DB2 V9.x to V10.x
• Actively Involved in design/configuring databases on HADR-TSA & HADR-HACMP and HACMP/VCS clusters
• Design and implement all the latest features of DB2 V9.1, V9.5, V10.1 and V10.5 DATA and INDEX COMPRESSION with REORG, Range-Partitioning, SYSIBMADM views, DPF etc.
• Experience in managing Tablespace Capacity Management, Archival logs, and DB Backups
• Usage of tools like DB2 Load, Import, Export, and Reorg, run stats, Reorg Check, Backup, Restore and Db2move
• Extensive experience in working with db2 specific tools such as db2pd, db2dart, db2support, db2top, db2inspect, db2advise, db2explain, db2diag, db2look, db2move & db2relocatedb
• Having conceptual Knowledge on Basic hardware & networking.
• Handled various aspects like solution design documentation, system design and integration.
• Deployed and configured OEM 12c plug-in for IBM DB2 LUW environments.
• Configured database auditing feature as a security measure for tracking un-authorized connections/ activities.
• Build the Logical and Physical standby databases, Failover and participating in DR Test.
• Checking Databases Backup and Restore validity periodically and Data refreshes from Production to Non-Production environment.
• Developed and implemented backup (online, offline), runstats, reorg, rebind and tablespace capacity monitoring report using Korn shell scripts on DEV, QA (UAT), and PROD systems.
• Worked on configuration/troubleshooting federated database environment.
• Experience in providing 24/7 Production support on large Databases of more than 10 TB and involving handling of Severity outage calls, database performance issues, storage management and tuning of databases for optimal performance.
• Tuning of DBM and DB cfg parameters to yields the maximum performance.
• Configured the partition technique for large tables to I/O and efficient data management.
• Worked on tuning database and Database manager configuration for optimum performance to support ETL applications. Worked on tuning Long Running Queries using db2batch, EXPLAIN, db2exfmt and db2advis
• Developed and Deployed the database maintenance shell scripts to stable the DB2 environment
• Gather Table/Index statistics and histograms and Tune Databases parameters for better SQL performance
• Monitored database and system performance and identified and removed bottlenecks. Monitored performance of the databases utilizing event monitors on statements, snapshots on database, locks, applications, bufferpools and tablespaces etc. Selected appropriate Database configuration parameters for efficient database operation. Optimized buffer pool configurations on DB2/UDB server.

TECHNICAL SKILLS

Operating system: AIX, LINUX, UNIX, SUN SOLARIS, Windows 2003 server, XP.

Languages: SQL, UNIX, Shell Scripting

RDBMS: DB2 UDB v8..x, v9.x,v10.x, oracle 9i, Oracle 10g and MS SQL.

Software: IBM Tivoli TSM and HADR

Monitoring Tools: Quest, Fog light, DB2MON and IBM Optim Performance Manager.

Tools: Manage Now, BMC Remedy, Maximo and Service Desk.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Senior Database Administrator

Environment: DB2 UDB v9.5,v9.7,v10.1&V10.5, OS - AIX, Linux

Responsibilities:

• Installation and Configuration of DB2 environment in LUW.
• Upgradation of database from v9.5fp7 to V9.7 fp11 from v9.7fp11 to V10.5 fp6.
• Actively Involved in design/configuring databases on HADR-TSA/HADR-VCS and VCS clusters.
• Apply the db2 patches by using zero down time Approach.
• Setting up the Q-Replication as per customer requirement by using Bi-Directional strategy.
• Experience in managing Table Space Capacity Management, Archival logs and DB Backups.
• Extensive work experience in DB Tuning, Performance issues and Query Optimization using db2batch & db2advis
• Having experience on DPF environment servers.
• Setting up the Zero Down Time server as per customer requirement by using database WRITE SUSPEND/RESUME mode.
• Hands on experience on DB Backup and Recovery strategies.
• Hand-on experience in Migrating Databases from DB2 V9.x to V10.x
• Extensive experience in working with db2 specific tools such as db2pd, db2dart, db2support, db2top, db2inspect, db2advise, db2explain, db2diag, db2look, db2move & db2relocatedb.
• Ensure availability of databases through database backups, verifying backups, ensure proper functioning of Jobs
• Improve security by controlling user privileges/roles and implement profiles to meet the Security Standards.
• Create and maintain DB2 UDB instances and databases for development, test, and production environments within AIX operating environment.
• Implemented backup compression techniques and can support Time finder backups
• Having good knowledge of AIX and Linux Operating System
• Monitor security breaches, error log( Confidential ), database and log space, user activity and resource utilization of production environment. Work with application programmers to ensure that application problems do not adversely affect production operations
• On-call 24x7 production support and Training guidance to offshore DBA' Confidential

Confidential, NJ

Senior Database Administrator

Environment: DB2 UDB V9.1, v9.5,v9.7&v10.1, OS - AIX, Linux

Responsibilities:

• Installation and Configuration of DB2 environment in LUW.
• Stabilizing the DB2 environments and streamlined the systems.
• Identifying key milestones and deliverables.
• Upgradation of database from v9.5 fp10 to v9.7 fp7.
• Configuring the High Availability techniques like HADR& HACMP.
• Installing and configuring the databases to IBM OPM tool for proactive monitoring of DB2 databases.
• Extensive experience in fine tuning of long running queries.
• Extensive experience in loading large volumes of data across DB’ Confidential .
• Backup & Recovery of Database, Online database backup, archived log files and Offline.
• Granting / revoking various authorizations to different Users/Groups.
• Capture and analyze Explain and Visual Explain information.
• Usage of tools like DB2 Load, Import, Export and Reorg, run stats, Reorg Check, Backup, Restore, Db2move and Db2look
• Creation and management of both system level and object level roles and privileges for various users. Killing sessions and granting/revoking user privileges and roles.
• Exposure on DR test & strategies like Failover Clustering/HADR.
• Cataloging Databases on various nodes.
• Involved in physical database layout design.
• Working with apps team to deploy the releases on time and more accurately.
• Snapshot monitoring was done to detect deadlocks, buffer pools and lock escalations.
• Provide assistance to the development team on performance tuning, resolving locking situations, assist data modeler with SQL scripts.
• Responsibilities include disaster recovery, capacity planning and Real-Time monitoring, troubleshooting and proactive maintenance.
• Perform file system copy from production to non-production using TSM backup and recovering DB2 databases in non-production environment.
• Implemented Database partitioning and Archival logging in DB2 UDB.
• Attending Weekend calls with offshore and onsite teams.
• Setup and maintain documentation and standards.

Confidential, California

Senior System Administrator

Environment: DB2 UDB V9.1, v9.5,v9.7&v10.1, OS - AIX, Linux

Responsibilities:

• Install IBM DB2 9.7 on AIX Server on seven systems, install DB2 client on Workstations and Catalog the Databases.
• Upgradation of database from v9.7 fp4 to fp6 and from v9.7fp4 to fp7.
• Data compression at DB level for DB2 systems to get optimum performance of sql queries and storage savings.
• Implemented the Compression feature to reduce the storage costs and improve the performance of the applications.
• Extensive experience in fine tuning of long running queries.
• Implemented ARCHIVELOG process to maintain active log files.
• Performed Database migration/upgrades between multiple versions.
• Hands on experience on DB Backup and Recovery strategies.
• Analyzing and implementing DB2 reorg utility based on the need for database reorganization
• Handling table space and file systems space issues. Extending Table space
• Working and troubleshooting on day-to-day problems via opening and closing tickets.
• Automate the db2diag and notification log files by updating dbm parameter.
• Create PMRs with IBM in case of any software and problems issues with DB2
• Setup and maintain documentation and standards.
• Performed Server migration.
• Provide 24/7 Oncall support on rotational basis.
• Upgradation of database from v9.7fp4 to fp6 and from v9.7fp4 to fp7.
• Extensive experience in loading large volumes of data across DB’ Confidential .
• Cataloging Databases on various nodes.
• Involved in physical database layout design.
• Implemented Database partitioning and Archival logging in DB2 UDB.
• Troubleshoot the issues as and when required.
• Attending Weekend calls with offshore and onsite teams.
• Setup and maintain documentation and standards.

Confidential

Senior database administrator

Environment: DB2 UDB V9.1, v9.5 & v9.7, OS - AIX, Solaris,Linux

Responsibilities:

• Maintained CIRATS APAR (Fix Pak installations)
• Maintained Database security (GSD-331 Standards)
• Installation, configuration, and upgrade DB2 databases.
• Creation of Instances and databases.
• Database objects creation & alteration (tables, indexes, views etc)
• Configuring Client / Server Connectivity.
• Managing Database user privileges (granting & revoking permissions)
• Database monitoring (free space in table spaces, snapshot, and Log verifications)
• Maintaining Database backup & recovery.
• Data Movement Utilities Like export, import, load & Move.
• Data Maintaining Utilities Like Reorgchk, Reorg, Runstats.
• Restoration of databases from online and offline backups.
• Experience in restoring databases in standalone server.
• Amended Load scripts to get better logging.
• Cataloging Databases on various nodes.
• Worked with application team in fixing the code releases & IT Builds
• Involved in 24x7 support and On-call support.

Confidential

Database Administrator

Environment: DB2 UDB V9.1, v9.5, OS - AIX, LINUX

Responsibilities:

• Installation, Creation and Configuration of Databases on AIX and Linux.
• Administration of Databases, Storage Groups, Table space, Tables, Views.
• Tablespace creation (both DMS and SMS)
• Creation of buffer pools, table spaces, tables using command center or Control center.
• Extending Table space, Creating & Dropping various DB2 Objects.
• Configured Backups and Archival logging to TSM.
• Restore/Redirect Restore of Databases as per the requirement
• Cataloging Databases on various nodes.
• Resolved DB2/TSM issues.
• Execute and run commands by using CLP and CLI.
• Handling table space and file systems space issues.
• Used Utilities DB2look, Db2trace, Db2move, Export, Import, & operational utility.

Confidential

Database Administrator

Environment: DB2 UDB V8.1,v8.2, V9.1 OS - AIX & Linux.

Responsibilities:

• Working knowledge of Database architecture.
• Supporting around 120 databases including Production, Development & Test with highest database size of 1.5 TB.
• Granting / revoking various authorizations to different Users/Groups to make it compliant as per ISCD.
• Taking Online /offline backup of Database, Table space.
• Monitoring the scheduled jobs like backups, data loads etc.
• Maintained Database security (GSD-331 Standards).
• Data Movement Utilities Like export, import, load & Move.
• Data Maintaining Utilities Like Reorgchk, Reorg, Runstats.
• Convert tablespaces to use Autostorage.
• Database cloning using redirected restores (from one instance to another instance)
• Cataloging Databases on various nodes
• Assisting with the creation and modification of primary database storage structure(tablespaces) and primary objects (tables, views, indexes)
• Analyze production failures and slow performance byDB2diagnosis tool such as DB2top DB2pdby snapshots.