SUMMARY

• A professional Database Administrator with 6 years of experience in implementation and administration of MongoDB and PostgreSQL.
• Sound knowledge in Data Modeling and schema less NoSQL Database systems such as Cassandra and Neo4j, Relational databases such as SQL Server.
• PostgreSQL and Oracle 10g, Data warehousing tools such as Talend on Windows & GNU/Linux environment.
• Deploy, Configure and maintain MongoDB and PostgreSQL databases and replica sets across multiple environments.
• Planning and performing MongoDB and PostgreSQL database upgrades and migrations.
• Monitor using Ops manager and MongoDB Cloud Manager and tune performance of MongoDB Databases.
• Good knowledge of performance tuning of MongoDB and PostgreSQL instances, Configuration parameter, Schema design, indexing on premises and on clouds AWS, RDS, EC2, ATLAS, S3, AZURE and Cosmos DB.
• Work with application team to understand the database needs of our applications and optimize them using MongoDB.
• Proficient with both window and Linux operating system
• Extensively involved in Cluster planning, Installation, troubleshooting and Performance Tuning of the MongoDB Clusters.
• Experience with HA solutions and backup/recovery strategies.
• Perform production level support and be part of the on - call rotation when required.
• Expertise of MongoDB and PostgreSQL HA strategies, including replica sets and sharding.
• Design & Implement sharding and indexing strategies for MongoDB and Partitioning in PostgreSQL.
• Deep knowledge of DB performance/scaling concepts and tuning best practices
• Experience with database replication and scaling issues
• Maintaining strong documentation.

PROFESSIONAL EXPERIENCE

Confidential, Clinton MD

Mongodb and PostgreSQL Database administrator

Responsibilities:

• Extensively involved in Cluster planning, Installation, troubleshooting and Performance Tuning of the Mongo and PostgreSQL instances on premise and on cloud.
• Implementing Backup and recovery strategies on QA and prod environments.
• Design, setup and Administer high volume and High transaction (failover + offsite) PostgreSQL DB installations with streaming replication.
• Manage MongoDB Ports
• Maximize Resources.
• Install, configure and manage database instances on production environments and lower environments.
• Storage Engine Upgrade from Mmapv1 to WiredTiger.
• Config Servers Upgrade from SCCC to CSRS (Config Servers to Replica Sets).
• MongoDB Version Upgrades.
• MongoDB Enterprise to Community Edition - Downgrade.
• Mongod and Mongos Instances Run as a Service where start, stop and restart commands are in place - In Binary Installation.
• Monitoring using Zabbix, Foglight, Dynatrace, and Log Rotate Scripts - UNIX bash scripting.
• Install and maintain MongoDB and PostgreSQL.
• Good exposure to CRUD, JSON.
• MongoDB And PostgreSQL cluster administration and management.
• Deploy replica set ( with and without arbiter).
• Deploy sharded environment (with and without replica set) i.e. MongoDB scaling across data centers.
• Creating and managing user management tasks on Mongodb and PostgreSQL.
• Managing sharded cluster and replica set members in Mongo environments.
• Upgrading MongoDB database while retaining the MMAPV1 storage engine as per application requirement.
• Expertise in upgrading MongoDB database in rolling fashion with wired tiger storage engine.
• Good understanding of Oplog and journals.
• Expertise in data migration from stress or development environment to production.
• Experience in troubleshooting database Performance Issues.
• Use database utilities like explain, mongotop, mongostat, mongodump, mongorestore, mongoimport, mongoexport etc.
• Ensures Backup and purges old logs.
• Monitor and tune performance of MongoDB databases. abase maintenance activities on quarterly/half yearly basis (vacuum full and Re-index operations).
• Refreshing the test and Dev environments based on customer requirements.
• Compiling AHC reports and implementing changes on Postgresql/PPAS clusters.
• Handling large databases in production support environment for various CMM 5 level customers for disaster.
• Conditions.
• Maintenance and management of in-house PostgreSQL databases.
• Day-to-day database monitoring and troubleshooting of production and test servers.
• User & security management: control user access to resource and information by allocating the right.
• Privileges/roles/profiles and functions.
• Perform Mongo and PostgreSQL DBA Routines.
• Monitor the database Status.
• Perform Operational user requests.
• Query data based on user request.
• Create, read and update data.
• Provide value adds by analyzing the performance of the database.
• MongoDB Installation.
• Configuring and monitoring replica sets.
• Optimization.
• Sharding setup, sharing monitoring, shard key.
• Selection, inserting large amounts of data.
• Performing Security measures, backups and restore backups.
• Install and configure MongoDB.
• Gathering requirements from business in the form of excel and converting to csv - importing to mongodb.
• Restructure the entire data as per the business requirements using javascript functions.
• Performing calculations using aggregation framework and javascript.
• Writing functions in MongoDB using JavaScript as per the requirement.
• Configuring and monitoring replica sets Optimization.
• Writing & implementing backup & restore plans.

Confidential, Lowe MA

MongoDB DBA

Responsibilities:

• Perform Mongo and PostgreSQL DBA Routines.
• Monitor the database Status.
• Perform Operational user requests.
• Query data based on user request.
• Create, read and update data.
• Provide value adds by analyzing the performance of the database.
• MongoDB Installation
• Configuring and monitoring replica sets
• Optimization
• Sharding setup, sharing monitoring, shard key
• Selection, inserting large amounts of data
• Performing Security measures, backups and restore backups