Fix Sidekiq migration timeout

What does this MR do and why?

Fix Sidekiq migration timeout

For #458743 (closed), the migration db/post_migrate/20240124043507_migrate_sidekiq_queued_and_future_jobs (released in 16.10) is timing out on Dedicated customers environment due to the migration running in DB transaction. This migration however doesn't interact with the DB at all, as it only migrates Sidekiq jobs to the correct queue based on routing_rules configuration.

This fix adds disable_ddl_transaction! to the migration.

Changelog: fixed

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.