Move service ping worker to sticky data_consistency

What does this MR do and why?

Move service ping worker to sticky data_consistency

• This is not a time sensitive job that needs to run on primary DB.

Resolves: #527113 (closed)

Changelog: changed

References

• Refs: !184339 (comment 2418138685)
• Follow-up from "Add DB metric for external audi... (#527113 - closed) • SAM FIGUEROA

How to set up and validate locally

MR acceptance checklist

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