PROFESSIONAL SUMMARY:

• 9 years of professional and progressive experience in IBM DB2 UDB with emphasis on Database Administration, Architect, development, migration, Analysis, testing, implementation and production support of critical OLTP, OLAP and Data warehouse environments.
• Experience in handling DB2 UDB security, establishing replication between servers, capacity planning, backup and restore, performance tuning, shipping archival logs, corruption and recovery and managing logins/permissions.
• Extensive experience using DB2 LUW/UDB EE and DB2 LUW/UDB EEE on LINUX/UNIX platform.
• Have extensively worked as Production DB2 UDB DBA in V9.5, V9.7, 10.5, 11.1 and on huge VLDB systems.
• DB2 11.1, 10.5, 10.1, 9.7, 9.5 database administrator functions including database object creation and alters implementation, reorgs, statistics collection and analysis.
• Expertise in configuring 2 - node, 3-node HADR setup with TSA using different tie-breakers from scratch to Production implementation.
• Database Administrator specializing in administration, operations, support, maintenance and tuning of oracle databases in multiple platforms - Unix, Windows.
• Creating detailed process documentations and deployment process on issues for future follow ups (runbooks/knowledge base).
• Proficient in creating database objects such as tables, table spaces, indexes, views, and aliases and altering tables and adding check constraints and referential integrity.
• Experience in maintaining databases, following best practices and establishing baseline configurations.
• Extensive work experience in DB2 Data Replication (DPropR), Stored procedure (SP), user defined function (UDF), and user defined table function.
• Skilled in database administration tasks such as SQL coding, relational database design, index strategies and SQL Troubleshooting using DB2 UDB.
• Extensive experience on migration migrated from 9.7 to 10.1, 10.5 & 11.1 Migration from AIX to LINUX, RHEL, UNIX and vice versa.
• Installing, configuring and upgrading IBM DB2/SQL, Server/Oracle server software and related software’s.
• Extensive experience in providing support and maintenance for database running on Linux/Unix/Windows.
• Experience in providing optimal solutions for structured and non-structured data using SQL and NoSQL
• Good experience in EXPORT, IMPORT and LOAD utilities, moving data between servers.
• Experience in monitoring DB2 Databases of sizes ranging from 1TB-5TB.
• On-call support (24X7) and Root Cause Analysis (RCA) for issues raised by users.
• In-depth knowledge of database technology, DB2 UDB Distributed databases (DPF).
• Experience with Unix/Linux/ OS platforms and Unix/Shell scripting and automation.
• Monitoring on-site events to proactively optimize system and application performance.
• Accountability for backups and high availability & disaster recovery (HADR) procedures.
• Proficiency in clustering techniques, load balancing and indexes.

TECHNICAL SKILLS:

Databases: DB2 UDB v9.x, v10.x, v11, MY SQL, DB2, MS ACCESS, MY-SQL, MS SQL 2012, 2014, MONGO-DB.

T: SQL, PL/SQL, UNIX, Shell Scripting, XML

Operating System: AIX, LINUX, UNIX, Z/OS, Windows

Third party tools: DBI, CA Log Analyzer, BMC Remedy, DB2Admin Tool, Data Studio, Fog light, TOAD

IBM Mainframe: Cobol, CICS, DB2, JCL, VSAM.

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Application/DB2 Database Administrator

Responsibilities:

• Developed physical data models (PDM) on different schemas and applications using Data studio.
• Extensively worked on tuning complex SQL queries using Explain Plan and recommended the improvements needed to reduce the execution time.
• Used IBM Data Studio to execute tasks, edit data in tables.
• Ran Explain Plain on store procedures to determine the performance.
• Migrated databases and database objects from DEV to QA using IMPORT, EXPORT and using inbuilt tool called DB2 TS.
• Created the SQL queries for populating and updating the database.
• Tuned/Optimized SQL queries for developers.
• Worked on Capacity planning strategy for UDB databases.
• Database sizing, tablespaces, indexes and log spaces design & implementation work.
• Provides solutions for storage system of tablespaces.
• Created scripts for migrating structure changes to different environments.
• Coordinated different tasks for the upgrade of DB2 to other team members and application DBA's.
• Provided technical expertise to developers and DB2 administrators with trouble shooting and performance issues.
• Provided DB2 LUW DBA support to Unify, Analytics, and Investment Screener application development.
• Used DB2 Movement Utilities like EXPORT, IMPORT, and LOAD.

Environment: DB2 ESE/WSE V 11.1/10.5/10.1/9.7 , PuTTY, IBM Data Studio.

Confidential, Collegeville, PA

DB2 Database Administrator

Responsibilities:

