Aparna R Prabhu

Database Administrator with 6+ years of experience in managing and optimizing MySQL, PostgreSQL, MongoDB, and Oracle databases across production environments. Experienced in performance tuning, query optimization, automation, AWS cloud infrastructure, and high-availability systems. Strong background in both DBA operations and backend SQL, PL/SQL development, with expertise in reducing infrastructure costs, improving database reliability, and automating operational workflows using Shell scripting and AWS services.

Database Administrator at Tata Consultancy Services (2022-11 – Present)

Database Administrator - Project 1: National Single Window System (NSWS) at Tata Consultancy Services (2025-01 – Present)

• Managed administration, monitoring, backup & recovery, and performance optimization of production MySQL, PostgreSQL, MongoDB, and Cassandra databases in high-availability environments.
• Served as the primary DBA for critical production systems, ensuring database uptime, security, operational reliability, and incident resolution.
• Optimized complex SQL queries, indexing strategies, and materialized views, significantly improving application and Power BI reporting performance.
• Reduced AWS infrastructure costs by approximately $200/month through database instance optimization, workload tuning, and storage management.
• Automated database archival, cleanup, monitoring, and maintenance workflows using Shell scripting and AWS Lambda, reducing manual operational effort.
• Designed and implemented data retention and archival policies to improve storage efficiency and long-term database performance.
• Integrated and validated large-scale datasets from multiple government ministries while ensuring data consistency, integrity, and availability.
• Implemented role-based access controls and customized authentication mechanisms to strengthen database security.
• Proactively monitored database performance using AWS CloudWatch and Glowroot, identifying bottlenecks and resolving production issues.
• Led incident management and root cause analysis (RCA) for database-related production issues, minimizing downtime and improving system stability.
• Collaborated with developers, analysts, and business stakeholders to design scalable data pipelines and database solutions aligned with business requirements.

Database Administrator - Project 2: Invest India Grid Platform at Tata Consultancy Services (2022-11 – 2024-12)

• Developed and maintained MySQL stored procedures, triggers, functions, and database objects to support application and business requirements.
• Designed and modified database schemas, tables, and column structures to support evolving application functionality and data models.
• Optimized complex SQL queries and indexing strategies to improve database performance and application response times.
• Performed database backup, restoration, import/export, and migration activities while ensuring data integrity and availability.
• Supported database deployment, troubleshooting, and production issue resolution in collaboration with development teams.
• Managed day-to-day MySQL database operations, monitoring, and maintenance activities across production and staging environments.

C++ / Oracle Developer at London Stock Exchange Group (2019-09 – 2022-06)

• Developed and maintained backend applications using C++ and Oracle for high-performance data processing and enterprise workflows.
• Wrote and optimized complex SQL queries, joins, stored procedures, and database operations to improve data retrieval efficiency and application performance.
• Assisted in database schema design, normalization, and table structure optimization to support scalable application functionality.
• Troubleshot and resolved application-level and database-related production issues, ensuring system stability and operational reliability.
• Collaborated with cross-functional teams to implement backend enhancements, database modifications, and performance improvements.
• Worked closely with MySQL databases to support data processing, transaction handling, and backend integration requirements.

Bachelor of Engineering (B.E.) in Electronics & Telecommunication – BMS College of Engineering (2019)

Pre-University (12th) – Jnana Sweekar PU College (2015)

SSLC (10th) – Sri Kumarans Children's Home (2013)