Uploaded File
add photo
Praveen
praveenk5874@gmail.com
440-769-1063
Philadelphia, PA 19102
MongoDB Database Administrator
9 years experience W2
0
Recommendations
Average rating
41
Profile views
Summary

More than 7 years of IT experience in database design, administration and all aspects of systems. Extensive knowledge in MongoDB concepts and good knowledge in administration.

  • Experience in working on 1TB+ databases.
  • Experience in upgrading and migrating various versions of Mongo database on different platforms.
  • Good experience in setup, configuration, security & implementation of Mongo Database clusters.
  • Migrating and Upgrading the Databases between different environments and versions.
  • Designed, installed & configured multi node MongoDB sharded cluster &replica sets on Linux and Windows platforms.
  • Proficient in adding / removing replica and shard nodes in MongoDB Cluster as needed.
  • Converted replicaset to sharded cluster because of data size growth and better query rate planning.
  • Good experience in Database Backups and Recovery Strategies. Worked on mongodump and mongorestore utilities.
  • Proficient in creating indexes (compound indexes, TTL indexes) as per the requirement. Good knowledge on CRUD operations & MongoDB aggregation concepts.
  • Good expertise in using Database tools like Mongo Compass and Toad.
  • Design, document, implement, and maintain all backup, recovery including disaster recovery.
  • Strong exposure on High Availability. Good knowledge on Journaling process.
  • Knowledge on cloud environment like AWS.
  • Proficient in Mongo Database Administration activities such as Upgrades, Patches, JIRA support.
  • Proven ability of providing production support for 24X7 on multiple databases.

Experience
MongoDB Database Administrator
Information Technology
Feb 2020 - present
Philadelphia, PA
Roles & Responsibilities:
  • Upgraded MongoDB instances from 3.4 to 3.6. Upgraded MongDB instances from 3.6 to 4.0
  • Deployed new enterprise version standalone nodes for development purposes.
  • Deployed new enterprise version replica set in testing and development environment.
  • Used automation agent for deploying new clusters.
  • Used backup agent for taking backups for the production and UACC environments.
  • Deployed BI connector for the reporting tool to connect to Mongo.
  • Created new DrDl for the BI connector.
  • Used Monitoring agent for monitoring replica sets and standalone nodes.
  • Created indexes on the collection as per business requirements and for improving query performance.
  • Used mongoexport to get the documents as per business requirements.
  • Monitoring of Document growth and estimating storage size for large MongoDB databases.
  • Created new users and roles as per business requirements.
  • Migrated documents between different environments.
  • Updated and deleted documents as per business requirements.
  • Handing Jira tickets on daily basis.
Database Backups DBA
Remove Skill
MongoDB Database Administrator
Information Technology
Feb 2019 - Jan 2020
Milwaukee, WI
Highlights:
  • Achieved zero downtime and implemented High Availability in OPS Manager. Roles & Responsibilities:
  • Built MongoDB with versions 3.6.x and 4.0.x in cloud environment. Implemented Migration from community version to enterprise version.
  • Upgraded MongoDB enterprise nodes from 3.6.x to 4.0.x
  • Upgraded Ops Manager from 3.6.x to 4.0.x
  • Deployed Monitoring agent on the nodes from Ops Manager. Deployed backup agent on the nodes from Ops Manager.
  • Deployed Automation agent on the nodes from Ops manager.Implemented replication of MongoDB databases.
  • Migrated data from MySQL to MongoDB as per the business requirement.
  • Deployed BI Connector from Ops manager to retrieve data for the reporting tools.
  • Created TTL indexes on the collection as per the business requirements and created new indexes for better performance.
  • Upgraded all MongoDB Nodes by using automation agent and manually.
  • Implemented MongoDB encryption at rest. Monitored the MongoDB performance using Ops Manager.
  • Performed regular maintenance like patching without downtime.
  • Configured SSL key files to implement security across all mongod instances. Implemented Encryption at Rest on all nodes.
  • Resolution of day to day related issues, documentation of Mongo DBA routine tasks.
  • Worked on taking backup and restoring using mongodump and mongorestore utilities.
  • Used mongoexport to get the documents as per the business requirements
  • Monitoring of Document growth and estimating storage size for large MongoDB databases.
  • Help development teams to understand and data model using MongoDB design principles.
  • Documenting MongoDB installation, operations, security, auditing multiple environments.
  • Created new users and roles as per the business requirement.
  • Working on creating POC for migration to MongoDB ATLAS. Environnent: MongoDB, OPS Manager, Linux/Unix, EFS storage, Javascript, AWS.
Data Replication Database Backups DBA MySQL
Remove Skill
MongoDB Database Administrator
Information Technology
Sep 2017 - Jan 2019
Roles & Responsibilities:
  • Built MongoDB multiple versions (2.x, 3.0.x and 3.2.x) of cluster. Implemented TTL and indexing based on collection of profiling data.
  • Performed monitoring and capacity planning.
  • Work with Development, Storage and Network teams in installation and administration of MongoDB in the IT Enterprise Environment.
  • Responsible in performing multiple upgrades to maintain the database function without errors.
  • Experience in handling the service requests with MongoDB Jira for resolving issues.
  • Adding and removing shards from sharded cluster.
  • Responsible for administration, maintenance, performance analysis, and capacity planning for MongoDB clusters.
  • Worked on MongoDB replication and sharding for the increased data needs.
  • Worked on best practices including planning, testing and failover testing.
  • Enabled sharding on databases and collections by choosing suitable shard keys.
  • Implemented Range based sharding and Hash based sharding.
  • Monitoring of Document growth and estimating storage size for large MongoDB clusters depending on data life Cycle management.
  • Created an instance in AWS and enabled replication node on the AWS cloud, to obtain high availability.
  • Created snapshot for the backup purpose in AWS.
  • Measuring the index use and dropping the indexes which are not actively used by queries.
  • Converted secondary node to Arbiter based on requirement to reuse of storage for different application.
  • Maintaining Sharded cluster availability. Environment: MongoDB, OPS manager, Linux/Unix, LVM Snapshots, Backup scheduler.
