avinash kant

Senior Software Engineer

Happiest Minds Technolgoies•  October 2015 - Present

 Experience in, Snowpipes, SnowSQL, Performance Tuning, and Monitoring as part of Snowflake deployments.  Optimized Snowflake resource utilization reducing the cost.  Architected AWS S3 to back up historical data from Snowflake beyond 90 days (Max Threshold) improving RPO.  Architected Automic Tool database reducing size by 60% by optimizing index, de-fragmentation, & purge.  Implemented Security role, row and column level security in Snowflake, GreenPlum and Oracle.  Redesigned the GreenPlum database avoiding frequent high impact failures and downtime.  Improved database performance to support data growth.  Database migration to DCA using automation tool Automic.  Analyzed migration of RDBMS DB2 to NoSQL MongoDB and designed its High Availability Cluster.  Managed a team of 3 members supporting the new MongoDB database.  Developed R2M tool to migrate data from RDBMS Oracle to NoSQL MongoDB database improving RTO.  Implement the HIPAA policy ensuring data access management for the clients.