Site-disorder driven superconductor–insulator transition: a dynamical mean field study