SUMMARY

• Over 8+ years of professional and progressive experience in IBM DB2 UDB with emphasis on Database Administration, Architect, development, migration, Analysis, Application design, testing, implementation and production support of critical OLTP, OLAP and Data warehouse environments.
• Have extensively worked as Production DB2 UDB DBA in V9.5, V9.7, and V10.1/10.5 on huge VLDB systems.
• Extensive experience in implementing replication, backup and recovery strategies, performance tuning and installing DB2 and extensive experience using DB2 LUW/UDB EE and DB2 LUW/UDB EEE on LINUX/UNIX platform
• Very good experience in WebSphere, WebLogic, JDBC, Tomcat and experience with Databases running under VMware, RedHat Linux, Virtual Storage Pools.
• Good experience in EXPORT, IMPORT and LOAD utilities, moving data between servers.Well acquainted with backup and recovery of database, online database backup, archived log files and offline database backup.
• Installed, set up and configured SAP Basis on DB2 UDB platform respectively.
• Extensive experience on migration (dbrehosting/consolidation/upgrades) assignments involving DB2/application migrations across like to like or cross platforms involving zlinux (Linux on z - series), p-series, AIX, RHEL, SUSE, x-series, windows platforms.
• Worked on SQL Replication and Q Replication. Well versed in all aspects of Relational Database Design and Administration like logical and physical database design, creation, maintenance, backup, recovery strategies, performance monitoring and tuning, problem identification and resolution, security and disaster recovery planning in both OLTP and OLAP/DSS (Data Warehouse Environments).
• Scheduling regular backups / Image Copies to disks, TSM and HP Data Protector tool. Proficient in creating database objects such as tables, table spaces, indexes, views, and aliases and altering tables and adding check constraints and referential integrity.
• Expertise in DB2 UDB Administration involving Performance Tuning, backup, Flashcopy and recovery, space management, disaster recovery and maintenance, HADR, TSA. Competent in monitoring databases using snapshot monitor and event monitor.
• Client server communications configuration experience using TCP/IP, NetBIOS, SNA (APPC), IPX/SPX, and clustering over system area networks with TCP/IP and Virtual Interface Architecture (VIA) protocols.
• Database utility experience including reorg, runstats, rebind, export, import, load, auto-load, backup, restore and recover database utilities.
• High availability (HA) and disaster recovery (DR) experience with DB2 HADR, offline transaction log shipping, split mirror images, data replication, and Microsoft Clustering Services (MSCS) using SCSI and SAN subsystems.
• Database and SQL statement access plan optimization experience with DB2’s Explain, Visual Explain, and Design Advisor tools.
• Extensive work experience in DB2 Data Replication (DPropR) and Stored procedure (SP), user defined function (UDF), and user defined table function experience with DB2 SQL/PL.
• Database analysis, design, and reverse-engineering experience using Power Designer Data Architect, Embarcadero ER/Studio, and ERwin.
• DB2 system, instance, and database security and auditing experience using table definitions, triggers, data replication, and automated monitoring and alerting of security events recorded by the DB2 Audit Facility.
• Extensive experience automating database maintenance and monitoring with shell scripts including automating system event logging, e-mail alert notification, and reporting using the DB2 utilities and Command Line Processor (CLP) with the Windows Shell, Windows Scripting Host (WSH), and Open Object REXX.
• Database migration experience from DB2 on Sybase ASE and Sybase SQL Anywhere to DB2 for Linux with the IBM DB2 Migration Toolkit.
• IBM Problem management, and resolution (PMR) experience with DB2 diagnostic log facility, administration notification log, trace facilities, db2 inspect, DB2 database analysis reporting tool (db2dart) and the IBM DB2 Lab.
• Experience in operational 24x7 support, best practice troubleshooting, monitoring, and maintenance.

TECHNICAL SKILLS

• DB2/UDB V8
• V9
• V10.1
• V10.5 DB2 Utilities
• DB2 Performance Monitor
• Platinum DBA Tools andUtilities
• SQL REP
• MQ REP
• Unix Scripting
• Relational Modeling Tools
• BMC Database Suite
• Quest
• DB2PD
• DPROP
• BMC Patrol
• Java
• DB2 Compression
• Windows
• AIX
• Linux
• SQL shell scripting KSH
• CSH
• SAP
• Siebel and PeopleSoft

PROFESSIONAL EXPERIENCE

SAP DB2 LUW DBA Consultant

Confidential, Dublin, OH

Responsibilities:

• Involved in Datacenter Migration from one region to other region followed by HA and DR Testing.
• Resolved issues encountered on Dev, QA, stage, production and test database environment.
• Implemented fail over solution for SAP Databases using HADR and TSA.
• Involved in DR Testing and implemented 4 way HADR.
• Configured NetBackup for new databases.
• Involved in upgrades from v9.7/10.1 to v10.5 and applying fix packs.
• Managing project transition, client handling, POC and preparing SOP’s.
• Working with Unix team for Organic growth on servers as part of projects.
• Granting/revoking permissions on Database objects and security.
• Performed online and offline backups as well scheduled them in crontab and redirect restores.
• Configured DBM and DB CFG changes as per SAP and IBM Recommendations.
• Improved application performance by running RUNSTATS, REORGCHK and REORG utilities.
• Maintained SAP Databases of TB’s size.
• Installed, Configured and upgraded DB2 AESE and ESE.
• Involved in performance tuning, recommending SQL queries for better performance using snapshot monitor, visual explain, index advisor, db2expln, db2exfmt.
• Involved in SAP EhP Upgrade Projects and support for DB related activities.
• Assisted Cloud team in Migrating Databases from On-premise to AWS cloud.
• Completed training on AWS Solution Architect.
• Monitoring setup for DB2 databases by using Confio and DSM tools.
• Configured HADR and TSA for Automatic Replication (IBM CDC) failover.
• Developed scripts for health checks and alerts for Splunk monitoring.
• Experience in good troubleshooting techniques to ensure quick and successfulresolutions (snapshot, db2pd, db2top etc.).
• Managed database loading, migrating and maintaining data with LOAD, EXPORT, IMPORT DB2LOOK.

DB2 UDB Database Administrator

Confidential

Responsibilities:

• Used UDB DBA maintenance activities like reorgs, runstats, back-up, restore, expanding and reducing the tablespaces etc.
• Implemented TSA with HADR across Dev, QA, Pre-Prod & Production Servers.
• Handled IBM Technical support for TSA and implemented the special builds sent by the IBM support to enable smooth functioning of TSA environment.
• Performance tuning of the OLTP applications running on the system.
• Done UDB DB2 database tuning by dealing with Database & Registry variables to enable speedy transactions.
• Used SAP DB6 Cockpit, to maintain UDB DB2 SAP databases.
• Creating and Maintaining DB2 Federated systems with data sources across heterogeneous database (DB2, Oracle, Sql Server) environment using DB2 Data Joiner and Relational Connect for migrating, converting and populating shared organizational data.
• Installing and configuring JDBC connectivity for JAVA, ODBC connectivity for APPSERVER for accessing Portal Databases.
• Implemented on High Availability using both HADR and HACMP features
• Used Informatica as an ETL tool to Extract, Transform and Load data to flat files extracted from the operational database and exported to the data warehouse setup.
• Developed ETL routines using DB2 load, unload utilities, DB2 connect, (data warehousing) and imports/exports.
• Designed the disaster recovery strategies, which involved the backup and recovery procedures, setting up of HADR across UNIX clusters, HADR with TSA (Tivoli Software Automations) Implementations.
• Implemented DB2 Audit Facility and SSL across multiple servers for the enterprise level DB2 Database.
• Worked extensively on db2move, Export, Load for exporting it to a file and then importing from the file to the database respectively i.e. moving the data from one database to the other one.
• Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.
• Support production environments, configuration, testing, and performance tuning of all DB2 database environments. Verify the database support requests and execute them in timely manner as the business SLA's.
• 24X7 Production DBA support for application development, deployment and support activities.
• Extensive experience supporting DB2 system administration, application development,
• Troubleshooting and resolving DB2 issues, performance tuning, monitoring data security and integrity.
• Responsible for performance tuning, support, analysis and resolution of database problems that occurs during the critical time processing.

Environment: DB2 Version 10.1/10.5, AIX, LINUX, DB2 Connect V 10.1, Jira Ticketing tool, Shell Scripting, BPM, Websphere, Quest Central, TOAD, SAP, DB2 Migration Toolkit.

DB2 DBA (SAP)

Confidential - Atlanta, GA

Responsibilities:

• Experience in administration of the large databases in terabytes.
• Experience in adding the data storage to the automatic storage database
• Experience in applying the fixpacks from Db2 9.7 FP4 to Db2 9.7 FP 6.
• Experience in troubleshooting skills of hanging of the databases due to TSM problems
• Expertise in staging the new servers builds.
• Scheduling the cronjobs for backup, runstats and other DB maintenance activities in AIX
• Expertise in the restore of the point in time recovery of the databases.
• Expertise in troubleshooting DB2 job failures and providing resolutions.
• Expertise in Performance Tuning, Monitoring of DB2 database on Linux and AIX using DB2
• Recommend and implemented fail over solution for SAP and other WAS architecture using the new IBM DB2 HADR (High Availability Disaster Recovery) capability
• Work with the Basis team to install the various SAP application servers and load balancing components and integrate such with the database servers on Oracle and DB2 UDB platforms.
• Startup, shutdown the SAP Central instance and application servers as requested by the environment team and as situation demanded.
• Disable unneeded Siebel server component groups and server components to conserve memory for other processes.
• Consistently ensure that SAP Central Instance, application servers, database server and web components are available by constant monitoring of the SAP environments using shell scripts and CCMS tools - all integrated with TSM Monitors.
• Installed, upgrade and apply fixpaks on DB2 UDB, Oracle and Sql server databases.
• Setup users and enforced security policies in DB2 UDB, Oracle and Sql server databases modules.
• Installed and configured MQSI broker and repository application server on top of a DB2 UDB and Oracle databases.
• Provided 24x7 hours support for service requests and on-calls for DB2 related problems in production environment.

