Summary
* DB2 Database Administrator with 6 + extensive experience in Database design, development, deployment and administration on LUW platforms.
* Skilled experience in installing and configuring DB2 9.x versions and fix packs on UNIX, Linux or Windows operating system efficiently.
* Eternal knowledge in designing physical, logical and relational databases, development and maintenance.
* Experience working with very large databases on Data Partitioning Feature (DPF) environment.
* Developed many reusable shell scripts for monitoring and performing daily and weekly tasks. Developed automated system for production BACKUPS, REORGS, RUNSTATS.
* Expertise in Backup, Recovery and roll forward techniques.
* Efficient professional in working with movement and maintenance utilities like move, export, import, look, runstats, reorg, reorgchk, rebind, and flush package cache.
* High skills in monitoring and performance tuning a database using snapshots and event monitors. Troubleshooting SQL statements with the help of Explains, db2advis, db2exfmt schema changes and configuration changes.
* Experience in developing disaster recovery techniques in HADR (High Availability Data Recovery) environment.
* Skilled in developing SQL queries, packages, triggers and stored procedures.
* IBM Certified Database Associate.
-
DB2 LUW DBA
- Information Technology
- Sep 2014 - Mar 2016
-
* Worked on installation of versions 10.1, 9.7 of DB2 UDB on AIX.
* Performed POC of DB2 V10.5 on AIX.
* Developed shell scripts for daily maintenance tasks, archiving DB2 log files, and performance monitoring.
* Generated ERD for the database using Erwin
* Physical database design, creation, implementation & maintenance operations (file system mount points & storage parameters) and logical database mapping to physical database (storage calculations, file systems, tablespaces, rollbacks, indexes, data files & logs).
* Worked on HADR setup with Tivoli System Automation (TSA).
* Worked on HADR setup for mission critical databases on AIX platform.
* Monitor HADR activity
* Created Capture and Apply program tasks for a DB2 Q-Replication system.
* Responsible for risk management analyze any suggested change to systems and determine risk factor as well as recovery steps.
* Performed capacity planning and performance tuning.
* Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.
* Developed document that provides an overview of the physical and logical design of the database environment implemented for JPMC.
* Provide database backup and recovery support for DB2 UDB
* Create, configure, monitor, and tune DB2 UDB databases for new internal projects
* Worked with tools DB2 Performance expert, DBArtisan, DB2MON, and Control center to debug and resolve database issues
* Extensively worked on tuning complex SQL queries, developing stored procedures, and functions
* Effectively carried out database performance tuning and troubleshooting & fixing problems faced by application developer.
* Involved in running REORGCHK, REORG, REBIND, RUNSTATS, LOAD utilities against the database ENVIRONMENT: DB2 EE V 10.1/9.X, Web sphere, AIX 5.x, windows NT/XP, Server, Erwin, and SAN, Clustered Environment
References
Average Rating
1 recommendation
-
DB2 LUW DBA
- Information Technology
- Nov 2011 - Sep 2013
-
* Designed creation of databases and database objects for DB2 UDB on Development, Test and Production environments.
* Involved in DB2 Q-Replication system for bi-directional Q-Replication between two LPARS.
* Created Capture and Apply program tasks for a DB2 Q-Replication system.
* Developed scripts for performance of database, to support the 24/7 loads to tables, online backups, and scripts to monitor the disk usage on file systems.
* Worked on version DB2 9.5.
* Closely observed the performance tests conducted by the testing team and used self-developed scripts to arrive at the bad SQLs.
* Worked on compressions, MDCs to improve the performances.
* Involved in performance tuning.
* Created UNIX scripts, Perl scripts for performing runstats, reorg, rebind, backup, load and export, Merge utility.
* Tuning the database using the database manager, profile registries and configuration parameters.
* Developed scripts to monitor the replication lag between the PROD and DR (Disaster Recovery).
* Refresh QA for every quarter from production 8TB of DB size.
* Very well used Global temporary tables, MQTs to optimize several queries.
* Refreshing the test database with production data using regular and redirected restore.
* Setup HADR for the production environments, also wrote shell scripts to monitor the HADR synchronizations and connections.
* Build MySQL servers installing the MySQL.
* Used to setup cluster environment in both ways MySQL replication and RedHat Cluster environment.
* Setup different kinds of replication types (Master-Slave, Master-Slave-Slave-Slave).
* Wrote scripts to take backups and maintenance work to make it fully automated to support as many servers around 80 MySQL server.
* Supported 24/7 support for both DB2 and MySQL for around 70 Production servers.
Environment: DB2 EE Version 9.X, AIX 5.3, MySQL 5.0.18, 5.0.28, 5.0.45, 5.1, 5.1.45.
References
Average Rating
1 recommendation
-
DB2 LUW DBA
- Information Technology
- Mar 2009 - Oct 2011
-
I was the part of team of 8. I have provided 24x7 support for a large database environment consisting of 25 different applications with over 250 databases on AIX and windows platform.
* Migrated databases from V8.x to version 9.5 of DB2 UDB on AIX 5.x and Windows 2003.
* Supported mission critical applications like online Banking, and Bank Branch applications.
* Worked on Proof of concept for V9.5 testing.
* Supported partitioned environment (DPF) with 16 physical partitions and ware house environment. Experience working with MDCs, MQTS, Range-Partitioned tables, and Range-Clustered tables.
* Worked on migrating databases from Windows to AIX platforms.
* Worked on setting up log archiving to TSM for SQL replication environment.
* Developed Capacity Planning strategy for all UDB applications.
* Worked on Hardware upgrade for a mission critical production database.
* Provided support on DB2 connect related applications.
* Extensively worked on tuning complex SQL queries, developing stored procedures, and functions.
* Experience in developing Perl scripts for maintaining and monitoring databases on Windows Platform.
* Developed shell scripts for daily maintenance tasks, archiving DB2 log files, and performance monitoring.
* Generated ERD for the database using Erwin.
* Involved in managing log files and thereby ensuring high availability of database in a 24X7 scenario.
* Performed capacity planning and performance tuning.
ENVIRONMENT: DB2 EE V 8.1/8.2/9.x, Web sphere, AIX 5.x, windows NT/XP, Server, and ERwin
