SUMMARY:

• Over 5+ years of IT Experience of including MongoDB and JAVA.
• Consult, make recommendations, and design and provide solutions related to the migration to MongoDB.
• Experience in Writing MongoDB Schema using Mongos.
• Good experience on MongoDB scaling across data centers and/or in - depth understanding of MongoDB, including replica sets. Schema using Mongos.
• Over 2+ years of experience in MongoDB (versions 2.x, 3.0.0 and 3.0.5) installation, configuration and administration
• Extensive experience sin designing MongoDB multi-shaded cluster and monitoring with MMS
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Expert in implementing advanced procedures like text analytics and processing using the in-memory computing capabilities like Apache Spark written in Scala
• Data Streaming using Apache Kafka and MongoDB
• Scalability benchmarking with MongoDB and NoSQL Database.
• Focused on architecting NoSQL databases like Mongo, Cassandra and Cache database .
• Designed and developed custom Mongo applications specific to Clients needs.
• Experience in Agile software development approach, a framework that delivers customer collaboration and interaction with processes and tools
• Proficiency in working with databases like MongoDB, Oracle 11gR2, MySQL.
• Proficiency in designing SOA architecture integrating several Middleware applications .
• Experience in upgrading database versions, migrating data across multiple databases and performed CRUD operations.
• Experience using AWS - Cloud Watch and created alerts for instances.
• Excellent team spirit and leadership qualities with good communication and interpersonal skills.
• Expert in analyzing the data along with designing data structures and data modeling.
• Proficiency in managing large shared MongoDB cluster.
• Expert in MongoDB installation/configuration, troubleshooting, performance, tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in-large and very dynamic environments.
• Experience on managing life cycle of MongoDB including sizing, automation, monitoring and tuning.
• Applied skills in software development, architecture, design, and support for new and existing products
• Experience with complex database and worked on controlled environments, change control, and validated systems.
• Experience with MongoDB Ops Manager for backup and query optimization.
• Expertise in managing the schemas, objects partitioning of tables and indexes.
• Experience in providing support for alerts from grid control and agents.

TECHNICAL SKILLS:

Databases: MongoDB, MS SQL Server, SQL Server Management Studio 2008, Oracle 11gR2

Programming Languages: JAVA, HTML, CSS,PHP and JSON

Development Tools: Eclipse IDE

Java/J2EE Technologies: Jsp, Servlets, EJB, JDBC

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

Virtual Machine: VM Ware Server, Oracle VM Virtual Box.

Databases Tools: RoboMongo, MongoDB Compass, NoSQL Manager and Mongo Booster, MongoDB Atlas, Elastic Search

Web Servers: WampServer and FileZilla, AWS

Testing: Selenium, Cucumber

I Report Tools: Jasper soft

Framework: Apache Scala, Apache Spark, Apache Kafka

Integration Tool: Maven

PROFESSIONAL EXPERIENCE:

Mongo DBA

Confidential, Phoenix, AZ

Roles & Responsibilities:

• Spherical geometry will appear distorted when visualized on a map due to the nature of projecting a three dimensional sphere, such as the earth, onto a flat plane.
• Collecting the entire information of the restaurants, users of the neighborhood.
• Importing the datasets into our database.
• Geographical data require 2dsphere, so create a 2d sphere index.
• Exploring the Data
• Inspect an entry into database.
• Create a document using JSON.
• Using geometry data for the location in GeoJSON
• Performing CRUD operations.
• Using users mobile information knowing the accurate location of user.
• Writing queries for find restaurants and users information.
• Documenting the data
• Storing the data using GridFS

Environment: JSON, Sharding, Replication, Aggregation, Profilers, PHP v5.5 and HTML coding, indexing, GeoJSon,2dsphere.

Mongo DBA

Confidential, Larose, LA

Role & 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.
• Architecture and Capacity planning for MongoDB/ Cassandra clusters
• Installation of MongoDB on physical machines, Virtual machines as well as AWS.
• Backup & Recovery, Database optimization and Security maintenance.
• 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.
• Utilized Kafka to capture and process real time and near-real time streaming data.
• Migrated Mongo database from MMAPV1 storage engine to WiredTiger storage engine.
• Managing Mongo databases using MMS monitoring tool.
• Performance tuning and stress-testing of NoSQL database environments in order 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.

Environment: MongoDB, Cassandra, Backup Scheduler, Sharding, Replication, Python, Shell scripting, Apache, PyMongo, Java Script

System Admin

Confidential, Malvern, PA

Roles & Responsibilities

