Everybody has strengths and weaknesses. You don't have to become the most awesome schmoozer in Toronto. You don't even have to be good at it. You say you have other strengths, that you are technically good at your job.
In that case you just need to stop being DEFICIENT at schmoozing. You have other strengths to compensate. Maybe some cover for their technical deficiencies by being really slick but you don't need to do that.
You just need to get to a point where your strengths are recognized and your lack of personal engagement isn't holding you back.
Just start making small talk with everybody. Tell some jokes. Learn about their families. People like to talk so ask them questions and let them tell their stories, try not to look at your watch and grimace if you don't really care what they are saying.
In the sense that you have to get to table stakes yes you can learn. A reasonable expectation is to become a not bad schmoozer. Good enough that people think "here is a guy I can work with" and take a closer look at the technical strengths you bring to the table.
Don't set an unrealistic expectations that you have to turn into some kind of glad handing Bill Clinton. You will be demoralized by the impossibility and you don't need that. Just stop being bad at it.
In a similar situation to the OP. In a job I hate, but I'm 4 years away from earning a pretty good pension. I'd like to work beyond that age at which I can retire (56), but in my field --Communicaitons--there's a crazy number of young people out there willing to work for really lousy wages...plus they can social media my ass into the ground.
Looking to use the next four years to perhaps develop some freelancing skills...in what area I'm not sure...in order to keep my hand in the game.
Generally speaking, I am not a people person(to say the least). I made a little file-birthdays, wives' names, rudimentary personal information like hobbies and interests, drink preferences, and memorized it. I make an effort to greet all the new employees. I make an effort to smile(big one) when greeting people, shake the hands, do shoulder slapping, and apply my secret file in small talk. Everybody knows my name, apparently, I'm a very outgoing and friendly guy. It's all a sham, but it works.
Here is a hint:
You don't actually have to like anybody. You don't really need to get to know them. You don't have to give a shit about their kids.
Just pretend that you do. Make a lot of contacts. Remember enough about them that you can ask a pleasant question about their family before getting down to business.
Having done the obligatory niceties be really fucking good at solving people's problems, by doing whatever it is you do really well, and be a straight dealer who is reliable and efficient.
There is a certain amount of small talk that gets people comfortable so they feel you are accessible and a guy they can work with. That is just table stakes. You also need to be communicative enough that people trust you because you keep them up to speed on what is going on, this also makes sure that they know what you are doing for them.
After that, what most people really like is somebody who actually gets the job done without any bullshit.
Some great advice here. Very interesting approaches.
Sometimes in life we all face situations that we're uncomfortable with. Usually, we just plug on and expand our comfort zones. It could be done bit by bit or you may face a situation where you have no choice but to tackle an uncomfortable situation. Unless we're talking extreme sports or violent crime, no one has ever died from pushing their limits.
The notion of changing vocation is daunting, but there are tons of resources out there to help. Most are geared to people who are unemployed, but the process of looking for something new isn't all that different.
Most Toronto Public Libraries have job search programs that can lead you to workshops in your area to help guide you.
Also, if you go to the Employment Ontario website, they have many resources to help.
For what it's worth, I used to be extremely shy, to the point that I would say I was bordering on being anti-social.
I saw how much some of my more outgoing friends enjoyed life and decided to just start being a little more outgoing.
I did this bit by bit over a span of a number of years. Even now, there are some days and situations when I have to dig deep to overcome my own limits.
Every time I lose get over my obstacles, I feel much better and the situations almost always turn out for the best.
The absolute worst thing that has ever happened to me when doing this, was I may have embarrassed myself a few times. Nothing serious and usually in front of people I would likely never see again, so no big deal.
Sorry for the longwinded essay, but I hope you manage to get to a better place.