PROFESSIONAL SUMMARY:

• Up to Eight years of experience in working as database developer and administrator.
• Experience in handling, configuration and administration of databases like MySQL and NoSQL databases like MongoDB and Cassandra.
• Experience in working with databases like MongoDB, MySQL and Cassandra.
• Strong MySQL and MongoDB administration skills in Unix, Linux and Windows.
• Experience in upgrading different databases and also migration of data among multiple databases.
• Experience in analyzing and visualizing the data along with data modeling.
• Experience in managing large shared MongoDB cluster.
• Experience in SQL coding and tuning.
• Experience in trouble shooting /performance tuning.
• Experience in diagnosing the problems and resolving issue across various servers.
• Experience in MongoDB installation, patching, troubleshooting, performance, tracking/tuning, back - up and recovery in dynamic environments.
• Experience in managing life cycle of MongoDB including sizing, automation, monitoring and tuning.
• Experience with complex data environments.
• Experience on working with MongoDB Ops Manager, Cloud Manager and Atlas Manager
• Experience in integrating databases like MongoDB, MySQL with webpages like HTML, PHP and CSS to update, insert, delete and retrieve data with simple ad-hoc queries.
• Self motivated, quick learner, goal-oriented, resourceful and innovative team player.
• Excellent team spirit and leadership qualities with good communication and interpersonal skills.

TECHNICAL SKILLS:

Modeling Tools: Microsoft Visio, Jira, GitHub

Databases: MongoDBv2.2-3.4, MySQL(5.5-5.6), MS SQL Server v.10-v.12, Amazon DynamoDB, Cassandra

Programming Languages: JAVA, SQL, HTML, CSS, Java Script and JSON, Node JS(WT)

Development Tools: Net Beans, Eclipse IDE, MS Office, MySQL Workbench

Operating systems: Windows 95/98/2000/XP, Linux, UNIX (CentOS)

Virtual Machine: VM Ware Server

Databases Tools: MongoVue, RoboMongo, Mongochef, MongoDB Compass, NoSQL Manager and Mongo Booster, SQL loader

Web Servers: WampServer and AWS

WORK EXPERIENCE:

MongoDB Developer

Confidential, New York, NY

Responsibilities:

• Experience in design and developing Application leveraging MongoDB.
• Experience in developing java programs at the Application side. Developed Ruby/Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongo dump and Mongo restore.
• Experience with creating script for data modeling and data import and export. Extensive experience in deploying, managing and developing MongoDB clusters. Experience in creating JavaScript for using DML operation with MongoDB .
• Creation, configuration and monitoring Shards sets. Analysis of the data to be shared, choosing a shard Key to distribute data evenly. Architecture and Capacity planning for MongoDB clusters. Implemented scripts for mongo DB import, export, dump and restore.
• Worked on MongoDB database 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 managing MongoDB environment from availability, performance and scalability perspectives.
• Worked on creating various types of indexes on different collections to get good performance in Mongo database.
• Worked on creating documents in Mongo database.
• Worked on multiple BSON type objects and used based on requirement.
• Responsible in all facets of Software Development Life Cycle (SDLC), including requirements gathering, establish technical specifications, set deadlines and milestones, Designing, Coding, Testing, Quality Assurance and Production Deployment.
• Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization.
• Configured replication with replica set factors, arbiters, voting, priority, server distribution, slave delays.

MongoDB DBA

Confidential, New York, NY

Responsibilities:

• Experience in deploying, managing and developing MongoDB clusters.
• Familiar with Clusters, Performance tuning, backup and recovery.
• Used multiple read concern level options to make sure a level of isolation for application reads.
• Applied write concern for level of acknowledgement while MongoDB write operations and to avoid rollback.
• Configured to read data from secondary server to reduce load on primary in replica set environment.
• Considering storage optimization for small documents.
• Used document references to query data from multiple collections.
• Experienced in performing Backup and recovery using MMS and Ops manager.
• Installation of MongoDB RPM’s, Tar Files and preparing YAML config files.
• Performed Data Migration between multiple environments using mongodump and mongo restore commands.
• Evaluating the Indexing strategies to support queries and sort documents using index keys.
• Enabled Journaling across all mongo instances for auto recovery of data after unexpected shutdown.
• Used MongoDB internal tools like Mongo Compass, Mongo Atlas Manager & Ops Manager, Cloud Manager etc.
• Worked on MongoDB database concepts such as locking, transactions, indexes, sharding, replication and schema design.
• Worked with huge reporting collections to wipe out aged data based on requirements.
• Worked on creating different type of indexes based on different collections to get good performance in MongoDB.
• Configured delayed secondary’s to avoid human failures in coding and development.
• Responsible for Ops Manager monitoring, performance tuning and trouble shooting tasks
• Experience in creating JavaScript for using DML operation with MongoDB.
• Created multiple databases with sharded collections and choosing shard key based on the requirements.
• Configuring high availability using geographical MongoDB replica sets across multiple data centers.
• Experience in analyzing chunk migrations, splitting and balancing across the cluster.
• Experienced in troubleshooting with good organizational and interpersonal skills.

