
Closed
Posted
Paid on delivery
I am looking for a senior full-stack engineer or a very small team to architect and build a multi-tenant SaaS platform designed for organizations that operate across unreliable networks and multiple devices. This is not a standard CRUD web application. The system must support simultaneous changes from web clients, mobile clients, and backend services, including periods where some clients are completely offline. The core challenge is designing a reliable synchronization architecture that prevents silent data corruption when conflicting changes are made independently. Core Requirements The platform must include: -Multi-tenant architecture with strict tenant isolation -Role-based and resource-level permissions -Web application -Mobile-responsive interface -REST or GraphQL API -PostgreSQL database -Background job processing -Redis or equivalent caching/queue infrastructure -Real-time event delivery -Offline-first client behavior -Incremental synchronization -Conflict detection and resolution -Idempotent API operations -Distributed audit logging -File/document attachments -Versioned records -Soft deletion and restoration -Full-text search -Rate limiting -Authentication with refresh-token rotation -Session/device management -Administrative dashboard -Automated database backups The Difficult Part: Synchronization Engine A client may perform operations while completely offline. For example: Device A 08:14:02 — changes customer status → ACTIVE 08:16:44 — changes assigned representative → USER_17 08:18:11 — adds note At the same time: Device B 08:15:31 — changes customer status → SUSPENDED 08:17:03 — deletes the customer Both devices may remain offline for several hours. When they reconnect, the system must determine: 1. Which operations occurred? 2. Whether operations are causally related 3. Whether they conflict 4. Which changes can be automatically merged 5. Which conflicts require user intervention 6. How the final state should be calculated 7. How the complete history can be reconstructed A simple updated_at comparison is not acceptable. The implementation should use an appropriate combination of: -Operation IDs -Client-generated IDs -Server sequence numbers -Record versions -Idempotency keys -Causal metadata -Tombstones -Synchronization cursors -Deterministic conflict-resolution rules The exact architecture should be proposed by the developer and justified technically. Auditability Every meaningful state transition must be reconstructable. Given a record's current state, an administrator should be able to determine: Who changed it When they changed it Which device made the change What the previous state was What the new state was Which operation caused the change Whether the operation originated offline Whether the operation was subsequently merged or rejected Audit records must be append-oriented and protected against ordinary application-level modification. Expected Deliverables The successful developer will be responsible for: 1. Technical architecture document 2. Database schema 3. API specification 4. Authentication/authorization system 5. Synchronization protocol 6. Conflict-resolution mechanism 7. Web application 8. Responsive UI 9. Automated tests 10. Integration tests 11. Load/concurrency tests 12. Docker-based development environment 13. CI/CD configuration 14. Production deployment documentation 15. Database migration strategy 16. Monitoring/error-logging strategy 17. Security documentation 18. Developer documentation Mandatory Technical Exercise Before awarding the project, shortlisted candidates may be asked to implement a small prototype demonstrating: > Two independent clients modify the same dataset while disconnected, reconnect at different times, submit operations in different orders, and eventually converge on the same deterministic state without losing valid operations. The prototype should also demonstrate duplicate request handling and recovery after partial synchronization failure. Security Requirements The application will handle potentially sensitive organizational information. The implementation must therefore consider: OWASP application-security principles SQL injection XSS CSRF where applicable Broken access control Tenant-isolation failures Token theft Replay attacks Rate limiting Secure file uploads Secrets management Secure logging Database access controls Security cannot be treated as a final-stage checklist. What I Am NOT Looking For Please do not apply if your experience is primarily: WordPress Elementor Basic landing pages Simple CRUD dashboards Template customization Basic Firebase applications Copy/paste SaaS projects Generic “full-stack development” AI-generated boilerplate without architectural understanding I am specifically looking for someone who can explain why their architecture will remain consistent under concurrency, offline operation, retries, duplicated requests, and partial failures. Proposal Requirements Generic proposals will be ignored. Your proposal must include: 1. Architecture Describe the synchronization architecture you would use and why. 2. Conflict Resolution Explain how you would handle the example where two offline clients modify and delete the same record. 3. Idempotency Explain how your system behaves when the same synchronization request is accidentally submitted five times. 4. Failure Recovery Explain what happens if the connection drops halfway through synchronization. 5. Experience Provide 2 relevant projects involving at least one of: Offline synchronization Distributed systems Event-driven architecture Multi-tenant SaaS Conflict resolution Real-time collaborative systems For each project, explain specifically what you personally implemented. 6. Technical Stack Recommend your preferred stack and briefly justify each major technology choice. Important I am looking for someone capable of taking responsibility for the architecture rather than simply implementing tickets. Please do not send a generic proposal such as: > “Hello sir, I have read your requirements and I can do this project perfectly. Please message me.” Those proposals will be rejected without further consideration.
Project ID: 40734073
34 proposals
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
34 freelancers are bidding on average $8,586 USD for this job

Hi there, I understand that building a robust multi-tenant SaaS platform will require a sophisticated synchronization architecture to handle offline operations and conflicting changes. For this, I propose using a combination of operational IDs and server sequence numbers to track changes reliably and ensure that all modifications can be merged without data loss. Additionally, I would implement a conflict resolution mechanism that allows for user intervention when necessary, while also utilizing deterministic rules to handle automatic merges when possible. The API system will ensure idempotent operations, so even if a request is accidentally submitted multiple times, the state remains consistent. I have substantial experience with distributed systems and real-time collaborative applications that align well with your project requirements. Happy to discuss the details and suggest the best technical approach. Regards, Ali
$5,000 USD in 14 days
0.0
0.0

