Dr Vinod Sharma, CEO and Director of DCC Animal Hospital, advises against keeping a goldfish on an office desk due to the significant waste they produce and the unstable environment of office spaces. Goldfish can live up to 20 years with proper care, but Dr Sharma suggests considering other species or being prepared for intensive maintenance before adopting a pet fish.