Environment: MongoDB, Sharding, Replication, Shell Scripting, AWS, Java Script

Database Administrator

Confidential

Responsibilities:

• Performed migration from MySQL to MongoDB V 3.0.11.
• Performed migration without any kind of impact on students, faculty and university administration.
• Installed MongoDB, configured, setup backup, recovery, upgrade and tuning and data integrity.
• Worked on creation of databases, collections and deployed JavaScripts using mongo shell.
• Performed query construction for further business requirements.
• Performed CRUD operations on the data imported.
• Overcame challenges like data migration from MySQL to MongoDB.
• Usage of tools like RoboMongo, MongoVue and NoSQL Manager for migration of data between databases without any kind of data loss.
• Responsible for managing MongoDB environment with high availability, performance and scalability perspectives.
• Performed operations related to sizing, query optimization, backup and recovery, security and upgrades including administration functions as part as profiling under assistance.
• Performed tuning on a daily basis for preventing issues and providing capacity planning using MySQL enterprise monitor.
• Developed stored procedures, triggers in MySQL for reducing traffic between client-server.
• Performed MySQL replication setup and administration on Master-Slave and Master-Master.

Environment: MySQL, MongoDB v3.0.7, RoboMongo v0.9.0, NoSQL Manager V3.3, Sharding, replication, shell scripting, Java script.

MYSQL DBA

Confidential

Responsibilities:

• Designed an RDBMS database used as the analysis database while ensuring the analysis data confirmed to the designs set out for the database.
• Experience in diagnosing and resolving data integrity issues which ensures both consistency and accuracy.
• Experienced in maintaining backup, recovery policies and procedures for databases.
• Maintained security which includes creating and maintaining users and roles.
• Designated and assigned database and table privileges for those users and roles.
• Experience in setting up database tuning, monitoring and administration using dbForge studio
• Created customer-facing trend analysis and internal analysis reports and dash boards using tableau.
• Migrated SQl server database into MySQL using Data Transformation Services.
• Creation of triggers for audit log of database.
• Scheduled both hot and cold backups using MySQL dump.
• Setting up Master-Slave replication between MySQL servers for high availability of data.
• Tuning databases by partitioning tables.
• Client connections, application logs and viewing error logs.
• Key Technologies: MySQL

MySQL Database Engineer

Confidential

Responsibilities:

• Developed database objects like tables, views, indexes, synonyms and sequences.
• Creation of tables, join conditions, correlated sub-queries, nested queries, views, sequences, synonyms for the business application development.
• Data purging to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.
• Worked with various dataflow tasks like merge join, merge, aggregate, OLE DB command and conditional split while designing SSIS packages.
• Designed layout of SSRS reports and determine the best way to present data to end users.
• Developed SSRS reports and dashboards using Microsoft Reporting Services Platform(SSRS), Microsoft SQL, MS Excel, pivot tables.
• Implementation of support of ETL process using SSIS packages in SQL server 2008
• Created materialized views to calculate aggregated data, such as sum of monthly avenue.
• Developed PL/SQL code for updating payment terms.
• Development of PL/SQL program units and sharing them among multiple applications for processing business logic in the database.
• Testing all forms, PL/SQL code for logic correction.

Environment: SQL, PL/SQL,SQL *Loader, Forms/Reports 6i, UNIX

MySQL Support DBA

Confidential

Responsibilities:

• Installation and setup of MySQL 5.1 Enterprise and Community servers on Windows/Linux
• Configuration of primary and disaster recovery sites for application and database servers.
• Assisted in configuring, monitoring, upgrading and maintaining application database related infrastructure.
• Managed Application Database system using MySQL and resolved all performance issues.
• Executed database security standards along with the database maintenance.
• Creating procedures and functions for reporting and ETL purpose.
• Database optimization by tuning queries for various modules in the project for better performance.
• Created validation rules for performing data validations based on the user profile and their record type.
• Created and customized reports and dashboards.
• Working with various MySQL tools like MySQL workbench, MySQL Administrator, MySQL GUI tools, MySQL performance monitor, MySQL migration toolkit.

MS SQL Server DBA

Confidential

Responsibilities:

• Involved in installation of SQL Server 2012 and SQL Server 2014 in newer environments.
• Installed and Applied patches to the existing SQL servers and Upgrading SQL servers .
• Installed SQL Server Active-Active and Active-Passive clusters.
• Configured SQL Server jobs for Index maintenance, Database Consistency jobs, Database backup jobs and Alerts.
• Ensured regular database backups and recommend the appropriate recovery models for the production databases as per the database usage.
• Setup SQL Server Disaster Recovery.
• Automated weekly and monthly non-production database refreshes.
• Involved in providing SQL DBA Production support and Management.
• Configured High Availability practices like Log Shipping, Database Mirroring and Replication.
• Set up database snapshots on the secondary mirror database for reporting purpose.
• Responsible for maintaining SQL Server security and granting access to users as per requirement.
• Performed SQL Server Performance Tuning and optimization.
• Performed SQL Server database sizing, partitioning and archiving/purging.
• Developed SSRS reports on the DBA metrics data.