SUMMARY:

• Over 8 years of IT experience in a variety of disciplines. Extensive 7 years of experience in Database Design, Development, Deployment, Migration, Upgrade, Downgrade and Administration.
• Experience in System Build, performance monitoring and tuning, query analysis, optimizing backup, recovery, table reorganization and runstats, handling change Controls, DB2 utilities and tools.
• Expertise in Implementing federated environments by defining server, wrappers, user - mappings, nicknames, and also refreshed existing federation views.
• Experienced in performing redirect restores from production to non-production environments.
• Strong problem determination skills using db2expln, db2exfmt, db2pd, db2dart, db2advis, db2diag, db2top, Snapshots, iostat, vmstat, topas and ps
• Experience in writing shell scripts for automating Database monitoring and performing day to day and weekly tasks, in order to reduce routine Administration Tasks.
• Experience in implementing Table Partitioning, Table Compression, and HADR within and across Datacenter, Read only standby and Log shipping.
• Experience in monitoring and tuning databases using advanced table function such as MON GET* to identify problem in SQL statements and performance bottlenecks, schema changes, configuration changes and explain analysis; working with developers and application team members.
• Experience in developing disaster recovery procedures for offsite recovery of production DB2 environments.
• Experience in maintaining and monitoring DB2 UDB v9.1/v9.5/v9.7/v10.5 Data Mart, warehouse, OLAP, OLTP environments.
• Experience in using DB2 tools such as MQT.
• Team player; sincere and dedicated with strong work ethic and a fast learning curve

TECHNICAL SKILLS:

RDB: MSDB2 UDB v9.1/v9.5/v9.7/v10.5(EE)

Database Tools: db2exfmt, db2expln, db2pd, db2dart, db2advis, db2diag, db2mon, db2top, MDC, MQT, Snapshots

Hardware: IBM 7038-6M2, SUN Fire 4800, Hitachi, EMC, net APP

Operating System: AIX 6.1/7.1, Suse Linux 10/11/12, RH Linux 5/6, Windows 2003/2008/2012 Enterprise and Standard

Application Servers: SAP NW 7.0/7.4/7.5, IBM Web Sphere, WebLogic, Data stage, Informatica Power center

Programming and Scripting Languages: Shell Scripting, SED, AWK, SQL, C, C++, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

DB2 LUW Administrator

Responsibilities:

• Involved in upgrading from DB2 UDB v10.1 FP3 to v10.5 FP5 on AIX 7.1 and Suse LINUX 12.
• Applied fix-packs to keep DB2 UDB at the most recent level on v10.5 ( v10.5 FP 5 to v10.5 FP 7)
• Involved in Database design, performance tuning and troubleshooting issues in DB2 and assisted application developers.
• Expert in setting up HADR Environments, composed necessary Monitoring shell scripts to verify synchronism.
• Analyzed the System behavior and improved the response time of OLTP system.
• Tuning database, database manager and database profile registry configuration parameters.
• Developed automated scripts using Korn Shell for monitoring Lock-Waits’s, Tablespace state, Table state, Buffer pool hit ratio and database growth to make sure the database is healthy and process the db2diag.log to keep track of the errors and send notifications.
• Successfully used Admin move table stored procedure for Reorganizing and compressing the Fact tables and Indexes.
• Worked on automatic storage databases.
• Involved in converting multiple database to automatic storage
• Changed the HWM of tablespaces in DB2 v10.5 in order to reclaim the space to OS file systems.
• Documenting DB2 Defects, test plans, Activity documents, Quality Assurance and Quality Management by way of efficiency at work in the optimum time-frame.
• Implemented federated environments by defining server, wrappers, user-mappings, nicknames, and also refreshed existing federation views.
• Using MON GET* table functions, constantly hunting for custom queries and further explaining those queries using db2expln utility and suggesting right query solution to the end user in situations of Database contention, sorting and locking.
• Performed db2 redirected restores as and when needed to copy data from prod to non-production environment.
• Involved in using db2expln, db2exfmt, db2batch and db2advis on SQL workloads to collect performance statistics that can be used to benchmark database and application changes.
• Extensively worked in identifying I/O, Memory and CPU issues using iostat, vmstat, db2top, ps, topas and nmon.
• Experience in using DB2 utilities such as REORGCHK, REORG, RUNSTATS, LOAD utilities.
• Worked on tablespaces design to accommodate large amount of data and improve the I/O performance.
• Involved in Analyzing and identifying the access strategies which are selected by the DB2 Optimizer for execution of SQL statements including the selection of indexes, join techniques, sorts and table queues using Explain reports.
• Developed database security strategy to provide access to large number of users in production environment.
• Involved in Datacenter Migration to migrate the databases from one datacenter to another.
• Provided 24X7 on call support for production operations

