-- Backup

exec msdb.dbo.rds_backup_database
@source_db_name='<db-name>',
@s3_arn_to_backup_to='arn:aws:s3:::<bucket-name>/<bkp-name>.bak',
@overwrite_S3_backup_file=1,
@type='full';
GO
exec msdb.dbo.rds_task_status;

-- Restore

exec msdb.dbo.rds_restore_database
@restore_db_name='<db-name>',
@s3_arn_to_restore_from='arn:aws:s3:::<bucket-name>/<bkp-name>.bak';
GO
exec msdb.dbo.rds_task_status;