Backend/DevOps Wizard for Dashboard Revamp
Budget: €30 – €250 EUR
### **Backend/DevOps Specialist Wanted for Royalty Accounting Dashboard Optimization**
#### **About the Project**
We operate a platform dedicated to the monetization and distribution of artists' music. One of our critical requirements is a **royalty accounting dashboard** that processes **streaming data, artist earnings, geographical analytics, and other relevant information** using **CSV files** provided by our partners on a monthly basis.
This dashboard has already been developed by a previous team, but it now requires **bug fixes, optimization, and feature enhancements** to improve its performance.
? **Once the first phase (bug fixing & optimization) is complete, we will begin a full UI/UX redesign of the platform.**
---
### **? Technical Challenges & Issues to Solve**
#### **1️⃣ Severe CSV Processing Delays on the Live Server**
- **Local execution:** <5 seconds
- **Server execution:** **Over 24 hours**
- Optimizing **PostgreSQL database** and **CSV file processing** is essential.
#### **2️⃣ Deployment & Server Execution Issues**
- Hosted on **Hamravesh & Vercel**, but deployments fail, resulting in **Service Unavailable** errors.
- **Debugging environment variables** (e.g., `POSTGRES_DB`, `POSTGRES_USER`, etc.) in Vercel.
- **Optimizing and managing Docker, Kubernetes, and CI/CD** to ensure smooth execution.
#### **3️⃣ Artist-Specific Dashboards with Role-Based Access**
- Each artist has a **personalized dashboard** with **tiered access controls**.
- **Authentication, authorization, and permission management** must be implemented.
#### **4️⃣ Codebase Debugging & Performance Optimization**
- Reviewing and fixing critical files:
- `earnings.utils.py`
- `users/signals.py`
- `core/settings.py`
- Resolving **ImportError** issues.
- Optimizing **Gunicorn, Celery**, and **server logging**.
---
### **?️ Tech Stack**
✅ **Backend:** Django (Python)
✅ **Database:** PostgreSQL
✅ **Frontend:** _(Modifications if needed)_
✅ **Server & Deployment:** Hamravesh, Vercel, Docker, Kubernetes
✅ **Storage & Cloud:** AWS S3 (for file storage)
✅ **Version Control:** GitHub
---
## **? Phase Two: UI/UX Design & Implementation**
After the **bug fixes and system optimization**, we will **redesign and enhance the UI/UX** for better usability.
? Designing a **modern, responsive, and data-driven interface**.
? Implementing **custom dashboards for each artist** with advanced analytics.
? Using **React.js or Vue.js** (if necessary) for better user interaction.
? Enhancing **user experience (UX)** for artists and system administrators.
? **UI/UX designers can submit their resumes for potential collaboration in Phase 2.**
---
### **? Required Skills**
? **Strong expertise in Django & Python**
? **PostgreSQL database optimization & CSV file processing**
? **Server deployment and management (Hamravesh, Vercel)**
? **Proficiency in Docker, Kubernetes & CI/CD pipelines**
? **Experience with Gunicorn & Celery for faster processing**
? **Authentication & role-based access control**
? Familiarity with **Frontend (React/Vue)** is a plus.
---
### **⏳ Collaboration Duration**
⏳ **Phase 1 (Bug Fixes & Optimization):** 1 month
⏳ **Phase 2 (UI/UX Implementation):** Ongoing collaboration
✅ **Long-term opportunities for dashboard development and feature enhancements.**
---
### **? Compensation & Work Type**
? **Engagement Type:** Project-based / Freelance / Full-time
? **Salary/Payment:** Negotiable based on experience
? **Payment Structure:** **Milestone-based payments** aligned with project progress.
---
? **Interested candidates? Apply now!**
#### **About the Project**
We operate a platform dedicated to the monetization and distribution of artists' music. One of our critical requirements is a **royalty accounting dashboard** that processes **streaming data, artist earnings, geographical analytics, and other relevant information** using **CSV files** provided by our partners on a monthly basis.
This dashboard has already been developed by a previous team, but it now requires **bug fixes, optimization, and feature enhancements** to improve its performance.
? **Once the first phase (bug fixing & optimization) is complete, we will begin a full UI/UX redesign of the platform.**
---
### **? Technical Challenges & Issues to Solve**
#### **1️⃣ Severe CSV Processing Delays on the Live Server**
- **Local execution:** <5 seconds
- **Server execution:** **Over 24 hours**
- Optimizing **PostgreSQL database** and **CSV file processing** is essential.
#### **2️⃣ Deployment & Server Execution Issues**
- Hosted on **Hamravesh & Vercel**, but deployments fail, resulting in **Service Unavailable** errors.
- **Debugging environment variables** (e.g., `POSTGRES_DB`, `POSTGRES_USER`, etc.) in Vercel.
- **Optimizing and managing Docker, Kubernetes, and CI/CD** to ensure smooth execution.
#### **3️⃣ Artist-Specific Dashboards with Role-Based Access**
- Each artist has a **personalized dashboard** with **tiered access controls**.
- **Authentication, authorization, and permission management** must be implemented.
#### **4️⃣ Codebase Debugging & Performance Optimization**
- Reviewing and fixing critical files:
- `earnings.utils.py`
- `users/signals.py`
- `core/settings.py`
- Resolving **ImportError** issues.
- Optimizing **Gunicorn, Celery**, and **server logging**.
---
### **?️ Tech Stack**
✅ **Backend:** Django (Python)
✅ **Database:** PostgreSQL
✅ **Frontend:** _(Modifications if needed)_
✅ **Server & Deployment:** Hamravesh, Vercel, Docker, Kubernetes
✅ **Storage & Cloud:** AWS S3 (for file storage)
✅ **Version Control:** GitHub
---
## **? Phase Two: UI/UX Design & Implementation**
After the **bug fixes and system optimization**, we will **redesign and enhance the UI/UX** for better usability.
? Designing a **modern, responsive, and data-driven interface**.
? Implementing **custom dashboards for each artist** with advanced analytics.
? Using **React.js or Vue.js** (if necessary) for better user interaction.
? Enhancing **user experience (UX)** for artists and system administrators.
? **UI/UX designers can submit their resumes for potential collaboration in Phase 2.**
---
### **? Required Skills**
? **Strong expertise in Django & Python**
? **PostgreSQL database optimization & CSV file processing**
? **Server deployment and management (Hamravesh, Vercel)**
? **Proficiency in Docker, Kubernetes & CI/CD pipelines**
? **Experience with Gunicorn & Celery for faster processing**
? **Authentication & role-based access control**
? Familiarity with **Frontend (React/Vue)** is a plus.
---
### **⏳ Collaboration Duration**
⏳ **Phase 1 (Bug Fixes & Optimization):** 1 month
⏳ **Phase 2 (UI/UX Implementation):** Ongoing collaboration
✅ **Long-term opportunities for dashboard development and feature enhancements.**
---
### **? Compensation & Work Type**
? **Engagement Type:** Project-based / Freelance / Full-time
? **Salary/Payment:** Negotiable based on experience
? **Payment Structure:** **Milestone-based payments** aligned with project progress.
---
? **Interested candidates? Apply now!**