SUMMARY:

• Over 6 years of experience in NoSQL Database Administration and RDBMS. Involved in migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, NoSQL, Amazon web services, troubleshooting and documentation.
• Over 4 years’ experience in MongoDB installation, configuration, administration and upgrading.
• Over 3 years’ experience in Cassandra Architecture, Cassandra data modelling & Monitoring Cassandra using Opscenter.
• Experience in designing MongoDB multi - sharded cluster and monitoring with MMS.
• Experience in upgrading and migrating various versions of Mongo database on different platforms.
• Focused on designing NoSQL databases like MongoDB, Document DB and Cassandra database.
• Knowledge on Couchbase, DynamoDB.
• Designed and developed custom Mongo applications specific to clients' needs.
• Experience in Agile software development, a framework that delivers customer collaboration and interaction with processes and tools.
• Extensive experience with Python in Linux, UNIX and Windows environments.
• Full life cycle experience in highly secure, extremely large-scale deployments of very high volumes of critical data with extensive security.
• Extensive knowledge of Web development, from concept through implementation and optimization.
• Experience in various phases of SDLC such as requirements gathering, analysis, design, implementation, maintenance of software applications and testing Client/Server and web applications.
• Responsible for most of the view/controller changes, model/database integration with other members of the team.
• Applied skills in software development, architecture, design, and support for new and existing products. Experience working in both Agile and Waterfall development environments.
• Fast learner, can quickly in corporate and implement new procedures with efficiency and accuracy.
• Skilled in troubleshooting with good organizational and interpersonal skills.
• Team player with excellent communication skills and ability to lead. Self-motivated individual with exemplary analytical and problem-solving skills.
• Exceptional ability to collaborate with team members for code and design reviews. Self-motivated worker with strong focus on business goals and end-user experience.
• Excellent knowledge on CQL (Cassandra Query Language), for retrieving the data present in Cassandra cluster by running queries in CQL.
• Involved in designing various stages of migrating data from RDBMS to Cassandra, Mongo DB.
• Commendable knowledge on read and write processes, including SSTables, MemTables and Commitlog.
• Experience with querying on data present in Cassandra cluster using CQL (Cassandra Query Language)
• Used Datastax OpsCenter and Node tool utilities to monitor the Cassandra cluster.
• Having working knowledge with multiple Data centers set up.
• Experience in efficiently managing backup and restoring data in live Cassandra Cluster.
• Experience in benchmarking Cassandra Cluster using Cassandra stress tool.
• Tested the application and the cluster with different consistency levels to check for the writes and reads performance with respective to Consistency Level.
• Can handle commissioning and decommissioning nodes along with monitoring of Cassandra Cluster.
• Have Knowledge on Apache Spark with Cassandra.
• Creates Linux Virtual Machines using VMware Virtual Center.
• Experience of doing Casandra upgrades to Major & latest versions.
• Designed framework for doing migration from RDBMS to Cassandra
• Involved in doing fine-tuning for HEAP, GC, THP settings in Cassandra nodes.
• Expertise in AWS, experience in implementing new AWS EC2 instances and working with EBS and S3 storage.
• Managed Amazon Web Services like EC2, S3 bucket, RDS, EBS, ELB, Auto-Scaling, AMI, IAM through AWS Console and API Integration with Puppet Code
• Experience in Installation, Configuration and Maintenance of Oracle 12c, 11g/10gRAC with ASM and single instance database.
• 24*7 Production Database Support to ensure availability, efficiency and recoverability.

TECHNICAL SKILLS:

Database Technologies: Mongo DB, Document DB, Cassandra DB, Dynamo DB, Oracle.

Amazon Web Services: EC2, S3, ELB, Auto scaling, Cloud Front, Cloud Formation, RDS, Cloud watch. Cloud trail, IAM, SNS, Redshift.

Server Automation Tools: Ansible, Chef.

Security: Kerberos, LDAP.

Languages: CQL, SQL, PL/SQL, Shell Scripting, Python.

Operating Systems: Linux (Red Hat, CentOS, Ubuntu), windows.

Version control Tools:: Git, GitHub and SVN.

WORK EXPERIENCE:

Confidential, St. Louis, MO

Mongo Database Admin Advisor

Responsibilities:

