Firebase Database Refactoring Specialist (Multi-User CRM)

# Firebase Database Refactoring Specialist (Multi-User CRM) ## Project Overview We have an existing CRM system for a sports club built on Firebase. The current implementation stores most of the application data in a single database document/file, which causes data conflicts when multiple users are working simultaneously. We are looking for an experienced Firebase developer to redesign the database architecture to support multiple concurrent users without data overwriting or synchronization issues. ## Responsibilities * Analyze the existing Firebase database structure. * Refactor the database from a single large document into a scalable collection/document architecture. * Split data into logical collections (Members, Invoices, Attendance, Payments, Coaches, Classes, etc.). * Ensure multiple users can update different records simultaneously without conflicts. * Implement atomic operations using Firebase Transactions or Batched Writes where required. * Optimize read/write performance and reduce unnecessary document updates. * Apply proper Firebase Security Rules. * Update all affected CRUD operations. * Maintain backward compatibility where possible. * Test concurrent access with multiple users. * Document the new database structure. ## Technical Requirements * Strong experience with Firebase Firestore. * Experience designing scalable NoSQL database structures. * Knowledge of Firebase Transactions, Batched Writes, and offline synchronization. * Experience handling concurrent user operations. * Experience optimizing Firebase performance and minimizing read/write costs. * Ability to work with an existing codebase. ## Expected Deliverables * Refactored Firestore database architecture. * Updated application code using the new structure. * Zero data conflicts during simultaneous edits. * No data overwriting between users. * Improved performance and scalability. * Documentation explaining the new database design. ## Nice to Have * Experience building CRM or ERP systems. * Experience with sports club or membership management systems. * Knowledge of Firebase Cloud Functions. * Experience implementing audit logs and change history. ## Success Criteria After completion: * Multiple staff members can use the CRM simultaneously. * No user can accidentally overwrite another user's changes. * Database operations are faster and more efficient. * The system is scalable for future growth. * All existing features continue to work correctly after migration. Please include examples of Firebase projects where you redesigned or optimized Firestore architecture for multi-user environments.