A sheaf-theoretic approach to homology manifolds and Poincaré/Atiyah duality