• Established standard controls and procedures to ensure data integrity and security.
• Managed database instances for Consolidated Online trading system in DB2 UDB in version 10.5 and 11.1 on AIX 7.0 and RHEL.
• Managed and troubleshooted DB2 UDB databases on 30 UNIX servers, sizes up to 5TB.
• Assisted developers with the performance test initiatives and suggested various recommendations using tools like DB2Advis.
• Creating data models & analyzing business requirements into technical data requirements to update existing data models (logical/physical)
• Managed all the DB related activities such as DB modeling, design, development, maintenance and support.
• Moved data from business partner's MySQL database to and from core DB2 databases as well as performing MySQL backups and maintenance.
• Transferred stored procedures from SQL server into DB2 on windows.
• Database sizing, tablespaces, indexes and log spaces design & implementation work.
• Database security and Audit design, test and implementation.
• Physical database design, creation implementation and maintenance operation (file system mount points & storage parameters) and logical database mapping to physical database
• Requested TSM management class from the TSM administration and configured database parameters to use TSM management class.
• Implemented several DR solutions using HADR custom log shipping scripts to suit varying business needs and requirements.
• Upgraded DB2 databases with various fix packs.
• Performed weekly/monthly database maintenance such as REORG, RUNSTATS, REBIND and backups as well as LOADS, IMPORTS and EXPORTS.
• Setup DB2 UDB/AIX production and development environments.
• Database clean up (development) scripts (UNIX, Shell scripts, Crontabs and SQL) for automated clean up every week.
• Moved database objects like tables, views, triggers, stored procedures from MYSQL to DB2.
• Assisted in the development of database administration standards and procedures.
• Ensured proper backup and recovery by maintaining DB2 image copies and recovery JCLs
• Provided recommendations for ongoing tuning environment bases on growth projections.
• Monitored task with respect to database performance on package applications.
• Installed and configured UDB software applied and maintained fix packs.
• Escalated Performance exceptions and worked with application.
• Implemented Backup/Recovery of database.
• Provided on-call (24X7) support for users and productions databases.

Environment: DB2 UDB for LUW V10.5 & 11.1, SQL SERVER, MY-SQL, Shell Script, BMC Patrol, Control Center, TOAD, AESE, Performance Expert, Optimal Performance Manager (OPM)

Confidential, Mc Lean, VA

DB2 Database Administrator

Responsibilities:

• Installed DB2 10.5 AESE on AIXLINUX environments and migration of DB2 UDB versions to 9.1 to DB2 UDB V9.5, V9.7, V10 and V11.1
• Implemented HACMP Strategy and High Availability Disaster Recovery (HADR with TSA), federation, performance monitoring, and fine tuning OLTP and DSS application and problem determination and troubleshooting.
• Upgraded DB2 databases with various fix packs.
• 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.
• Analyzing business requirement and converting them into technical requirements for the existing data models (logical/physical) or creating new data models (logical/physical).
• Interacted with UNIX application group playing a diverse role with large teams of DBA’s.
• Extracted mainframe data using DataStage to DB2 LUW.
• Created large tablespaces using automatic storage management.
• Refining existing data models and creating data architecture sections for development.
• Design the backups and recovery strategies for Oracle databases from 10.5 thru 12C and DB2 UDB databases to meet our customer SLA requirements.
• • Responsible for optimizing and continuously improving the quality of all oracle database systems using recommended oracle tools
• Configured HADR AND TSA for automatic replication (IBM CDC) failover.
• Supported UDB DB2 4 node cluster from the server side and allocated additional disks for the pure scale cluster.
• Monitored and tuned database software after installation and applied fix packs for peak performance.
• Responsible for query performance optimization, tuning implementations and production support.
• Dropped and added users, logins, aliases and groups to the database and granted/revoked permissions on database objects.
• Performed weekly/monthly database maintenance such as REORG, RUNSTATS, REBIND.
• Implemented several DR solutions using HADR custom log shipping scripts to suit varying business needs and requirements.
• Performed database design and generated initial DDL as required.

Environment: DB2 Version 9.7/9.5.x/9.1.x,10.5, DB2 UDB for LUW, DB2 Connect 9.5.x/9.1.x, AIX 6.1/5.3, Web sphere Federation Server 9.5.x, Oracle 12c, shell scripting, MVS-Z/OS, DB2 Client 9.5.x/9.1.x, TSA, HP Service manager, DB2 AESE

Confidential, Reston, VA

DB2 Database Administrator

Responsibilities:

