SUMMARY

• Around 6+ years of IT experience with expertise in Installation, troubleshooting, maintenance and tuning of DB2 Linux UNIX and Windows (LUW) production and non production databases.
• Migrated DB2 databases across several versions and installed fixpacks to keep DB2 at most recent level.
• Exposure as Application DBA for DB2 UDB on LUW 9.x and 10.x.
• Created and Altered database Objects
• Monitored and Tuned Database environments and Application queries to optimize overall performance.
• Extensive experience in setting up and maintaining High availability disaster recovery (HADR) databases.
• Involved in Disaster Recovery strategy and Business Continuity Planning and Testing.
• Developed and Implemented Enterprise wide Backup and Recovery strategy for both partitioned and non - partitioned environment by understanding Business and Application Rules.
• Altered db and dbmcfg parameters to tune the database and Applications to optimize performance.
• Expertise in database maintenance utilities like REORGCHK, REORG and RUNSTATS to maintain performance at all times.
• Used data movement utilities like Export, Load, Import, db2move and Ingest to move data across environments or tables or different data sources.
• Migrated databases using backup and redirected restores, using Load Cursor utility to migrate data across the db2 family where backup and restore are not supported.
• Performed routine health checks of databases in question using shell scripts to capture OS and DB2 monitor data into files and provide documentation on bottlenecks found and recommendations to improve performance.
• Used db2top, db2pd, db2exfmt, db2batch, db2advis, snapshots and administrative views to analyze access plans, gather performance metrics, provide index recommendations and bench marking.
• Experience in monitoring the availability & performance of AIX, Linux Servers through tools like top, topas, vmstat, netstat, svmon, nmon, lparstat, and iostat
• Supported Application Development and OS administration team in cases of unplanned outages and Migration
• Good knowledge of Health Plan Data Models (HPDM), Enterprise Data Models, Data Dictionary, Domains, Star schema, dimensional Data Models and Metadata management.
• Worked on Spring Cloud that is built on Spring Boot and utilizes parent and starter POMs in Spring Microservices.
• Signed and developed the monitoring system used for SaaS Cloud/AWS Elastic Environments, including monitoring individual instance health, overall environment health, and managing individual component failure cases.

TECHNICAL SKILLS

RDBMS: DB2 LUW on 8.x,9.x and 10.x, SQL Server 2005 and 2008, Oracle

Database Tools: DB2 Data Studio, DB2 Connect, Fog Light and Spot Light, DB2 Governor and Query Patroller, DB2 Replication Center, Informatica, Golden Gate, Work Load Manager

Operating System: Microsoft Windows, Red Hat and SUSE Linux, Confidential AIX, Solaris

Ticketing Tools: CA Global Service Desk, Remedy, Service Now, Heat

Languages: SQL, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

DB2 Database Administrator

Responsibilities:

• 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).
• Executed successful database high availability and disaster recovery failovers.
• Database backup and recovery experience with online full and incremental backups, online and offline transaction log archiving, restore and roll-forward (including redirected restore), and recover database utilities.
• Created the shell scripts in short time period according to the client requirements like identifying the applications which are running for long time & kick out the applications which are in Lock-hold state.
• Created various shell scripts to automate database maintenance such as reorg/runstats and backup/restore /snapshot monitors.
• Created several shell scripts to perform the database utilities like Load, Import, Export.
• Experience in writing and running self-security-monitoring shell scripts to ensure that right authorities and privileges assigned on users.
• Monitored the performance of the databases utilizing event monitors on statements, snapshots on database, locks, applications, bufferpools and tablespaces etc.
• Performed problem analysis and created monitoring scripts to capture a snapshot of Locking Issues. Added indexes to existing tables to fix the locking issues.
• Assess impact on performance with different changes and review scalability of the infrastructure.
• Maintain standard procedural documentation related to all aspects of operating the database platforms.
• Participate in incident resolution as an escalation point for database incidents.
• Document known errors or workarounds in the shared Knowledge Base.
• Opened PMR’s with Confidential DB2 support and worked with support engineer to resolve database and OS related issues.
• Scheduling jobs through Crontab& at in both AIX and Linux.
• Created UDB instances and Databases for both v9.x and v10.x in Test, QA, Dev and PRODUCTION environments.
• Experience in resolving incident management and change management tool like ServiceNow and experience in creating change orders for making required changes against databases.
• Opening PMR's to Confidential for critical DB issues and coordinating with Confidential for installing fixes.
• Provide on-call (24X7) support for all databases and document all the issues encountered when on-call

Environment: AIX 5x, 6x, 7x, RedHat LINUX 5.5/6.3, Windows, DB2, TSM, VeritasNetbackup, CA Service Desk, Apache Webserver, MQ, Websphere Application Server & UNIX shell scripting

Confidential, Southberry, CT

DB2 Database Administrator

Responsibilities:

• System Verification Testing; Testing of DB2 Product v10.1 FP1 for its capabilities and its behaviors with newly introduced features, like peer-window in HADR.
• Installing the new release/Fix-packs by pulling the new builds, setting up the environment DPF/HADR, Creating the instance and Database which spans on all nodes. Populating the database.
• Analyze the diagnostic log records for any problems and troubleshooting. Try to find the bugs in yet to release product. Report to DB2 Software Lab, Toronto.
• Observe takeover/failover by secondary server from Primary. Observe Behaviors of primary and standby servers.
• Impact analysis about the implementation on various Administration modules of the DB2 product.
• Performance tuning of DB2 production databases. Tuning SQLs for better performance, I/O and Memory Tuning, Registry Tuning, Runstats, Reorgs.
• Creating and Altering DB2 objects like Table spaces, Tables, views and Indexes etc.
• SQL Query Tuning using db2advis and db2expln and troubleshooting database issues using db2diag, db2pd, db2top, Snapshot and event monitors.
• Well experienced in packaging applications to build platform independent applications using Websphere Application Assembly Tool (AAT).
• Database migration from SQL Server 2000 and Oracle 9i to DB2, used Confidential Migration Toolkit.
• Worked with Confidential support in various occasions by raising PMR and collected info using db2support to assist in troubleshooting.
• Involved in Maintenance activity of DPF.
• Experience on Incident / Problem and Change management process.
• Experience on restoring the database from one Linux server to another Linux server using Redirect Restore method.
• Reviewed existing database and the system, to improve the database performance using different parameters (like Buffer pool, SORT heap and other memory parameters) in production environment.
• Created views and granted privileges to the users as required to their access.
• Resolving locking issues at the application, by giving recommendations to make changes in the application to reduce/avoid deadlocks and lock timeout.
• Upgraded instances regularly with latest fix packs .
• Worked extensively with restores, redirected restores and Unicode conversions.
• Good experience in 24/7 production environment support and involved in on call support on rotation basis.

Environment: DB2 UDB v8 FP14, on AIX, Linux, and Windows on AMD Machines. iSeries Server. DB2 Connect. Database partitioned on four Physical nodes each having two logical nodes. Multiple Clients running on different platforms ; AIX, Linux and Windows. HADR setup on AIX; Primary and Secondary servers