Hey Hotsauce,
I'm sorry I couldn't reply earlier. Since I worked on the doors 2 months ago, based on your suggestion I took a look at the connectors in both doors. They looked fine but I unplugged and reconnected them again. Door locks & remote have been working fine since then.
Yet another proof of how valuable and useful this forum is-specially without any bumper-to-bumper warranty left.