The story of Shukracharya receiving Sanjivani Vidya is found in Chapter 16 of the Kāśīkhaṇḍa of the Skanda Purāṇa.
As per it, Shukracharya performed a very severe penance, by inhaling smoke of husked rice for a thousand years before he finally got the vidya from Lord Shiva:
Kavi (Śukra) washed the great dirt of the mind in the form of fickleness by means of ...
Shukracharya ‘is’ the guru of the Daityas and Danavas. He is the planet Venus, among the nine planets in jyotisha and ‘lives’ in his own Loka which is described below.
As per the Puranas, the world of Shukracharya lies beyond that of Budha. It is about seven hundred thousand yojanas from the earth.
O descendant of Kura, the Sun’s disc is a hundred thousand ...
Can I get specific instances where he exactly used the Mrit Sanjeevani Mantra and was successful in reviving
There are few instances where he used Mṛtasañjīvanī and was successful:
During the war b/w Andhaka and Lord Shiva ~Shiva Purana: Rudra-saṃhitā: Yuddha-khaṇḍa: Chapter 47
During the war b/w Devas and Asuras ~Mahabharata: Adi Parva: Sambhava Parva: ...