SUMMARY

• Overall 14+Years’ Experience in IT Industry as Database Administrator with specializing in data architecture and development using Oracle, MySQL, NoSQL, Big data Technologies.
• Technical Expertise in Database system architecture and design, modeling, development, data warehousing, decision support systems, web - based data solutions, Unix system administration, internet communications, user interface and ergonomics, multilingual application development, feasibility analysis (prototyping), application and query performance tuning.
• A team player and leader with excellent written and verbal communication skills and outstanding interpersonal skills.
• Over 5 years of NoSQL DBA experience in Mongodb/Cassandra/Couchbase/DynamoDB,Hive with expertise in Partitioning, clustering, sharding, High availability and performance tuning
• Experience with Cassandra data modeling and CQL scripting
• Experience in supporting Cassandra and/or big data databases in a clustered environment
• Experience in Administration of MongoDB databases throughout the development and production lifecycles.
• Building, Designing, and automating the MongoDB Architecture.
• Managing Hadoop ecosystem HDFS, Hive, Oozie and Solr
• Experience in deploy, monitor, back up and scale MongoDB using Ops Manager
• Experience in migrating Cassandra from AWS/Azure to on premise Openstack cluster
• Migration Experience from EC2 MongoDB to MongoDB Atlas
• Implemented large-scale data processing using Cassandra and Mongodb sizes over 100TB with 50+ nodes.
• Managing Kafka Streams Data using Nosql Databases .
• Setting up DynamoDB and DocumentDB for the data migration from mongodb
• Experience in migration from cloudant to DocumentDB
• Perform practices and considerations for the operations of MongoDB instances and deployments
• Full lifecycle of the Couchbase including sizing, deployment, monitoring and ongoing tuning.
• Cluster building for couchbase of more than 20 nodes holding 20 TB of data
• Document modeling for JSON based data store for couchbase/Mongodb
• Experience with Pearl, Bash and/or Java scripting
• Experience is Amazon RDS Postgres Databases
• Define and establish best practices with Cassandra, including configuration, monitoring health and backups of the cluster
• Experience with Amazon DynamoDB, manage user creation and
• Experience with cloud envoirnments like AWS and Openstack
• Experience in building Mongodb Sharded system with replica sets over Multi datacenter.
• Experience with Dockers and running Mongodb in Containers.
• JSON, document modeling using Mongodb/Couchbase
• Sound knowledge of Mongodb Indexing, Query performance tuning and optimizations
• Automation of tasks through Ansible
• Experience in using Using Grafana,promotheus,telegraf for monitoring Mongo Databases
• Production level container infrastructure management experience with Cloud Foundry
• Monitor and optimize Mongodb database performance and capacity planning
• Experience in Monitoring and optimizing database performance and capacity planning
• Experience in Tuning JVM using jconsole,jstat and Eclipse MAT
• Experience in setting up and configuring Backup and recovery procedures for databases.
• Knowledge of Hardware including RAID, Multiprocessor Architecture, Networking, Memory.
• Expertise in upgrading OS from RHEL 5 to 6 for SQL/NoSQLdatabases.
• Experience with Elastic Search/logstash and kibana .
• Setup puppet recipes for mysql/mongodb/
• Used Agile/Kanban system to manage the projects.
• Experience with creating portal in for OpenstackVM management using provisioned cluster.
• Performed Automation for VM configuration using Puppet/Chef
• Experience with Unix Shell Scripting for automating the DBA tasks.
• Good at intellectual knowledge base creation-documentation during the project implementation phase and maintenance phase
• Hard working, well in analytical and logical problem solving and excellent communication skills. Worked efficiently as an individual as well as in team environment
• Have given presentation and writtenwhite paper on Performance Tuning and Capacity planning in Oracle.

TECHNICAL SKILLS

Operating System: RHEL,Centos,Ubuntu,AIX,HPUX,Sun,MS Windows 2012,2008

RDBMS: Microsoft SQL Server 2012, Oracle 11g12c,, MySQL5.x,Postgres

NoSQL Technologies: Mongo DB 2.x/3.x,Cassandra1.x,2.x,Vertica7.x,Couchbase

Scripting Language: Shell,PHP,Python,PowerShell

Performance Tools: MySQL workbench/MySQL monitor,Oracle OEM,Datastax Opscenter, Jstat,Jconsole,Nagios, Percona Tool kit, Htop, NetHogs, iftop

Application Server: IIS7,Apache,Tomcat,Weblogic

Business Suite: Oracle ERP11i/R12

Office Suite: Microsoft Office, MS VISIO.MS Projects

PROFESSIONAL EXPERIENCE

Confidential

Sr DBA Remote

Responsibilities:

