I'd say 'by trade' is usually only used to refer to an occupation involving skilled manual or mechanical work. I'd never say 'a secretary by trade' or 'a researcher by trade', but I might possibly say 'a pharmacist by trade' -- probably due to the fact that I've heard many pharmacists complain that their job seems to consist primarily of manually measuring or counting out medication.