Do I need to be present in person to sign the notarial deed for the purchase in Malta?

No, you can grant power of attorney to a lawyer who will handle the formalities on your behalf.