Re-naturalized quarry lakes are important ecosystems, which support complex communities of flora and fauna. Microorganisms associated with sediment and water form the lowest trophic level in these ecosystems and drive biogeochemical cycles. A direct comparison of microbial taxa in water and sediment microbial communities is lacking, which limits our understanding of the dominant functions that are carried out by the water and sediment microbial communities in quarry lakes. In this study, using the 16S rDNA amplicon sequencing approach, we compared microbial communities in the water and sediment in two re-naturalized quarry lakes in Singapore and elucidated putative functions of the sediment and water microbial communities in driving major biogeochemical processes. The richness and diversity of microbial communities in sediments of the quarry lakes were higher than those in the water. The composition of the microbial communities in the sediments from the two quarries was highly similar to one another, while those in the water differed greatly. Although the microbial communities of the sediment and water samples shared some common members, a large number of microbial taxa (at the phylum and genus levels) were prevalent either in sediment or water alone. Our results provide valuable insights into the prevalent biogeochemical processes carried out by water and sediment microbial communities in tropical granite quarry lakes, highlighting distinct microbial processes in water and sediment that contribute to the natural purification of the resident water.