Hello, I am Dr. Rajesh Rolen, PhD in Computer Science & Engineering, with experience of over 20+ years in Redis As a preferred freelancer in the top 1%, I have done 400+ projects here on freelancer.com, I have 4.9 ratings out of 5 on average, which showcases my quality of work and timely delivery. Key Highlights: - Free Hosting Support on the Cloud or any desired platform. - Free 3 months of post-delivery support to ensure that our client doesn’t face any challenges after the launch of the project. - Free Dedicated tester on projects to ensure quality delivery, so clients don’t need to act as a tester. - 10+ Years experience UI/UX team to ensure intuitive UI. Portfolio: https://www.freelancer.com/u/Microlent Please open the chat and send me a message, so we can have a more detailed discussion about the project to give you the project timeline and cost. Thank you for considering my services. I look forward to engaging in a productive conversation and understanding how I can be of assistance in bringing your project to life. Regards Rajesh Rolen
$11,600 USD in 180 days
0.0
0.0

Howdy, For this system, I’d implement an operation-based synchronization protocol using client-generated operation IDs, idempotency keys, server sequence numbers, record versions, tombstones, sync cursors, and causal metadata. PostgreSQL would remain the authoritative data source, supported by an append-oriented operation/audit log, Redis for queues and events, and deterministic conflict-resolution rules. In your example, independent status updates can be merged using field and version rules, while a concurrent deletion would be represented as a tombstone and surfaced as a conflict when a subsequent operation depends on the deleted record. Duplicate sync requests would return the result of the previously committed operation instead of executing it again. Interrupted batches would resume from the last acknowledged cursor, ensuring retries remain safe and consistent. I’d propose a PostgreSQL + Redis architecture with a typed REST/GraphQL API, Docker-based development, automated concurrency testing, and an initial prototype demonstrating convergence before moving into the full implementation. I can also provide my two most relevant project examples along with my exact contributions directly in chat rather than presenting unverifiable credentials. Would you like the technical exercise to be the first milestone? Looking forward to collaborating with you. Portfolio: https://www.freelancer.pk/u/zainalitariq245 Best regards, Zain Ali...
$5,000 USD in 10 days
0.0
0.0

Hey, The real challenge here is not CRUD but making offline synchronization converge correctly when devices retry, reorder, edit, or delete data independently. I’d build around client generated operation IDs and idempotency keys, per record versions, server sequence numbers, tombstones, synchronization cursors, and causal metadata where needed, so the system can distinguish retries, ordering, concurrency, and genuine conflicts instead of relying on updated_at. For the offline cases, independent field or operation changes can be merged when they are non-conflicting, while deletes use tombstones with deterministic conflict handling. Accepted, rejected, and merged operations would remain reconstructable through append oriented audit events. Duplicate requests would remain idempotent, and interrupted synchronization could safely resume from the client cursor without reapplying acknowledged operations. I can show you similar architecture examples in chat. I’d also be comfortable starting with the mandatory convergence prototype before committing to the full architecture. Portfolio: https://www.freelancer.com/u/Hammadhassan21 Best regards, Hammad Hassan
$5,000 USD in 15 days
0.0
0.0

Hi. This is a good fit because multi-tenant SaaS platform development is usually less about basic CRUD operations and more about implementing a robust synchronization architecture so existing data integrity and tenant isolation continue working. I have experience with Redis, distributed systems, event-driven architecture, and complex conflict resolution. The main technical issue in offline-first synchronization is that concurrent modifications from disconnected clients create non-deterministic states, which can cause silent data corruption or permanent loss of valid operations when those clients reconnect. I would solve this by implementing a causal metadata layer using vector clocks and operation logs, establishing deterministic conflict-resolution rules based on versioning, and utilizing idempotency keys to ensure that partial synchronization failures are safely retried without duplicating state transitions. I can also configure strict tenant isolation, role-based access control, and automated audit logging so the system works fully after completion while maintaining a complete, reconstructable history of every state transition. The goal is to make the system run exactly like a highly consistent distributed event store and ensure everything is tested and stable. And I can help you so on. Thanks.
$10,000 USD in 7 days
0.0
0.0

As an experienced full-stack engineer with a knack for designing robust, scalable SaaS platforms, I offer you the perfect blend of technical prowess and project management skills you require. My deep expertise in Distributed Systems will be critical to architecting a multi-tenant platform with precise tenant isolation and operational across unreliable networks and devices - addressing one of the significant challenges your project brings. What sets me apart from other candidates is my ability to wield complex synchronization engines effectively - a skill that will be paramount in creating your system's core requirement of conflict detection and resolution. Your "Difficult Part" is my passion as I strive never to let any client's offline operations get lost in thin air, perfectly merging them while reconstructing the complete history effortlessly. I understand that this project is about more than just lines of code. It's about crafting a comprehensive solution addressing real-world connectivity issues while maintaining security, performance, and aligning perfectly with your business needs. My promise is to not only deliver end-to-end technical components (from documentation to production deployment) but also provide long-term support as we grow together. Let's turn this challenge into an opportunity!
$5,000 USD in 10 days
0.0
0.0

Mogadishu, Somalia
Member since Sep 26, 2026
₹150000-250000 INR
₹250000-500000 INR
$3000-5000 USD
₹250000-500000 INR
₹12500-37500 INR
₹150000-250000 INR
$5000-15000 USD
₹12500-37500 INR
$5000-15000 USD
$3000-5000 USD
$5000-15000 USD
$3000-5000 USD
₹250000-500000 INR
₹12500-37500 INR
₹150000-250000 INR