Prem kumar singh — Associate Consultant

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 .

Stackforce AI infers this person is a Database Administration expert with a focus on both SQL and NoSQL technologies.

Location: New Delhi, Delhi, India

Experience: 19 yrs 3 mos

Skills

Database Administration
Open Source Databases
Nosql Databases

Career Highlights

Over 12 years of experience in database administration.
Expertise in high availability solutions for critical databases.
Strong background in both SQL and NoSQL databases.

Work Experience

Accenture

Senior Database Consultant OpenSource - MySQL/MariaDB/Mongodb/postgresql /AWS (1 yr 7 mos)

Navisite acquire by Accenture

Senior Database Consultant - MySQL/MariaDB/Mongodb/Cassandra . (4 yrs 5 mos)

Times Internet

Lead Database Administrator (1 yr 2 mos)

Technology Manager (7 yrs 2 mos)

Applect Learning Systems Pvt. Ltd.

Database Administrator (1 yr 1 mo)

Fashion and you

Sr. DBA (1 yr 3 mos)

Competent Software Pvt Ltd

DBA (3 yrs 9 mos)

System/Linux Administrator (1 mo)

Education

MBA at Sikkim Manipal Institute of Technology - SMU

MBA at Sikkim manipal university

B.A at Delhi university (New Delhi)

Prem kumar singh

Associate Consultant

New Delhi, Delhi, India19 yrs 3 mos experience

Highly Stable

Key Highlights

Over 12 years of experience in database administration.
Expertise in high availability solutions for critical databases.
Strong background in both SQL and NoSQL databases.

Stackforce AI infers this person is a Database Administration expert with a focus on both SQL and NoSQL technologies.

Contact

Skills

Core Skills

Database AdministrationOpen Source DatabasesNosql Databases

Other Skills

.NETAWSApacheBusiness IntelligenceCCassandraDBA AdministrationData WarehousingDatabase DesignDisaster RecoveryETLHigh AvailabilityJavaScriptLinuxMariaDB

About

Experience

19 yrs 3 mos

Total Experience

3 yrs 6 mos

Average Tenure

1 yr 7 mos

Current Experience

Accenture

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

Nov 2024 – Present · 1 yr 7 mos · Noida, Uttar Pradesh, India · Remote

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

MySQLMariaDBMongoDBPostgreSQLAWSDatabase Administration+1

Navisite acquire by accenture

Senior Database Consultant - MySQL/MariaDB/Mongodb/Cassandra .

Jun 2020 – Nov 2024 · 4 yrs 5 mos · Gurgaon, Haryana, India · Remote

MySQLMariaDBMongoDBCassandraDatabase AdministrationNoSQL Databases

Times internet

2 roles

Lead Database Administrator

Apr 2019 – Jun 2020 · 1 yr 2 mos · Noida Area, India

Lead Database Operation

MySQLPerformance TuningHigh AvailabilityDatabase Administration

Technology Manager

Apr 2013 – Jun 2020 · 7 yrs 2 mos · Noida Area, India

Database Administrator(Tech Lead)

Database AdministrationMySQL

Applect learning systems pvt. ltd.

Database Administrator

Mar 2012 – Apr 2013 · 1 yr 1 mo · Okhla

Database Administrator

Database Administration

Fashion and you

Sr. DBA

Dec 2010 – Mar 2012 · 1 yr 3 mos · Gurgaon

Databases : -
Mysql 5.#
SQL Server (2008)
Linux
Windows.

MySQLSQL ServerLinuxDatabase Administration

Competent software pvt ltd

2 roles

DBA

Promoted

Mar 2007 – Dec 2010 · 3 yrs 9 mos

All DBA administration task

DBA AdministrationDatabase Administration

System/Linux Administrator

Mar 2007 – Apr 2007 · 1 mo

Responsibilities as MySQL DBA : (Expertise in mysql )
Monitor database operations.
Mysql Clustering Testing & Implementation
Multiple 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 another
Mysqlslap 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.