Venkata Mathi Email & Phone Number

Ashburn, Va, Us

Minneapolis, Mn, Us

> Supported with setup of POC environment in AWS to replicate the data from Oracle to PostgreSQL using AWS Database Migration Services.> Provided on-call support round the clock (24/7) to DB2 QREP on Mainframe & z/Linux.> Created AWS PostgreSQL database on AWS RDS.> Provided Technical solution to set up the replication for 12c databases (Native Oracle Targets) without impacting the current 11g replication setup since IBM doesn’t support federated technology for 12c databases.> Implemented / setup Parallel replication environment for 12c databases successfully and resolved the issues Identified by testing team.> Upgraded Q replication to latest DB2 FixPack level (FP7) and resolved all the issues during upgrade and provided the steps to QREP team to implement same changes in VAL and PROD. > Developed a shell script to automate the count process and this will reduce the overhead of the system from the current process and also reduce the number of processes.> Setup Event Publishing (EP) using DB2 Q Replication on z/OS.> Involved in setup of DB2 Q Replication from DB2 Mainframe to Oracle database using DB2 Federated technology. > Supported development teams in adding new tables/columns to replication process.> Troubleshooted DB2 Q Replication related issues on Mainframe and zLinux and helped team to resolve the DB2 related issues.> Automated the process to STOP/START all subscriptions in different regions. > Provided Technical solution to set up the replication on LMDC without impacting the replication on BDC for LMDC migration project and documented the steps to QREP team to implement same changes in VAL and PROD. > Worked with application / testing team to resolve the DB2 QREP issues.> Developed scripts to receive Monitoring Alerts for Q Replication

Mclean, Va, Us

> Involved with installation, configuration, patching, upgrade and Migration DB2 UDB databases and standby databases for High Availability and Disaster Recovery purpose.> Experience in managing DB2 UDB on UNIX/Linux, Sun Solaris, HP-UX & AIX> Hands on experience in DB2 HADR, TSA configuration, implementing and maintaining standby databases.> Experience in Performance Tuning and optimization using EXPLAIN PLAN, DB2 Advisory.> Extensive experience in Database online/offline, full, incremental and differential Backups.> Good experience in PATCHING AND UPGRADATION for Development and Production databases.> Good experience in Scripting for migration projects and database jobs> Provide 24X7 production support, problem resolution and recovery processes during an outage resolution.> Highly involved in performance tuning like performing REORGS, RUNSTATS on the database tables frequently and tuning SQL Queries and REBINDING them to the database.

Washington, District Of Columbia, Us

> Actively participate in the system development process including a review of database requirements for new and existing programs. Assist application developers by creating and implementing physical database designs to best-fit corporate application requirements.> Monitor and report resource utilization on all Database systems. Participate in weekly on-call rotation with other Database Administrators.> Perform CRUD operations and development using Stored Procedures and functions (PL/SQL).> Provided support for DB2 V9.1 including: SMP/E installation, customization, internal and application testing, development of migration, backout and remigration plans.> Database performance tuning through database physical design, configurations and implementations of data aggregations, partitioning, indexing and related settings.> Involved in planning and implementing archive/purge, defrag and re org activities for VLDB of 1+TB size data ware house application with an estimated reduction in storage needs of around 500 GB.