You would have to have a medical examination done by an FAA Medical Examiner. You would have to disclose your condition, following which more than likely the examiner would defer your medical to the FAA certification office in Oklahoma city. They will make a decision based on the the reports you provide as per their protocol. More than likely, if issued you will get what's known as a special issuance medical. This medical is good for 1 year usually and requires testing at regular intervals as a condition for keeping the medical.
Special issuance medicals can be expensive to maintain because of the tests that are required. In many cases your insurance will not pay for these tests. It might be customary to spend $1000 every year or more on your medical, depending on the tests that are required.
Employment should not be an issue if you are issued a special issuance.
I suggest you join AOPA if you are not a member and take advantage of their medical department who can direct you correctly. There are other places as well but they will cost a lot more than AOPA.
Good luck and thanks for your service from a fellow veteran.