Dog agility training began as a sport in the UK in the 1970s and involves successful completion of an obstacle course. It's a great way to develop a strong bond between pet and owner; it can also help build confidence in timid dogs (and owners). It's also a great form of exercise as it uses not just the dog's physicality, but the intelligence as well. The human partner may find that their fitness improves as they are required to do as much work as the dog. Whilst agility training can be done to allow participation in competition, there's no rule to say it's not just for a fun time with your dog.
Dogs are naturally sociable animals; their understanding of their world is based upon a social position within a hierarchical pack. Some dogs are dominant, others will be submissive and both will behave according to its position. Your family group is basically a pack scenario to Fido. Whilst you really don't want him to be top dog, nor do you want him to be so submissive that he spontaneous urinates to try and grovel for you. In this latter scenario Fido's confidence is definitely requiring a boost!
If you are the sort of person who actively likes being with dogs, but are unhappy with the sort of line of work that you are in maybe it's time to combine an activity that you love with a way of earning money! One of the simplest ways of doing this is to start a dog walking business. If you are unsure of what all this would entail then as with any business, it requires research: fortunately there are plenty of pet trade magazines and website that can help with this side of things.