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.
- ...
- 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
Database
Networking & Security
Development Tools
Software Engineering
Software Testing
Web Development
Others
Programming Language
Portfolio Projects
Company
Paytm
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.
Skills
Ansible Apache Cassandra AWS AWS Aurora Cassandra Cloud Security Framework AWS-EC2 Maxwell MongoDB MySQL MySQL Administration MySQL Programming Proxysql Remote Desktop Services - (RDS) AWS S3 SQLTools
GitCompany
Fintech Solution
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.
Tools
MySQLWorkbenchCompany
Just dial - a local search engine
Description
- MySQL Installation, 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.
Tools
MySQLWorkbench