Prem Kumar Singh

Senior Database Consultant OpenSource at Accenture- MySQL/MariaDB/Mongodb/postgresql/AWS Performance & Scability expert .

Role
Senior Database Consultant Opensource - Mysql Mariadb Mongodb Postgresql Aws at Accenture
Location
New Delhi, DL, IN
LinkedIn followers
500 followers

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

Experience

  1. Senior Database Consultant Opensource - Mysql Mariadb Mongodb Postgresql Aws

    Accenture

    Nov 2024 — Present · Noida, IN

    Senior Database Consultant OpenSource - MySQL/MariaDB/Mongodb/postgresql /AWS

Education

  • Sikkim Manipal University of Health, Medical and Technological Sciences

    MBA

    2010 — 2012

  • Delhi university (New Delhi)

    B.A

    2001 — 2004

  • Sikkim manipal university

    MBA

    2010 — 2011

Skills

  • Replication
  • Javascript
  • Disaster Recovery
  • Shell Scripting
  • Performance Tuning
  • High Availability
  • Oracle
  • Databases
  • Etl
  • Pl/Sql
  • Data Warehousing
  • Php
  • Mysql
  • Unix
  • System Administration
  • Apache
  • Microsoft Sql Server
  • Unix Shell Scripting
  • Database Design
  • Mongodb
  • C
  • Database Administration
  • Sql
  • Linux
  • Red Hat Linux
  • .net
  • Windows
  • Business Intelligence

Find verified contacts for anyone on LinkedIn

Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.

Free plan included · No credit card required

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.

Prem Kumar Singh — Senior Database Consultant Opensource - Mysql Mariadb Mongodb Postgresql Aws at Accenture in New Delhi, DL, IN | Unifers