Vikash R.

Vikash R.

MySQL | MongoDB | Cassandra | postgres | DBA | database Admin

Noida , India

Experience: 8 Years

Vikash

Noida , India

MySQL | MongoDB | Cassandra | postgres | DBA | database Admin

24685.6 USD / Year

  • Immediate: Available

8 Years

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.
  • ...

Show More

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.

Show More Show Less

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.

Show More Show Less

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.

Show More Show Less