Senior Django Developer - PSQL Optimization & Microservices Architecture Consulting

### Project Overview We are looking for a Senior Django Backend Engineer to provide architectural consulting and database optimization advice. Our application is a high-throughput microservices-based system that requires performance tuning, specifically targeting PostgreSQL performance bottlenecks and service-to-service communication. This is a consulting engagement consisting of 1-2 video/audio call sessions to review our current setup, identify bottlenecks, and discuss optimization strategies. ### Target Architecture & Challenges - Framework: Django (Python) - Database: PostgreSQL (high read/write load, connection pooling issues, slow queries) - Pattern: Microservices ### Scope of Consultation - Reviewing current database schema, indexing strategies, and query patterns. - Advising on Django ORM optimizations (select_related/prefetch_related, raw queries, connection management). - Recommending architecture adjustments for high-throughput data pipelines. - Providing concrete, actionable advice on Postgres tuning (work_mem, shared_buffers, indexing). ### Requirements - 5+ years of experience with Python/Django in production environments. - Deep expertise in PostgreSQL optimization (indexing, query execution plans, scaling). - Practical experience with microservices architectures and handling high-throughput systems. ### Budget & Structure Payment Type: Fixed-Price * Total Budget: $90$ * Milestones Configuration: * Milestone 1 (Set during contract phase): Initial Architecture & Query Review Session ($45 \text USD$) * Milestone 2 (Set during contract phase): Follow-up Optimization Action Plan & Feedback Session ($45 \text USD$) ### How to Apply Please start your proposal with the word "OPTIMIZE" so I know you have read this. Briefly list 2-3 specific PostgreSQL optimization techniques you have successfully implemented in high-load Django applications.