Prashanth Kollapu

US Lottery Operations (09/2022 - Present):

• The project deals with the U.S. Lottery operations that include Powerball lotteries and jackpots, which are configured under IBM Db2 and PostgreSQL on Azure Cloud.

Responsibilities:

• Managing IDM, DB2 11.5, and PostgreSQL 14.7 versions.
• Managing IDM, DB2 11.5, and PostgreSQL 14.7 versions.
• Performing reorgs, tuning scripts, and pruning jobs.
• HADR configuration.
• Fixing DB issues, such as disk and DB-related query issues.
• Managing the database on Azure cloud.

Comcast 5 NBCU MSP (10/2018 - Present)

Description: The Comcast NBCU is a mass media communication project, where we handle multiple servers of different platforms, such as PostgreSQL, MySQL, and MongoDB, to meet the customer needs that are required to perform on the DB.
Responsibilities:

• Managing various PostgreSQL 9.x, 11.x, and 12.x version servers, and MariaDB 10.x versions.
• Handling common database procedures, such as running performance tuning scripts, creating and maintaining stored procedures, user databases, and logins, as per user requirements.
• Replication setup.
• Job scheduling and script execution
• Performing database backup and restore (refresh).
• Making sure databases operate smoothly and efficiently, and fixing any errors or problems that occur.
• Performing MySQL, PostgreSQL server builds, upgrades, decommissions, server migrations, and security audits.
  Monitoring the health of servers with replication, high availability groups, and distributed availability groups.