Vikas Singh

Legacy Platforms:

• Core competency in DB2 Mainframe DBA and LUW DB2
• Good knowledge of IBM Maintenance and Housekeeping Utilities like Load, Reorg and Runstats
• Good knowledge of backup and recovery strategy on db2 zos
• Experience on designing objects in different domain
• Good knowledge on QREP / CDC / HVR replication products
• Good knowledge on working of application programs and performance tuning
• Worked on REXX tools to support project work and automation
• Have experience on problem solving in production, application development and testing support
• Worked extensively on data refresh activity on prod and dev environment
• Experience on supporting DBA activities during version migration, tool upgrade
• Worked on various products and tools like CA Platinum, CA Insight, Detector
• Worked on performance tuning and application issues during development
• Resolving production job abends and issues, locking issues and contentions
• Worked DB2 LUW database administration
• Good experience in DB2 Fix pack installation, DB2version upgrade

• Experience in maintaining file system, regular data cleanup and archiving strategy
• Experience on DB2 offline and online Backup and Recovery strategy
• Experience on resolving performance issue on database
• Experience in maintaining Database Configuration Parameters, Tuning Database and Instance level parameters
• Troubleshooting database issues using db2diag, db2pd, Snapshots
• Generating DDL using DB2LOOKutility
• Monitoring query performance by using db2top, monitoring queries
• Worked on MS sql server database for various project related testing

Cloud:

• Experience on AWS platform and services
• Experience on aurora Postgres database administration on AWS

Automations:

• Experience in coding tools and generating reports using python scripting
• Worked on various API to generate reports
• Worked on Tableau / Power BI tools for dashboard and reporting