SUMMARY

• Hands - on experience on DB2 v8.x, v9.x, v10.x, v11.
• Experience on End to End implementation of Q Replication.
• 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, updatetables 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 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.

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: ManageNow, BMC Remedy, Maximo and Service Desk.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, Nebraska

Sr. DB2 DBA

Environment: IBM DB2 V9.5, 9.7, 10.1, 11.1 DB2 Pure Scale, AIX 6.1, TOAD, OPM, Erwin, TSM, Q-Replication, Data Stage, Cisco Storage Manager, Flash Copy Manager.

Responsibilities:

• Responsible for installations for DB2 ESE on AIX/Linux environment and migration of DB2 UDB version 9.1 to DB2 UDB V9.5, V9.7, V10 and V11.1.
• Worked with DB2 LUW V8 and V9.5, 9.7, 9.8 Pure Scale and above.
• Implemented HACMP Strategy and High Availability Disaster Recovery (HADR with TSA), Federation, Performance monitoring and fine tuning OLTP and DSS Applications, and Problem determination and troubleshooting.
• Interacted with UNIX and Application group, and playing a diverse role with a large team of DBAs.
• Extracted Mainframe data, using Data Stage to DB2 LUW.
• Implemented Q-Replication method to sync data from OLTP to Data Warehousing environment.
• Created large table spaces, using Automatic Storage Management.
• Supported UDB DB2 4 node cluster from the server side and allocated additional disks for the Pure Scale cluster.
• Used Erwin data modeling tool for designing logical and physical data model.
• Monitored and tuned database software after installation and applied fix packs for peak performance.
• Mentored customers on managing complex environment, database performance tuning through database physical design, configurations and implementations of data aggregations, MQTs, partitioning, indexing and related settings.
• Extensive Knowledge on Shell Scripting.
• Performed database objects creation and alteration (tables, indexes, views, stored procedures, functions).
• Responsible for query performance optimization, tuning implementations, and production support.
• Established standards, controls, and procedures to ensure data integrity and security.
• Established effective security processes plans and policies, like SOX.
• Command Substitution is also done using shell scripting.
• Implemented database auditing with the help of db2audit tool.
• Implemented security administration tasks, such as identification and authentication controls.
• Performed version migrations from V9.7 and V10.1.
• Provided recommendations for ongoing tuning of environment based on growth projections.
• Monitored tasks with respect to database performance on packaged applications.
• Escalated performance exceptions and worked with the application.
• Supported team to improve package performance.
• Implemented Backup/Recovery of databases.

Confidential, Middletown, NJ

Sr. DB2 DBA

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

Responsibilities:

• Installation and Configuration of DB2 environment in LUW.
• Upgradation of database from v9.5fp7 to v9.7fp11 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 knowledge in Database Physical Support and Design.
• Shell Scripting is used for manipulation of files, executing programs and text printing.
• 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.