PROFESSIONAL SUMMARY:

• Over 8+ years of experience in IT industry as an Cassandra DBA and MongoDB DBA working for various organizations.
• Having over 5+ years of DBA experience in MongoDB, Apache Cassandra & Datastax Enterprise edition installation, configuration, backup configuration, upgrade, node tool commands, bootstrapping, performance tuning, decommissioning, migration etc.
• Over 3 years of experience on Oracle 10g/11g, 12c database planning, installation, upgrade and migrations, performance tuning, backup, recovery, security provisioning, data guard, golden gate etc. on production, staging, development environments, understanding ITIL guidelines.
• Good noledge on tools like CHEF, Kafka, Apache Spark etc.
• Good experience in Designing, Planning, Administering, Installation, Configuring, Troubleshooting, Performance monitoring of Cassandra Cluster.
• Involved in designing various stages of migrating data from RDBMS to Cassandra.
• Used Datastax OpsCenter and Node tool utilities to monitor teh cluster.
• Have Knowledge on Apache Spark wif Cassandra.
• Experience of doing Casandra upgrades to Major & latest versions.
• Expertise in AWS, experience in implementing new AWS EC2 instances and working wif EBS and S3 storage, NLB s, Designing AWS EC2 Security Groups, IAM roles
• Managed Amazon Web Services like EC2, S3 bucket, RDS, EBS, ELB, Auto - Scaling, AMI, IAM through AWS Console and API Integration wif Puppet Code
• Experience in Installation, Configuration and Maintenance of Oracle 12c,11g/10gRAC wif ASM and single instance database.
• Back-end programming, database Triggers, stored procedures and functions using PL/SQL.
• Good noledge on Hadoop Architecture and Hadoop echo system.
• In depth noledge on integrating Cassandra wif Hadoop.
• Good noledge on Spark SQL, Spark Streaming and Scala.

TECHNICAL SKILLS:

Programming Languages: Java, C, C++, PL/SQL, Scala

Web Technologies: HTML, HTML5, CSS, XML, JavaScript, PHP, Joomla

Relational Databases: SQL Server, MySQL, Oracle 9i,10g, DB2 LUW 9.7/10.5

Scripting: Shell Scripting, Python basics, Ansible

Cloud Technologies: AWS, Google Cloud.

Tools & IDEs: Visual Studio, Eclipse, Rational Rose, MySQL Workbench, Net Beans, Visual Basic, OpsCenter, DevCenter, CloudWatch

Operating System: AIX, Sun Solaris, RedHat Linux, CentOS and Windows

Ticketing tools: JIRA, BMC Remedy, Apple tools like Radar and central station for ticketing tools

Agile tools: VersionOne

PROFESSIONAL EXPERIENCE

DevOps and Database Engineer

Confidential

Responsibilities:

• Design, implement and improve analytic solutions for Confidential databases on-prem and AWS Cloud
• Capacity planning of Cassandra cluster Design, Build and deploying Cassandra clusters in various environments Cassandra data modelling Support and manage Cassandra clusters Configuring backup / restore utilities and developing disaster recovery policies and procedures.
• Involved in building databases and supporting more that 35+ NonProd environments from on-prem to AWS cloud and two Production environments in AWS cloud and also stage environments.
• Movement of data from other databases to Cassandra, write and maintain scripts in support of database maintenance to ensure consistent performance.
• Coordinate wif other IS&T support groups like DevOps, System Engineers and Site Operations team to maintain teh overall application health and security, also doing miscellaneous housekeeping activities.
• Designed AWS EC2 Security Groups for Databases to control teh limited restricted connectivity’s to databases like (Cassandra, Couchbase, Mongo, Oracle, AuroraPostgres and AWS Elasticsearch)
• Hands-on experience writing ansible playbooks for multiple requirements like setting up Cassandra, MongoDB, Oracle-client and Postgres setup on a AWS EC2 instances
• One of teh code-owner for databases github repository for code maintenance related to databases infrastructure which can build AWS resources using CloudFormation on Cloud
• Keep production database servers operational wif adequate failover, backup, and recovery plans.
• Setup NoSQL databases like Mongo, Cassandra & Couchbase along wif teh multi Datacenter data replication strategy as per teh requirements from business.
• Non-Production and Production Oracle and NoSQL (Mongo, Couchbase & Cassandra) Database health checks and corrective actions using monitoring tools like AWS CloudWatch, Cassandra OpsCenter and Apple Internal tools
• Information Security and Vulnerability Management - Implying teh necessary changes for teh security threats at teh database level to maintain teh necessary compliance.
• Assess teh usage of Amazon Web Service (AWS) that makes it easy to set up, operate, and scale relational & NoSQL databases in teh cloud for AOS database systems.
• Perform Proof Of Concepts (POC) on new database technologies like Flyway Database sql Deployments Automation, MySQL & Postgres to assess their performance and usability at Apple Online Stores (AOS).
• Automate teh SQL deployment to databases using Ansible and Flyway+Docker images for deployment.
• Worked on AWS migration projects from ADC to AWS cloud, successfully migrated many of teh Non Prod environments from Apple DC to AWS cloud.
• Implemented writing CloudFormation templates to create NoSQL & Oracle-client, Cron jobs EC2 instances for connectivity to databases.
• Managed custom role access to AWS environments and fixing bugs for implementing custom roles using Role-Based Access Control (RBAC).
• RBAC policy implementation and troubleshooting, Automation enhancements, Artifactory on boarding, AWS Tools for resource management, Infrastructure Support for AWS DB stack.

