As a child, I had ADHD, I guess technically speaking I still do, sometimes I realise after doing something that maybe it still affects me a little (though generally these cases are just funny little things I do, nothing negative), but I've completely changed from when I was a kid, I'm a very chilled and relaxed and patient person and pretty much everyone I meet these days can't imagine me ever being massively hyperactive.
I don't think such things should be limited by labels given to people, almost anyone with ADHD could probably do any job just as well, or better, as anyone with out it(providing it is actually something they're skilled at, knowledgeable of etc...) It's no different than a "normal" person choosing a career. It's just something that interests the person, likely something they know they're good at or can do.
Personally most of my work involves the outdoors as a coach and instructor and generally being pretty active, but it's mainly because that's what I love doing the most. But I also love and have an interest in electronics and engineering as well as having done a fair amount of programming, and I am just as able to sit down and concentrate on one thing closely for hours. Yes I often find that I am potentially distracted easily, but there are so many ways of avoiding and working past distractions that it essentially shouldn't matter.
Most important point: any career you want! As anyone will get bored in any job if it's not one they care much for! =)