Swetha Manavalan

Results-driven Database Administrator with extensive expertise in managing multi-database environments including Cassandra, Postgres and Oracle across on-prem and cloud platforms. Experienced in performance tuning, high availability and production support, with a proven track record of improving and reducing the latency by up to 40%.

Senior System Engineer at PRODAPT SOLUTIONS PVT LMT (2025-06 – Present)

• Managed user creation, role-based access control (RBAC), and least-privilege permissions across Cassandra and PostgreSQL, ensuring 100% accurate and compliant access provisioning.
• Executed SQL scripts and production deployments across on-premise and AWS RDS PostgreSQL environments with proper validation and rollback strategies, ensuring safe and reliable releases.
• Resolved data inconsistencies in Cassandra using read-repair techniques and carried out Solr core reindexing to restoring Search functionality and data integrity
• Performed RCA for production issues using Dynatrace and Grafana dashboards, reducing repeated incidents by 25% and improving system stability.
• Monitored and optimized PostgreSQL and Cassandra performance by analyzing query execution, managing connection usage, and resolving long-running and blocking sessions, improving DB responsiveness by 20%.
• Performed AWS RDS PostgreSQL minor version upgrades across 100+ production instances, achieving 98%+ success rate with minimal downtime using snapshots and roll back strategies.
• Decommissioned redundant AWS RDS production instances to optimize resource usage, achieving cost savings without impacting availability or data integrity.
• Performed instance type upgrades, failover and switch over operation in AWS RDS ensuring seamless transitions, performance optimization and zero/minimal service disruption.

System Engineer at TATA CONSULTANCY SERVICES LIMITED (2021-12 – 2025-05)

• Optimized Cassandra table designs, improving response times by 35% and reducing transaction latency by 30 seconds.
• Automated 90% of Cosmos DB backup processes using shell scripts and configuration management tools, ensuring 99.99% data availability.
• Configured high availability, replication, and fault tolerance strategies across Cassandra clusters, reducing downtime by 60%
• Performed patch management, rolling upgrades, and failover testing across Cassandra clusters to ensure continuous operations and minimal downtime.
• Led the migration of on-premises databases to Azure Cosmos DB, achieving cost reduction, improved scalability, and enhanced system availability.
• Implemented and managed SSL certificate renewals across database clusters to strengthen security and maintain compliance standard.
• Diagnosed and resolved 95% of Level 2 database incidents, escalating critical issues promptly within SLA guidelines.
• Fine-tuned CQL queries, indexing strategies, and node configurations to boost data retrieval efficiency by 40%.
• Performed node repairs, data consistency checks, and backup/restore operations using Nodetool and automation scripts, improving database stability and reliability.
• Led Root Cause Analysis (RCA) investigations for production incidents, implementing long-term corrective actions to prevent issue recurrence.
• Monitored database health and performance using Dynatrace, enabling proactive issue detection and real-time alerting.

Master's degree in Computer Application – Ethiraj college for Women (2019 – 2021)

Bachelor's degree in Computer Application – St. Joseph's College of Arts and Science (2016 – 2019)