Membrane-based oil–water separation has shown huge potential as a remedy to challenge oily wastewater with ease and low energy consumption compared to conventional purification techniques. A set of new composite ceramic membranes was fabricated to separate surfactant-stabilized oil/water (O/W) emulsion. Carbide-derived carbon (CDC) was functionalized by 3-aminopropyltriethoxy silane (APTES) and subsequently deposited on a ceramic alumina support and impregnated with piperazine as an additional amine. The APTES functionalized CDC-loaded membrane was then crosslinked using terephthalyol chloride (TPC). Different loadings of functionalized CDC (50 mg, 100 mg and 200 mg) were employed on the ceramic support resulting in three versions of ceramic membranes (M-50, M-100 and M-200). The fabricated membranes were thoroughly characterized by Scanning electron microscopy (SEM), X-ray diffraction (XRD), Attenuated total teflectance Fourier transform infrared (ATR-FTIR) spectroscopy, Energy dispersive x-ray spectroscopy (EDX) and elemental mapping. The highest permeate flux of 76.05 LMH (L m−2 h−1) at 1 bar using 67.5 ppm oil-in-water emulsion (as feed) was achieved by the M-50 membrane, while an oil separation efficiency of >99% was achieved by using the M-200 membrane. The tested emulsions and their respective permeates were also characterized by optical microscopy to validate the O/W separation performance of the best membrane (M-100). The effect of feed concentration and pressure on permeate flux and oil–water separation efficiency was also studied. A long-term stability test revealed that the M-100 membrane retained its performance for 720 min of continuous operation with a minor decrease in permeate flux, but the O/W separation efficiency remained intact.