PROFESSIONAL SUMMARY:

• Having 7 years of experience in Database design, Administration and development in Mongo DB, Oracle and MySQL. 
• Over 3+ years of experience in   MongoDB   Installation, Configuration and Administration. 
• Experienced in NOSQL Database design and principles ( MongoDB , Cassandra). 
• Proficient in designing   MongoDB   dynamic schemas and Data modelling concepts. 
• Experienced in Design, Analysis, Administration and Development and implementation stages of several Client/Server applications using Java/J2EE, HTML5, JavaScript, Object Oriented Programming, SQL Server, MySQL and Oracle. 
• Experienced in implementation of backup and recovery process for various databases like   MongoDB , Oracle and MySQL. 
• Experienced in   MongoDB   document Schema design. 
• Worked on MMS monitoring tool to support multiple versions of   MongoDB . 
• Good knowledge on Mongo utilities (mongostat, mongotop, mongoperf, mongodump and mongorestore). 
• Extensive experience on Master - Slave architecture in Mongo and MySQL. 
• Efficient in handling Index rebuilding, maintenance activities on secondary's without impacting business in rolling fashion across the replica sets. 
• Worked on Microsoft Azure, AWS cloud environments. 
• Complete understanding of Software Development Lifecycle and Core area of experience in to validate end-to-end business scenarios of B2B (Business to Business) applications. 
• Ability to understand the project requirements and deliver it with proper estimation and quality. 
• Solid Experience in UNIX skills including writing shell scripts, CRON JOBS and utilities. 
• Extensive experience in the entire process of the software development life cycle (SDLC) including requirements definition, prototyping, architecture, design, implementation, testing and maintenance. 
• Excellent exposure to Version Control Systems like Git (git flow), Svn. 
• Good experience writing robust, well-tested front end and back end codes. 
• Hands-on experience using GitHub, Amazon EC2, Git. 
• Strong knowledge on Document store databases like   MongoDB   and Cache store services like Redis. 
• Experience with Agile methodologies and involved in all aspects of software development life cycle including requirements definition, prototyping, architecture, design, implementation, testing and maintenance. 
• Used open source tools like, Mongochef, Robomongo for crud operations, Zabbix, appDynamics, Kibana and Graphite for Monitoring and Nagios for alerts. 
• Knowledge of Configuration Management tools (Puppet) in developing. 
• Experience with Performance Analysis and Troubleshooting in developing. 
• Extensive experience in Database Programming, Designing, Modeling and Development. 
• Highly dedicated, quick starter, solution driven pattern programmer, Strong in Object Oriented Analysis and Design, Excellent at solving complex problems under strict deadlines. 
• Self-motivated, goal-oriented, innovative, flexible and resourceful team member. 
• Excellent Communication, Interpersonal and Leadership skills.

TECHNICAL SKILLS:

Programming Languages: Java, C, C++, C#, Shell Scripting

Technologies/Java Enterprise API: JSP, Servlets, JavaBeans, JDBC, Struts, RMI, EJB, Hibernate, Spring, Web Services, SOA, JMS, SAX and DOM Parsers, AJAX, JAXB, JAXP, JSF, JNDI, Java Mail, Applets, Java Multihreading, JAX-RPC, JPA, JAX-WS, JAX-RS, iBATIS

Web/XML Technologies: HTML/DHTML, XHTML, CSS, JavaScript, AngularJS, Node.js, Backbone.js, jQuery, AJAX, XML, XSL, XSLT, CSS, DTD, SAX, DOM, SOAP, XPath, XSD, XQuery, ASP.NET 1.1, ADO.NET, VB.Net

Development Tools (IDEs) & Tools: Eclipse, JDeveloper, MyEclipse, IBM WSAD/RAD/RSA, NetBeans, EditPlus, JIRA, Log4j, MS Visio, Putty, WinSCP, Rational ClearQuest, Talend Open Studio, Tableau

Web/Application Servers: Apache Tomcat, IBM Websphere, WebLogic, JBoss

Design Patterns: MVC, Front Controller, Session Façade, Singleton, Business Delegate, DAO

Databases & Programming: Oracle 12c/11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , MySQL5.1/4.1, DB 2 9.1/8.1/7.2 ,Toad, SQL, PL/SQL, Stored Procedures, PostgreSQL, MongoDB

Platforms: Windows 2000/NT/XP/7, Linux, Unix, Mac OS X, MS DOS

Testing Tools: JUnit, Mockito

Version Control: CVS, SVN, VSS, GIT, TFS, Harvest, Rational Clear Case.

Software Engineering: UML, Design Patterns, Object Oriented Methodologies, Service Oriented Architecture, Test Driven Development, Scrum and Agile methodologies

Build Tools: Ant, Maven

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Senior MongoDB DBA

Responsibilities:

