If u take it to Apple, they will want to replace the casing, not sure, but at least usd$300 bux?
Can u DIY? This maybe a simple case of twisted metal causing the magsafe to not make proper contact with the jack. A simple, relatively speaking, mechanical issue.