SUMMARY

• Having around 11.5 Years of experience as a Senior DB2 LUW DBA, DB2 Technical Lead and Enterprise Warehouse Architect on DB2 ISAS.
• Have extensively worked as Production DB2 UDB DBA/Architect in V9.5, V9.7, and V10.1 & DB2 V10.5 (BLU) on huge VLDB systems (200+TB) DPF clusters and IBM Smart Analytics systems EDWs.
• Extensive experience in supporting huge environment (VLDB) in IBM Smart Analytics in DB2 ESE on V9.7 & V10.5 and designing database solutions.
• Expert in setting up DB2 WLM (workload manager) and maintain/support the same.
• Have successfully completed Executive Management Program from Indian Institute of Management (IIM Lucknow) in 2013 on Advanced Strategic Management.
• Summary of total experience as a DB2 LUW DBA
• Worked as a Senior DB2 Subject Matter expert and Sr DB2 DBA for DB2 LUW on all L4, L5 Production issues.
• Complete Implementation and set - up of multi terabyte DB2 DPF environment.
• DB2 DPF Database Backup and Restoration of 200+ TB of data.
• Have extensively worked on DB2 to HADOOP data movement utilities.
• Excellent hands-on experience in all kinds of implementation in the latest DB2 versions starting from V9.1 to V9.7, V10.5 Data-warehousing Projects, DB2 Architecture set-up & Migration on SAP and Non-SAP databases.
• Have extensive experience in designing database solutions for business requirements.
• Sound experience in Data Warehousing and ETL.
• Good experience in the administration of DB2 UDB Version 8 to till 10.5 with BLU, Partitioning and HACMP (PowerHA) for databases.
• Good knowledge of Change Management process and Configuration Management.
• Assist in capacity planning, space management and data maintenance activities for database system. Perform database enhancement and modification as per the requirements.
• Varied experience in different environments - OLTP, DSS and knowledge of allied tools for ETL.
• Experience in Disaster Recovery solutions for HADR including designing, configuring and ongoing support.
• Experience in set-up, implementation of Q-Replication and ongoing support .
• Have worked on leading & managing teams on multiple Account / Project transitions from different customers based in USA & Canada to IBM’s IT infrastructure.
• Have always worked as a DB2 specialist in handling L4/L5 issues and customers escalation handling for different clients.
• Have sound experience in implementing Latest Features of DB2 BLU (10.5), Database Partitioning Features (DPF), Range Partitioning, MDC, Range Clustered Tables, MQTs, Replicated MQTs, Table Compression, Complete TSM Set-up for DB2 backups, Replication using Event Publishing, DB2 Installation and configuration, DB2 performance tuning and troubleshooting.
• Have extensive experience as a DB2 LUW DBA on Both OLTP systems as well as on DWH systems on huge DPF multi-partition system on RAID-10 (QUAD-CORE), RS/6000 system on Linux/Unix/Aix.
• Have expertise in handling 24x7 high transactional mission critical production databases.
• Expertise in Performance tuning, problem research and resolution.
• Expertise in identifying and resolving problems using strong analytical technique, innovative approaches, and taking initiative in preventing and solving problems.
• Major customers worked for during the last few years are: Confidential, Expedia Inc, State Street Bank and Trust, Boots UK, Mead Johnsons, Celero Canada, CHS - EIW, Morgan-Stanley, IBM Data Center serving multiple telecom giants.

PROFESSIONAL EXPERIENCE

Sr DB2 DBA

Confidential, Greater New York Area

Responsibilities:

• Designing, developing, implementing and administering DB2 LUW v9.7, v10.1 databases for chase OLTP applications and Enterprise Datawarehouse .
• Maintain and facilitate standard backup procedures, retention plans, and restore testing.
• Data migration between different systems and data-centers including regular data refreshes
• Work pro-actively to gauge the performance of the application & database and provide recommendations to achieve the optimal architecture
• Possess impact on performance with different changes and review scalability of the infrastructure.
• Consult with vendors & other teams to recommend best practices and tune software during the development cycle.
• Assist in tuning SQL in stored procedures.
• Perform testing and production builds involving data changes and stored procedure building while following established change management procedures
• Implementing and administering HADR for High Availability .
• Implementing and Administering Q-Replication for IBM DB2 Databases .
• Handling and managing high transactional mission critical production databases.
• Designing database solutions for business requirements .

