Prem Kumar Singh

Background

About Prem Kumar Singh

Working as DBA/Consultant with more than 12 years of Excellent Experience as Lead MySQL/Mongo/Cassandra/Redis DBA in Times Internet Limited. Maintaining Mission critical servers in HA using MaxScale/Galera Clusters/HAProxy/Shared Clusters and different tools. Having work experience in various product based startup's across the globe. Likes the open source software. Interested keenly on MySQL and its forks ( Percona ) and Linux.Performance tuning of MySQL/Mongo/Redis/Cassandra to get its best from OS level and Query Optimizer.Building up the high availability solution using MySQL/Mongo/Cassandra. Responsibilities as MySQL DBA :(Expertise in mysql /MariaDB) Monitor database operations/Performance -using Grafana/Cacti. Automate Installation/Configuration of Database through chef. Responsibilities as NoSQL (MongoDB/Cassandra) DBA :(NoSQL) Installation & Configuration of Mongo DB/Cassandra. MongoDB Sharding setup and configuration for testing. Cassandra Cluster setup at 7 Nodes Clusters Cassandra cluster Snapshot and restoration. Use Mongodb Replication/Replica Set for HA. Good understanding of Schema design. Design Map Reduce for reporting Mongodb data. Data Migration from Mysql to MongoDB Reporting data through MapReduce. Responsibilities as BigData (Hadoop/Hive) DBA : Installation & Configuration of Hadoop Cluster. Data migration from MySQL/Mongo to Hadoop/HDFS cluster through Sqoop tool or manual. Reporting data through MapReduce/Hive (HQL). Data migration from MySQL to Hadoop/HDFS cluster through Sqoop tool or manual. Provide support to development team in Development of application-specific. Specific Task apart from DBA work: Test and Implement Chef server for AutoMate Installation/Configuration. Securities concern implemented IPtables. Participate in PCLI Audit & Database changes implemented. Monitoring configuration with Grafana, Db – InfluxDB & Clinet – telegraf.