Extensive experience working with Postgres, MySQL, and SQLite both on the back-end and front-end, including migrations.
- Experience setting up SQL environments on macOS and Linux, as well as with Docker and third-party database-as-a-service platforms
- Setting up automated migrations to deploy SQL schema changes when a new version of a service is deployed to production
- Troubleshooting and fixing failed migrations in production
- Working with a variety of GUI and CLI tools for working with different dialects of SQL locally and remotely on a server
- Using Flyway to automate database migrations in backend Java and Kotlin apps