Django API & PostgreSQL Integration

I have a Django-based service in place and now need a specialist who can wire it cleanly to a PostgreSQL back-end. The schema already exists; what’s missing is the robust, well-documented integration layer that lets the application expose and consume data through a RESTful API without bottlenecks or security gaps.

The job centres on configuring Django (with Django REST Framework) to talk to PostgreSQL, mapping existing tables to models, creating any required migrations, and fine-tuning connection pooling so the API scales under load. I will rely on you to craft the views, serializers, and query logic that translate complex business rules into efficient SQL executed on the database.

Acceptance criteria are straightforward:
• Endpoints return the correct payloads in JSON, matching the provided OpenAPI spec.
• All read/write operations hit the right tables using parameterised queries generated through the ORM or, where performance demands, hand-optimised SQL.
• A concise README explains setup, environment variables, and the steps to run unit tests.

If you have deep familiarity with PostgreSQL quirks, Django migrations, and REST performance tuning, I’m eager to review your approach and start immediately.