• Involved in Requirements and Analysis: Understanding the requirements of the client and the flow of the application as well as the MVC application Framework. 
• Experience in managing large-scale, geographically-distributed database systems, including relational (Oracle, MySQL) and NoSQL ( MongoDB ) systems. 
• Extensive experience in deploying, managing and developing with   MongoDB   clusters.
• Familiar with   MongoDB   clusters, performance tuning, backup and recovery. 
• Managed run-time configuration, processes, scaling, backup and recovery, monitoring, and performance tuning for production   MongoDB   instances. 
• Implementation of   MongoDB   security mechanism with various Authentications. 
• Applied patches and upgraded from 2.4 to 2.6 and 3.0. Worked with multiple storage engines in   MongoDB . 
• Implemented LVM snapshots and MMS backups for large scale   MongoDB   systems. Administering   MongoDB   databases using various Mongo utilities. 
• Created multiple databases with shared collections and choosing shared key based on the requirements. 
• Developed data modelling for data from RDBMS to   MongoDB   for optimal reads and writes. 
• Worked on custom map/reduce engine to analyze   MongoDB   databases directly using the on-disk format. Faster and more memory-efficient than other solutions. Used for generating metrics to drive business decisions. 
• Complete understanding of Software Development Lifecycle and Core area of experience in to validate end-to-end business scenarios of B2B (Business to Business) applications. 
• Worked on API server and maintained, written using Python Twisted and my own   MongoDB   driver. Handles data synchronization to millions of mobile devices from a single machine. 
• Scalable data design for   MongoDB   and Redis. Worked on pre-splitting mechanism using shard keys to distribute data across shards. 
• Point in time Backup and recovery in   MongoDB   using onsite MMS. 
• Familiar with   MongoDB   clusters, Java scripting to load unstructured data into shared environment. 
• Managed and maintain   MongoDB   servers across multiple environments. 
• Migrated large amount of data between mongo clusters using mongodump, mongorestore, mongoexport and mongoimport. 
• Worked on creating GridFS collections and loading GridFS data using Mongofile utilities. 
• Implemented CR Authentication, SHA-1 Authentication across different   MongoDB   versions. 
• Worked on restoring rollbacks when primary node is switching in replica set because of system failures. 
• Worked on cloud based Azure, AWS and on-prime environments. 
• Knowledge of Configuration Management tools (Puppet) in developing and experience with Performance Analysis and Troubleshooting in developing. 
• Worked on creating indexes on secondary nodes. 
• Implemented Tag depending upon the data requirement and balancing chunks in sharded cluster. 

Environment: MongoDB , Cassandra, MMS, Puppet, Linux/Unix, LVM Snapshots, Backup scheduler, Data guard, replication, python, shell scripting, Pearl, Java script.

Confidential, AL

Sr. MongoDB Consultant

Responsibilities:

• Extensive experience in deploying, managing and developing with   MongoDB   clusters. 
• Implementation of   MongoDB   security mechanism with various Authentications. 
• Having good experience in Migrating single Instance database to RAC Environment.
• Performed Capacity Planning, Undo segments and Health check reviews in RAC. 
• 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. 
• Worked on API server and maintained, written using Python Twisted and my own   MongoDB   driver. Handles data synchronization to millions of mobile devices from a single machine. 
• Scalable data design for   MongoDB   and Redis. Worked on pre-splitting mechanism using shard keys to distribute data across shards. 
• Point in time Backup and recovery in   MongoDB   using onsite MMS. 
• Familiar with   MongoDB   clusters, Java scripting to load unstructured data into sharding environment. 
• Migrated large amount of data between mongo clusters using mongodump, mongorestore, mongoexport and mongoimport. 
• Monitored 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 
• Created Partition's estimated stats on one partition1 and copied the stats to remaining partitions using dbms stats. 
• Performed CRUD operations like Update, Insert and Delete data in   MongoDB . 
• 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: MongoDB , Oracle 11g, SQL * Plus, RAC, RMAN, Shading, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential, VA

Sr. Database Developer

Responsibilities:

• Worked in all phases of SDLC process to implement this project. 
• Implemented Migration of Origenate Crystal Reports to Oracle Apex Reports. 
• Involved in   Database   Migration from DWH Production to ODH Environment (Operational Data Warehouse) 
• Participated in the   Database   Design having Data Model, ER Diagrams, and Process Flow Charts using Erwin Tool. 
• Coordinated with the front end design team to provide them with the necessary stored Procedures, Functions and Packages and the necessary insight into the data. 
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE. 
• Created Indexes on the tables for faster retrieval of the data to enhance   database   performance. 
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make   Database   Faster and easier to maintain. 
• Partitioned the fact tables and materialized views to enhance the performance. 
• Extensively used Bulk collection in PL/SQL objects for improving the performing. 
• Extensively involved in using Hints to direct the optimizer to choose an optimum query execution plan. 
• Created Materialized views and Materialized view log required for the application. 
• Implemented   Database   security with creating & revoking Roles and assigning appropriate roles and privileges to users. 
• Working with DBA's to analyze the AWR reports and tuning queries by using the SQL PROFILE and Automatic SQL Tuning. 
• Participated in exporting and importing data between the databases by using   Database   link.
• Additional rules for Standard Housing are developed and implemented as per the Client Requirements.

