The design looks quite similar to Flyway[0]. I can confirm that this design has been working quite well for us in a large-scale production environment.

[0] https://flywaydb.org/