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 with expertise in Partitioning, clustering, sharding, High availability and performance tuning
• Experience in supporting Cassandra and/or big data databases in a clustered environment
• Implemented large-scale data processing using Cassandra and Mongodb sizes over 100TB with 50+ nodes.
• 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 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
• Production level container infrastructure management experience with Cloud Foundry
• Monitor and optimize Mongodb database performance and capacity planning
• Installation of HP Vertica Cluster setup, upgrade & patching etc.
• 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, Alpharetta GA

Sr DBA

Responsibilities:

• Build Java tool for migration from Sql based table structure to Json format .
• 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
• Spining mongodb instabce in containers in Docker system
• Cluster setup for couchbase
• Configure Cassandra Cluster with Multi DC configuration.
• Installation of HP Vertica Cluster setup, upgrade & patching etc.
• PAAS using cloud foundary subsystem.
• 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.
• 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.
• 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).

Confidential, Newark CA

Sr DBA

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

Confidential, Sunnyvale, CA

Sr DBA/Cloud Openstack SE

Responsibilities:

• Installation and configuration of Mongodb database servers.
• Writing SQL queries, stored procedures and code review of SQL Code by developer
• Created documentations for Mongodb databases i.e. Backup & Recovery procedures
• Created Maintenance procedures, Performance Tuning procedures.
• Build Cassandra cluster rind with nodes in the Multi DC for High availability.
• Monitor and optimize Cassandra database performance and capacity planning.
• Collect data that introspects the performance of query and update operations on a mongod instance.
• Installed LAMP stack, and build PHP portal over apache.
• Monitor Replication for master /slaves configurations.
• Migration of Cassandra/Mongodb database from physical machines to openstack cloud.
• Build PHP portal to manage Mongodb database on openstack cloud.
• Automated Mongodb/Cassandra server build during the vm spin and joining it to the Nosql cluster.
• Writing of UNIX shell scripts to manage the health of database proactively.

Confidential, San Jose, CA

Oracle Apps DBA/Architect/Performance Tuner

Responsibilities:

• Responsible for installation of Oracle Applications R12/11i in single node &Multinode
• Perform Complex RAC setup with shared appl-tier application system
• Load testing the oracle application before the go live using Mercury Load runner
• Load Balancing Mid-Tier web servers with BigIP Load balancer with 4 nodes
• Load Balancing Concurrent Processing tier - PCP with 2 nodes
• Applying one-off fixes to Database Oracle Homes (both RAC and non-RAC) using Opatch utility
• Cloning Oracle Applications instances both R12 and 11i instances with RAC to RAC, Multi node
• Applying Rollup Patches R12.0.1, R12.0.2, R12.0.3.
• Developing Strategies for Oracle Application Upgrades from a lower version to higher version
• Frequent Upgrades of techstack components and applying one-off fixes to 10.1.2 and 10.1.3 Oracle
• Setting up resource manager with DBMS Scheduler
• Upgrading 11.5.10 environment to 11.5.10 CU2
• Setting up and monitoring the Data Guard for 10g Production servers.
• Applying patches using distributed AD
• Relinking applications executables

Confidential, Pleasanton, CA

Oracle Apps DBA/Architect/Performance Tuner

Responsibilities:

• Oracle Applications R12 MultipleNode installation in Sun Boxes.
• Tuning of Jservand Apache web server, forms server and architectural differences between technologies stacks of apps 11i. Actively participated in several mercury cloud tests for Network Efficiency.
• Load testing the oracle application before the go live using Mercury Load runner
• UpgradePatching of the R12 Instances
• TroubleshooterApache, Forms and CM service availability on daily basis
• Installed and configured the Load balancer for apps mid tiers
• Capacity planning of the Hardware sizing for CPU/RAM for Database tier and Mid tiers
• Setup monitoring through EM 10g Grid Control and Oracle Alerts
• Cloned and automated cloning/refresh process of test and development databases
• Applied RDBMS patches using Opatch
• Oracle Application Maintenance. The Maintenance includes patching, cloning
• Created the plans for the Application Stress testing
• Performance Tuning of Applications and database using AWR reports.

Confidential

Oracle Apps DBA Research

Responsibilities:

• Upgrade of the Oracle Application 10.7 to 11.5.9 for Manufacturing, Financials and Order Supply
• Upgrading Oracle Databases from 8i to 9i.
• Configuring the Apps on RAC with 2-node database.
• Installed and configured the Load balancer for apps mid tiers
• Cloning of Database and Applications using adclone, autoconfig and manual cloning.
• Used the Maintenance tools like adadmin, adpatch, adaimgr, admrgpch, adctrl
• Patch application to the production and non-production environment like Dev, SIT, UAT, and QA.
• 24X7 Production support when on Call.
• Database backup and recovery Using RAID /BCV (Time Finder) integrated with Third party tools.
• Trouble shoot day-to-day database and application problems.
• Analyzed the statspack report for the performance Tuning.
• Tuning for I/O Contention, Memory contention, Row Migration, Block Contentions, etc.