A common question seems to be along the lines of 'my grandfather was a gardener/soldier/housemaid/etc for Queen Victoria. Do any records exist regarding their employment?'
Click https://www.royal.uk/archives
and then select FAQs. Do read them for a lot more information.

Findmypast have a dataset with over 386,000 names called Royal Household Staff 1526-1924.