Summary
Overview
Work History
Education
Skills
Timeline
Generic
PHANI PRATHYUSH

PHANI PRATHYUSH

Infra Database Administrator
Hyderabad

Summary

A Versatile DBA with over 15 years of successful experience in Database Administration, Database Migration of Cross platforms. Experience in migration of Oracle to Postgresql, Oracle to MSSql. Experience in migrating Apache Cassandra database to Azure CosmosDB using Arcion. Experience in managing multi-flavored databases viz., Oracle, PostgreSQL, MySQL, MongoDB, Cassandra, and DB2 UDB Recognized consistently for performance excellence and contributions to success in retail, banking and insurance industries. Strengths in understanding the situation to respond and patiently polite backed by training in ITIL. Competent System Engineer offering wealth of experience in project management, scripting and Remote Desktop Services. Offer Master of Information Systems degree and desire to work in Information Services industry and I target to see myself as a Cloud specialist and a ML/AI operations specialist. Multi-Flavored Cloud Admin consistently rewarded for success in planning and operational improvements. Experience in policy development and staff management procedures positively impacting overall morale and productivity. Enthusiastic DBA eager to contribute to team success through hard work, attention to detail and excellent organizational skills. Clear understanding of Oracle, Exadata DMA, MySQL, Postgres, MongoDB, MS SQL and training in Git-hub, Chef and Jenkins. Motivated to learn, grow and excel in IT industry

Overview

16
16
years of professional experience
6
6
years of post-secondary education

Work History

Infra Database Lead

Techmojo Solutions Pvt Ltd
Hyderabad
12.2022 - 03.2025
  • Configured PostgreSQL databases on AWS RDS.
  • Built Cassandra Cluster on EC2 Instances.
  • Automated Flyway Jobs Using Jenkins, GitLab.
  • Worked on Debezium and POC on Striim.
  • Had Experience on Dynatrace, Grafana.
  • Built Redis database cluster on Elasticcahe & on EC2 Instances.

Cloud Architect

Gap Inc
Hyderabad
08.2019 - 12.2022
  • Migration of databases from on-prem to cloud(OCI, Azure)
  • Setup OEM for development and production databases and registering around 300 databases
  • Created OCI and Azure cloud tenants for oracle, mysql, and postgres databases
  • Migrated oracle databases from 11g,12c to 19c
  • Deployed jobs using Jenkins and chef
  • Habituated with git-hub to add servers/databases to nagios monitor
  • Set up and controlled user profiles and access levels for each database segment to protect important data
  • Identified and remediated single points of failure and security risks.

Senior Associate

Cognizant Technology Solutions
Singapore
08.2014 - 08.2019
  • Created and implemented database designs and data models
  • Built databases and table structures for web applications
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers
  • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process
  • Created scripts and processes for data integration and maintenance
  • Utilized Python to handle debugging and automation scripting tasks
  • Planned, implemented and integrated updated system-oriented projects
  • Analyzed requirements and implemented systems to deliver comprehensive system development life cycle solutions
  • 11g MAA Set up for about 20 databases
  • Configured Goldengate for homogeneous transactions, both on RAC and non RAC systems
  • Installation of Cassandra and Postgres and configuring datastax and application tier for databases respectively
  • Intermediary support of MySQL and MS SQL Server too
  • Integrated OEM to SNOW to generate INC tickets

Analyst - Database Administration

Verizon Data Services India Pvt Ltd
Hyderabad
07.2011 - 08.2014
  • Data Center Consolidation for Oracle databases
  • Worked on Cassandra NoSQL database and created Keyspaces tables based on requirements of queries need to be run on tables and compaction strategy
  • Installed/Configured and Supported Multiple Cassandra Clusters and Oracle DBs in AWS
  • Contributed to DB2 and MS SQL Server databases while partaking in regular oracle administration activities
  • Planned and conceived computer systems using information engineering, data modeling and structured analysis
  • Planned and implemented security measures to safeguard vital business data
  • Tested programs and databases to identify issues and make necessary modifications
  • Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process
  • Created and implemented database designs and data models
  • Administered, supported and monitored databases by proactively resolving database issues and maintaining servers
  • Wrote and maintained technical and functional specifications to document database intentions and requirements
  • Created scripts and processes for data integration and maintenance
  • Established compatibility with third party software products by developing program for modification and integration

Apps Database Administrator

Wissen Infotech Pvt Ltd
Hyderabad
06.2009 - 07.2011
  • Trainee Database administrator involved in almost all activities of database administrator for Oracle, Teradata, MsSQL and Postgres
  • Installation, Maintenance & Configuration of databases
  • Distribution of Table spaces among different disks and creation of db objects and monitoring tablespaces
  • Clone apps tier and db tier using AppWorx tool
  • Monitoring Mount points (Disk) for space issues and solving them
  • Db crash recovery and analysis
  • Implementation of 10g RAC systems
  • Developed PL/SQL code for client needs

Education

Master of Science - Computer Applications

Jawaharlal Nehru Technological University
Hyderabad, TG
08.2006 - 05.2009

Bachelor of Science - Physics, Chemistry, And Mathematics

Osmania University
Hyderabad, TG
06.2003 - 04.2006

Skills

Oracle RAC 11g, OEM 12c

Exadata, Dataguard, Goldengate

PostgreSQL DB Administration

Cassandra DB Administration

Redis DB Administration

MySQL DB Administration

Timeline

Infra Database Lead

Techmojo Solutions Pvt Ltd
12.2022 - 03.2025

Cloud Architect

Gap Inc
08.2019 - 12.2022

Senior Associate

Cognizant Technology Solutions
08.2014 - 08.2019

Analyst - Database Administration

Verizon Data Services India Pvt Ltd
07.2011 - 08.2014

Apps Database Administrator

Wissen Infotech Pvt Ltd
06.2009 - 07.2011

Master of Science - Computer Applications

Jawaharlal Nehru Technological University
08.2006 - 05.2009

Bachelor of Science - Physics, Chemistry, And Mathematics

Osmania University
06.2003 - 04.2006
PHANI PRATHYUSHInfra Database Administrator