VISHAL CHOUDHARY
Database Administrator
Indore
Summary
Enthusiastic and responsible Database Administrator with 6 years of expertise. Highly skilled in creating and maintaining MySQL Database with Security and Standards. Proficient in PostgreSQL Database as well as PL/SQL. Looking to work in a creative and competitive ambiance to help me unleash my skills and grow. Having lead a small team, can work as a lead if provided such opportunity.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
Work History
Senior DBA
Sourcefuse
Noida
10.2022 - Current
- MySQL Servers handled in Microservice Architecture using Kubernetes
- Helm Charts deployment for installation of MySQL Servers, Routers.
- Cluster configuration and monitoring
- High Availability solutions like HA Proxy deployment for Live servers
- Load Balancers such as ProxySQL deployment
- Replication configuration across Clusters
- Query tuning and performance optimization
- Handling of DR
- Backups and Recovery
MySQL DBA
Serosoft Solutions Pvt. Ltd
Indore
08.2021 - 10.2022
- Worked as a Single DBA handling more than a dozen Production servers and other staging MySQL Servers.
- Installation, Upgradation of MySQL Servers
- Query Optimization, Database Performance Tuning, identifying slowness on instances and resolution
- Procedures, Triggers, Function, Views and Events Creation and Deployment.
- Capacity and I/O planning of Servers
- Complex queries creation and assisting team for any issues.
- Backups and Point in Time Recovery
- Using Percona Tools for monitoring and analysis
- Audit Log configuration for Production MySQL Servers
- Developed and maintained courteous and effective working relationships.
MySQL and Postgresql DBA
Tata Consultancy Services
Gandhinagar
12.2017 - 08.2021
- Postgresql and MySQL Servers daily health check up
- Analysis of slow query logs and query optimization
- Analysis of error logs and resolution
- Postgresql users based authentication configuration
- Installation of MySQL and Postgresql Servers
- Query writing and execution
- Procedures and Triggers Creation
- Migration of Data from Excel to MySQL Tables and vice versa
- Documentation of Database related tasks
- Shell scripting for performing database backups
Education
B Tech -
SVITS
Indore 08.2013 - 05.2017
Skills
INSTALLATION AND UPGRADATIONBACKUPS AND RECOVERYMONITORING PRODUCTION SERVERREPLICATION CONFIGURATION AND TROUBLESHOOTINGCLUSTER CONFIGURATIONSQL PROCEDURES, FUNCTION AND TRIGERRS CREATIONWRITING DATABASE EVENTS AND SCHEDULINGLOGS ANALYSIS, RCA AND RESOLUTIONQuery Optimization
Procedures, Views and Triggers Creation
Database Performance TuningMySQL, PostgreSQL, PL/SQL
Backups and Retention PolicyImport and ExportLinux operating system
Timeline
Senior DBA
Sourcefuse
10.2022 - Current
MySQL DBA
Serosoft Solutions Pvt. Ltd
08.2021 - 10.2022
MySQL and Postgresql DBA
Tata Consultancy Services
12.2017 - 08.2021
B Tech -
SVITS
08.2013 - 05.2017