Senior MySQL/AWS Database Administrator

NAKUL VINAYAK PANSE

*****.*********@*****.*** +91-996*******

PROFILE SNAPSHOT

SENIOR MYSQL/AWS DATABASE ADMINISTRATOR MYSQL, MARIADB, AWS RDS, PERFORMANCE TUNING & CLOUD SOLUTIONS

Experienced MySQL/AWS DBA with over 10+ years of expertise in database administration, including MySQL, MariaDB, Aurora MySQL, and AWS RDS. Proficient in database replication (master-slave, InnoDB clustering), performance tuning, database migrations, and cloud environments (AWS, Azure). Strong background in automation using shell scripting, Terraform, and CronJobs to streamline backup, monitoring, and maintenance tasks. Extensive experience with database optimization, logical and physical backups, and user management in both cloud and on-prem environments. Demonstrated ability to lead large-scale database migrations, implement disaster recovery strategies, and collaborate effectively with cross-functional teams to ensure high availability and data integrity.

CORE ACUMEN

Problem-Solving & Analytical Skills Collaboration & Teamwork

Project Management & Documentation Customer-Centric Approach

Adaptability & Innovation Continuous Learning & Professional Growth

Security & Compliance Awareness Communication & Leadership

Time Management & Efficiency Performance Tuning TECHNICAL SKILLS

Databases: MySQL (5.6, 5.7, 8.0), MariaDB, Aurora MySQL, MSSQL, MongoDB, PostgreSQL

Cloud: AWS (RDS, Aurora, IAM, CloudWatch), Azure SQL, Terraform (IaC)

Backup & Recovery: MariaBackup, MySQL dump, AWS RDS backup/restore

Replication & Clustering: MySQL replication, InnoDB clustering, Aurora replication

Performance Tuning: Query optimization, indexing, memory & disk space management

Automation: Shell scripting, Crontab, Terraform commands

Tools: MySQL Workbench, ServiceNow, Jira

Operating Systems: Linux (RHEL, CentOS), Windows Server

Networking: Database connections, user access management over networks EDUCATION

Master of Computer Application (MCA)

Shivaji University, Kolhapur, Maharashtra, India – 2013

Bachelor of Computer Application (BCA)

Dr. B.A.M. University, Aurangabad, Maharashtra, India – 2010 CERTIFICATIONS

Oracle SQL Expert Certified (10g)

AWS Cloud Practitioner Essentials

AWS Certified Solutions Architect – Associate

Preparing for Azure Database Administrator (DP-300)

Preparing for AWS Certified Solutions Architect – Professional WORK EXPERIENCE

LTIMindtree

Senior Specialist, MySQL/AWS DBA April 2025 – Present

Spearheaded the administration of MySQL and MariaDB database systems in AWS RDS and on-premises environments, ensuring optimal performance and availability.

Configured and maintained InnoDB clusters for high availability and load balancing across multiple regions in AWS, ensuring 99.99% uptime.

Managed database replication for master-slave setups and implemented disaster recovery solutions using AWS RDS snapshots, MariaBackup, and MySQL dumps.

Optimized database performance by analyzing slow queries, indexing strategies, and server configuration, resulting in a 30% reduction in query execution time.

Led database upgrades from MySQL 5.6/5.7 to 8.0, including schema migration and testing for application compatibility.

Automated database management tasks, including backups, performance monitoring, and patching, through shell scripting and CronJobs.

Provided mentoring and training to junior database administrators, improving team efficiency in handling complex database issues.

Zensar Technologies

Senior Engineer, MySQL/AWS DBA March 2022 – April 2025

Managed over 150 MySQL and MariaDB database instances deployed in AWS RDS and on-premises Linux/Windows servers.

Designed and implemented a highly efficient database migration strategy, successfully migrating on-premises MySQL databases to AWS RDS with zero downtime and minimal data loss.

Played a key role in the configuration of replication architectures, including both master-slave and master-master replication for high availability.

Streamlined database performance by identifying and resolving bottlenecks in query processing, resulting in improved application performance.

Led the creation of detailed backup and disaster recovery plans, implementing point-in-time recovery (PITR) for critical production databases.

Implemented and tested InnoDB cluster setups for high availability on Windows Server, providing 24/7 operational support and ensuring zero data loss during failover events.

Worked closely with developers and application teams to troubleshoot database performance issues and ensure compatibility with various MySQL and MariaDB versions. Wipro Technologies

Senior Administrator, MySQL DBA February 2020 – March 2022

Administered MySQL and MariaDB database engines in both cloud and on-premise environments, ensuring continuous service availability and performance optimization.

Oversaw database upgrades from MySQL 5.7 to 8.0 and MariaDB 10.4 to 10.6, ensuring smooth transitions with minimal downtime.

Configured and managed user access and permissions for multiple database environments, enforcing security policies and compliance standards.

Implemented backup strategies using MySQL dumps and MariaBackup for large-scale databases, ensuring data integrity and minimal recovery times.

Utilized MySQL Workbench for database administration and performance tuning, providing comprehensive diagnostics and improving query performance.

Led the integration of monitoring solutions using AWS CloudWatch and third-party tools for proactive performance tuning and health checks.

Conneqt Business Solutions

Senior Executive, MySQL DBA May 2018 – February 2020

Administered high-availability MySQL and MariaDB databases, ensuring efficient replication and data redundancy across multiple environments.

Performed database migrations from Windows to Linux environments, including full data transfer, schema migration, and testing for application compatibility.

Developed and maintained batch files and shell scripts for database backups, maintenance, and optimization, ensuring seamless operational workflows.

Collaborated with the development team to improve query performance by identifying inefficient SQL queries and proposing optimization techniques.

Provided on-call support and troubleshooting for critical production databases, resolving issues related to replication, performance, and data consistency.

