My pain medication is making me sleepy and groggy, but I have to work. What else can I take?

Pain medications. Apparently, sedative drugs are not for you. You need non-opiate analgesics or ineterventional pain treatments for long term relief. Please see a well qualified pain physician for your options.
NSAIDS. Non-steroidals are a good choice. Over the counter or prescription lie Celebrex or mobic (meloxicam).