Data Replication Database Backups Database Upgrades DBA
Remove Skill
Mongo Database Administrator
Information Technology
Oct 2016 - Aug 2017
Chicago, IL
Roles & Responsibilities:
  • Designed, installed & configured multi node MongoDB sharded cluster &replica sets on Linux and Windows platforms.
  • Adding / removing replica and shard nodes in Mongodb Cluster as needed. Created Text Index for querying specific documents with string content.
  • Supported choosing a shard key and making sure of even distribution of data across multiple shards.
  • Converted replicaset to sharded cluster because of data size growth and better query rate planning.
  • Supported the MongoDB database migrations/upgrade from 3.2 to 3.4 and higher versions. Installed and configured the MongoDB replica set.
  • Deploying, migrating data, monitoring, analyzing, and tuning MongoDB. Experience in migrating from Oracle and SQL Server databases to MongoDB.
  • Extensive experience in upgrading various versions of MongoDB.
  • Monitored the MongoDB performance using Ops Manager.
  • Configured SSL key files to implement security across all mongod instances.
  • Resolution of day to day related issues, documentation of Mongo DBA routine tasks. .
DBA Oracle SQL Server
Remove Skill
Mongo DB Admin
Information Technology
Jun 2015 - Sep 2016
Charlotte, NC
Roles & Responsibilities:
  • Responsible for administration, maintenance, Performance analysis, and Capacity planning for Mongodb 2.x, 3.0.x and 3.2 versions.
  • Installing and running Mongodb with multiple instances on servers.
  • Secure MongoDB using authentication.
  • Configuring, implementing and supporting High Availability (Replication) with Load balancing (sharding) cluster of Mongodb having large amount of data.
  • Optimizing MongoDB CRUD Operations.
  • Adding / removing replica and shard nodes in Mongodb Cluster as needed.
  • Designed & implemenedt sharding and indexing strategies for huge data sets.
  • Manage and Monitor large production MongoDB sharded cluster environments.
  • Migrated Mongo instances from MMAPV1 to Wiredtiger storage engine.
  • Ensure data replication with no lag.
  • Pro-actively identify, troubleshoot and resolve live MongoDB issues.
  • Work with Development, Storage and Network teams in installation and administration of MongoDB in the IT Enterprise Environment.
  • Help development teams to understand MongoDB design principles.
  • Documenting MongoDB installation, operations, security, auditing multiple environments.
No skills were added
Remove Skill
Database Administrator
Information Technology
Jan 2014 - Mar 2015
Responsibilities:
  • Designed, maintained, created and configured databases for DEV, UAT and PROD.
  • Provided support to the application team in benchmarking and also to get the desired data for testing using the flashback feature.
  • Created, added redo logs and members. Monitored the log switching in the redo logs.
  • Operating System security, Data security policy, User security policy and Password Management policy as per bank's requirement.
  • Database Backup through RMAN to Tapes and restore from Tapes to disk
  • Import and Export of Data. Daily backup of archive logs
  • Managed disk space and paging space management for the consistent performance of database.
  • Analyzed the bank's requirements and implemented the changes on the database level.
  • Created and configured the logical standby database. Monitored performance of the logical standby database. Kept the PROD and Data guard in sync.
  • Monitored application servers for the 100% uptime and load balancing. Managing the load balancing of two nodes through the user connections on the application servers.
  • Monitored Disaster Recovery server and checking the log transfer. Ensuring the data to be in synch.
  • Applied Security Interim Patch and upgraded the database.
  • Tuning of databases for consistent performance. Prepared reports for AIX system to monitor the system level performance, resource utilization.
Database Backups DBA Disaster Recovery
Remove Skill
Oracle Database Administrator
Information Technology
Mar 2012 - Dec 2013
Atlanta, GA
Roles & Responsibilities:
  • Provide level 3 support to mission critical, Production, Test and development databases in 24 7 environment
  • Performance tuning to enhance performance of SQL statements. Improved performance of existing process that reduced runtime from 8 hours to 5 minutes.
  • Created script to migrate users from one environment to another.
  • Improved existing storage capacity reporting to analyze and provide trend to leadership.
  • Automated excel dashboard and reporting with the use ODBC connectors that saved 5 man hours every day.
  • Performed POC's on NoSQL databases. Implemented NoSQL databases like Mongo, Cassandra in Dev/Test environment.
  • Perform compression and move activity and data warehouse database. Database cloning through Data Pump Import and Export. Maintain monitoring scripts to check the health of the database
DBA Oracle Performance Tuning SQL
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Networking Systems
University of Sunderland 2010
Information Technology
Anna University 2008
Skills
DBA
2021
6
Database Backups
2021
4
Data Replication
2020
3
Database Upgrades
2019
2
Oracle
2017
2
Disaster Recovery
2015
1
MySQL
2020
1
Performance Tuning
2013
1
SQL
2013
1
SQL Server
2017
1
Database Design
0
1