• Working closely with customers to get new projects to MongoDB.
• Discussing with customers about the use cases of database and suggesting them the right hardware.
• Building MongoDB clusters (Standalone/Replica sets /Sharding clusters) depending on the requirements.
• Automated the built process using python scripts and installed Mongo manually.
• Worked on MongoDB 3.2.x-ent, 3.4.x-ent, 3.6.0-ent, 4.0.x-ent, 4.2.0-ent versions.
• Upgraded MongoDB versions manually and using ops manager.
• Encrypted clusters with SSL and also authenticated with LDAP
• Experience working on Venafi tool to download SSL certificates.
• Deployed Automation, Monitoring and Backup agents on Linux machines.
• Enabled backup’s in ops manager to take snapshots.
• Experience on performing snapshot, point-in-time and queryable restores on request by application teams.
• Managed around 450 on premise RHEL machines and around 70 ec2-instances.
• Built ops manager application on both production and non-prod environments from scratch.
• Experience on enabling load balancer on Mongo Ops manager on premise and on AWS.
• Experience on creating Databases, Users, Collections, Views, and Indexes.
• Experience on performance tuning, query tuning.
• Closely works with application teams on query, performance tuning.
• Working on AWS, spinning ec2-instances using CFT’s, creating S3 buckets, security groups, EBS volumes.
• Closely works with Application teams, Cloud ops team, Network team, Firewall team, Linux team, security team, Splunk team, Imperva team to resolve issues/blockers.
• Worked on installation and configuring of Splunk forwarder and on-boarded MongoDB logs to Splunk. Created Splunk dashboards and delivered to application teams to view logs and other metrics.
• Worked on Imperva installations on ec2-instances for the DAM monitoring.
• Worked on Document DB installations using AWS CLI.
• Configured document db to send logs to cloud watch by enabling audit logs, profiler logs.
• Worked on exporting audit logs to s3 bucket.
• Migrated RDBMS to NoSQL Databases.
• Migrated Data from On premise MongoDB to Mongo on AWS.
• Closely works with application teams to resolve issues, support production deployments.
• Provided 24x7 on-call support.

Environment: MongoDB, Document DB, AWS, Python, Splunk, Imperva, Venafi, LDAP.

Confidential, Deerfield, FL

Mongo DBA

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. Implementing on premise MMS monitoring and backup solution.
• Used MongoDB third party tools (ROBO MONGO, MONGOOWL, MONGOVUE, MONGO COMPASS) and mongo-built in binaries to monitor and analyze the performance of MONGODB.
• 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.
• Design architecture of MongoDB multiple versions 4.0.x, 3.6.x and 3.2.x Replica sets, Sharded cluster. created Ad hoc reports by querying multiple collections with $lookup operator
• Have written various aggregation pipelines ($group, $project, $sort, $match, $limit and $skip) and created views based on the different business requirements
• Experience in managing MongoDB environment from availability, performance and scalability perspectives.
• Configuring high availability using geographical MongoDB replica 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 Wired Tiger storage engine.
• Managing Mongo databases using MMS monitoring tool.
• Worked on multiple BSON type objects and used based on requirement.
• Implemented multiple CRUD operations and familiar with new enhancements in each release.
• Supported Bulk Write operation jobs, analyzing the queries, and performs tuning based on environment.
• Wrote services to store and retrieve user data from the MongoDB for the application on devices.
• Performance tuning and stress testing of NoSQL database environments 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.
• Developed Ruby/Python scripts to monitor health of Mongo databases and perform ad-hoc backups using Mongo dump and Mongo restore.
• Worked with capped collections to wipe out aged data based on requirements.
• Administered multiple environments, automating backups and checks, restore, validation/integrity checks, growth modeling and predictions, and system expansion; assisted with upgrade efforts with MongoDB
• Worked on creating distinct types of indexes on different collections to get reliable performance in Mongo database.
• Familiar with MongoDB write concern to avoid loss of data during system failures.
• Implemented read preferences in MongoDB replica 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.
• Skilled in troubleshooting with good organizational and interpersonal skills.

Environment: MongoDB, MMS, OPS, mtools, Robomongo, BSON, JSON, Aggregation, Arbiter, Balancer, RPM, tar files, Mongo Shell, MMAP v1, wiredtiger, Snapshot, Sharding, Replication, Shell scripting, JavaScript, Perl script .

Confidential, Rockville, MD

Cassandra Consultant

Responsibilities:

