Prem Kumar Singh

Prem Kumar Singh Email and Phone Number

Senior Database Consultant OpenSource - MySQL and MariaDB and Mongodb and postgresql and AWS @ Accenture
New Delhi, DL, IN
Prem Kumar Singh's Location
New Delhi, Delhi, India, India
Prem Kumar Singh's Contact Details

Prem Kumar Singh personal email

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 .

Prem Kumar Singh's Current Company Details
Accenture

Accenture

View
Senior Database Consultant OpenSource - MySQL and MariaDB and Mongodb and postgresql and AWS
New Delhi, DL, IN
Website:
accenture.com
Employees:
636296
Prem Kumar Singh Work Experience Details
  • Accenture
    Senior Database Consultant Opensource - Mysql And Mariadb And Mongodb And Postgresql And Aws
    Accenture
    New Delhi, Dl, In
  • Accenture
    Senior Database Consultant Opensource - Mysql/Mariadb/Mongodb/Postgresql /Aws
    Accenture Nov 2024 - Present
    Noida, Uttar Pradesh, India
    Senior Database Consultant OpenSource - MySQL/MariaDB/Mongodb/postgresql /AWS
  • Navisite
    Senior Database Consultant - Mysql/Mariadb/Mongodb/Cassandra .
    Navisite Jun 2020 - Nov 2024
    Gurgaon, Haryana, India
  • Times Internet
    Lead Database Administrator
    Times Internet Apr 2019 - Jun 2020
    Noida Area, India
    Lead Database Operation
  • Times Internet Limited
    Technology Manager
    Times Internet Limited Apr 2013 - Jun 2020
    Noida Area, India
    Database Administrator(Tech Lead)
  • Applect Learning Systems Pvt. Ltd.
    Database Administrator
    Applect Learning Systems Pvt. Ltd. Mar 2012 - Apr 2013
    Okhla
    Database Administrator
  • Fashion And You
    Sr. Dba
    Fashion And You Dec 2010 - Mar 2012
    Gurgaon
    Databases : -Mysql 5.#SQL Server (2008)LinuxWindows.
  • Competent Software Pvt Ltd
    Dba
    Competent Software Pvt Ltd Mar 2007 - Dec 2010
    All DBA administration task
  • Competent Software Pvt Ltd
    System/Linux Administrator
    Competent Software Pvt Ltd Mar 2007 - Apr 2007
    New Delhi Area, India
    Responsibilities as MySQL DBA : (Expertise in mysql )Monitor database operations. Mysql Clustering Testing & ImplementationMultiple Mysql Instance installation on Same machine.Test and implement Mysql new version (5.5.*)Migrate data from mysql old version to new implemented version.Estimate MySQL database capacities; develop methods for monitoring database capacity and usage. Installing/Configuration Mysql on Linux servers.Develop and support MySQL database replication Develop and optimize physical design of MySQL database systems Tune and optimize the performance of all the staging and production database instances. Establish mechanisms for data backup/restore of relational databases; provide restoration services as needed Plan and execute disaster recovery. Develop stored procedures and database triggers in support of application development. Participate in application development projects and be responsible for the database architecture and design. Develop application-specific fault-tolerant distributed database mechanisms Participate in the creation of development, staging and production database instances, and the migration of those instances from one environment to anotherMysqlslap using for Queries performance monitoring.Responsibilities as NoSQL (MongoDB) DBA : (NoSQL)Installation & Configuration of Mongo DB.Replication setup (Master-Slave and Replica set) .Add/Delete Replication Node.Backup/Restore Data.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) DBA : Installation & Configuration of Hadoop.Reporting data through MapReduce.

Prem Kumar Singh Skills

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

Prem Kumar Singh Education Details

Frequently Asked Questions about Prem Kumar Singh

What company does Prem Kumar Singh work for?

Prem Kumar Singh works for Accenture

What is Prem Kumar Singh's role at the current company?

Prem Kumar Singh's current role is Senior Database Consultant OpenSource - MySQL and MariaDB and Mongodb and postgresql and AWS.

What is Prem Kumar Singh's email address?

Prem Kumar Singh's email address is pr****@****ail.com

What schools did Prem Kumar Singh attend?

Prem Kumar Singh attended Sikkim Manipal University Of Health, Medical And Technological Sciences, Sikkim Manipal University, Delhi University (New Delhi).

What skills is Prem Kumar Singh known for?

Prem Kumar Singh has skills like Mysql, Databases, Linux, Microsoft Sql Server, Database Administration, Replication, Sql, High Availability, Database Design, Performance Tuning, Shell Scripting, System Administration.

Who are Prem Kumar Singh's colleagues?

Prem Kumar Singh's colleagues are Ishwar Thakur, Shivali Agarwal, Andre Guerin, Bohdana Krysko, Rhea Varkey, Disha Shrivastava, Joe Stoddard.

Not the Prem Kumar Singh you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.