Venkata Mathi

Venkata Mathi Email and Phone Number

Sr. IBM DB2 and QREP Administrator at Center’s for Medicare and Medicaid Services (CMS) @ Select Computing, Inc. (SCi)
Ashburn, VA, US
Venkata Mathi's Location
Ashburn, Virginia, United States, United States
Venkata Mathi's Contact Details

Venkata Mathi personal email

n/a
About Venkata Mathi

> 20+ years of IT experience as IBM DB2 UDB, SQL Server, PostgreSQL, Oracle and Vertica analytics DBA in IBM DB2 UDB 12/11/10.5/10.1/9.5, MSSQL 2019/2014/2012/2008, Oracle 19c/18c/12c/11g, PostgreSQL 11/10.5, MySQL 5.1/4.1, Vertica 9.3/9.0 database design, implementation, administration, tuning and troubleshooting. Eexperienced in very large-scale Multitenant Architecture CDB/PDB database environments.> Experience in AWS cloud technologies including Virtual Servers EC2, database service RDS and Virtual private cloud(VPC)> Proficient in Database Design/Architecture, Disaster recovery, SQL Mirroring, Log Shipping, SQL Server AlwaysON, HADR, Multi-subnet AlwaysOn, Backup and Rollforward recovery techniques. Strong in SQL & Application Tuning. Expertise in DBA Scripts for adhoc backup & recovery and Database tuning.> Managed a comprehensive and ongoing release management and planning program. Scheduled and managed all performance tuning and troubleshooting efforts.> Review, recommend and monitor the source code/versioning management function adhering to technical management guidelines.> Utilized standard tools and methodology to develop system and support performance metrics.> Act as primary conduit to and representative of the IT Operations team. Oversee support efforts between IT Operations and other Dignity Health teams, provide escalation and resolution functions when necessary.> Perform crisis management during high-severity operational incidents by following the problem management, change management and service management processes. > 24/7 support of production database services to ensure the highest standards of availability resilience, integrity, security and performance required by our business > Work within a cross functional Agile team to develop new components in a highly iterative fashion. Involves close collaboration with product owners, QA, and operational teams.> Evaluate and manage existing software and licensing configurations, systems and the design, implementation and management of new/improved systems.> Working with Project Managers to identify and manage risks, issues and opportunities for the systems, including the development of contingency plans and provide development and design assistance to development and other application support teams.> Supported end-to-end project plans to track milestones / quality toll gates & delivery timelines to further track and escalate project risks, issues, dependencies, control gaps, and minutes the action items.

Venkata Mathi's Current Company Details
Select Computing, Inc. (SCi)

Select Computing, Inc. (Sci)

View
Sr. IBM DB2 and QREP Administrator at Center’s for Medicare and Medicaid Services (CMS)
Ashburn, VA, US
Venkata Mathi Work Experience Details
  • Select Computing, Inc. (Sci)
    Sr. Ibm Db2 And Qrep Administrator At Center’S For Medicare And Medicaid Services (Cms)
    Select Computing, Inc. (Sci)
    Ashburn, Va, Us
  • Select Computing, Inc. (Sci)
    Sr. Ibm Db2 / Qrep Administrator At Center’S For Medicare & Medicaid Services (Cms)
    Select Computing, Inc. (Sci) Oct 2013 - Present
    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
  • Freddie Mac
    Sr. Db2 Udb Database Administrator / Engineer
    Freddie Mac Jan 2012 - Sep 2013
    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.
  • Internal Revenue Service
    Sr. Db2 Udb Database Administrator
    Internal Revenue Service Aug 2011 - Jan 2012
    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.
  • Zurich Financial Services (Ukisa) Group Services Limited
    Sr. Database Architect / Onsite Offshore Coordinator
    Zurich Financial Services (Ukisa) Group Services Limited May 2007 - Aug 2011

Venkata Mathi Education Details

  • Nagpur University
    Nagpur University
    Engineering

Frequently Asked Questions about Venkata Mathi

What company does Venkata Mathi work for?

Venkata Mathi works for Select Computing, Inc. (Sci)

What is Venkata Mathi's role at the current company?

Venkata Mathi's current role is Sr. IBM DB2 and QREP Administrator at Center’s for Medicare and Medicaid Services (CMS).

What is Venkata Mathi's email address?

Venkata Mathi's email address is vm****@****csc.com

What schools did Venkata Mathi attend?

Venkata Mathi attended Nagpur University.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.