SUMMARY

• 8+ years of IT experience with 4+ years of intensive experience in Distributed, Columnar database, Apache Cassandra/ DSE Cassandra Data Modelling/Administration.
• Experience in data modelling and analyzing and accommodating all the use cases based on the business requirement.
• In depth knowledge of Cassandra architecture.
• Data modelling, making use of materialized views, a new feature in Cassandra to accommodate all the use cases and reduce the application side code in syncing the data.
• Also, modelling based on best practices like partition per query by de - normalizing the data for good performance of the cluster based on the use cases.
• Hands on experience with installing, configuring and monitoring DataStax Enterprise/ Apache Cassandra cluster.
• Detailed understanding of read, write and delete processes.
• Experience in choosing consistency levels and replication factor based on the type of data being saved in the database.
• Strong knowledge in Distributed Systems and Client/ Server Architecture.
• Hands on Experience in working with the Cassandra Query Language (CQL) for querying the data present in the Cassandra keyspace.
• Hands on experience with benchmarking and load testing Cassandra-stress tool.
• Expertise in performing YAML based stress testing using Cassandra- stress tool.
• Proficient in managing and monitoring Cluster using DataStax OpsCenter to ensure the databases are running well.
• Collaborated with Developers and Analyst on all aspects of data management like compaction strategies, consistency levels, and replication factors.
• In detail understanding of Cassandra cluster topology.
• Good knowledge on Internode communications (gossip protocol) and Snitch protocol.
• Experience in configuring Cassandra cluster with multiple datacenters
• Experience with Java based DataStax driver to connect, load and retrieve data from the Cassandra cluster.
• Proficient in choosing different compaction strategies: Size Tiered, Leveled or Date Tiered compaction strategies to Consolidate SSTables, and remove tombstones based on the use case.
• In detail knowledge of Memtable, SStable, CommitLog and Flushing.
• Involved in planning different stages of migrating data from RDBMS to Cassandra.
• Experience in bootstrapping, repairing and decommissioning the nodes.
• Hands on experience using DataStax DevCenter to create and run Cassandra Query Language (CQL) statements on Cassandra cluster.
• Extensive experience as a Linux (Red Hat Enterprise Linux Advanced Server, CentOS) System Administrator.
• Hands-on experience in provisioning and managing multi-datacenter Cassandra cluster on public cloud environment - Amazon Web Services - EC2.

TECHNICAL SKILLS

NoSQL Databases: DataStax Enterprise

Cluster Management Tools: OpsCenter, JMeter, JConsole, Kafka Manager, Cassandra-Stress tool

Server Automation Tools: Chef

Relational Databases: Oracle

Hadoop Ecosystems: HDFS, MapReduce, Hive, Pig

Security: Kerberos

Languages: Core Java, HTML, CSS

Operating Systems: Linux (Red Hat, CentOS, Ubuntu), Windows

IDE: Eclipse, STS

PROFESSIONAL EXPERIENCE

Cassandra Consultant

Confidential, Atlanta, GA

Responsibilities:

• Developed Cassandra data model to match existing business model which was in relational model.
• Analyzed the existing relational data model, EDB procedures and implemented the Cassandra Data model.
• Figured all the query patterns and designed the data model to accommodate the use cases.
• Used Cassandra materialized views feature in data modelling and accommodated all the use cases with minimal number of tables.
• Involved in planning, designing and implementing the multi data center DSE Cassandra cluster.
• Installed DataStax Enterprise 5.0 in Multi datacenter environment.
• Installed and administered all environments: Dev, SIT, JIT, UAT and production clusters.
• Collaborated with developers, testers to make them understand the architecture and query patterns in Cassandra.
• Tuned JVM Parameters depending on use case and performance test results.
• Implemented two data models, one for customer-vehicle-device current status (Read Intensive) and another for transactional (Write Intensive) use cases.
• Configured Performance Tuning and Monitoring for Cassandra Read and Write processes for fast I/O operations and low latency time
• Worked in an Agile Methodology.

Tools: Datastax Enterprise 5.0, Cassandra 3.0, OpsCenter 6.0, Cassandra-stress tool, DevCenter, Issuetrak, confluence, JIRA, Jenkins

Cassandra Consultant

Confidential, Bentonville, AR

Responsibilities:

• Involved in planning, designing, and implementing multi-rack Cassandra cluster.
• Developed Cassandra data model to match the business requirements.
• Monitored and administered Cassandra clusters using DataStax OpsCenter.
• Proficient in adding, deleting and repairing of the nodes in the cluster along with monitoring the health of the cluster.
• Configured Performance Tuning and Monitoring for Cassandra Read and Write processes for fast I/O operations and low latency time.
• Proficient in working with Nodetool utility for managing the cluster.
• Enabled Security properties like authenticator and authorizer to protect the data from unauthorized users.
• Collaborated with Developers and Analyst on all aspects of data management like compaction strategies, consistency levels, and replication factors.
• Used SSL encryption to configure internode communication between Cassandra nodes and client.
• Performed importing data from various sources to the Cassandra cluster using Sqoop.
• Designed, automated the process of installation and configuration of secure DataStax Enterprise Cassandra using chef.
• Knowledge on applying updates and maintenance patches for the existing clusters.

