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.