SUMMARY

• Over 7 plus years of IT experience with emphasis on database design, administration, maintenance and performance tuning using DB2 UDB (ESE) on UNIX and NT.
• Worked through all phases of system development life cycle and has performed as a senior level DB2 LUW DBA.
• Extensive DB2 LUW DBA and DB2 Connect experience with activities involving design, installation, configuration, requirements gathering, data modeling, tuning, security, backup, recovery and integration of database applications.
• Expertise in developing support activities including installation, configuration and successful deployment of changes across all environments.
• Provided production support for critical applications on a 24x7 rotating basis.
• Experience in writing shell scripts for various kinds of administration and maintenance tasks.
• Extensive Experience as LUW DBA in AIX, Linux and Windows.
• Involved in setting up SQL Replication between sources and reporting databases.
• Expertise in developing support activities including installation, configuration and successful deployment of changes across all environments.
• Provided production support for critical applications on a 24x7 rotating basis for databases on EE & EEE
• Data maintenance utilities used REORG, RUNSTATS, RESTORE, LOAD, QUIESCE, IMPORT, EXPORT, DB2LOOK, and DB2MOVE.
• Solid experience on IBM tools like db2pd, db2top, db2explain and db2advis
• Involved in implementing Disaster Recovery strategy.
• Setting up High Availability Disaster Recovery (HADR) and involved in testing failover scenarios.
• Worked with third party tools like Embarcadero DBArtisan and Quest.
• Implemented backup compression technique.
• Database space management
• Solid experience on IBM tools like db2pd, db2top, db2explain, db2advis and db2move.
• Data Migration / Data Transfer between different systems and databases.
• Excellent Interaction with Functional and business analysts, department Managers, different levels of users, developers and experience with Software Development Life Cycle.

TECHNICAL SKILLS:

H/W AND OS: AIX 5.X, 6.X, & 7.X, S4500, Windows NT, Windows 2005 & 2008 server, Red hat Linux 5/6

DBA TOOLS: Control Center, Visual explain, Platinum Erwin/ERX, AQT, QUEST, DPROPR, SQL*PLUS, SQL*Loader, SQL*NET, DB Artisan, TOAD, IBM Data Studio 4.1

SOFTWARE: DB2 UDB 8.x and 9.x,10.x DDL, DML, DCL, DB2 utilities, Web sphere, DB2 Connect, SAP Basis.

LANGUAGES: SQL, C, C++, Java 2, Java script, XML, HTML.

PROFESSIONAL EXPERIENCE:

Confidential, Wholesale Club, MA

Sr. DB2 LUW DBA

Responsibilities:

• Involved in regular day to day administrative tasks, supporting developers and Production support.
• Worked closely with UDB developers and assisted them with performance issues and halped them with Configuration Assistant to catalog teh databases.
• Performed database recovery efficiently with minimum downtime and data loss with available resources.
• Provided support for development team that involves solving lock contention, data export, data import, performance tuning, data bug fixing etc.
• Involved in Importing and Exporting data and database structure using db2look and db2move utilities.
• Worked on migrating our E - commerce Databases from AIX to Amazon AWS Cloud.
• Used OEM in performing database managing activities.

ENVIRONMENT: DB2 UDB 9.7, 10.1, 10.5 AIX 6.1, Oracle 11g/12c, Red Hat Linux 6.7, Tivoli, AWS, Netcool.

Confidential, Texas

DB2 LUW DBA

Responsibilities:

• Managing multipleDB2UDB V9, v10 & V11 databases on medium to large systems
• Working on Linux/AIX/Windows.
• UDBDBAmaintenance activities like reorgs, runstats, back-up, restore, expanding and reducing teh table spaces.
• Built an application from scratch and involved in all phases of planning and design.
• Understand and remediate production issues on fly and conduct teh Root cause analysis.
• Perform Installations, version Upgrades & Fix Packs onDB2UDB databases.
• Worked with DR test & strategies like Failover Clustering/HADR.
• Worked with ITIL Methodologies like Change, Incident, Problem, Service Management using Service Now .
• Working knowledge on IBM Info sphere Change Data Capture 10.2
• Working with storage utilities like TSM / IBM BCV Knowledge of Optim tool for performance monitoring.

ENVIRONMENT: DB2 UDB 9.7, 10.1, 10.5/11.0 AIX 5.1/6.1/7.0, Zena, Quest, Tivoli, Netcool.

Confidential Wholesale Club, MA

DB2 LUW DBA & Oracle DBA

Responsibilities:

• Involved in regular day to day administrative tasks, supporting developers and Production support.
• Worked closely with UDB developers and assisted them with performance issues and halped them with Configuration Assistant to catalog teh databases.
• Performed database recovery efficiently with minimum downtime and data loss with available resources.
• Provided support for development team that involves solving lock contention, data export, data import, performance tuning, data bug fixing etc.
• Involved in Importing and Exporting data and database structure using db2look and db2move utilities.
• Worked on migration from AIX to Amazon AWS.
• Used OEM in performing database managing activities.

ENVIRONMENT: DB2 UDB 9.7, 10.1, 10.5 AIX 6.1, Oracle 11g/12c, Red Hat Linux 6.7, Tivoli, Netcool.

Confidential, NJ

DB2 LUW DBA & Vertica DBA

Responsibilities:

• Supporting all environments which include DEV, UAT and PROD.
• Worked on BankAmerica card information application (BACardi). Bacardi is a midrange data warehouse for analytical modeling and reporting of credit card data.
• Worked on OLTP Debit Card Fraud management system.
• Creating new database objects and working on any database structural changes.
• Heavily using data movement utilities like LOAD, EXPORT, and IMPORT.
• Worked on utilities like REORG, RUNSTATS, REORGCHK and REBINDS.
• Monitoring database backups and Space management.
• Working on Database Restores when needed for developers.
• Worked on HADR setup using TSA.
• Working knowledge on DPF databases.
• Involved in setting up Qreplication between Operational Database and Reporting database and troubleshooting issues associated with Qreplication control and source tables.
• Performing daily trouble-shooting activities.
• Worked on weekend changes and deployments.
• Worked on migrating databases from AIX to Linux.
• Worked on Production support 24 * 7.

DB2 Environment: AIX 6.x, Shell Scripts, Red hat Linux 6.x, DB2 LUW V9.x/10.1/10.5, Vertica7.0, TSA, Java.

Confidential, NJ

DB2 LUW DBA

Responsibilities:

• Involved in regular day to day administrative tasks, supporting developers, Production support and create database objects.
• Worked as a Team lead and I had two direct reports from offshore team. I assigned tasks which are to be done at off hours.
• Tuned databases using IBM Tools like snapshot monitor, db2exfmt, db2expln, Index Advisor and problem diagnosis.
• Monitored Replication process by checking capture, apply and teh spill files created by apply process. Checked teh replication log files for known errors and monitored teh heartbeat process.
• Worked closely with UDB developers and assisted them with performance issues and halped them with Configuration Assistant to catalog teh databases.
• Performed database recovery efficiently with minimum downtime and data loss with available resources.
• Provided support for development team that involves solving lock contention, data export, data import, performance tuning, data bug fixing etc.
• Configured LOGARCHMETH1parm for archival logging, involved in space monitoring, moving teh db2diag.log and resolved issues with log full conditions.
• Installation of DB2 UDB 10.1 (EEE) on AIX.
• Setting up High Availability Disaster Recovery (HADR) and involved in testing failover scenario.
• Monitoring database activity using Embarcadero DBArtisan and setting up database alerts and restoring databases using TSM.
• Experience in managing very large databases.
• Experience in deploying DB2 on multiple servers.
• Providing 24x7 on call Production support for databases on single and multiple partitions.

Environment: DB2 UDB EE 10.1,9.7 and 9.5, AIX 7.1 and AIX 6.1, Red hat Linux 5/6, Embarcadero DBArtisan 8.1.1, TSM Clear Case, Clear Quest, Remedy, WebSphere commerce, Autosys, Tivoli Storage Manager, LDAP, MVS and Korn Shell.

Confidential, Los Angeles, CA

DB2 LUW DBA

Responsibilities:

• Primarily involved in providing production support of DB2 UDB databases on AIX and Linux servers.
• Created and maintained instances and databases in development, test and productionenvironments.
• Created multiple buffer pools for optimal performance and allocation of resources.
• Implemented automated backups, Space monitoring, moving db2diag.logs, monitoring size of table spaces by setting up a threshold.
• Running teh REORGCHK, REORG and RUNSTATS utilities to reduce disk fragmentation and improve performance.
• Involved in building databases on fail over servers using redirected restore.
• Involved in Importing and Exporting data and database structure using db2look and db2move utilities.
• Worked on SAP DB2 databases.
• Extensively used DBA Cockpit tool to perform Database operations which includes scheduling backup jobs and doing health checks.
• Worked on migrating databases from AIX to Linux using DB2MOVE.
• Setting up High Availability Disaster Recovery (HADR) and involved in testing failover scenario.
• Experience in managing very large databases.
• Experience in deploying DB2 on multiple servers.
• Monitored database performance and work with senior peers to determine corrective actions.
• Granted various authorizations to different users and groups.
• Worked on IBM DB2 utilities like Runstats, Reorgchk and Reorg.
• Involved in Performance tuning & Query optimization.
• Performed high-speed bulk data loads using DB2 load utility.
• Interacted with teh customers and gatheird teh requirements and analyzed teh data for theapplication.
• Provided 24x7 On Call Production Support.

ENVIRONMENT: DB2 UDB 9.1, 9.5, AIX 6.1, AIX 7.1, Red Hat Linux 5, Windows 2000, SAP Net Weaver 7.0, Cockpit, JAVA, LDAP, MVS and TSM.

Confidential

DB2 LUW DBA

Responsibilities:

• Involved in regular day to day administrative tasks, supporting developers, create instances and databases in Development, test and staging databases.
• Supported SAP DB2 databases.
• Used DBA Cockpit tool to centrally manage all DB2 database operations.
• Creating new Databases and database objects.
• Maintained instances and databases as per FTI standards, assisted application users in setting up connection to teh database.
• Created and maintained users, groups and schemas for applications as well as controlling database access.
• Running teh REORGCHK, REORG and RUNSTATS utilities to reduce disk fragmentation and improve performance.
• Worked on Multi-partition databases.
• Space management tasks like adding/resizing, monitoring tablespace containers.
• Tuned databases using IBM Tools like snapshot monitor, db2exfmt, db2expln, Index Advisor and problem diagnosis.
• Monitored Replication process by checking capture, apply and teh spill files created by apply process. Checked teh replication log files for known errors and monitored teh heartbeat process.
• Worked closely with UDB developers and assisted them with performance issues and halped them with Configuration Assistant to catalog teh databases.
• Performed database recovery efficiently with minimum downtime and data loss with available resources.
• Provided support for development team that involves solving lock contention, data export, data import, performance tuning, data bug fixing etc.

ENVIRONMENT:DB2 UDB EE/EEE 8.2 Fix pack 4(V8.1 Fixpack 11), AIX 5.2, Solaris 5.8, Embarcadero DBArtisan 8.1.1, SAP Net Weaver 7.0, Cockpit tool, Clear Case, Clear Quest, Remedy, Web Logic, Autosys, Tivoli Storage Manager, Korn Shell.