• Effectively handled data modeling in MongoDB 3.0.
• Upgraded Mongo database server from MongoDB V2.6.11 to V3.0.
• Deployed Mongo Ops manager 1.8/1.6 and MongoDB Compass.
• 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 with MongoDB.
• Effectively architecture Mongo Ops manager 1.8 deployment in High Availability.
• Deployed and effectively handled replica sets and failover scenarios.
• Effectively handled Rolling Patch Upgrade for mongo 2.6.
• Handled MongoDB monitoring, performance tuning and troubleshooting tasks.
• Implemented minor level patch deployments for mongo 2.6.x.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Handled elastic search 1.7.2 deployment on MongoDB 3.0.Review conflict for CPU, memory, network or disk resources.
• Experience in handling the service requests with MongoDB Jira for resolving issues
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Performed multiple upgrades during the project to keep the database software stable and function without errors.
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
• Handled elastic search 1.7.2 deployment on MongoDB 3.0.
• Reviewed conflict for CPU, memory, network or disk resources.
• Experience in handling the service requests with MongoDB Jira for resolving issues.
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.

Environment: MongoDB V3.0/2.6.11, Mongo Ops Manager V1.8/1.6, MongoDB Compass v3.0, MongoDB Jira, Sharding, Replication, Aggregation, Profilers, PHP v5.5 and HTML coding,Elastic Search

Jr Database Engineer

Confidential, Hoboken, NJ

Roles & Responsibilities :

• Created and customized reports and dashboards.
• Provided 24/7 Remote/on-call production support.
• Created validation rules for performing data validations based on the user profile and their record type.
• Defined lookup and master-detail relationships on the objects.
• Designed a requirement website page containing Functional Requirements and Data requirements using PHP and HTML to run certain ad­hoc queries.
• Conducted a Plan and test migration strategy of the database frequently
• Migrated the data to the Oracle Database Appliance.
• Performed many Post-migration verifications and updates.

Environment: MS SQL Server 2008, Oracle 11g, PHP v5.4, HTML, Import/Export data sheets, Run SQL Queries, Migration Tools, MS Visio, FileZilla

System Admin

Confidential, Chattanooga, TN

Role & Responsibilities:

• Worked in a heavily sharded environment (120 shards). Client data is split into multiple shards effectively. Wrote a shell script to regularly audit schema configurations across shards. Also wrote scripts for pruning reporting tables across schemas .
• Setup different Percona clusters for various applications. Dealt with migration of native MySql nodes to percona cluster. Used RSU and TSI methods to perform schema changes on clusters
• Worked with application teams to release database changes to production systems .
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Effectively configured Replication
• 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.
• Documented all servers and databases.
• Database engineering is based on SDLC pattern. Involved all the steps like requirement analysis, Design, Development and Testing and then deployment.
• 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 5.6.2, Oracle10g, PHP MyAdmin, NDB Cluster, Web Services, Shell Script, Apache, LINUX

Database Admin

Confidential, Philadelphia, PA

Roles & Responsibilities :

• Provided 24x7 on call production support
• Supported developers and users, Monitored sysdba privileges, O.S authentication, passwords, privileges, register for security update using meta link, worked with sys admin to close unnecessary open ports, used secure protocol, used password to protect listeners also audit users log on/ log off created/ dropped objects and capturing the actual SQL statement that was issued rather than only the fact or the event occurred.
• Regular logs usage review.
• Regular Database Monitoring, using Grid Control (Oracle & MySQL).
• Review status of nightly Database and Application Server incremental backup reports. (Oracle &MYSQL) Work with system administrator on any issues.
• Verify database backups for exports and hot backup emails.
• Verify free space host availability on (backup/archive) directories.
• Monitored the database size and increased the size when required, analyzed the database tables and indexes and then rebuilt the indexes if were fragmentations in indexes.
• Checked completion results for any scheduled jobs, corns or data processing including refreshes.
• Reviewed daily invalid object reports for all databases.
• Verify and confirm applications, databases and application servers are operational and functioning normally by monitoring OEM, server processes, automated e-mails, etc.
• Created users, allocation of appropriate table space quotas with necessary privileges and roles for MySQL databases.
• Build Bitmap indexes and created materialized views for data warehouse project.
• Turned the Flash Recovery Area on to backup oracle databases from any logical corruptions (table, index) that making the backup faster.
• Responsibilities also, included removing row chaining for better performance deciding the naming conventions of data file, redo log file, table spaces and segments.

Environment: MySQL 5.5.6, PHP MyAdmin, PHP 4.x, 5.x, NDB Cluster, Web Services, Shell Script, Apache, LINUX.