Environment: SAP, DB2 UDB 9.7, FP 6, 8, DB2 10.1, SUSE Linux 10 and Red Hat Linux.

DB2 UDB Database Administrator

Confidential - New York

Responsibilities:

• Provided DB2 database migration for Confidential DB2 v9.5/v9.7 migration project.
• Installed and configured DB2 v9 .7fp5 on Linux, AIX and Windows.
• Migrated DB2 v9.5 databases to DB2 V9.7
• Change Management - Schedule change, get approvals, do broadcast and work on change tickets.
• Data refresh at table level and database refreshes across prod/non-prod environments.
• Performance Tuning of all UDB instances - identifying performance degrading factors and taking corrective measures to improve server and query performance. The tuning efforts ranged from physical I/O tuning, memory cache optimization, Application Tuning included query optimization and Proper index selectivity.
• Monitor table space growth statistics for the production databases and estimate the size for the month/year by actively participating in Capacity Planning meetings with users and managements and drew out relevant statistics for upper management to study.
• Moving databases from Development to Production after successful completion of application testing.
• Installed/ Configured CDC in LUW/AIX.
• Designed and implemented strategy for running data reorg/runstats on timely basis for large tables to avoid data fragmentation and improves performance and system throughput.
• Supported developers to write SQL statements and test them before running it in Production environment. Take the backup of the database when restarting the dprop.
• Database backup & recovering the database at the time of crash.
• Displaying and Setting up the environment variables. Updating the instance and database configuration parameters dbmcfg and dbcfg respectively.
• Ran db2move, Export, Load for exporting it to a file and then importing from the file to the database respectively i.e. moving the data from one database to the other one.
• Responsible for successful execution of the ticket, documenting status, providing feedback to the owner and closure of the tickets.
• Support production environments, configuration, testing, and performance tuning of all DB2 database environments. Verify the database support requests and execute them in timely manner as the business SLA's.
• Perform DB2 installation, configuration, and upgradation and install fixpacks to keep DB2 at most recent level on AIX, LINUX, Solaris servers including in HADR environment.
• Drive intermediate Severity-1 and Severity-2 issues through to resolution.
• Worked extensively with backups (Offline and online), restores, redirected restores and backups/Restore using TSM and table compression.
• 24X7 Production DBA support for application development, deployment and support activities.

Environment: DB2 Version 9.7.x/9.5.x, AIX, LINUX, DB2 Connect V 9.7, BMC Patrol, DPROP, HP Service Manager, Microsoft Cluster, Control-M, Windows Server 2008 R2 enterprise, Shell Scripting, BPM, TSM, PowerShell, Java, JSP, AIX, LUW, SQL Server, Oracle and MySQL.

DB2 Database Administrator

Confidential

Responsibilities:

• Administration of database, table and table spaces.
• Moving 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. Migrated from V8.2 to V9.1
• Create and modify databases and database objects as per application requests.
• Provided on-call support and well exposed to 24x7 environments.
• Daily and weekly database Maintenance activities such as backup, runstats, reorg and all related activities for databases.
• Worked on SQL Tuning using db2advisor and db2explain tools.
• Updated the DBM and DB configuration parameter.
• Generated SQL Statements using DB2LOOK Utility.
• Apply fixes and patches as necessary to DB2 UDB & Oracle database environment to keep track of cutting edge technology.
• Develop a problem tracking applications that assigned all related systems errors/problems to appropriate database and / or application personnel using remedy.
• Design the backups and recovery strategies for Oracle databases from 7.3 thru 10g and DB2 UDB databases to meet our customer SLA requirements.
• Managed major resources deployment within departmental budget by assigning DBA personnel according to their skill sets and interest and make proposal for training and professional development.
• Multi-tasked by managing other projects within departmental budget and resources when assign by senior management personnel.
• Installed, setup, configured and manage data replication using Oracle 10g Streams and DB2 UDB data propagator respectively.
• Installed, setup, configured and manage high availability topology for Oracle and DB2 UDB environment using RAC, DataGuard and DB2 high availability disaster recovery (HADR) respectively.
• Manage and provide steady state support for Oracle database RAC environment after implementation and go-live.
• Installed, setup, configured and manage federated systems using Oracle and DB2 UDB as data sources respectively.
• Installed, set up and configured SAP Basis R3 4.6C on Oracle and DB2 UDB platform respectively.
• Setup and configured the SAP Central Instance and other application servers within the Landscape.
• Installed, set up and configured SAP Solution Manager for SAP R3 4.6C on Oracle and DB2 UDB platform to monitor the entire enterprise.
• Perform SAP architecture sizing and capacity planning to meet SAP enterprise deployment.

