PERSONAL SUMMARY:

• 5 years of experience in design, administration, analysis and implementation stages of various databases like MongoDB, ORACLE, SQL Server, My SQL and Postgresql
• Extensive experience in designing MongoDB replica sets and multi - shaded cluster.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Focused on architecting No SQL 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 replica set issue across different versions of Mongo.
• Extensive experience in scripting in Linux, UNIX and Windows environments.
• Extensive knowledge in MongoDB concepts and good knowledge in Administration.
• Experience building structured MVC web applications using JavaScript, AngularJS, Node.js, jQuery, Express, MongoDB.
• Developed enhancements to MongoDB architecture to improve performance and scalability.
• Familiar with MongoDB clusters, Java scripting to load unstructured data into sharding environment.
• 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.
• 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:

DATABASES: Mongo 3.0, 3.2, 3.4, ORACLE 9i, 10g and 11g, Postgres, SQL Server 2012/2008, SQL server 2008R2, MySQLOperating Systems Window 2003 Server, Windows 98, Windows XP, Linux and UNIX (AIX). Solaris and WINDOWS Servers, RHEL6, RHEL7

UTILITIES& TOOLS: ,TOAD, RMAN, EXPDP, IMPDP, IMP, EXP,Robomongo,Mongochef,mongodump,mongorestore,mongostat,mongotop,mongo Atlas

Languages: python, Nodejs, XML, SQL,PL/SQL, Java

PROJECT EXPERIENCE:

Sr. MongoDB Developer/Administrator/DBA/MongoDatabase

Confidential, Los Angeles, CA

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 inMongo.
• ManagingMongodatabases using MMS monitoring tool.
• Worked on balancer issues and chunk migration failures.
• Created users inmongodatabase and assigned specific roles to maintain security of Database.
• Performance tuning and stress-testing ofMongodatabase usingMongoutilities.
• Troubleshooting of different versions ofMongodatabase systems and cluster configurations to ensure high-availability in various crash scenarios and restoring roll backs to avoid loss of Data. UpgradedMongosystems from 2.6 to 3.0.5.
• Also involved with creating shards, replica sets, monitoring, and projections forMongoSystems.
• Explain plan of mongodb java scripts and suggested tuning of queries when and where it is required.
• Developed JavaScript's to monitor health ofMongodatabases 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 ps 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.

Confidential, Akron, OH

Database Administrator

Responsibilities:

• Involving with installation and maintenance of MongoDB for high availability.
• Involving in change control process and Upgraded the Oracle 12c/11g to Mongo DB 3.2 version and applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day - to-Day Backups, Log's & recovering them as per the requirement.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Involvement in space management, rectification of lock problems, managed quotas.
• Performing Migration of databases 10g on Hp - UNIX to Oracle 11gR2 on Linux. Created and monitored database objects like Indexes, Views, Users, and DB Links.
• Implementing High availability using Golden Gate Replication.
• Writing scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also, wrote UNIX scripts to process batch jobs.
• Monitoring queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports
• Creating Partition's estimated stats on one partition1 and copied the stats to remaining partitions using dbms stats.
• Performing CRUD operations like Update, Insert and Delete data in MongoDB.
• Working on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design, etc.
• Working on creating various types of indexes on different collections to get good performance in Mongo database.
• Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high-availability in various crash scenarios.
• Working on creating documents in Mongo database.
• Upgraded Mongo systems and involved with creating shards, replica sets, monitoring, and projections for Mongo Systems.
• Working with capped collections to wipe out aged data based on requirements.
• Administered multiple environments (up to 25TB), automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB.
• Working on creating various types of indexes on different collections to get good performance in Mongo database.
• Familiar with MongoDB write concern to avoid loss of data during system failures.
• Analyzing chunk migrations, splitting and balancing across the cluster.
• Working on pre-splitting mechanism using shard keys to distribute data across shards.
• Skilled in troubleshooting with good organizational and interpersonal skills.

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

Database Administrator

Confidential, Warwick, RI

Responsibilities:

• Performed CRUD operations like Update, Insert and Delete data in MongoDB.
• 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.
• Responsible for managing MongoDB environment with high availability, performance and scalability perspectives.
• 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.
• Worked with Gridfs collections to store large size documents and enabled sharding with range based sharding keys.
• Worked on Mongodb database design and indexing techniques. Good knowledge on MongoDB write concern majority.
• Implemented read ps in MongoDB replica set. Configured hidden members in replicaset.
• Installed and configured MongoDB for an enterprise application to analyze the big data requirements.
• Configured replication and high availability for MongoDB instances
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design, etc.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high-availability in various crash scenarios. Worked on creating documents in Mongo database.

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

Confidential, Orlando, FL

Oracle DBA

Responsibilities:

• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• Creating and Maintaining of databases.
• Creating table spaces, tables, indexes, data files etc.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Managing, troubleshooting and resolving Oracle database and applications issues.
• Perform capacity planning required to create and maintain database environments.
• Helping to the developing team and data warehousing team.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Writing complex queries and procedures using SQL *plus and toad.
• Developed shell scripts and automated nightly jobs using crone to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Monitoring the background processes activity, setting the appropriate number of DBWR processes, changing the init.ora parameters etc.
• Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Monitoring table space size, resizing table space, relocating data files for better disk I/O
• Managing archive logs, DB - links, partitions.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases
• Maintain Oracle schemas and SGA region.
• Guiding and leading warehousing team for better performance.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Implemented Oracle high availability solution using Oracle 10g PHYSICAL STANDBY.
• Managed the PHYSICAL STANDBY including Switchover and Failover scenarios.

Environment: ORACLE 10g, 9i, RHEL 4.x, SUN SOLARIS 9, HP-UX 11