Prasanthi Gurubelli

Professional with over 9+ years database administration experience in DB2 LUW (Unix), 4 years in Oracle and PostgreSQL (AWS).

Experience in supporting business critical production servers and efficiently solving issues within Service Level Agreement. Extensive experience in supporting DB2 LUW versions 9.7/10.5/11, DB2 HADR, SQL/QReplication, Oracle 19C, Aurora PostgreSQL, Goldengate, Shareplex, Amazon Web Services(AWS) – EC2/RDS, Jenkins, UNIX Shell Scripting.

Experience in cloud environments such as AWS and OCI. Dedicated team player with strong work ethic and fast learning curve; excellent communication and troubleshooting skills.

CONSULTANT ORACLE/DB2 DBA at Verizon (2021-01 – 2025-12)

A leading telecommunications company providing wireless, wireline and networking solutions serving consumers, businesses, and government globally.

• Responsible for creating Linux(EC2) servers, carving out storage, creating database users, deploying database binaries, creating and populating databases via export/import and by using AWS Schema Conversion tool (SCT) and Data Migration service (DMS).
• Responsible for DB2 to Aurora Postgres Migrations using AWS Schema Conversion tool (SCT) and Data Migration service (DMS).
• Experience in spinning up Linux(EC2) servers and performing Quarterly Rehydrations.
• Participated in Disaster Recovery exercises for Aurora Postgres and Oracle.
• Applied Oracle PSUs on a regular basis.
• Performing deployments and releases frequently in all environments using Jenkins/CICD pipeline.
• Extensively used Export/Import/Datapump utilities for selective Backup, transferred tables between Oracle Instances.
• Experience in oracle database administration across broad environments like onprem standalone, Rac Cluster, OCI and ATP.
• Worked with Shareplex replication for data sync of tables across multiple applications.
• Oracle Database user management by creating users and granting required roles/privileges after standard approvals.
• Developed shell scripts to monitor databases and to generate alerts for critical situations.

CONSULTANT DATABASE (DB2) at Verizon (2014-03 – 2020-12)

A leading telecommunications company providing wireless, wireline and networking solutions serving consumers, businesses, and government globally.

• Performed database installation, Configurations and administration of DB2 LUW databases on AIX, Linux & Solaris platforms.
• Determined project requirements; planned for database backup & recovery, infrastructure, capacity and maintenance.
• Performed Schema/Database Refreshes as part of Application Requirements.
• Performed database performance tuning and optimization.
• Troubleshooted and resolved DB2 issues within SLA.
• Collaborated with System admins and application teams for the change requests like OS patching, Middleware upgrades, Database upgrades.
• Performed database version upgrades and fix pack installations and patch updates.
• Performed database migrations from AIX/Solaris to Linux.
• Configuring HADR, SQL Replication and DR Setup with Log Shipping and supporting.
• Support databases on Linux VERITAS & REDHAT clustering and Aix HACMP.
• DB2Audit/Splunk setup and configuration to capture database events.
• Configuration of Native encryption & SSL connections Encryption.
• Performing redirect restore/ roll forward from one environment to another.
• Monitoring the database manager, databases, locks, applications, table spaces, active logs etc. by using snapshot, db2pd, db2top and event monitors.
• Perform data Export/Import with data movement utilities such as Load, DB2move, and import/export.
• Perform and support database design, Data analysis, performance tuning, monitoring and application support.
• Participated in Disaster Recovery exercises.
• Automated the DB2 services shutdown / startup, Healthchecks for system maintenance activities.
• Involved in depth analysis for recurring db2 issues and resolved issues timely.
• Responsible for migrating the DB2 databases across the data centers.
• Monitored and tuned databases for performance, provided query analysis, expanded / rebalanced tablespaces. Troubleshoot issues related to database locks, memory/CPU, heap, swap etc.
• Provided extensive on call support for 24*7 production environments as primary DB2 DBA.
• Worked closely on IBM PMR's and Implement a permanent fix to DB2 databases as advised.

Information Specialist at NewtGlobal (2012-04 – 2014-02)

A leading telecommunications company. Client: Verizon

• Provided 24x7 database support for DB2 LUW databases.
• Installed and configured DB2 using system5/RPM installation packages for database product deployments on Linux, AIX, Solaris servers.
• Performed database upgrades, backup and restore/rollforward operations, failover and failback.
• Performed database loads and unloads; Implemented database life-cycle maintenance.
• Setting up new environments for debugging production issues in applications and setting environments for tests.
• Table space management – Adding, dropping, extending, reducing and resizing table space containers, Create and managing SMS, DMS, and Automatic Storage table spaces.
• Analyze the diagnostic log records for any problems and troubleshooting. Solve any issues reported in the db2 diagnosis log.
• Used shell scripts for reporting database health checks and to run maintenance jobs.

B.E – Vasavi College Of Engineering (2007)