"I worked there as a waiter" is almost always better. "My job was to be a waiter" is possible, but has limited use. It kind of sounds as if being a waiter was an act, or pretence, rather than an ordinary straightforward job.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.