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.
- ...ing AWS Cloud 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.
Skills
-
- 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
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.