Mayur Makwana

A passionate and dedicated software professional, technologically intuitive, capability to handle precarious situations, provide efficient solutions, process dedication and execute actions on time.

High-performing professional with extensive experience managing large-scale, complex databases. Skilled in MySQL/MSSQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.

• Expertise in installing, supporting and managing High availability Mysql Database in Production (Standalone, Master/Slave and Inndo DB setups).
• Maintains database by planning, monitoring, query optimization, Performance monitoring for improving performance of database.
• Expertise in MySQL Replication Setup and Troubleshooting and Master / Slave setup.
• Expertise in Data Backup, Archival and Restoration of MYSQL Database.
• Aware of storage management, user management, and security management.
• Expertise in DDL, DML and stored procedures, triggers, views and ability to write SQL queries and statements to explore source data and data issues.
• Experience of working Disaster recovery strategies.
• Experience of installing MySQL on window and Linux environment.
• Experience in implementation of ERP.
• Hands on MySQL version 5.7.
• Experience in Data Migration

• E
• Trade by Morgan stanley., Morgan Stanley (Client), In this project we are maintaining and supporting more than 30 databases for the client. There are MySQL & MSSQL databases which we work upon and keep them up to date., MySQL, MSSQL., 3, Database Administrator, support and maintenance., 09/2021 - Present, Maintains database by planning, monitoring, and improving performance., Maintain database environments for our clients, Secures database by preparing access and control policies and procedures., Supports application design by contributing expertise to applications, operations, and technical support teams., Database Management, Data Maintenance, Decision Making, Problem Solving, Process Improvement, Database Security, Provide problem-solving, code review, risk assessment, and security recommendations, Ability to write SQL queries and statements to explore source data and data issues, Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity., Increased databases performance by utilizing MySQL config changes, multiple instances and by upgrading hardware., Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan., Worked with the engineering team to implement new design systems of databases used by the company. Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc., Performed MySQL Replication setup and administration on Master-Slave and Master- Master., Databases engineering is based on SDLC pattern. Involved all the steps like requirement analysis, Design, Development and Testing and then deployment., Supporting management with different databases related decisions.

• ECW, eClinicalWorks India Pvt Ltd., eCW is an application wherein Doctors in USA use it. They use it to store data about patient from scratch. We were supporting the application on ticketing basis. We use to work on installation of the whole environment for the practice (Clinic). Installation of application, MySQL database and services, Dumping and re-creating the data provided. Working on Linux environments for faxing solutions which was integral part of the software. Working of FTP servers as well to keep all the things intact., JAVA, MySQL, 9, Software Specialist., 05/2018 - 09/2021
• Google AdWords, eTouch Systems India, Mumbai, Supporting the EVOQ tool which was used by search analysts., 15, Database support and maintenance, 04/2017 - 01/2018, Extending support to Analysts to work on the EVOQ tool., Log analysis and maintenance of the EVOQ tool., Recording new issues in documents and keep them up to date for future reference for troubleshooting purpose., Troubleshoot and resolve technical issues and guide end users till resolution, Participated with clients in meeting for technical discussion.

• Date of Birth: 12/16/92
• Gender: Male

AZ 900 - Microsoft Azure Fundamentals