Sr DB2 DBA

Confidential, Bellevue, Washington

Responsibilities:

• Sr. DB2 DBA LUW on ISAS - DPF Linux2.0 supporting Global EDWs with size more than 200 TB.
• Working on restoring huge Multipartition DPFs on DR Environment with size more than 200 TB (every week) on 72 Physical Nodes DPF cluster.
• Supporting all aspects of DB2 on DPF starting from Build work, Production Troubleshooting, Performance Tuning, IBM PMRs, IBM Optima High-performance Data load, DB2-Hadoop Integration, ETL and Database designing etc.
• Worked as a Senior DB2 Subject Matter expert and Sr DB2 DBA for DB2 LUW DBA Team in Expedia Inc USA on all L4, L5 Production issues.
• Complete Implementation and set-up of multi terabyte DB2 DPF environment.
• DB2 DPF Database Backup and Restoration of 200+ TB of data.
• Have extensively worked on DB2 to HADOOP data movement utilities.
• Excellent hands-on experience in all kinds of implementation in the latest DB2 versions starting from V9.1 to V9.7, V10.5 Data-warehousing Projects, DB2 Architecture set-up & Migration on SAP and Non-SAP databases.
• Sound experience in Data Warehousing and ETL.
• Have sound experience in implementing Latest Features of DB2 BLU ( 10.5), Database Partitioning Features (DPF), Range Partitioning, MDC, Range Clustered Tables, MQTs, Replicated MQTs, Table Compression, Complete TSM Set-up for DB2 backups, HACMP Set-up ( Power HA ), DB2 Installation and configuration, DB2 performance tuning and troubleshooting.
• Have extensive experience as a DB2 LUW DBA on Both OLTP systems as well as on DWH systems on huge DPF multi-partition system on RAID-10 (QUAD-CORE), RS/6000 system on Linux/Unix/Aix.
• Have expertise in handling 24x7 high transactional mission critical production databases.
• Expertise in Performance tuning, problem research and resolution.
• Have extensive experience in designing database solutions for business requirements.

Project Lead and Senior DB2 SME

Mead Johnson Nutrition

Responsibilities:

• Senior SME and Project Lead for DB2 LUW DBA Team in IBM Global Delivery supporting multiple customers starting from Project Transition from client place in USA until implementation and final steady-state set-up and end to end production support.
• Has worked on DB2 V8.x and on DB2 V9.1/9.5/9.7 on Linux, AIX and Windows.
• Worked in DB2 V9.1, V9.5, V9.7 DPF new features and enhancements in 9.7.
• Worked on implementing High Availability solution on POWER- HA (HACMP), HADR set up and administration, SQL-Replication, Federation.
• Have extensive experience in designing database solutions for business requirements.
• Assist in DB capacity planning, space management, sizing and data maintenance activities for database system, DB2 Architecture and processes. DB2 Backup set-up on TSM client.
• Along with Business Systems Services, installs and maintains software used for supporting and monitoring DB2. Applying upgrades along with Business System Services to DB2 in test and production.
• Assisting all development work on DB2, This includes helping with application development, designing and creating database objects, migrating from test to production, and implementing batch schedules with the appropriate DB2 utilities.
• Has extensive experience as a DB2 Production DBA working in end-to-end implementation of new DB2 UDB Servers starting from Installation, Implementation, Migration (Mainframe /UDB), DB2 Version Migration (from V8 to V9.x), Development ( SQl/Pl, Stored procedures, triggers, MDC /MQT, Range Partitioning etc), DB2 Recovery etc along with setting-up and automating DB2 Monitoring system to minimize human interference (Space, CPU, Archive-Logs, weekend maintenance like Purging/Archiving/Reorg/Run stats/Rebind etc).
• Assure best practice sharing with in the pool in the Form of Tech Talks and group discussions.
• Present in Major incidents bridges and performed RCA for all MIM’s.
• Performed Technical deep dives for all Accounts and initiated Defect prevention.
• Handled vendor interactions under critical situations to avoid escalations and faster resolution.
• Ensured Technical assessment for all Change implementations in the Pool/Account.

