Rohit Vaddi
O'Fallon,Missouri
Summary
Dynamic Lead Platform Engineer with over 11 years of expertise in designing, deploying, and supporting large-scale database platforms, including PostgreSQL, Cassandra, and Redis, in both on-premises and AWS environments. Possesses a robust foundation in distributed systems, performance tuning, replication, high availability, observability, and database modernization. Demonstrated success in enterprise cloud migrations, implementing disaster recovery strategies, optimizing database performance, and automating operational workflows to enhance overall system efficiency. Recognized for enabling high-throughput, low-latency systems while ensuring reliability and security across diverse platforms.
Platform engineering professional with deep understanding of system architecture and cloud environments. Possesses history of driving infrastructure improvements and automating processes to enhance operational efficiency. Focused on collaborative team efforts and adaptable to dynamic project requirements, ensuring dependable and flexible performance. Skilled in infrastructure as code, containerization, and cloud services, valued for reliability and problem-solving abilities.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Lead Platform Engineer
Mastercard
06.2024 - Current
- Develop automated database platform solutions using Infrastructure-as-Code (IaC), leveraging AWS CloudFormation to provision, configure, and standardize cloud infrastructure components.
- Migrated legacy CloudFormation templates to AWS CDK, redesigning infrastructure automation using TypeScript, improving modularity, maintainability, and deployment accuracy across environments.
- Architect and deploy 9-node Apache Cassandra clusters in on-premises data centers, including node provisioning, topology design, capacity planning, and automated bootstrap/rebuild workflows.
- Designed and implemented an on-prem 6-node PostgreSQL BDR (Bi-Directional Replication) cluster with a proxy layer for load balancing, conflict avoidance, high availability, and seamless failover routing.
- Introduced AWS Keyspaces as a new managed Cassandra technology into the Mastercard cloud ecosystem, driving architecture reviews, preparing CRB presentations, and ensuring the implementation adhered to Mastercard’s security, governance, and compliance standards.
- Developed IaC modules and automated operational workflows using AWS CDK, CloudFormation, shell scripting, and internal automation frameworks, reducing manual operational tasks.
- Integrated Cassandra and PostgreSQL platform telemetry with Dynatrace, creating dashboards, baseline thresholds, alerting policies, and performance indicators for proactive issue detection.
- Collaborated with platform, cloud, and application engineering teams to define infrastructure patterns, best practices, modernization roadmaps, and cross-team architectural alignment.
- Implemented strong security practices, enforcing IAM governance, TLS encryption, certificate management, and compliance with PCI and internal audit requirements.
- Built and integrated AWS Lambda functions to automate operational workflows, environment validation, cluster health checks, and repetitive database administration tasks, reducing manual effort and improving platform reliability.
- Designed and developed Aurora PostgreSQL database environments, including cluster provisioning, parameter tuning, performance optimization, and integration with application workloads.
Database Administrator
NetCracker
03.2013 - 03.2022
- Installed, configured, and administered OSS Redis, Redis Enterprise, and AWS ElastiCache Redis in high-availability, low-latency environments.
- Set up Redis replication and clustering, and performed performance tuning including memory optimization, eviction policy tuning, latency analysis, and slowlog review.
- Implemented Redis monitoring using RedisInsight, CloudWatch, and integrated alerting systems.
- Installed, configured, upgraded, and tuned PostgreSQL across on-prem, EC2, RDS, and Aurora PostgreSQL environments.
- Implemented PostgreSQL Streaming Replication, Hot Standby, and BDR multi-master replication for high availability and disaster recovery.
- Designed and executed PostgreSQL backup and recovery strategies using pg_dump, pg_dumpall, and pg_basebackup.
- Performed PostgreSQL performance tuning, query optimization, indexing, VACUUM management, and bloat analysis using EXPLAIN ANALYZE and automated reporting.
- Automated PostgreSQL and replication tasks including cluster deployment, backups, benchmarking, and maintenance using Ansible and AWS Lambda.
- Migrated databases from on-prem Oracle to Aurora PostgreSQL using AWS DMS and SCT tools.
- Installed, configured, and maintained Cassandra, MongoDB, Oracle, MySQL/MariaDB, Elasticsearch, and SQL Server databases.
- Installed, configured, and upgraded Cassandra clusters, including node management, repair strategies, topology setup, and multi-datacenter deployments.
- Installed and upgraded MySQL/MariaDB databases, configured master–slave replication, and deployed MaxScale and Galera clusters for high availability.
- Conducted migration of MySQL workloads from on-prem and cloud environments to Aurora MySQL.
- Automated RDS provisioning and infrastructure workflows using AWS CloudFormation and Jenkins pipelines.
- Performed database health checks and monitoring using AppDynamics, CloudWatch, SolarWinds, and Nagios.
- Designed and implemented backup strategies and automated routine DBA tasks (installation, backups, cleanup, data extraction).
- Managed and supported large enterprise database environments, including multi-terabyte deployments up to 1000 TB.
- Performed Oracle DBA responsibilities including production monitoring, troubleshooting, backup/recovery, and performance tuning.
- Collaborated with architects and engineering teams to design database schemas, data models, and infrastructure standards.
- Implemented blue-green deployments and executed controlled cutovers for cloud database environments.
Education
Master of Science - Project Management
Northeastern University
Boston, Massachusetts, MA04-2024
Bachelors in Technology - Computer Science
JNTU
Hyderabad, India04-2012
Skills
- Database management: PostgreSQL, Cassandra, Redis, MySQL
- Experience with cloud platforms: AWS and Azure
- Scripting and infrastructure automation expertise
- Skilled in observability platforms
- Database replication and clustering
- Cloud infrastructure oversight
- Managed serverless solutions
- Linux environment configuration
- Agile development methodologies
Certification
- AWS Solutions Architect – Associate
- AWS Database Specialty
- PostgreSQL Certified Professional
- Cassandra Certified Administrator
- Cassandra Certified Developer
- Oracle Certified Professional (OCP)
- PMP – Project Management Professional
- Scrum Master Certified
- ISTQB – Certified Tester
Timeline
Lead Platform Engineer
Mastercard
06.2024 - Current
Database Administrator
NetCracker
03.2013 - 03.2022
Master of Science - Project Management
Northeastern University
Bachelors in Technology - Computer Science
JNTU