PROFESSIONAL EXPERIENCE

MongoDBDeveloper/MongoDBA

Confidential, Austin, TX

Responsibilities:

• Extensive experience in deploying, managing and developing MongoDB clusters.
• Creation, configuration and monitoring Shards sets. Analysis of the data to be shared, choosing a shard Key to distribute data evenly.
• UsedMongoDBthird party tool (ROBO MONGO) and mongo - built in binaries to monitor and analyze the performance of MONGODB.
• Installation ofMongoDBon physical machines, Virtual machines as well as AWS. Backup & Recovery, Database optimization and Security maintenance.
• Worked onMongoDBdatabase concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Created multiple databases with sharded collections and choosing shard key based on the requirements.
• Experience in managingMongoDBenvironment from availability, performance and scalability perspectives.
• Configuring high availability using geographicalMongoDBreplica sets across multiple data centers.
• Migrated Mongo database systems from No-SSL authentication to SSL authentication using certificates.
• Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine.
• Managing Mongo databases using MMS monitoring tool.
• Performance tuning and stress-testing ofNoSQLdatabase environments in order to ensure acceptable database performance in production mode.
• Testing, evaluation and troubleshooting of differentNoSQLdatabase systems and cluster configurations to ensure high-availability in various crash scenarios.
• Upgraded Mongo systems and involved with creating shards, replica sets, monitoring, and projections for Mongo Systems.
• Extensive experience on linux and shell scripting.
• Installed and configured Mongodb in Linux servers.
• Monitored the servers and Linux scripts regularly and performed
• Developed Ruby/Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongodump and Mongorestore.
• Worked 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 withMongoDB
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Familiar withMongoDBwrite concern to avoid loss of data during system failures.
• Implemented read preferences inMongoDBreplica set.
• Configured delayed secondary's to avoid human failures in coding and development.
• Strong experience in analyzing chunk migrations, splitting and balancing across the cluster.
• Worked on pre-splitting mechanism using shard keys to distribute data across shards.
• Skilled in troubleshooting with good organizational and interpersonal skills.

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

Database Administrator

Confidential, Dallas, TX

Responsibilities:

• Performed CRUD operations like Update, Insert and Delete data inMongoDB.
• Experience in deploying, managing and developingMongoDBclusters 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 inMongoDBusing MMS. Data modeling for data from RDBMS to andMongoDBfor optimal reads and writes.
• Responsible for managingMongoDBenvironment 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 onMongodbdatabase design and indexing techniques. Good knowledge onMongoDBwrite concern majority.
• Extensive experience on Linux operating system.
• Implemented read preferences inMongoDBreplica set. Configured hidden members in replica set.
• Installed and configuredMongoDBfor an enterprise application to analyze the big data requirements.
• Configured replication and high availability forMongoDBinstances
• Worked onMongoDBdatabase 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 differentNoSQLdatabase systems and cluster configurations to ensure high-availability in various crash scenarios. Worked on creating documents in Mongo database.

Environment: Oracle 11g, RAC, RMAN,MongoDB, Sharding, TOAD, Shell Scripts, UNIX, Windows XP

MongoDBDBA

Confidential, Tampa,FL

Responsibilities:

• Managing large - scale, geographically-distributed database systems, including relational MySQL and NoSQL (MongoDB) systems
• Administration and management of the entire development, QA and production environment.
• Installed and configured MySQL on Linux and Windows environments.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Performed CRUD operations like Update, Insert and Delete data inMongoDB.
• Worked on creation ofMongoDBdatabases, collections and deploying JavaScript's using mongo shell.
• Responsible for managingMongoDBenvironment with high availability, performance and scalability perspectives.
• Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Effectively configured MySQL Replication.
• Designed databases for referential integrity and involved in logical design plan.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
• Proficiency in Unix/Linux shell commands.
• Created data extracts as part of data analysis and exchanged with internal staff. Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Shell script is being used for some data migration and backend work management. Supporting management with different database related decisions.
• Handling Release management and user acceptance.

