As recovery of clean and potable water from oil contaminated produced water lies at the heart of petroleum industry, various membranes have been developed to address this challenge. Given the salient features of high thermal and chemical stabilities, ceramic membranes possess huge potential for recovering potable water from produced water. A new CDC/PA@Ceramic membrane (carbide-derived carbon/polyamide on Al2O3 ceramic support) was fabricated by depositing carbide derived carbon (CDC) on alumina support through two phases of interfacial polymerization using piperazine and 3,5-diaminobenzoic acid crosslinked through terephthaloyl chloride. The merits of the fabricated membrane were thoroughly characterized by several characterization techniques including Field emission scanning electron microscopy, Energy-dispersive X-ray spectroscopy, Elemental mapping, Powder X-ray diffraction and Attenuated total reflectance Fourier transform infra-red spectroscopy. The CDC/PA@Ceramic membrane showed promising performance in terms of permeate flux and separation efficiency for oil/water emulsion. The separation efficiency remained >96% for all studied emulsion-concentrations (250 ppm, 125 ppm and 67.5 ppm). The highest separation efficiency was >98% with a feed concentration of 67.5 ppm of oil/water emulsion. The highest pure water permeate flux reached 250 L/m2.h at 4 bar. The long-term stability test showed that the CDC/PA@Ceramic membrane remained stable for elongated time of 720 min with constant separation efficiency of >96% and permeate flux of 58 L/m2.h at 2 bars. All results were validated by visual inspection, fluorescence spectrophotometry and optical microscopy of the feed and permeate throughout the membrane performance tests. The CDC/PA@Ceramic membrane can be a potential candidate for recovering precious water from the waste produced water.