Now you can Instantly Chat with Vikash!
About Me
IT professional with 5.8 + Years of work experience in the field of Information Technology, Working primarily on MySQL , Cassandra and Managing AWS Cloud Services. Experienced in Infra Automation: Have worked on Ansible. Expertise in installing MySQL...oud Services. Experienced in Infra Automation: Have worked on Ansible. Expertise in installing MySQL/MariaDB Server and Replication system. Expertise in installing nosql databases Cassandra / MongoDB. Expertise in Cassandra cluster scaling UP / Down (Remove node, node decommission and replacing node). MongoDB sharding implementation. Expertise in High Availability solution for MySQL/MariaDB / Cassandra/ MongoDB: Have deployed Orchestrator on 200+ nodes. Expertise in Online Schema Migration with zero downtime (0 sec) for big tables : Have deployed gh-ost. Expertise in various Archival and Backup Solutions. Expertise in MySQL/MariaDB Intelligent Load Balancing: Have deployed ProxySQL on very large scale. Experienced in MySQL/MariaDB Config optimization for better performance on High load system. Experienced in Query Reviews / Optimization. Experienced in MySQL/MariaDB Micro Monitoring for better analysis: Have deployed PMM. Experienced in writing backend process using MySQL/MariaDB and SHELL. Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities. Experienced in handling huge database size(worked on Tables in TBs). Expertise in import/export, database optimization. Experienced working with various tools like Percona Toolkit, gh-ost, MySQL Orchestrator, PMM. Expertise in import/export, database optimization and writing queries. Major tasks include automation using UNIX shell scripts. Dynamic team player who is consistently motivated toward success and completion of projects with an ability to work independently.
Show MoreSkills
-
-
-
-
-
- 2 Years
Advanced
-
- 2 Years
Intermediate
-
-
-
-
-
-
-
-
-
-
- 2 Years
Intermediate
-
- 1 Years
Intermediate
-
-
-
-
-
- 5 Years
Advanced
-
-
-
- 5 Years
Advanced
-
-
- 5 Years
Advanced
-
-
- 4 Years
Advanced
-
-
- 6 Years
Expert
-
-
-
- 2 Years
Intermediate
-
- 4 Years
Advanced
-
- 2 Years
Intermediate
-
-
-
- 6 Years
Advanced
-
-
- 4 Years
Advanced
-
-
- 4 Years
Advanced
-
- 4 Years
Advanced
-
-
-
- 2 Years
Intermediate
-
- 2 Years
Intermediate
-
- 2 Years
Intermediate
-
-
-
-
-
-
-
-
- 6 Years
Advanced
-
-
-
-
-
-
-
- 5 Years
Advanced
-
Positions
Portfolio Projects
Description
- High Availability solution for MySQL using MySQL Orchestrator ( https://github.com/github/orchestrator ).
- Have worked on scaling solutions like ProxySQL, HAproxy.
- Have managed 200+ MySQL instances.
- Have experience of working on High QPS systems (15k+).
- Have managed database in TBS (24 TB+) in MariaDB.
- Have expertise in multi-source replication system with MariaDB (20+ slave connection on single machine).
- Have wrote various automated job for automatic partitions extending to automation binlog purge.
- Have worked on various monitoring tools like: Zabbix, PMM, Datadog.
Description
- Implement and maintain database servers on Amazon RDS / Aurora and EC2.
- Implement replica set of MongoDB Instances.
- implement sharding.
- Database Profiling, Locks , Memory Usage, No of connections, page fault etc.,
- Monitoring at Server, Database, Collection Level, and Various Monitoring Tools related to MongoDB.
- Maintaining Master-Master, Multimaster, Master Slave Replication on AWS RDS.
- Migration of data using Amazon data migration Services and Data Pipelining.
Description
- MySQLInstallation, Configuration and Up gradation.
- Create database objects (tables, indexes)
- Maintaining Master-Master, Multimaster, Master Slave Replication on AWS RDS.
- Write database procedures, functions and triggers.
- Assist developers with database activities.
- Tune database queries.
- Monitor application related jobs and data replication activities.
- When performance issues arise, determine the most effective way to increase performance including server configuration changes or index/query changes.