• deployment orchestration for Snowflake monolith using custom orchestration tools

• touch free automation to auto-deploy in release testing farm

• developed cmd2 based command line tool to allow execution of SQL commands across multiple snowflake instances

 Developed a precheck framework using Chef Inspec

 Developed an os patching script that does online ksplice based patching on a monthly cadence

 Designed and implemented custom classes to provide in Ruby and Python to allow structured access to the db host properties required (code dynamically discovers the attributes it needs and has a caching layer)

 Designed and implemented a service to trigger database patching on specific preconditions

 Designed and implemented a service to monitor workflow execution and notify appropriate team via PagerDuty alerts when user intervention is required

 Designed and implemented module to gracefully drain workload from databases

 Worked with application monitoring team to automate silencing monitoring system during maintenance

 Designed and developed a command line tool to interact with an orchestration server (java-based application), run specific prechecks to validate user inputs on orchestration server and/or node and trigger endpoints to start and monitor the workflow.

 Developed a heartbeat mechanism between the orchestrator and modules executing on remote hosts to detect any unexpected crash or failure allowing quicker mitigation

 Led a team of 2 developers in designing and delivering database configuration management tool to allow t-shirt sizing of fusion pods

 Worked closely with an offshore team enhancing the inhouse orchestration tool to make it more generic and configuration driven

 Worked on provisioning script which are triggered on database side to provision the application

 Developed common library class in ruby to allow programs to do check pointing and execution metric collection

 Build self-contained python + Openssl to bootstrap python3 on hosts without touching system python (and have low dependency)

 PoC to use ansible playbooks to run workflow with resume capability

 Developed code to integrate with inhouse service catalog (Cisco Estore) to allow users to request code repository, artifact storage or deployment pipeline based on templates from a self-service portal

 Developed tool to migrate CVS/PVCS/SVN/MKS code repository into a new standardized SVN repo along with revision history

 Developed automation for creating private or public artifact storage repository in JFrog Artifactory

 Developed workflow provisioning code to create pipelines in IBM uDeploy/uRelease to allow touch free continuous deployment

 Owned administration of CollabNet SVN, JFrog Artficatory (including security audits, upgrades) and worked closely with a peer team on administration IBM uDeploy and IBM uRelease production servers.