[WIP] remove multi-site “/backups” infix (PR #9719)

for multi-site clusters the current destination is $S3_BACKUP_BUCKET/backups/$DATABASE but it should be $S3_BACKUP_BUCKET/$DATABASE

GitHub