PROFESSIONAL SUMMARY

• Hands on experience on DB2 V8.x, V9.x, V10.x.
• Apply the db2 patches by using zero down time Approach.
• Hands on experience in Database partition feature.
• Involved in flash copy recovery for databases in huge size.
• Strong noledge 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
• 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
• Extensive experience in Create, delete, drop, updates tables in DB2 databases.
• 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
• Experience on End to End implementation of Q Replication.
• Having conceptual Knowledge on Basic hardware & networking.
• Handled various aspects like solution design documentation, system design and integration.
• Provide weekly status reports on database health and performance.
• 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 TEMPthan 10 TB and involving handling of Severity outage calls, database performance issues, storage management and tuning of databases for optimal performance.
• Handling all types of tickets and resolving within the SLA's and completing SRM's and WO's within time.
• 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
• 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. Interact with the System Administrator for database issues including capacity planning, such as installation and configuration of new disks on Unix Systems.Oracle & SQL:
• We has supported L1 activities like database health check monitoring and script executions (DDL, DML), batch jobs monitoring.

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, MS SQL.

Software: IBM Tivoli TSM and HADR

Monitoring Tools: DB2MON and IBM Optim Performance Manager.

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

PROFESSIONAL EXPERIENCE

Confidential, Florida, Miami

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

Responsibility

• 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.
• 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.
• Strong noledge in Database Physical Support and Design
• 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 noledge of AIX and Linux Operating System
• Monitor security breaches, error log(s), database and log space, user activity and resource utilization of production environment. Work with application programmers to ensure that application problems do not adversely effect production operations
• On-call 24x7 production support and Training guidance to offshore DBA's
• We has supported L1 activities like database health check monitoring and script executions (DDL, DML), batch jobs monitoring.
• User security management.

Confidential,Boston, Massachusetts

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

Responsibility

• 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’s.
• 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.
• Troubleshoot the issues as and when required.
• Attending Weekend calls with offshore and onsite teams.

Confidential

DB2 DBA

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

Responsibility

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