Add /health endpoint for app health checks

[matthew-li]

Add a /health endpoint that returns overall application health status.
At minimum, should verify DB reachability. Additional checks TBD.