Scalable .NET React Data Portal

Project Overview
Build a full-stack web application with .NET backend, React frontend, and a PostgreSQL database. The system must handle ~5 lakh transactions, 200+ screens, API integrations, schema migrations, and performance tuning—designed to scale for high concurrency and large datasets. All API calls require token-based authentication and role-based authorization (Admin / User / Guest), and the UI should hide or show features accordingly. Work in a separate Git branch with clean commits.

Responsibilities
• Design and implement a PostgreSQL schema, relationships, and seed scripts based on provided datasets.
• Import CSV data and migrate from tables → schemas.
• Build a stateless .NET REST API using async patterns, with role policies and Swagger docs.
• Create a React UI (200+ screens) that consumes the API, with dynamic data display and responsive tables.
• Implement client-side validation, error handling, and role-based rendering.
• Ensure scalability (code-splitting, optimized queries, EF Core/Dapper).
• Provide Docker-compose for one-command local deployment and a brief deployment guide.

Requirements
• Basics of React (hooks, functional components).
• Experience with .NET Web API, REST principles, and authentication/authorization.
• Good knowledge of SQL, relational design, CSV handling.
• Strong debugging and problem-solving skills.

Nice to Have
• Experience with axios, EF Core, Dapper, or Docker.
• Familiarity with UI patterns (tables, accordions).
• Understanding of cloud-agnostic deployment practices.

Final Deliverables (Due: 31st December)
• Production-ready .NET API with role-based access and Swagger.
• React UI respecting Admin / User / Guest permissions.
• Complete PostgreSQL schema, seed data, and configuration.
• Docker-compose setup for local environment.
• Test credentials + handover checklist ensuring access control works.