Looking for a job

Prakash Hodawadekar

@prakashhodawadekar

Message

Senior Database Administrator specializing in cloud management and performance optimization.

Canada

Message

What I'm looking for

I am seeking opportunities that foster innovation and collaboration, where I can leverage my database expertise to drive performance and reliability in cloud-native database solutions utilizing AWS and GCP technologies.

I am a Senior Database Administrator with over a decade of experience in database engineering and administration, particularly within AWS and GCP environments. My enthusiasm for leveraging my extensive skills is evident in my work supporting cutting-edge gaming technologies. I excel in performance optimization and automation using DevOps principles, and I am keen to contribute to innovative cloud-native platforms.

Throughout my career, I have maintained critical business applications with a 99.9% uptime by managing SQL and NoSQL databases, including MySQL, PostgreSQL, and MongoDB. My efforts in automating routine tasks have enhanced team efficiency by 30%, and I have established monitoring frameworks that significantly reduce system anomalies. I take pride in guiding junior DBAs and promoting knowledge sharing within my teams, ensuring a collaborative and growth-oriented environment.

Experience

Work history, roles, and key accomplishments

Current

Senior Database Administrator

Current

Cornerstone OnDemand

Oct 2023 - Present (1 year 7 months)

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.

MySQL PostgreSQL MongoDB ArangoDB DynamoDB AWS Cloudwatch Prometheus Grafana Shell Scripting Database Procedures Database Administration Performance Optimization Capacity Planning

Senior Database Administrator

Cornerstone OnDemand

Mar 2023 - Oct 2023 (7 months)

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.

Database Administration Performance Optimization AWS RDS Blue Green Deployment Database Security RBAC Encryption Terraform Elasticache Redis

Lead Database Administrator

Edcast

Jan 2020 - Feb 2023 (3 years 1 month)

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

Indexing Partitioning AWS Backup Amazon S3 AWS Glue Kafka

Lead Database Administrator

BNED LoudCloud

Jul 2016 - Dec 2019 (3 years 5 months)

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

Data Manipulation Database Design Troubleshooting Log Analysis RDS Performance Insights Cloudwatch Grafana MySQL Server Scrum

Manager

Thomas Cook India

Mar 2015 - Jun 2016 (1 year 3 months)

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.

Database Administration Data Integrity Backup Pl SQL Customer Management Cross Functional Team Management

Software Engineer

Affinity Global Inc

Jan 2011 - Mar 2015 (4 years 2 months)

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.

Schema MySQL Data Modeling Performance Tuning Troubleshooting Data Processing Data Migration

Education

Degrees, certifications, and relevant coursework

University of Mumbai

Bachelor of Science in Information Technology, Information Technology

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.

University of Mumbai

Master of Computer Applications, Computer Applications

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.