We provide IT Staff Augmentation Services!

Mongodb And Postgresql Database Administrator Resume

Clinton, MD

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

Hire Now