feat: Add observability and logging features

Commit notes

This commit introduces comprehensive logging with Pino, request correlation, and metrics endpoints. It also enhances the health check and adds optional OpenTelemetry export. Database connection pooling is also configured for better performance.

Co-authored-by: armin.naimi <[email redacted]>