• DB2 fix pack and database upgrades; client installations
• Monitoring and administration of DB2 LUW Versions 9.5 to 11.1
• Performing backups and restores
• Automation of DBA functions via scripting
• Participating in on-call rotation and working in shifts.
• Generating and analyzing db snapshots and provide performance guidance
• Stored Procedures for transformation and processing data.
• Capacity planning and Storage design [bufferpool sizing, tablespace partition groups depending on containers’ design, partitioning keys implementation, MDC organize by columns etc]
• Performance monitoring, lock analysis, transaction analysis, statement analysis using db2top

DB2 DBA

• Responsible for successful delivery of DB2 Connect product for all DB2 fixpaks since DB2 9
• Worked on logical and physical implementation of p-series boxes for testing
• Participated in maintenance scripts development, testing. Wrote scripts for monitoring and redirected restore
• Large table partitioning
• Installed and configured DB2 UDB 9.1,9.5,9.7 and their fixpaks on multiple servers [LUW]
• Installed and tested DB2 connect gateway
• Automated the entire process of installing WAS and deploying the application
• Provided technical support to applications developers including guidance during SQL query development and overall applications performance issues pertaining to the ongoing development effort.
• Responsible for designing and planning database layout for optimal performance, monitoring and tuning DBM and DB configuration, bufferpools, capacity planning, software maintenance, HA (High Availability) design, replication setup for DR (Disaster Recovery)
• Performing day-to-day administration tasks such as creating new objects, reviewing SQL code, troubleshooting as well as scheduling and running backups, runstats, reorgchks, reorgs, binds, etc.
• Implemented DB2 database partitioning on 4 linux physical server (18 logical nodes).
• Create/maintain shell scripts to monitor and maintain the DB2 UDB database environment
• Recommended and implemented UDB instance parameters changes for optimal performance.
• Reproducing customer-specific issues in test environment and work closely with development to fix them
• Work in agile methodology-based environment, conduct and participate in scrums and meet the stipulated deadlines

• Performance tuning for SQL queries, reports and data load scripts for ETL/Data Warehouse projects
• Integrate database tuning activities into transport and release process (review and verify releases in each environment of each system)
• Provide performance guidance for developers and analysts
• Design maintenance and optimization processes (table/index compression, range partitioning, table space reclamation, MQTs, MDCs, archive, REORG, and RUNSTATS)
• Diagnosed the need and implemented data partitioning for the tables
• Administer / maintain DB servers having 4-8 cores and upto 2 TB storage each.
• Tuned complex SQL queries to increase performance by 30%
• Planned, designed and implemented db2 security structures in db2 v97, db2 v10.1 across the entire client BI application landscape of 20 servers
• Validated the impact of fixpak upgrades and research the new features of upcoming product releases
• Installed DB2 on new servers and perform DB upgrades and migrations to new versions v10.1 and v10.5
• Understanding of various schemas and their pros/cons: star schema, snowflake schema, and 3rd normal form
• Proficient in identifying project needs, estimating and prioritizing tasks, setting intermediate goals and milestones to accomplish the final outcome