We provide IT Staff Augmentation Services!

Mongo Database Administrator Resume

5.00/5 (Submit Your Rating)

New York, NY

SUMMARY:

  • Over 6+ years of experience in design, administration, analysis and implementation stages of various databases like MongoDB, ORACLE, SQL Server and MySQL,
  • Over 3+ years of experience in MongoDB large scale database systems.
  • Extensive experience in designing MongoDB replica sets and multi - sharded cluster.
  • Experience in upgrading and migrating various versions of Mongo database on different platforms.
  • Focused on architecting NoSQL databases like Mongo and Cassandra databases.
  • Designed and developed load balancing Mongo applications.
  • Good experience on advanced queries, query conditionals and aggregation framework.
  • Good experience on MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets.
  • Used MongoDB third party tools (ROBO MONGO, MongoDB access manager) and mongo-built in binaries to monitor and analysis the performance of MONGODB.
  • Worked on initial sync of replicaset issue across different versions of Mongo.
  • Extensive experience in scripting in Linux, UNIX and Windows environments.
  • Full life cycle experience in highly secure, extremely large-scale deployments of very high volumes of critical data with extensive security.
  • Participated in DR activity of database for every quarter.
  • Well experienced in Planning Application implementation from end to end includes architecting, designing the metadata, building, loading data. Worked with Business unit, Process unit, Review process, Rules.
  • Responsible for most of the view/controller changes, model/database integration with other members of the team.
  • Good knowledge on database security and implementation of auditing.
  • Supported production database servers and applications that provided secure mission and critical services.
  • Worked on Change management Requests (CMR), Incident Management Requests (IMR) and Line Items.
  • Ability to grasp new technologies quickly and adapt to the same.
  • Experience in preparing the Technical Documents on relevant topic.
  • Performed on-call technical support to minimize the impact of system disruptions.
  • Managing projects ranging from simple implementation to heterogeneous setup for organizations of varying size and complexity in a 24/7 production environment.

TECHNICAL SKILLS:

Programming Languages: Ruby, Java, C, SQL, PL/SQL

Scripting Languages: Python, Ruby scripting, Shell scripting, JavaScript

Application &Web Servers: Apache Tomcat, WebLogic

Development Tools: Eclipse IDE, NetBeans, TextMate, RubyMine

Protocols: HTTP/HTTPS, TCP/IP, SOAP, SMTP, REST

Operating Systems: Linux, Unix, Solaris, Windows

Database Tools: Mongo utilities (Mongostat, Mongotop, Mongofile, Mongodump

PROFESSIONAL EXPERIENCE

Mongo Database Administrator

Confidential - New York, NY

Responsibilities:

  • Experience in deploying, managing and developing MongoDB clusters on Linux and Windows environment
  • Database management for scheduling, tuning, taking backups using on-premise MMS monitoring and backup solution.
  • Point in time Backup and recovery in MongoDB using MMS.
  • Data modeling for data from RDBMS to and MongoDB for optimal reads and writes.
  • Used Neo4j for graphical based search.
  • Responsible for managing MongoDB environment with high availability, performance and scalability perspectives.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, Stored outlines, Statistics. Worked on different storage engines in Mongo.
  • Managing Mongo databases using MMS monitoring tool.
  • Worked on balancer issues and chunk migration failures.
  • Created users in mongo database and assigned specific roles to maintain security of Database.
  • Performance tuning and stress-testing of Mongo database using Mongo utilities.
  • Troubleshooting of different versions of Mongo database systems and cluster configurations to ensure high-availability in various crash scenarios and restoring roll backs to avoid loss of Data.
  • Upgraded Mongo systems from 2.6 to 3.0.5. Also involved with creating shards, replica sets, monitoring, and projections for Mongo Systems.
  • Explain plan of mongodb java scripts and suggested tuning of queries when and where it is required.
  • Developed JavaScript's to monitor health of Mongo databases and perform ad-hoc backups using Mongodump/mongoexport and Mongorestore/mongoimport.
  • Worked with Gridfs collections to store large size documents and enabled sharding with range based sharding keys.
  • Administered multiple environments, automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB
  • Worked on Mongodb database design and indexing techniques.
  • Good knowledge on MongoDB write concern majority.
  • Implemented read preferences in MongoDB replica set.
  • Configured hidden members in replicaset.

Environment: MongoDB, Cassandra, Ruby, Neo4j, MMS, Puppet, Linux/Unix, LVM Snapshots, Backup Scheduler, Data guard, Sharding, Replication, Python, Shell scripting, Perl, PyMongo, JavaScript.

Database Administrator

Confidential - Piscataway, NJ

Responsibilities:

  • Responsible for administration and supporting Oracle 11g, 10g and 9i databases on different linux OS such as RHEL, AIX, HP-UX, Solaris and Windows in DEV, QA, UAT and Prod environments.
  • Installation and Setting up of Standalone databases, 2 node 11g RAC in Linux environment and 11g ASM on RAC databases.
  • Clone production databases to lower environment.
  • Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
  • Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.
  • Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
  • Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
  • Capacity planning of the databases.
  • Replicate schemas using Golden Gate schema replication which includes online change synchronization and ddl synchronization.
  • Export and Import of database objects to copy from one database to another database between different environments.
  • Troubleshooting errors and using the expdp/impdputiliy on a very regular basis for copying data across schemas.
  • Created UNIX shell scripts to automate batch jobs through Cron.
  • Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.
  • Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
  • Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
  • Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
  • Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
  • Used Explain Plan to monitor the query execution and views to make sure the operations run without issues.
  • Performed CRUD operations like Update, Insert and Delete data in MongoDB.
  • Worked on creation of MongoDB databases, collections and deploying JavaScript's using mongo shell.
  • Worked on creating various types of indexes on different collections to get good performance in Mongo database.
  • Created documents in Mongo database.

Environment: Oracle 11g, MongoDB, SQL * Plus, SQL*Loader, SQL Developer, Oracle RAC, Shell Scripts, UNIX, Windows XP.

Oracle SQL Developer

Confidential -Lynchburg, VA

Responsibilities:

  • Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
  • Involved in Unit Testing Stored Procedures and Functions.
  • Created Materialized Views and partitioning tables for performance reasons.
  • Worked on various backend Procedures and Functions using PL/SQL.
  • Resolved performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
  • Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
  • Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
  • Involved in all phases of the SDLC for Designing & giving recommended approach to satisfy the requirements.
  • Development of C modules for activation, deactivation and modification of these plans in Clarify Front End
  • Created SQL*Loader scripts to load data into the temporary staging tables.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team
  • Used TOAD, PL/SQL developer tools for faster application design and developments
  • Developed procedures using Dynamic SQL.
  • Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems
  • Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
  • Created Materialized Views and partitioning tables for performance reasons.
  • Resolving the issues on priority basis.
  • Responsible for Analyzing and Implementing the Change Requests.
  • Involved in handling the changes in compiling scripts according to the database changes.

Environment: C, C++, UNIX shell scripting, Oracle 10g, PL/SQL, Toad, SQL *Plus.

We'd love your feedback!