Prakash Hodawadekar

Maintained SQL (MySQL, PostgreSQL) and NoSQL (MongoDB, ArangoDB, DynamoDB) databases, ensuring 99.9% uptime for critical business applications. Automated routine database administration tasks using Shell scripts and Stored Procedures, enhancing team efficiency. Established a monitoring framework with AWS CloudWatch, Prometheus, and Grafana, reducing system anomalies and ensuring high availability.

Authored stored procedures that automated 70% of repetitive data management tasks, freeing up resources. Monitored, administered, and optimized the performance of databases, achieving a 20% reduction in maintenance downtime. Pioneered AWS RDS Blue/Green deployments to execute seamless database version upgrades with zero critical failures.

Developed automated data cleansing routines to increase data integrity, prevent data loss, and minimize errors. Expanded database performance optimization strategies by implementing query tuning, indexing improvements, and partitioning techniques, leading to a 30% improvement in query execution times. Implemented a database backup and recovery strategy for various DB stacks using AWS Backup servic

Developed complex ad hoc queries and scripts that enhanced data manipulation processes, contributing to a 20% increase in reporting accuracy. Diagnosed and resolved complex database issues via log analysis and using native and managed tools like AWS RDS Performance Insights, CloudWatch, Grafana, PMM, and NewRelic. Managed MySQL Server installation and updates lifecycle, maintaining 99.9% server up

Supported database administration tasks that maintained data integrity across multiple internal applications. Created automated scripts for database backup and monitoring, reducing maintenance time by 30%. Collaborated with cross-functional teams to gather requirements, design, and develop PLSQL modules for the customer management system.

Translated complex project requirements into data schemas, supporting long-term business objectives and IT strategies. Assisted in developing database parser software to automate data loading processes, increasing efficiency by 20%. Developed and maintained MySQL databases, including data modeling, performance tuning, and troubleshooting.

Completed a comprehensive program in Information Technology, covering fundamental principles of computer science, software engineering, and data management. Developed strong analytical and problem-solving skills in IT domains.

Pursued advanced studies in computer applications, focusing on software development methodologies, database systems, and network management. Gained expertise in designing and implementing complex software solutions.