PROFESSIONAL SUMMARY:

• 8+ years of IT experience in Database design, administration and all aspects of Systems Development using Client/Server technologies that includes Requirements gathering, Analysis, Design and Development.
• Experience in developing application, automated scripts leveraging MongoDB.
• Extensive experience in designing MongoDB multi - shared cluster and monitoring with MMS.
• Designed and developed custom Mongo applications specific to client needs.
• Proficiency in multiple databases like MongoDB, Cassandra, MySQL, ORACLE and MS SQL Server.
• Extensive knowledge in MongoDB concepts and good knowledge in Administration.
• Good experience in MongoDB versions for installation, configuration and 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.
• Expertise in web and mobile front-end development using HTML, CSS, JavaScript and frameworks/Libraries such as Bootstrap and AngularJS.
• Source control and Application life-cycle management experience using Git and GitHub.
• Hands-on experience using HTTP servers such as Apache HTTP server.
• Application development experience using NetBeans IDE, Brackets, Atom and Eclipse IDE and rich client application development using NetBeans platform.
• Web programming experience developing several websites using PHP and MySQL, Worked on design/ development of front-end projects, Systems administration experience in Linux Cent OS and MySQL server.
• Extensively used various design patterns such as MVC (Model-View-Controller), Singleton, MVVM.
• Responsible for authoring of website functionality with JavaScript, HTML, CSS.
• Manage MongoDB/Oracle DB environments from the availability, performance and scalability perspectives.
• Mentoring and supporting the total Engineering team on all aspects of the MongoDB/Oracle databases as a SME(Subject Matter Expert).

TECHNICAL SKILLS:

Languages: SQL, HTML,Java, Java Script, Unix Shell Script.

Database: MySQL, Oracle 10g/11g, MS SQL, DB2, Mongo DBv2.2-3.4

Modeling/Business Tools: Microsoft Visio, Rational Rose, Drools

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

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

PROFESSIONAL EXPERIENCES:

Confidential, Chicago, IL

MongoDBA

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.
• Coordinated with application team in installation, configuration and troubleshoot issues with Apache, Web logic on Linux servers
• 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.
• 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 troubleshooting 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, Cassandra, Ruby, Postgres, MMS, Puppet, Linux/Unix, LVM Snapshots, Backup Scheduler, Data guard, Sharding, Replication, Python, Shell scripting, Perl, PyMongo, JavaScript

Confidential, Phoenix, AZ

Mongo DBA

Responsibilities:

• Disaster recovery strategies and regular recoverability test. 
• Tuning and optimizing access patterns (queries, query sequences, commands) for MongoDB. Created multi-stage aggregation pipelines for data processing and analysis. 
• Microsoft Azure multi-region replica set replication and Optimizing MongoDB CRUD Operations. 
• Experience in MS SQL Server upgrades from 2000 to MS SQL server 2005 and from MS SQL 2005 to MS SQL 2008. 
• Expertise in installation and configuration of MS SQL Server 2000, 2005 on both standalone and Clustered Environments. This involves all coordination till deliver to the customer. 
• Extensive experience in Database/Application Architecture and Software Development Life cycle. 
• Years of experience in managing developers, tester, DBA and other IT professionals. 
• Expertise in Stored procedure, Triggers, Backup/Recovery, Disaster recovery and planning, MS-DTS, T-SQL Tuning /Optimization and troubleshooting, Design and Administration of Federated Databases on Microsoft Clustered Environment. 
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor. 
• Monitored and effectively tuned the SQL database instances by utilizing own scripts. 
• Extensive experience in implementing High availability solutions like Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines. 
• Manage and Implement database releases and Moving database from Test and Stage to Production. 
• Knowledge in Data modeling. 
• Ability to learn and adapt to new environments. 
• Handled numerous Change Management requests on production servers Supported 24 X 7 Production on Call. 
• Good sense of teamwork, leadership quality, integrity, aptitude to learn and ability to put in sustained quality effort consistently.

Confidential, Seattle, WA

MongoDBA Developer

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.
• Administered, maintained Red Hat Enterprise Linux 5.X/ 6.X and IBM AIX 6.X/7.X troubleshooting hardware, operating system, applications & network problems and performance issues.
• Installed and configured RHEL 6.X/7.X servers using Kickstart with PXE for Linux, Apache, MySQL and Perl/ PHP installations.
• 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.
• Created UNIX shell scripts to automate batch jobs through Cron.
• 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.
• Performed user administration & maintained centralized sudoers file replicating managed servers using rdist.
• 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

Confidential

MySQL Database Engineer/ MySQL Support DBA

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.
• 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
• 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.
• 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.
• 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.

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