Tools: Cassandra, OpsCenter, Cassandra-stress tool, SSTable Loader, Service Now, Chef, DevCenter

Cassandra Consultant

Confidential, Phoenix, AZ

Responsibilities:

• Actively participated in requirement gathering sessions and capability planning for multi data center Cassandra cluster.
• Installed, Configured, administered and monitored multi Data center Cassandra clusters.
• Involved in upgrading the present Oracle data model to Cassandra data model.
• Proficient in adding, deleting and repairing of the nodes in the cluster along with monitoring the health of the cluster.
• Evaluated and tuned data model by running endurance tests using JMeter, Cassandra Stress Tool and OpsCenter.
• Collaborated with Developers and Analyst on all aspects of data management like compaction strategies, consistency levels, and replication factors.
• Managed and monitored multi Data center Cassandra cluster using OpsCenter.
• Enabled Security properties like authenticator and authorizer to protect the data from unauthorized users.
• Consistency levels for read and write queries were implemented depending on the use case.
• Used Chef Recipes for automating the installation process.
• Optimized the Cassandra cluster by making changes in Cassandra properties and Linux OS configurations.
• Configured Performance Tuning and Monitoring for Cassandra Read and Write processes for fast I/O operations and low latency time.
• Developed shell scripts along with setting up of CRON jobs for monitoring and automated data backup on Cassandra cluster.
• Managed the nodes in Cassandra cluster using nodetool utility.
• Involved in commission and decommissioning of the nodes in the existing Cassandra cluster.
• Worked on tuning Bloom filters and configured compaction strategy based on the use case.
• Performed importing data from various sources to the Cassandra cluster using Java/Python APIs or Sqoop.
• Responsible for Database Backup, Restoration and Recovery procedures.

Tools: Cassandra, Oracle, OpsCenter, DevCenter, Cassandra-stress tool, SSTable Loader, Service Now

Cassandra Consultant

Confidential, Houston, TX

Responsibilities:

• Employed in designing, implementing and monitoring multi-rack Cassandra cluster.
• Involved in upgrading current data model (Oracle) to Cassandra data model.
• Administered and monitored multi Data center Cassandra cluster based on the understanding of the Cassandra Architecture.
• Enabled Security features like authenticator and authorizer to protect the data from unauthorized users.
• Involved in writing Scripts to run repair on all nodes for maintaining the data consistent.
• Worked with CQL3 to execute queries on the data persisting in the Cassandra cluster.
• Administered and monitored Cassandra cluster using DataStax OpsCenter and Nodetool utility to monitor CPU usage, memory usage and health of nodes in the cluster.
• Designed, automated the process of installation and configuration of secure DataStax Enterprise Cassandra using chef.
• Used SSL encryption to configure internode communication between Cassandra nodes and client.
• Deployed and maintained PROD, client test, QA and Dev clusters.
• Used SSTable loader to Bulk load external data into a Cassandra cluster.
• Worked on tuning JVM Parameters depending on use case and performance test results.
• Played responsible role for deciding the hardware configurations for the cluster along with other teams in the company.
• Knowledge on applying updates and maintenance patches for the existing clusters.
• Configured Performance Tuning and Monitoring to analyze the impact of changes on the cluster.
• Experienced in configuring node-to-node and client-to-node encryptions.

Tools: Cassandra, Oracle, OpsCenter, Cassandra-stress tool, JMeter, SSTable Loader, Service Now, Chef

Systems Engineer

Confidential

Responsibilities:

• Proficient in Linux system installation, configuration, administration, maintenance, monitoring and setting up alerts.
• Performed User ID creation, modification, deletion and maintain server security.
• Created volume groups logical volumes and partitions on the Linux servers and mounted file systems on the created partitions.
• Monitored and fixed performance related issues in Linux machines.
• Monitored system logs and root’s email for important messages such as errors and warnings or hardware failure errors.
• Improved system performance by working with the development team to analyze, identify and resolve issues quickly.
• Ensured data recover by implementing system and application level backups.
• Performed various configurations, which include networking and IPtable, resolving host names and SSH keyless login.
• Managing Disk File Systems, Server Performance, Users Creation and Granting file access Permissions.
• Automated administration tasks through scripting and Job Scheduling in CRON.
• Creating and managing Logical volumes; Installing and updating packages using YUM.
• Installed and maintained software packages (.rpm) as necessary.

Tools: Linux (Red Hat, CentOS, Ubuntu), Service Now

Analyst Programmer

Confidential

Responsibilities:

• Installed and configured all the Linux servers in the network per specifications of clients.
• Performed User ID creation, modification, deletion and maintain server security.
• Maintained necessary back-up of the important files anddocumented Linux scripts for future reference.
• Monitored the servers and Linux scripts regularly and performed troubleshooting steps.
• Performed level upgrades, softwareadministration& the RPM installation on Red HatLinux.
• Monitored system metrics and logs for any problems.
• Maintained the MySQL server and authentication to required users for databases.
• Running Crontab to back up data.
• Maintaining the MySQL server and Authentication to required users for databases.
• Performed servers updates, patching, upgrade and package installations using YUM and RPM.
• Developed, maintained and updated various scripts for services (start, stop, restart, recycle, and cron jobs).
• Installation of SSH and configuration of keys based authentication.

Tools: Linux (Red Hat, CentOS, Ubuntu), CRON, Service Now