Environment: MySQL,MongoDB, Master-slave replication, shell scripting, Java script, Import, Export, AIX and Red Hat, Data guard, sharding, replication, python.

Database Administrator

Confidential, Dallas, GA

Responsibilities:

• Created replication andMongodbSharding clustering in Azure cloud environment.
• Managing large - scale, geographically-distributed database clusters across the globe.
• Working on Azure cloud, Aws cloud and on-prime environments.
• Be a part of cluster sizing, and machines count.
• Worked on Multiple data center deployments.
• SSL encryption, Mtools, Analysis of data usage for proper index creation and data modeling.
• Coordinate and plan with Application teams onMongodbcapacity planning for new applications.
• Analyze usage of data and work with application teams on implementing collection index strategies, proper use of aggregation/query frameworks, event changes to the document model.
• Ensured System sizing and Tuning with properMongodbuse of memory, pre-heating data, and proper configuration of storage read ahead, NUMA, and Huge Pages.
• Participate in scalability testing to ensureMongodbhigh performance
• Upgrade Mongdb replica set and sharded cluster to multiple versions.
• AnalyzeMongodblog, OpLog file, MongoStat, Server Status, and MMS/OPS manager, to determine and validate root cause analysis of outages and performance bottlenecks.
• Implemented UNIX shell script to automate password changes, gathering performance statistics, collection stat, mlogfilter and mtools query performance analyzer.
• Planned and Implemented SSL encryption forMongodbintra-cluster communications.
• Knowledge of Configuration Management tools (Puppet) in developing and Experience with Performance Analysis and Troubleshooting in developing.
• Analyzed data to determine appropriate Shard key.
• Analyzed performance activity to determine if data required balancing in sharded cluster.
• Backed up databases from replication secondary server.
• Implemented indexing for better performance.
• Implemented MMS forMongodbmonitoring and backup process.
• Involved in Requirements and Analysis: Understanding the requirements of the client and the flow of the application as well as the MVC application Framework.
• worked on creating indexes on secondary nodes.

Environment:MongoDB, Ruby, MMS, Linux/Unix, Backup Scheduler, Sharding, Replication, Python, Shell scripting, JavaScript

Software Developer

Confidential, Sanfrancisco, CA

Responsibilities:

• Review SQL and PL/SQL for Production and sub - environments to ensure accuracy and optimization.
• Performed daily monitoring of databases for availability and performance metrics.
• Reviewed log files from overnight and batch processes for significant events.
• Created Database tables, views and indexes.
• Creation of functions using PL/SQL. Creation of DML, DDL, DRL, TCL, DCL using SQL. Creation of Joins, Equijoin, Sub quires in SQL.
• Invoices are imported from the Excel sheets to the Oracle Database using SQL * LOADER
• Developed Reports as per client requirement.
• Involved in creation of SQL and PLSQL scripts. Creation of Packages, Stored Procedures & triggers using PL/SQL and loaded data using SQL*Loader.
• Created HTML and CSS from Photoshop mockups.
• Defined and developed the application's presentation layer using HTML, CSS, JavaScript, and JQuery Scripting and framework.
• Worked and involved in development, enhancement and testing of the application. Defined different media queries for different devices.
• Got chance to interact with business team on regular basis and gather requirements.
• Successfully wrote and implemented SQL Queries, Stored procedures and Triggers in SQL Server Evaluated, analyzed, and tested web interface to understand and enhance the overall usability of the designs.
• Actively participated and provided feedback in a constructive and insightful manner during weekly Iterative review meetings to track the progress for each iterative cycle and figure out the issues.
• Ensured site design integrity and quality control consistency throughout the project's lifecycle.
• Updated the website from time to time for special Requirements.
• Responsible for quality assurance of finished websites including the validation of web forms and links.

Environment: SQL, JavaScript and windows XP, Oracle 9i, Developer 2000, XML, Windows NT 4.0, MS Access 2000