I've never replaced the USB on a dual shock before but I have repalced many USB connectors on phones. Shouldn't be any different. Your soldering knowlage should carry you to success.
Before you do any work on it make sure you do your research as well as just looking at how the board and usb are soldered. Disassemble the remote and just take a look at it. Take pictures of the current USB and board for reference. Pre heat the area and make sure you have plenty of flux to keep the heat flowing to the right place.
Good luck on your repair.