Uploaded File
add photo
Sandeep
sandeepgopagoni533@gmail.com
203-997-5441
Arlington, TX 76003
DB2 LUW DBA
12 years experience W2
12/29/2024
2
Recommendations
Average rating
226
Profile views
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.

Experience
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

DBA Database Backups Database Design DB2 DB2 LUW DB2 PE IBM WebSphere Shell Scripts Capacity Planning UDB Performance Tuning Stored Procedure Data Replication HADR AIX Windows Performance Monitoring Risk Management Erwin Data Modler SQL SAN
Remove Skill
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.

DBA DB2 DB2 LUW DB2 PE Shell Scripts SQL Data Replication UDB Performance Tuning MySQL Perl HADR Database Backups Database Design Performance Testing Quality Assurance
Remove Skill
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

DBA Data Replication DB2 DB2 LUW DB2 PE IBM WebSphere Capacity Planning Shell Scripts SQL AIX Performance Tuning Erwin Data Modler Stored Procedure Perl UDB Data Migration DB2 Connect
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Certifications
IBM Certified Database Associate
Skills
Data Replication
2016
5
DB2
2016
5
DB2 LUW
2016
5
DB2 PE
2016
5
DBA
2016
5
Performance Tuning
2016
5
Shell Scripts
2016
5
UDB
2016
5
AIX
2016
4
Capacity Planning
2016
4
Erwin Data Modler
2016
4
IBM WebSphere
2016
4
Perl
2013
4
SQL
2016
4
Stored Procedure
2016
4
Database Backups
2016
3
Database Design
2016
3
HADR
2016
3
Data Migration
2011
2
DB2 Connect
2011
2
Performance Testing
2013
2
Quality Assurance
2013
2
SAN
2016
2
MySQL
2013
1
Performance Monitoring
2016
1
Risk Management
2016
1
Windows
2016
1
Disaster Recovery
0
1
Triggers
0
1