• Install, configure, and maintain Apache Cassandra database clusters
• Administration of MongoDB databases throughout the development and production lifecycles.
• Building,Designing, and automating the MongoDB Architecture.
• Migrate Cassandra from Azure to Openstack inpermise
• Migration from CLoudant to DocumentDB AWS .
• Data modelling for the DocumentDB .
• Setup DynamoDB AWS and manage the performance for it .
• Manage Time Series Data using Dynamo DB
• Setting up DynomoDB AWS .
• Manage Cassandra database using opscenter.
• Added/bootstrap and Removed/replace nodes to clusters.
• Monitor and optimize Cassandra database performance and capacity planning.
• Setting Cassandra varied parameters like per compactions, cache, bloomfilter.
• Deployment of MongoDB database using ansible including backup and monitoring setup
• Managing Kafka Streams Data using Nosql Databases .
• Health Check of MongoDB Database, Setup Replica set and Sharding environment
• Monitoring of Various issues related with Database, Monitoring at Server, Database, Collection Level
• Migrated MongoDB from EC2 to Mongodb Atlas
• Using Monitoring Tools related to MongoDB, Database Profiling, Locks, Memory Usage, No of connections
• Backup and Recovery for MongoDB
• Working with developers of database designing.
• Managing Hadoop ecosystem HDFS,Hive, Oozie and Solr
• Database software Installation and Configuration
• Database Migrations and Upgrade Server Performance tuning and Recommendations
• Root cause analysis
• Setup databases on the cloud env AWS and openstack
• Export and Import of Data to and From MongoDB, Run time configuration of MongoDB, Data Managements in MongoDB Hands on Administrative Tasks.
• Multi DC Cluster setup for MongoDb
• Using Grafana,promotheus,telegraf for monitoing Mongo Databases
• Configure Cassandra Cluster with Multi DC configuration.
• Writing shell scripts using Experience with Pearl, Bash and/or Java scripting
• Backup and restore of MongoDB databases using LVM snapshots and Ops Manager backups

Confidential

Sr DBA Remote

Responsibilities:

• Build NoSQL system heavy write intensive applications using Mongo/Cassandra
• Implemented Mongodb Indexing, Query performance tuning and optimizations
• Deploy, monitor, back up and scale MongoDB using Ops Manager
• Configuring Nagios for OS and Database health monitoring.
• Configure Cassandra Cluster with Multi DC configuration.
• Migration of Oracle/MySQL databases to Cassandra/mongodb.
• Using Monitoring Tools related to MongoDB, Database Profiling, Locks, Memory Usage, No of connections
• Configuring replica set and sharding for mongo databases
• Database software Installation and Configuration
• Database Migrations and Upgrade Server Performance tuning and Recommendations
• Root cause analysis
• Export and Import of Data to and From MongoDB, Run time configuration of MongoDB, Data Managements in MongoDB Hands on Administrative Tasks.
• Multi DC Cluster setup for MongoDb
• Using Grafana,promotheus,telegraf for monitoing Mongo Databases
• Configure Cassandra Cluster with Multi DC configuration.
• Writing shell scripts using Experience with Pearl, Bash and/or Java scripting
• Backup and restore of MongoDB databases using LVM snapshots and Ops Manager backups

Confidential

Sr DBA Alpharetta GA

Responsibilities:

• Build Java tool for migration from Sql based table structure to Json format .
• Build NoSQL system heavy write intensive applications using Mongo/Cassandra on AWS
• JSON, document modeling using Couchbase
• Using ops manager for monitoring Mongo DB
• Full lifecycle of the Couchbase including sizing, deployment, monitoring and ongoing tuning.
• Writing and Tuning N1QL queries
• Spining mongodb instabce in containers in Docker system
• Cluster setup for couchbase
• Installation of HP Vertica Cluster setup, upgrade & patching etc.
• PAAS using cloud foundary subsystem.
• Configuring replica set and sharding for mongo databases
• Set the procedure of restoring a replica set from an archived backup such as a mongodump or MMS Backup file.
• Automating backups using python scripting.
• Fine tuning JVM using jconsole, jstat and Eclipse MAT
• Setup sharded system with replica sets over muti DC configuration.
• Implemented Mongodb Indexing, Query performance tuning and optimizations
• Configuring Nagios for OS and Database health monitoring.
• Supported Mutimaster/master slave configuration for MySQL databases.
• Troubleshooting issues raised by the users and technical team during the entire upgrade project
• Scheduling and monitoring backups using CommVault.
• Performed various troubleshooting tasks (ex. Latency Analysis, Thread state Analysis, etc.)
• Create and maintain EC2 Instance on AWS (small, medium, large and xlarge).

Confidential

Sr DBA Newark CA

Responsibilities:

• Build NoSQL system heavy write intensive applications using Mongo/Cassandra
• JSON, document modeling using Couchbase
• Full lifecycle of the Couchbase including sizing, deployment, monitoring and ongoing tuning.
• Writing and Tuning N1QL queries
• Cluster setup for couchbase
• Configure Cassandra Cluster with Multi DC configuration.
• Manage Cassandra database using opscenter.
• Added/bootstrap and Removed/replace nodes to clusters.
• Monitor and optimize Cassandra database performance and capacity planning.
• Setting Cassandra varied parameters like per compactions, cache, bloomfilter.
• Configuring replica set and sharding for mongo databases
• Set the procedure of restoring a replica set from an archived backup such as a mongodump or MMS Backup file.
• Fine tuning JVM using jconsole, jstat and Eclipse MAT
• Setup sharded system with replica sets over muti DC configuration.
• Implemented Mongodb Indexing, Query performance tuning and optimizations
• Configuring Nagios for OS and Database health monitoring.
• Migration of Oracle/MySQL databases to Cassandra/mongodb.
• Supported Mutimaster/master slave configuration for MySQL databases.
• Troubleshooting issues raised by the users and technical team during the entire upgrade project
• Scheduling and monitoring backups using CommVault.
• Performed various troubleshooting tasks (ex. Latency Analysis, Thread state Analysis, etc.)
• Create and maintain EC2 Instance on AWS (small, medium, large and xlarge).