SUMMARY

• I have over all 8+ years of Demonstrated skills in IBM 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 TSA developing procedures for database Backup/Recovery in production environments.
• I have experience in maintaining multi partitioned databases.
• Also I have basic experience in Unix Shell scripting and Oracle.
• I am a Team player with good interpersonal and communication skills and the ability to work in a team environment, including user/client interaction.
• I have Willingness and ability to quickly adapt to new environments and learn new technologies.
• Hands on experience on DB2 V8.*, V9.*, V10*.
• 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 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
• 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, update 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
• 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 than 3 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.

TECHNICAL SKILLS

RDBMS: DB2 UDB LUW on 8.*, 9.*, and 10.*, SQL Server and Oracle

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 NetBackup, TSM, DB2 Federation, DB2 Query Patroller, DB2 Governor, db2top and db2pd

Application Server: WebSphere, WebLogic, JBoss

Languages: SQL, Shell Scripting, awk, sed

Operating Systems: Linux (Red Hat and SUSE), UNIX (AIX, Solaris), Windows

PROFESSIONAL EXPERIENCE

Confidential, ENGLEWOOD,CO

DB2 - DBA

Environment: DB2 V10.5.DB2 V10.1,V9.7 Sun Solarise, AIX P6, Linux, Oracle, IBM Netezza

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.
• 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
• Setting up the Zero Down Time server as per customer requirement by using database WRITE SUSPEND/RESUME mode.
• Strong knowledge 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 knowledge 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 affect production operations
• On-call 24x7 production support and Training guidance to offshore DBA's
• We have supported L1 activities like database health check monitoring and script executions (DDL, DML), batch jobs monitoring.
• User security management.

Confidential

DB2 - DBA

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’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 v 9.1, V9.5, V9.7 AIX&Linux.

Responsibilities:

• Administration DB2 V9.7 databases on LUW platform.
• Installed and configured DB2 v8, v9, V9.5, V.9.7on Linux, AIX and Windows.
• Database creation and designing.
• Fixpack installation.
• Performance Tuning
• 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.
• 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
• 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.
• Experience in Performance monitoring/testing COGNOS applications
• Experience with RDBMS like Oracle or Microsoft SQL Server
• Experience reviewing SQL to address performance problems

Confidential

DB2 - DBA

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

Responsibilities:

• Responsible for enterprise architecture and performance of DB2 LUW.
• Planned and designed enterprise wide deployment strategies for DB2 installations/fixes, database builds and standard operating procedures.
• Automated or simplified routine tasks such as backups/reorgs/runstats/binds, purge jobs and replication setup via Perl and shell scripting.
• Supported and built active-active databases using update anywhere replication via SQL and Q-replication technologies.
• Mentored and guided developers and application support on DB2 database technology.
• Performed POC's and document latest technologies on new features of DB2
• Coordinated and performed migration of DB2 LUW servers to VMWare cloud environment.
• Supported large number of servers around 200 efficiently using automation and scripts.
• Create scripts for Bench mark testing of DB2 servers.
• Administered database, table and table spaces.
• Moved the data by using EXPORT, IMPORT, LOAD, db2move utilities.
• Monitored Databases using snapshot monitoring and Event monitoring.
• Database backup & recovering the database as per business requests.
• Implemented DB2 Security, Locking and Concurrency Control.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to in corporate the new functionalities.
• Created and modified databases and database objects as per application requests.
• Provided on-call support and well exposed to 24x7 environments.
• Performed SQL Tuning using db2advisor and db2explain tools.
• Updated the DBM and DB configuration parameter.
• Generated SQL Statements using DB2LOOK Utility.
• Worked as part of a database administration team and provided support for critical and non-critical implementation and maintenance issues.
• Performed performance tuning and capacity planning using the parameters of DBM configuration file &DB configuration file and various DB snapshots.