Umbraco Websites Migration to New Hosting

I have moved hosting suppliers and need help getting my two Umbraco websites working on the new server.

Key Requirements:
- Transfer and configure the SQL Server databases for both websites.
- Diagnose and fix any issues preventing the websites from loading.
- Ensure all content is successfully migrated and functional.

Ideal Skills:
- Extensive experience with Umbraco CMS.
- Proficient in SQL Server management.
- Strong troubleshooting skills for web hosting issues.

Backups of the SQL databases can be provided as .bacpac