Confidential, Chicago, IL

Cassandra Consultant

Responsibilities:

• Big Data Consultant Apache Cassandra 2.1, 3.0 and DSE 4.8.7/5.0, MongoDB 2.4/6, 3.0. Linux (RHEL, CentOS) in Online Business Unit(OBU) group supporting databases and infrastructure for highly transactional Sears.com, Kmart.com and Mygofer.com websites and OBU reporting data warehouse databases.
• Responsible for availability and performance of online databases (Sears.com, Kmart.com and Mygofer.com).
• Created 30 node Cassandra cluster for online checkout using Cassandra DSE - 5.0.11.
• Involved in designing Cassandra data model for cart and checkout flow.
• Moved cart data from DB2 to Cassandra.
• Developed Puppet modules and Ansible playbooks for cluster installs and cluster upgrades.
• Forwarded teh Cassandra system logs and gc logs to Splunk and configured teh dashboards and alerts for Cassandra on it.
• EC2, EBS, RDS managing on cloud in AWS using ansible managing and configuration tools by installing teh workstations, writing teh playbooks and upload them to teh server of teh ansible.
• Implemented DSE SOLR solution to push incremental orders data into centralized Hadoop cluster.
• Good hands on experience wif Solr on TEMPeffective and extensive search on teh Cassandra Database cluster built on DataStax using teh dynamic fields and Faceting.
• Created 48 node Cassandra cluster for Single Point Inventory application in Apache 1.2.5.
• Upgraded Single Point Inventory(SPI) 48 node cluster from Apache 1.2.5 to DSE-5.0.11.
• Upgraded mobile checkout(UC) cluster from Apache Cassandra 1.1 to DSE 5.0.11.
• Implemented dual data center setup for all Cassandra cluster.
• Worked wif Operations Team on specific Puppet manifests for application installations and related config files.
• Used Puppet to Implement Automated Application Deployment.
• Implemented Snapshot backups for all Cassandra clusters.
• Implemented Datastax Hadoop solution to integrate promotional data wif enterprise Hadoop cluster.
• Implemented Spark solution to enable real time reports from Cassandra data.
• Implemented a distributed messaging queue to integrate wif Cassandra using Apache Kafka.
• Created Mongo cluster wif 4 shards and 3 replica sets for GameOn and GreenDB projects.
• Involved in data modelling for IAS and UC Cassandra Clusters.
• Perform capacity planning related activities on database storage and performance.
• Provide support for Cassandra/MongoDB and DB2 LUW databases in OBU.
• Verifiable record for achievement of Exceeding Expectations, as a Database Administrator.

Confidential, Austin, TX

Big Data Administrator

Responsibilities:

• Big Data Administrator in Digital Team to Support Cassandra databases used in various Card Applications.
• Involved in capacity planning and requirements gathering for multi datacenter Cassandra cluster
• Involved in teh process of designing Cassandra Architecture.
• Involved in NoSQL database design and implementation.
• Installed, Configured, Tested Datastax Enterprise Cassandra multi - node cluster.
• Involved in database deployments, capacity planning, monitoring multi datacenters, performance tuning, and troubleshooting.
• Worked wif users for any kind of issues they are facing in teh database.
• Involved in data migration from Oracle to Cassandra.
• Used Jenkins as a continuous integration tool for configuring to build and deploy automatically of daily process
• Hands on experience in configuring, adding new (bootstrapping), removing, upgrading and decommissioning Cassandra nodes/data centers.
• Performed backup and recovery on Cassandra nodes..
• Performed cleanup operations on Cassandra nodes.
• Performed Cassandra Cluster Rolling upgrades.
• Hands on experience wif Node tool utility to manage a cluster.
• Developed continuous delivery product release pipelines using Jenkins, and enable release and operations automation using Ansible.
• Used Jenkins as a continuous integration tool for configuring to build and deploy automatically of daily process
• Performed bulk data loading into Cassandra using SSTableLoader.
• Configured SSL encryption for inflight traffic, communication between Cassandra nodes and client.
• Used Github version control for storing infrastructure scripts.
• Scheduled repair and cleanup process in production environment
• Provided teh support to IBM DB2 and Oracle databases.

Confidential

Database Administrator

Responsibilities:

• Database Administrator IBM DB2 - LUW, Oracle on AIX) in Database Management Support Services group for Investment and Capital Markets (ICM) Applications
• Managing multiple Production and Development DB2 LUW Applications environments of different releases.
• Database server Installation, Database Creation, Maintenance, Backup, Recovery & Performance Tuning
• Migration of UDB database from 9.5 to 9.7.
• Migration of Oracle databases from 9.2.0.7 to 10g(10.1.0.4)
• Involved in creating logical data models for various applications using Erwin.
• Converted logical models into physical models.
• Implementation of high availability and disaster recovery of databases through DB2 HADR in production environment
• Developing shell scripts for database monitoring and maintenance.
• Research and resolve database issues.
• Design and implement required processes to ensure ongoing Audit/SOX compliance for databases.
• Performing certifications for new RDBMS features and new versions.
• Verifiable record for achievement of Exceeding Expectations, as a Database Administrator.