About

Prateek Ghamandi is a Senior DevOps Engineer at QuestionPro with 4.78 years of relevant experience. He is responsible for creating analytical dashboards for surveys using Clickhouse as the database. He played a crucial role in designing and developing the system and configured real-time data replication from MySQL to Clickhouse using debezium and Kafka queues. Prateek has also created a WiKi for monitoring the infrastructure of the company and configured Jenkins Backup using Jenkins pipeline itself and sent failure notification to messaging systems. Prior to joining QuestionPro, Prateek worked as an Assistant Manager at Bharat Petroleum Corporation Limited. He managed 330+ VMs in VMware Virtualized Infrastructure with vSphere and vRealize Automation, including Site Recovery Manager Replication and HA of vSphere application. He also managed storage and networks through VMware vSphere and vRA and automated VM provisioning and deployment using custom workflows in vRA. Prateek was responsible for monitoring and troubleshooting with vROPS and vRLi. He managed and patched physical servers and ESXi hosts in the primary data center and performed DR drills half-yearly for all production systems. Prateek has experience in source code management, reporting, requirements management, project management, automated builds, testing, and release management of .NET, .NET Core, and Node.js applications using TFS 2017 and Azure DevOps Server. He implemented Continuous Integration and Continuous Deployments for IIS applications and MS SQL and migrated TFS to Azure DevOps Server. Prateek also has experience in designing, deploying, and administrating MS SQL server infrastructure (SQL Server 2008, 2012, and 2016) in development, test, and production environments. He has experience in performance tuning, troubleshooting, and maintaining High Availability and Disaster Recovery of highly transactional SQL Server Instances. Prateek's education includes a Bachelor's Degree in Computer Science from Walchand College of Engineering, Sangli, which he completed in 2018. He also completed his High School from Jindal Public School in 2012. Prateek has a diverse tech stack, including DevOps, SQL, Python, Jenkins, infra, Docker, Azure, Ansible, test, Kafka, MySQL, AWS, CI/CD, Javascript, Keras, Integration, Web, Image Processing, NLP, Kubernetes, ML, Flask.