• Involved in capacity planning and requirements gathering for multi datacenter Cassandra cluster
• Involved in the process of designing Cassandra Architecture.
• Involved in NoSQL database design, integration and implementation.
• Installed, Configured, Tested Datastax Enterprise Cassandra multi-node cluster that has 4 Datacenters and 5 nodes each.
• Installed and configured Cassandra cluster and CQL on the cluster.
• Involved in the process of data mover for disaster recovery platforms Backup and recovery.
• Involved in database deployments, capacity planning, monitoring multi datacenters, performance tuning, and troubleshooting.
• Knowledge on set up Cassandra wide monitoring scripts and alerting system.
• Knowledge on bootstrapping, removing, replicating the nodes in Cassandra and Solr clusters.
• Experienced in upgrading the existing Cassandra cluster to latest releases.
• Migrated large amount of data from Oracle to Cassandra
• Migrating oracle data model to Cassandra to achieve and reduce the SLA from 10 minutes to 2 seconds and also improve user experience by using kafka and cassandra.
• Designed, Automated the process of installation and configuration of secure DataStax Enterprise Cassandra cluster using puppet.
• Performed regular maintenance activities like Patching, User Maintenance, Database Refresh and Disaster Recovery tasks in Oracle as of when required.
• Bulk-loaded the data into Cassandra using sstableloader tool and read the data using sstable2json tool.
• Experienced in provisioning and managing multi-datacenter Cassandra cluster on public cloud environment Amazon Web Services (AWS) - EC2.
• Imported data from various resources to the Cassandra cluster using Java APIs.
• Strong understanding of internal processes of NoSQL approach.
• Optimized the Cassandra cluster by making changes in Cassandra properties and Linux (Red Hat) OS configurations.
• Working closely with Datastax to resolve issues on cluster using ticketing mechanism.
• Configured Performance Tuning and Monitoring for Cassandra Read and Write processes for fast I/O operations and low latency time.
• Performed Stress and Performance testing to benchmark the cluster
• Administered Cassandra cluster using Datastax OpsCenter and monitored CPU usage, memory usage and health of nodes in the cluster.
• Configured accordingly to achieve maximum throughput and execution time based on the benchmarking results.
• Configured, Documented and Demonstrated inter node communication between Cassandra nodes and client using SSL encryption
• Experienced in storing the analyzed results into the Cassandra cluster.
• Used Github version control for tagging the new versions.
• Involved in the Migration of data from one database to another database.
• Knowledge on applying updates and maintenance patches for the existing clusters
• Scheduled repair and cleanup process in production environment

Environment: Cassandra 2.1, Oracle 11g, DevCenter, Cqlsh, OpsCenter, Node tool, UNIX, Cassandra-stress, Shell Scripting, GitHub, Maven, Solr, Shell Scripts, Sqoop, Spark, SQL, NoSQL, CQL, AWS.

Confidential

Oracle Database Administrator

Responsibilities:

• Design, Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure / Cluster ware, Oracle 11g two node RAC for the database tier.
• Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions & data dictionary corruptions
• Patching & upgrades on Oracle 11g database (whilst minimizing or eliminating the impact to Live services, i.e. using rolling node patching)
• Cassandra database physical layout design and capacity planning
• Have involved in the process of upgrading, Adding & removing nodes also, have collected production metrics by using SPLUNK tool
• Worked with logical backup using Data pump and Exports/Imports Utility
• Database Load and Transformation Techniques (SQL Loader, External Tables)
• Upgraded production and all test database
• Execute the collection of requirements, product comparisons, product research, and architecture
• Performed data migrations using ETL tools.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Data guard.
• Support Production, QA, DEV, UAT databases.
• Experience in programming with Perl, Unix/Linux shell scripting, Oracle PL/SQL.
• Configured and Monitored of databases using OEM 12c Grid Control
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration ETL tools
• Replication and Extracting data and applying on production using Golden Gate and Shareplex.
• Identify training needs within support organization and proactively create and deliver training sessions to address these requirements.
• Configuration of Oracle Standby Databases (Active Data Guard) for high availability/Disaster Recovery Solution from Production Server to the DR Server
• Experience on Oracle Shareplex for data replication for enterprise data centers including installation, configuration, administration, performance monitoring.
• Creating documentation during project planning, project execution and project maintenance phases.

Environment: Oracle RAC Database 12c, 11g, 10g, SQL, NoSQL, AIX, Solaris11, RE Linux 6, MYSQL, Windows.