Dwarikesh Sharma

Background

About Dwarikesh Sharma

Certified Cassandra DataStax DBA ->Overall experience of around 11 years in IT industry in which 7 years+ experience in Cassandra DBA and development->Building, setting up and administration of Cassandra multi node clusters->Experience in configuring backup, restore, repairs and monitoring of Cassandra clusters using Nodetool utilities/JConsole/Custom scripts and DataStax Ops center->Cluster management activities like add/remove/decommission/replace nodes and data Center->Data Refresh activities within cluster and between clusters using sstableloader And csv bulk load ->Cassandra clusters setup on aws cloud with different AZ.Basic understanding on aws env->Upgrade Datastax Cassandra Clusters and Apache Cassandra as well->Depth knowledge of architecting and creating Cassandra/NO SQL database systems->Designing a Data Model based on query driven approach in Cassandra for Pharmaceutical Analytic Application->Strong understanding of complex inner workings of Cassandra, such as the gossip protocol, hinted handoffs, read repairs, compaction->A deep understanding of Cassandra design principals, cluster connectivity, security and the factors that affect distributed system performance->Deployment and support highly available and scalable distributed Cassandra database solutions for Analytical mission critical applications->Ansible Automation, Linux Shell Scripting Hands-on experience on many Cassandra projects Handling Sybase ASE Operations such as High Thread Utilizations, DB Data Space, DB Log segment filling up, Rep thread down due to data duplication and other, Latency between Primary and RDD, Database Refresh (backup and loading data), tempdb space issue. Adding space in tables segment, Linux Patching support->Solr core creation, reloads, unload, and full re-indexing in Cassandra DataStax clusters->Splunk configuration for system log, audit log and spark log for Cassandra clusters->Hands-on experience on Integration of Spark, Scala and Cassandra with SBT build on IntelliJ IDE->Worked on MDM (Master Data Management) and Data Warehouse projects for US pharmaceutical company (pharmacies/wholesalers/hospitals/prescriptions)->Designing SSIS ETL Packages to produce various kinds of in/out files, to apply various transformations on data for cleaning/massaging of pharmaceutical data and to push/pull data from SQL data warehouse as well as MDM->Expertise in development and maintenance of SSIS (ETL) packages, jobs involving large volume of data->Hand-On experience on ServiceNow, Jira, Filezilla, GitHub, BugZilla