SUMMARY

• Over 5 years of experience in NoSQL Database Administration and Oracle database administration. Involved in migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, NoSQL, Amazon web services, troubleshooting and documentation.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Focused on architecting Mongo database.
• Designed and developed custom Mongo applications specific to client needs.
• Proficiency in multiple databases like MongoDB, ORACLE.
• Fast learner can quickly incorporate and implement new procedures with efficiency and accuracy.
• Skilled in troubleshooting with good organizational and interpersonal skills.
• Team player with excellent communication skills and ability to lead. Self - motivated individual with exemplary analytical and problem-solving skills.
• Exceptional ability to collaborate with team members for code and design reviews. Self-motivated worker with strong focus on business goals and end-user experience.
• Involved in designing various stages of migrating data from RDBMS to Mongo DB.
• Expertise in AWS, experience in implementing new AWS EC2 instances and working with EBS and S3 storage.
• Experience in Installation, Configuration and Maintenance of Oracle 12c, 11g/10gRAC with ASM and single instance database.
• Full life cycle experience in highly secure, extremely large-scale deployments of very high volumes of critical data with extensive security.
• Experience in various phases of SDLC such as requirements gathering, analysis, design, implementation, maintenance of software applications and testing Client/Server and web applications.
• Responsible for most of the view/controller changes, model/database integration with other members of the team.
• 24x7 Production Database Support to ensure availability, efficiency and recoverability.

PROFESSIONAL EXPERIENCE

Confidential

Mongo DBA

Responsibilities:

• Worked on MongoDB database concepts such as building Indexes, Shard clusters, replicasets.
• Design architecture of MongoDB multiple versions 3.4.x, 3.6.x, 4.0.x Replica sets, Sharded cluster.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Migrated Mongo database systems from No-SSL authentication to SSL authentication using certificates.
• Enabled SSL, PEMKeyFile, CAFile and coordinated with Devops team and Linux Admins regards to Root Certificate.
• Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine.
• Managing Mongo databases using MMS monitoring tool.
• Worked on multiple BSON type objects and used based on requirement.
• Implemented multiple CRUD operations and familiar with new enhancements in each release.
• Supported Bulk Write operation jobs and analyzing the queries and performed tuning based on environment.
• Supported Mongo queries in improving performance by analyzing performance tests.
• Wrote services to store and retrieve user data from the MongoDB for the application on devices.
• Performance tuning and stress-testing of NoSQL database environments to ensure acceptable database performance in production mode.
• Testing, evaluation and troubleshooting of different NoSQL database systems and cluster configurations to ensure high availability in various crash scenarios.
• Developed Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongodump and Mongorestore.
• Built Ops manager from scratch.
• Monitored Mongo replicasets using Ops manager.
• Did Point-in -time restores, backups, profiling on Ops manager.
• Worked with capped collections to wipe out aged data based on requirements.
• 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 creating distinct types of indexes on different collections to get reliable performance in Mongo database.
• Familiar with MongoDB write concern to avoid loss of data during system failures.
• Implemented read preferences in MongoDB replica set.
• Configured delayed secondaries to avoid human failures in coding and development.
• Created Ad hoc reports by querying multiple collections with $lookup operator
• Have written various aggregation pipelines ($group, $project, $sort, $match, $limit and $skip) and created views based on the different business requirements
• Strong experience in analyzing chunk migrations, splitting and balancing across the cluster.
• Skilled in troubleshooting with good organizational and interpersonal skills.

Environment: MongoDB 3.4, 3.6, 4.0, Ops Manager, mtools, Robo 3T, Studio 3T, Aggregation, Mongo Shell, Sharding, Replication, shell scripting, python.

Confidential

Mongo DBA

Responsibilities:

