Automation of database schema management is a automated process to manage the database schema . Technologies used are git , flask and Cassandra database . Users check in their schema in git and tag it . Once tagged , it triggers a webhook to call a flask . Based on the schema changes and tag applied the flask application executes applying the schema changes to the database .

This project was for migrating the Cassandra database from AWS to GCP .
A vpn was established between AWS and GCP through the internal data enter . Once done , new Cassandra data enter created in GCP and connected with the DC in AWS. Both DCs were made part of same Cassandra cluster. Data were streamed from AWS dc to GCP dc . Nodetool rebuild was used . Once done the AWS dc nodes were removed.

Created a Cassandra as a service project using technologies like nodejs, ansible and openstack. The UI was created in nodejs through which a user can request a Cassandra cluster . Then the ansible was kicked off in the background to spin vms in openstack and install Cassandra in them . The information was also stored in database for information purpose . This helped to build large Cassandra clusters quickly .

Invloved in large infrastructure deployments especially for cassandra and kafka . Automated end to end deploymenf using infrastructure automation tool like anaible .