Yes, you can apply a TN visa at a US port of entry. You need show your Canadian passport, US company's offer letter and probably your diploma. The visa is good for one year. In one year, you need go back to Canada and re-enter USA for a new TN visa. If you change your employer, you also need go back to Canada and re-enter USA.

Good luck.