Balamurali Veeravel

Around 10 years of experience in database administration with a primary responsibility of System Programmer & DBA on DB2 z/OS and with additional responsibility of DBA & Engineer on DB2 LUW. DBA and Engineering expertise including installation, customization, implementation, database design, database migrations, optimizing SQL queries, monitoring entire subsystems, production support , backup and recovery strategies, providing recommendations to app teams and database maintenance activities. ROLES AND RESPONSIBILITIES: • Performed SMP/E for installations, migrations and maintenance of software products • Worked on Parallel sysplex and DB2 data sharing environment • Installed, migrated and applied maintenance on DB2, CA tools, optim and other software products • Skilled in DB2 Utilities, DDF, SQL, Subsystem Administration (DB2 Catalog, Logs, BSDS, Buffer Pools, Stored Procedures), Performance Monitoring and Tuning • Experience and knowledge on DB2 Connect and DB2 attachment facilities • Extensively used CA/BMC tools and utilities for DB2 Database Administration • Proficient in data governance tools including Optim for TDM, data privacy and data growth • Proficient in monitoring tools including Omegamon, Main view and RMF • Working Knowledge on IDAA • Experience on running various Omegamon PE reports(accounting, auditing and statistics) • Worked with application teams on design, creation, and maintenance of DB2 database objects • Performed various DDL, DCL operations – create, alter, rename, drop, grant, revoke on DB2 database objects • Monitoring Table space and Log Utilization of DB2 databases • Usage of db2look utility to build a database • Data movement utilities like export, import, load and db2move utility • Knowledge on DB installations and fix pack upgrades • Knowledge on Backup/recovery of databases and High Availability Disaster Recovery (HADR) • Usage of db2dart, db2advis, db2expln, db2top, db2pd, event monitor tools for performance analysis