• Migrated Development (DEV), Test (UAT) & production (PROD) databases from DB2 9.7 to 10.5
• Maintained, implemented, tuned and upgraded DB2 database (z/OS) data sharing environments in SAP environments.
• Managed database loading, migrating and maintaining data with LOAD, EXPORT, IMPORT DB2LOOK
• Improved quality of the DB2 pureScale Release (DB2 9.8, DB2 9.8.1, DB2 9.8.2, DB2 9.8.3, DB2 9.8.4) by working with the System Verification Test team to investigate and fix complex problems in a clustered environment
• Took online and offline backups and wrote shell scripts and schedule them.
• Cataloged multiple instances and conferred connectivity to database from remote clients.
• Upgraded DB2 databases with various fix packs.
• Bound server DB2 utilities to the database.
• Requested TSM management class from the TSM administration and configured database parameters to use TSM management class.
• Requested space for file system and raw-device to UNIX group
• Dropped and added users, logins, aliases and groups to the database and granted/revoked permissions on database objects.
• Provided application support, design, user administration, security, performance tuning, optimization and backup/recovery.
• Installed DB2 V10.1 AESE on sandbox and worked on prototypes scenarios for replication

Environment: DB2 UDB for LUW, Fix pack, DB2 AESE, AIX, DB2 UDB for LUW, IBM Migration Toolkit, USE Linux 10 and Red Hat Linux, Linux, shell scripting, TSM, SQL Server, Quest Central and Toad.

Confidential, Chantilly, VA

DB2 Database Administrator

Responsibilities:

• Administered DB2 databases on LUW including SQL tuning, resource monitoring performing security architecture review.
• 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
• Involved with monitoring different type of databases that needed to be synched to a heterogenous architecture with various systems integrated into DB2
• Assisted with Data migration and Data Quality processes in multiple on-going projects.
• Upgraded DB2 from 9.7 to 10.1
• Upgraded DB2 databases with various fix packs.
• Analyzed database performance using tools such as DB2ADVIS, DB2TOP, DB2PD utilities.
• Ran periodic backups (delta/incremental) daily and weekly.
• Created and setup DPF with 13 nodes on three servers for DWE databases.
• Implemented several DR solutions using HADR custom log shipping scripts to suit varying business needs and requirements.
• Performed weekly/monthly database maintenance such as REORG, RUNSTATS, REBIND and backups as well as LOADS, IMPORTS and EXPORTS.
• Used DB2 10.x features such as compression, automatic storage and self-tuning memory management to provide scalability and maximize return on hardware investment.
• Extensively involved in application support, design, user administration, security, performance tuning, optimization and backup/recovery.
• Implemented DB2 security, locking and concurrency controls.
• Constantly migrated instances, databases to current level of DB2 versions/fix packs to in corporate new functionalities.
• Generated SQL statements using DB2LOOK.
• Monitor and manage critical z/OS resource through IBM Omegamon/BMC Main view tool.
• Worked with different IBM DB2 Tools like Admin and Automation Tools, QMF, File aid for DB2, Omegamon for z/OS, Visual Explain and Data Studio.
• Installed setup, configured and managed high availability topology for Oracle and DB2 UDB environment using RAC, Data Guard and DB2 High Availability Disaster Recovery (HADR) respectively.

Confidential

DB2 Database Administrator

Responsibilities:

• Wrote shell scripts in UNIX/LINUX for DB2 configuration.
• Provided server installation, configuration and upgrades on AIX/UNIX/Linux/Windows environments for DB2 V9.x as well as older versions V7.x and V8.x
• Performed routine DB2 database backups, restores, performance tuning and capacity analysis on SQL Server 2005.
• Supported migration of oracle database to DB2 UDB using IBM Migration Toolkit.
• Ensures optimal performance and availability of all oracle databases; resolving database capacity and other distributed data issues
• Responsible for DB2 physical database design, implementation and maintenance on Z/OS
• Created/Altered database objects (tablespaces, schemas, tables, views, index, triggers, stored procedures, etc.)
• Performed responsibilities of DBA applications involved with DDL statements to create, modify, alter databases objects and involved with performance tuning of complex SQL Queries
• Automated backups (both online and offline), reorgs, run stats, space monitoring, moving db2diag.log, monitoring size of tablespaces by setting a threshold.
• Upgraded DB2 databases with various fix packs.
• Worked largely with data movements utilities IMPORT, LOAD and EXPORT in peak conditions.
• Use Z/OS DB2 native mainframe daily to perform DB2 DBA functions.
• Tuned database and database manager configuration for optimum performance.
• Experimented with changing buffer pools, tablespaces, page size to improve time taken by ETL to build data marts.
• Used TSM for backups and user exit for archival logs.
• Provided on-call support for all production database

Environment: DB2 V9.1, V9.5, V9.7, V10.1, AIX, Linux, Oracle, IBM Data Stage, Windows, SQL server, Z/OS, DB2 AESE.