• Experience in managing, installation, configuration and administration of MongoDB (Versions 3.0x, 3.2x, 3.4X and 3.6X)
• Good knowledge on creating collections and performed CRUD operations like Update, Insert & Delete and using aggregation operators.
• Good experience with installing, configuring and monitoring with OPS manager.
• Experience in adding clusters to the Ops Manager.
• Worked on setting up the scheduled backup in Ops Manager. Worked on setting up the alerts from Ops manager.
• Experience in monitoring, performance tuning and managing MongoDB Cluster.
• Experience in deploying, managing and developing MongoDB Clusters.
• Worked on maintenance of SHARDS, REPLICA-SETS in rolling fashion as a part of high availability.
• Experienced in monitoring, back up and scaling Mongo databases using OPS Manager.
• Good knowledge in establishing the Point in time Backup in MongoDB using OPS Manager.
• Efficient in Sharding setup, sharding monitoring, shard key selection, inserting large amounts of data in MongoDB.
• Experience in installing MongoDB from Scratch.
• Experience in identifying the slow queries and analyzing the explain plan. Implemented read preferences in replicaset.
• Good Knowledge on Backup/Restoration of Database through Mongo dump/Mongo restore utility.
• Hands on experience in building the indexes for the faster querying and good performance.
• Experience in resize the Oplog size in MongoDB Versions 3.4 and 3.6.
• Experience in migrating the storage engines MMAPv1 to Wire Tiger
• Enabled and setup the MongoDB Auditing.
• Enabled SSL, PEMKeyFile, CAFile and coordinated with Devops team and Linux Admins regards to Root Certificate.
• Experience in creating the PEMKey Files.
• Created users in MongoDB at database levels, admin level with assigned privileges. In depth knowledge about the chunk migration in sharded clusters.
• Experience in enabling security at data base level by creating users at database level with limited privileges and roles.
• Good experience and knowledge on using GridFs in storing large documents exceeding the size limit of 16MB.
• Hands on experience in setting up the priority of the nodes in a replicaset. Experience in adding shards in existing sharded cluster.

Environment: MongoDB, MMS/OPS, mongostat, mongotop, mongofiles,, Linux/Unix, primary, secondary, priority, query optimizer, read concern, read preference, write preference, write concern

Confidential

Oracle DBA

Responsibilities:

• Provided System support for both development and 24/7 production environments.
• Experienced in ORACLE Software Installation, DBCA to create database and DBUA to upgrade Oracle database on the Red Hat LINUX and Windows environment.
• Experience in implementing and maintaining Virtual machine (VM).
• Tuning for performance at Operating system level and Database Level. Performance tuning with ASH, AWR, ADDM Reports.
• Monitors database activity and file usage, and ensures necessary resources are present.
• Perform daily incremental backup and full weekly backup using Oracle recommended backup utility, RMAN.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Database migration using Data Pump as well as RMAN.
• Operating system CPU average, Load average, IDLE time average monitoring by TOP, IOSTAT, NETSTAT, and VMSTAT.
• Creating and dropping of users, granting and revoking permissions to users/roles.
• Using Oracle Enterprise Manager (OEM) for routine administration, database monitoring, replication process and performance tuning.
• Monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Develop and enforce database related policies, standards, naming conventions, operating procedures and best practices.
• Create and maintain multiple databases, users, roles and privileges.
• Administer database user accounts. Create, modify, reset username/password, lock and unlock user accounts.
• Familiar with Fine Grain Access (FGA) and Fine Grain Access Control (FGAC).
• Experience in schema management, Tablespace, datafile and extent management, as well as user and privilege management.
• Tablespace management including, adding/resizing data files, allocated quotas to user and managed disk space.
• Extensively used data moving utilities like export/import, Data Pump.
• Familiarity of Oracle High Availability Architecture (HA) involving Oracle RAC, ASM, Golden Gate, Data Guard and EXADATA.
• Optimized database performance by analyzing tables and indexes.

Environment: Oracle 10g,RMAN,Virtual machine (VM), Agile/Scrum Windows, MS-Project, MS-Office Suite, MS Visio, MS PowerPoint, Quality Center 10, UNIX, SQL, Data Analysis.