Confidential

DB2 Database Administrator and Architect

Responsibilities:

• Working as an overall database designer and architect and catering to DBA needs for different Production and Non Prod Database environments.
• Implementing policy and process for Archiving and Purging data on very large OLTP/DWH system in terabytes.
• Performing data migration activities from Mainframe/ADABAS to DB2 UDB Servers on AIX/Linux.
• Implementing COMPRESSION and achieve up to 70% compression.
• Setting-up automated scripts and tools to monitor real-time database activity & health.
• Setting up and working with Federated Environment.
• Writing DB2 load scripts, stored procedures, shell scripts using awk, triggers, SQL/PL scripts.
• Performing Table Data Roll In/Roll Out using DB2 Range Partitioning Features.
• Writing DDL to perform changes to DB2 objects (Tables, Indexes, Triggers, Stored Procedures, Views and Functions etc).
• Analyzing and advising on capacity planning based on transaction volumes and growth.
• Creating database utilities and routines for the maintenance of DB2 objects.
• Performance tuning of DB2 Database Server including Bufferpool Tuning/Query Tuning/Database Parameter Configuring and Tuning using various best practices and different methodologies available from IBM.
• IO Tuning Including Bottleneck and Resource Contention Minimization.
• Utilizing performance monitoring tools to determine program in-efficiencies.
• Working with development staff providing assistance with SQL, program architecture, performance issues and other areas related to data integrity.
• All other housekeeping staffs for the Production Database Servers.
• Performance Tuning for poorly performing applications/queries.
• Different DB2 Code Page Conversions while managing and storing data in different Languages (Spanish, Japanese).
• Table Partitioning Scheme Generation and Implementation Including Range, Hash, and Composite.
• Working with AUTOSYS commands for scheduling database jobs.
• Database Designing and creating DB2 structures including logical and physical data modeling, table design and index design.
• Index Identification & removal of redundant Indices from the system.
• Using Buffered INSERT/LATERAL Insert, Replicated MQT refresh, GLOBAL Temp Table etc.
• Worked on implementing High Availability solution on POWER- HA (HACMP), HADR set up and administration, SQL-Replication, Federation.
• Implemented scripts for space, database management alerts.

DB2 Database Administrator

Confidential

Responsibilities:

• Taking complete ownership of the production servers assigned as a database administrator.
• Installation of DB2 applications version 8.2, V9.1 on Windows NT/2000 and AIX 5.3.
• Upgradation of Databases using fixpak installations.
• Create and manage DB2 instances and databases and various DB2 UDB storage objects.
• Automation of database monitoring and maintenance tasks using Unix shell scripts.
• Monitoring and management of databases on a multi-partitioned environment.
• Implemented scripts for space, database management alerts.
• Prepared the backup strategy for the Applications and Implemented Backup scripts.
• Performance tuned various databases involving database parameter tuning, query optimization, run stats and Reorg database maintenance utilities.
• Performed database migration of critical servers using automated scripts for redirected restore.
• Worked in configuring HACMP and HADR, SQL - Replication.
• Performed data purging of huge data.
• Conducted internal trainings on DB2 Database Administration.
• Database Designing and creating DB2 structures including logical and physical data modeling, table design and index design.
• Tracked and controlled user authorities and accesses to the servers and databases.
• Performed data maintenance operations using utilities for data load, import and export.
• Interacted with IBM Support team (PMR) for providing solutions.

Confidential

DB2 Database Administrator

Responsibilities:

• Create and manage DB2 instances and databases and various DB2 UDB storage objects.
• Automation of database monitoring and maintenance tasks using Unix shell scripts.
• Monitoring and management of databases on a multi-partitioned environment.
• Implemented scripts for space, database management alerts.
• Prepared the backup strategy for the Applications and Implemented Backup scripts.
• Writing Shell Scripts for monitoring the jobs and complete automation of the DBA tasks.
• Stored Procs and Trigger development.
• Database designing and troubleshooting.