GANESH GAIKWAD
Navi Mumbai
Summary
With a proven track record at Accenture, I excel in cloud database management and client relationship management, showcasing expertise in MySQL and PostgreSQL. I've successfully migrated databases to GCP with minimal downtime, optimizing performance and ensuring robust disaster recovery strategies. My approach combines technical proficiency with strong interpersonal skills to exceed client expectations. Highly skilled Senior Database Administrator with expertise in managing complex database systems. Proven capability to design, implement and maintain efficient databases, with focus on data security and integrity. Demonstrated strong problem-solving skills, strategic thinking and team leadership abilities. Made significant contributions in previous roles by improving processes and enhancing system performance.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Software Engineering
Accenture
Mumbai
11.2024 - Current
- Monitored database performance and identified and addressed any performance bottlenecks
- Installed, configured, and maintained database servers, resulting in minimal downtime
- Developed automated scripts to maintain database consistency and accuracy
- Created and maintained database backups, ensuring data could be recovered in the event of data loss
- Developed a disaster recovery plan that ensured data availability and integrity in the event of an outage
- Upgrade MYSQL major version.
- Handling multiple client request 24*7 support
- Optimized storage and archiving practices to manage database size and performance.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Provided support for complex issues related to software tools, applications and databases.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Established security controls to help protect client systems.
- Analyzed and resolved complex database and system issues promptly.
- Automated routine database tasks to improve system reliability and reduce manual errors.
- Designed and implemented database systems to meet organizational needs.
- Managed user access and privileges to secure sensitive data effectively.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Migrated existing databases from one platform to another with minimal downtime.
- Resolved customer queries related to database issues promptly and accurately.
Cloud Database Engineer
SEARCE INC
03.2022 - 10.2023
- Create a MySQL, Postgres cloud sql instance
- Migrate the MYSQL & Postgres DB from AWS to GCP using DMS service
- Migrate the MYSQL, Mongo, redis & postgres DB from AWS VM to GCP manage service
- Also I have setup MySQL, postgres, mongodb replication between AWS VM to gcp VM
- Setup read replica in different regions
- Configured automated backup, point in time recover, Highly availability, audit log
- Also I have migrated multiple clients database on GCP environment
- Multiple cloud SQL database done performance tuning on database using query insight
- Azure to gcp cloudsql migration using striim tool
- Arround 2TB database migrate on GCP cloud using DMS tool
Database Administrator
Navisite
Mumbai
10.2023 - 11.2024
- Monitored database performance, and identified and addressed any performance bottlenecks.
- Developed automated scripts to maintain database consistency and accuracy.
- Installed, configured, and maintained database servers, resulting in minimal downtime
- Designed and implemented a database architecture that improved scalability and availability.
- Developed a disaster recovery plan that ensured data availability and integrity in the event of an outage
- Created and maintained database backups, ensuring data could be recovered in the event of data loss
- Collaborated with developers and stakeholders to ensure database requirements are met
- Implemented a serverless architecture using AWS technologies that reduced operational costs.
- Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
- Optimized storage and archiving practices to manage database size and performance.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Identified needs of customers promptly and efficiently.
- Conducted system analysis and testing to identify and resolve technical issues or inefficiencies.
- Updated and maintained databases with current information.
Database Administrator
CLOVER INFOTECH PVT LTD
02.2019 - 03.2022
- 24/7 handling client site technically and operationally in executing work related to database management.
- Expertise in: MySQL DBA.
- Installation and configuration of MySQL server.
- Configure the MySQL server on both platforms (Linux and Windows).
- Worked with the workbench and SQLyog GUI tool.
- Proactive Health Checkup
- Backup and Restoration of MySQL Databases.
- Take a backup using the Percona Hot Backup utility.
- Configure the alert script, i.e.,
- Backup alert, replication alert, max connection alert.
- Created and monitored performance metrics to keep databases functioning at optimal capacity.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
Education
B.sc computer science -
Mumbai university
01.2018
H.S.C - science
Maharashtra
State Board
01.2014
S.S.C -
Maharashtra State
Board
01.2012
Skills
- MySQL (55,56,57, 80)
- PostgreSQL & EDB (92,94,95,96,10, 11,12,13)
- Database Tools: MySQL Workbench, SQLyog, PgAdmin
- GCP cloud
- AWS Cloud
- Cloud migration
- Backup and recovery
- Cloud database management
- Database migration
- Performance tuning
- Disaster recovery
- Database security
- Automation scripting
- Backup strategies
- Client relationship management
- User access management
- Cloud migration strategies
- Capacity planning
Additional Information
- MySQL: Install & configuration MySQL 5.1, 5.5, 5.6, 5.7, 8.0 versions. Database Monitoring & Troubleshooting. Configuration performance tuning parameter as per server configuration. Implementing database mail alert using postfix utility (Linux). Persona hot Backup & Restoration of database. Export/ Import data using in-built utility. MySQL Server Version upgrades. Database backup policy. Implement re-index, automated index rebuilds weekly basis. Install & Configure ODBC server (Window/Linux). Monitoring and tuning MySQL Server performance. Monitor, analyze & identify disk I/O, memory & processors. Configured Bin-log as DR Strategy (Replication). MySQL database DR-drill Monitoring & troubleshooting Replication(master-slave) issues and also configure automation script for replication (Error) mail alert. Configured deadlock alert Configured max database connection alert. Configured alert of most executed query in database Implement MySQL Server Security Policy on servers. Table data migration from Oracle to MySQL, MSSQL to MySQL, PostgreSQL to MySQL or vice spoon ETL tool. DDL/DML Audit Configuration. Manage the large size of database around 2TB in Google cloud platform Archival data and optimize the table
Certification
- Oracle MySQL solutions engineer specialist at Oracle ( No expire )
- Associate Cloud Engineer at Google cloud ( Jun, 2022 - Jun, 2024 )
- Professional Cloud Database Engineer at Google cloud ( Nov, 2022 - Nov, 2024 )
Languages
Marathi
First Language
English
Advanced (C1)
C1
Hindi
Advanced (C1)
C1
Blog
- Using striim tool migrate
azure mariadb to gcp cloudsql
MySQL.
BLOG Link:
Setup Change Data
Capture(CDC) from Azure
Mariadb/MySQL to GCP
Cloudsql-MySQL using
Striim. | by Ganesh Gaikwad |
Jul, 2023 | Searce
Timeline
Software Engineering
Accenture
11.2024 - Current
Database Administrator
Navisite
10.2023 - 11.2024
Cloud Database Engineer
SEARCE INC
03.2022 - 10.2023
Database Administrator
CLOVER INFOTECH PVT LTD
02.2019 - 03.2022
B.sc computer science -
Mumbai university
H.S.C - science
Maharashtra
State Board
S.S.C -
Maharashtra State
Board
Similar Profiles
Mitesh Rao APPADOOMitesh Rao APPADOO
Category Manager - Technology (UK, IE and Africa) at AccentureCategory Manager - Technology (UK, IE and Africa) at Accenture
John Jethro E. GanzonJohn Jethro E. Ganzon
Cloud Infrastructure Team Lead at AccentureCloud Infrastructure Team Lead at Accenture
Prerana JadhavPrerana Jadhav
Software Development Senior Analyst at AccentureSoftware Development Senior Analyst at Accenture
Ritika RaoRitika Rao
Media and Graphic Design Analyst at AccentureMedia and Graphic Design Analyst at Accenture
SUSHANT KUMARSUSHANT KUMAR
Sr Manager- CNOC Team at Reliance JioSr Manager- CNOC Team at Reliance Jio