Environment: DB2 Version 9.7/9.5.x/9.1.x, DB2 Connect 9.5.x/9.1.x, AIX 6.1/5.3, Web sphere Federation Server 9.5.x, DB2 Client 9.5.x/9.1.x, BMC Patrol, HP Service manager, Control-M

DB2 Database Administrator

Confidential - Jersey City, NJ

Responsibilities:

• Managed database instances for Consolidated Online trading system in DB2 UDB in version 8.x and 9.x on AIX 5.3 and Linux servers.
• Provided DBA 24x7 on call Support for company wide UDB Production databases. Responded and troubleshoot all database related issues and had a 100% on-time resolution for all PROD and DR issues. As a result no Production or DR database had any downtime throughout the years.
• Managing DB2 UDB databases on 30 Unix servers, sizes up to a few hundredsGBytes. Troubleshoot all database related problems.
• Analyzed and tuned problematic SQL statements, As a result, the response time of some slow running queries went from hours to minutes or in some cases even to seconds, resulted in dramatic reductions in application processing time.
• Assisted developers with the performance test initiatives. Performed index analysis and made recommendations to development teams.
• Work with BMC team to comprehensively test and configure UDB Monitoring thresholds and scenarios for version 8.2 and 9.1 to ensure BMC monitoring was available when databases were upgraded in Production environment.
• Responsible for researching various UDB FixPacks for v8.x and v9.x and provided assessment of these FixPack to the upper management. Applied various FixPacks to v8.x and v9.x database servers.
• Installed Performance Expert and OPM (Optimal Performance Manager). Configured and tested both software products in Engineering, test and QA servers.
• Performed backup and restore functions using TSM. Redirect restored test databases with production databases. Moved databases from one server to another or from existing file systems to new file systems.
• Managed some Oracle databases for multiple applications and functioned as an Oracle backup DBA.

Environment: DB2 UDB v7.x, v8.x, v9.x, UNIX, Linux, Oracle, PERL, Shell Script, BMC Patrol, DB Artisan, Control Center, Performance Expert, Optimal Performance Manager (OPM).

DB2 UDB Database Administrator

Confidential

Responsibilities:

• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis on SQL Server 2000.
• Performed all responsibilities of an Application DBA involved with the DDL statements to create, modify or Alter Database Objects and also involved with performance tuning of complex SQL Queries.
• Tuned LOCKLIST parameter and Upgraded DB2 UDB instance from 32 bit to 64 bit and installation of latest FixPak.
• Supported Migration of Oracle Database to DB2 UDB Using IBM Migration Toolkit.
• Converted Stored Procedures and Triggers from Oracle to DB2 UDB.
• Created/Altered database objects (tablespaces, schemas, tables, views, indexes, triggers, stored procedures etc).
• Automated backups (both online and offline), Reorgs, Runstats, Space monitoring, moving db2diag.log, monitoring size of tablespaces by setting up a threshold
• Worked heavily with data movement utilities IMPORT, LOAD, and EXPORT under high volume conditions
• Developed groups of Views organized by multiple table schemas which allow different sets of users to selectively access different subsets of data by different naming conventions, but allow all users access to the same underlying physical data. Supported this on the security level by developing GRANT scripts to allow only appropriate user's access to certain Views
• Demonstrated ability in database design and implementing appropriate changes to the physical database (indexes, database and server configurations, etc.) as needed for optimal performance
• Creating EXPLAIN tables and running visual explain utility on sql statements
• Tuned database and Database manager configuration for optimum performance. Experimented with changing buffer pool and table space page size to improve time taken by ETL to build data marts
• Performed database loads and unloads.
• Supported PeopleSoft Applications in a DB2 UDB EEE Environment.
• Used TSM for backups and User Exit for archival logging
• Provide on-call (24X7) support for all production databases

Environment: DB2 UDB for LUW, Fixpack, AIX, Oracle, IBM Migration Toolkit, Erwin, Linux, PeopleSoft, TSM, SQL Server, Quest Central and Toad.