About

Sonu Gupta is a certified GCP Professional Cloud Architect, Cassandra Administrator & Developer with over 11 years of experience in different flavors of databases and working on different cloud services such as GCP, AWS, and Azure. He currently works as a Senior Advance Software Engineer at Honeywell. Sonu has extensive experience in NoSQL databases such as Cassandra, RDBMS databases like Oracle, PostgreSQL, and EDB, and Hadoop distributions like Cloudera and Hortonworks. He has expertise in database design & data modeling, distributed or master-to-master or master-slave as per requirement, database migration, and capacity/nodes recommendation to the team during the design phase. As a Cassandra Administrator, Sonu has experience in Cassandra backup and recovery for DB/Keyspace/ColFamily Backup & recoveries, Cassandra implementation and administration, DSE Cassandra upgrade, Cassandra Opscenter installation, upgradation, migration, and performance tuning by tweaking Cassandra.yaml/Cassandra-env.sh. He is also skilled in troubleshooting read/write latency and timeout issues, configuring backup, alerts, repairs, and monitoring of Cassandra clusters using Opscenter, and adding/removing nodes and data centers. Sonu is proficient in writing queries for different purposes, preparing hot fixes and daily patches for different clients, bulk data loading through SQL Loader, and cold and hot backup, import and export data, and database. He has also indexed tables using various types of indexes to improve performance. Sonu has worked with companies like IBM and Accenture in the past and has completed his Master of Computer Applications (MCA) from IGNOU. He is also familiar with tools like New-Relic, Solrwind, PL/SQL Developer, Toad, SQL Navigator, Freshdesk, Pagerduty, Shinken, Zabbix, JIRA, and Kibana. Overall, Sonu Gupta has 13.70 years of relevant experience and is a highly skilled and experienced OSS Architect with a strong focus on database management and cloud services.