Environment: DB2 UDB v9.5/ v9.7, v10.5, Oracle 11g/12c, AIX 6.1/7.1, Suse 10.x/11.x/12.x, SAP Net viewer, Windows 2003/2008/2012 servers, TSM, Autosys.

Confidential, Chicago, IL

DB2 UDB Administrator

Responsibilities:

• Involved in DB2 UDB v9.5 and v9.7 Upgrades on Data warehouse and Data-marts.
• Test and certify the new versions of software and fixpacks and making proof of concepts.
• Granting and revoking the access to the users and groups on the database and database objects
• Closely working with Informatica team to improve their batch performance
• Worked on corrupted and unrecoverable database to recoverable by using db2dart utility.
• Performed db2 redirected restores as and when needed to copy data from production to non-production environment.
• Experienced in using different utilities such as db2move, Load, export, Import, reorg and Runstats process.
• Experience in creating Wrappers, servers, user mappings and Nicknames to setup a federation view.
• Successfully used online table move stored procedure for Reorganizing and compressing the Fact tables.
• Involved in monitoring Database read and write activity using get snapshot commands, administrative views and table functions.
• Creation of databases and execution of DDL to create database objects like tables, Indexes, views, stored procedures and Triggers.
• Plan and coordinate many production changes and drive them till successful completion.
• Automation of routine jobs using Shell or Perl scripts
• Worked on different escalated issues in DB2.
• Successfully tested and implemented Range partitioning technique on Fact tables.
• Involved in using db2expln, db2exfmt, db2batch and db2advis on SQL workloads to collect performance statistics that can be used to benchmark database and application changes.
• Monitoring the Production batch cycles, resolved various abends, ensure smooth execution of the production batch cycles and availability of the database.
• Drive intermediate Sev-1 issues through the resolution and interact with IBM for resolving high Priority PMR issues
• Implemented Compression to reduce disk and memory requirements, and improve the application performance.
• Efficient in solving problems which are critical during my on call schedule which included all the production databases irrespective of the projects I am involved in.
• Knowledge of comprehensive change control procedures.
• Involved in Capacity planning and space management. Worked on space estimates and tablespace design to accommodate large amount of data in data warehouse environments.
• Supporting the development team and also 24x7 productions on call support.

Environment: DB2 UDB v9.1/v9.5/ v9.7 FP 1, AIX 5.3/6.1, Informatica power-center 8.1/6, Windows NT servers, DB2 Connect, Federated databases and TSM.

Confidential

DB2 DBA

Responsibilities:

• Applied fix-packs to keep DB2 UDB at the most recent level on v9.5 ( v9.5 FP 4 to v9.5 FP 9)
• Automated the backups, runstats, reorgs, moving the transaction logs and db2diag.log, check the skewing of tables
• Worked on DB2 defects along with IBM and applied special builds for the production and development environment.
• Creation of databases and execution of DDL to create database objects like tables, indexes, stored procedures, views, user defined functions
• Responsible for designing, implementing and testing Disaster Recovery procedures.
• Participate as a team member in projects that require outages, upgrades and patches to databases
• Granting and revoking the access to the users and groups on the database and database objects
• Performed db2 redirected restores as and when needed to copy data from production to non-production environment.
• Involved in many project releases in production, testing and development
• Efficient in solving problems which are critical during my on call schedule which included all the production databases irrespective of the projects I am involved in.
• Developed scripts to capture benchmarks for performance of database. Captured and maintained capacity planning reports including CPU, MEMORY, I/O, Disk Space, and Projected utilization based on future business requirements.
• Experience in creating Wrappers, Servers, User Mappings, and Nicknames in federated environment.
• Implemented change controls on weekends in production environment.
• Involved in capacity planning and space management. Worked on space estimate and tablespace design to accommodate large amount of data in data warehouse environment.
• Involved in Monitoring Database Read and Write Activity using GET SNAPSHOT commands or Administrative Views and Table functions
• Provide database backup and recovery support for DB2 UDB
• Worked on db2dart utility to recover the database from bad segments.
• Monitoring the Production batch cycles, resolved various abends, ensure smooth execution of the production batch cycles and availability of the database.
• Supporting the development team and also 24x7 productions on call support.