Infinity Labs

MySQL DBA November 2016 – November 2017

Provided full lifecycle administration for MySQL databases, ensuring their availability, performance, and security across development and production environments.

Implemented database performance tuning, including query optimization, indexing, and server parameter adjustments.

Assisted in the migration of MySQL databases between on-premises and cloud environments, improving overall system scalability and reliability.

Worked with the development team to ensure database security compliance, including proper user management and privilege settings.

Maintained comprehensive backup and recovery procedures, ensuring business continuity and minimal downtime during disaster recovery scenarios.

Arrive Technologies

SQL Developer March 2014 – March 2016

Developed and optimized complex SQL queries to meet business requirements and improve application performance.

Provided database administration support for SQL Server and MySQL databases, including routine maintenance, upgrades, and performance tuning.

Created stored procedures, views, and triggers to automate database tasks and ensure data integrity.

Assisted in data migration projects, moving data from legacy systems to modern SQL Server and MySQL databases.

Collaborated with the development team to ensure the integrity and efficiency of data processing operations across multiple platforms.

PROJECT PROFILE

EMS (Dubai-based) Client: EMS Supported OS: Windows, Linux DB Versions: MySQL 5.6, 5.7, 8.0 Technologies Used: MySQL, MariaDB, AWS RDS, Terraform, AWS IAM, AWS CloudWatch

Managed database monitoring, performance diagnostics, and alert management for MySQL databases.

Collaborated with clients on database migrations, ensuring minimal downtime during the transition between Windows and Linux platforms.

Worked with the backup team to configure and validate backup strategies for MySQL instances across multiple environments.

Used Terraform to automate provisioning and management of AWS resources, including MySQL RDS instances, ensuring seamless infrastructure deployment and updates.

Implemented AWS CloudWatch to monitor primary RDS instances and configured alerts for proactive issue resolution.

Led database refresh activities, ensuring up-to-date environments for development and testing purposes. STC (Dubai-based) Client: STC Supported OS: Windows, Linux DB Versions: MySQL 5.6, 5.7 Technologies Used: MySQL, MariaDB, AWS RDS, Terraform, AWS IAM, AWS CloudWatch

Responsible for daily database monitoring and diagnosing database performance issues by analyzing alert logs and system metrics.

Coordinated with clients during migration activities to move MySQL databases from Windows to Linux, ensuring data integrity and minimal service disruption.

Regularly updated MySQL RDS instances on AWS, applying patches and upgrades with minimal downtime using the Blue/Green deployment method.

Managed user access control, created database users, and assigned appropriate privileges based on client requirements.

Automated database maintenance tasks such as backups, database refreshes, and scheduled jobs using CronJobs. RJILAUTO (India-based) Client: RJILAUTO Supported OS: Windows, Linux DB Versions: MySQL 5.6, 5.7 Technologies Used: MySQL, MariaDB, AWS RDS, Terraform, AWS IAM

Managed MySQL and MariaDB databases across Windows and Linux platforms, ensuring high availability and fault tolerance.

Supported database migrations from legacy Windows environments to Linux-based systems, optimizing database performance during the transition.

Worked with the backup team to ensure database backups were configured properly and that regular restorations were successfully tested.

Extensively used MySQL utilities for database health checks, including monitoring disk and memory space usage, and resolving performance issues.

Indian Bank & Canara Bank (India-based) Clients: Indian Bank, Canara Bank Supported OS: Windows, Linux DB Versions: MySQL 5.6, 5.7 Technologies Used: MySQL, MariaDB, AWS RDS, Terraform, AWS CloudWatch, AWS IAM

Administered MySQL and MariaDB databases for large-scale enterprise environments, ensuring security, performance tuning, and backup integrity.

Implemented RDS monitoring using AWS CloudWatch to track resource utilization and set up alerts for proactive management.

Created and managed MySQL AWS RDS instances and Aurora MySQL instances, providing operational support and incident management for critical P1 and P2 issues.

Performed database upgrades from lower versions to MySQL 8.0, ensuring smooth application integration with minimal downtime.

Conducted database refresh activities to ensure development and production environments were consistent and up-to- date.

Firmenich (Geneva, Switzerland-based) Client: Firmenich Supported OS: Windows, Linux DB Versions: MySQL 5.6, 5.7, 8.0

Technologies Used: MySQL, MariaDB, AWS RDS, Terraform, AWS IAM, AWS CloudWatch, Terraform

Supported the installation, configuration, and maintenance of MySQL and MariaDB databases across multiple environments.

Created and managed Read Replicas for AWS RDS instances, improving database availability and ensuring high performance for critical applications.

Actively participated in patching activities and database upgrades, working closely with clients to ensure minimal disruption to services.

Provided support for data migration from Windows environments to Linux, ensuring seamless service during the transition.

Performed daily database health checks and monitored critical alerts, ensuring databases remained optimized and reliable. Netgear (Global-based) Client: Netgear Supported OS: Windows, Linux, Cloud (AWS, Azure) DB Versions: MySQL 5.7.34, MySQL 8.0.43 (All new versions) Technologies Used: MySQL, MariaDB, AWS RDS, Azure SQL, Terraform, AWS IAM, AWS CloudWatch

Managed MySQL databases and RDS instances across multiple cloud platforms (AWS, Azure), ensuring high availability and secure configurations.

Led database migration activities, transitioning on-premises databases to cloud environments, optimizing for scalability and performance.

Used Terraform for infrastructure-as-code, automating the creation and management of RDS instances, security policies, and other AWS resources.

Configured AWS CloudWatch to monitor database performance, set up alerts, and troubleshoot performance bottlenecks in real time.

Worked closely with application teams to provide query optimization support and ensure smooth deployment of database- driven applications.

Contact this candidate