Environment: Oracle (SQL & PL/SQL), Cold Fusion, Oracle Application Express 

Confidential, Baltimore, VA

MongoDB Administrator

Responsibilities:

• Worked on troubleshooting and evaluating different NoSQL database systems and cluster configurations to ensure Redundancy, high-availability in different crash scenarios. 
• Implemented and managed multiple environments (up to 10TB), automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB  
• Responsible for Design, Architecture, and Capacity planning for   MongoDB /Cassandra clusters. 
• Assisted in managing MongoDB environment from Disaster Recovery, availability, performance and scalability perspectives. 
• Configuring high availability using geographical   MongoDB   replica sets across multiple data centers. 
• Played Key Role in implementing   MongoDB   write concern to avoid loss of data during node failures. 
• Played Key Role in Implemented read preferences in   MongoDB   replica set using tag sets. 
• Implemented setting Priorities for the nodes, delayed secondary's as per the Application Requirements. 
• Good knowledge in configuring Oplog size as per the mongo DB requirement. 
• Implemented MongoDB on physical machines, Virtual machines as well as AWS. 
• Implemented Time To Live Index, Capped Collections to wipe out aged data based on requirements.
• Good knowledge on MongoDB database concepts such as transaction, locking, transactions, indexes, Sharding, replication. 
• Used MongoDB third party tools (MONGOVUE, ROBO MONGO, MONGOOWL) and mongo-built in binaries to monitor and analyze the performance of   MONGODB . 
• Involved with creating shards, replica sets, monitoring, Backup and Restore 
• Migrated Mongo database from MMAPV1 storage engine to Wired Tiger storage engine. 
• Migrated Mongo database systems from No-SSL authentication to SSL authentication using certificates. 
• Backup & Recovery, Database optimization and Security maintenance. 
• Implementing on-premise MMS/OPS manager monitoring and backup solution. 
• Implemented various Indexes like single, compound and text on various collections to achieve better query performance. 
• Good experience in writing Ruby/Python scripts to monitor Mongo databases and perform ad-hoc backups using Mongo dump and Mongo restore. 
• Extensive knowledge in deploying, configuring, managing sharded MongoDB clusters.
• Good experience in choosing shard keys based on the application query pattern to the collections. 
• Good knowledge on working with Range based shard key, Hashed based shard key and Tag aware sharding. 
• Good knowledge on chunk migrations, splitting and balancing across the cluster. 
• Implemented pre-splitting mechanism using shard keys to distribute data across shards. 

Environment: MongoDB , Cassandra, Mongo Chef, MMS, Cloud Manager, OPS Manager Linux/Unix, Sharding, Replication, Gridfs, TTL, Storage engine, java scripting, Shell scripting, Microsoft Visio.

Confidential

Software Developer

Responsibilities:

• Contributed to the development of web interface for User module and Admin module using JSP, HTML, XML, CSS, Javascript, AJAX, and Action Servlets with Struts Framework. 
• Extensively worked on CORE   JAVA   (Collections of Generics and Templates, Interfaces for passing the data from GUI Layer to Business Layer). 
• Struts2.0 is the MVC framework and backbone of the application. Façade design patterns were extensively used for entity bean and session bean interaction. 
• Created User Interface in DOJO/AJAX and Struts2 tags for different customized screens for each type of user. 
• Created Javabeans for Clients search engine based on address, and user specific interest. 
• Created JSP/Servlets Pages for the search Engine related to product promotions and events. 
• Worked on providing enhancements to the system that involved designing the solution, development and requirements analysis, implementation. 
• Created JSP pages for each participant involved in the event. 
• Deployed the Application using Apache Tomcat Application server.
• Presented the application module to team members.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements.
• Created Materialized Views and partitioning tables for performance reasons. 
• Resolving the issues on priority basis. 
• Responsible for Analyzing and Implementing the Change Requests. 

Environment: Environment: Java, Eclipse, Struts 1.x, Tomcat, Web logic Server, Oracle 10g, PL/SQL, Toad, SQL *Plus, J2EE ( JAVA , JSP, Servlets, JDBC, EJB), JavaScript, Struts, Apache Tomcat, JBOSS, Swing, HTML/DHTML, XML, CVS,   SQL , Oracle, Eclipse IDE.