Back-End Engineer (Database): design scalable database for a sports app
AnthroposThe company’s flagship app must handle 10 million users and peak loads of 100,000 concurrent users.
Current AWS cloud services face scalability and cost challenges during peak usage, risking reliability and growth potential.
Your goal is to propose a secure, scalable, and cost-effective database solution within a $2 million budget.
Your Role
You are an IT consultant specializing in database architecture for Sports App Database Solution, a fitness technology company.
Other participants
Context
Sports App Database Solution is a medium-sized tech company specializing in fitness technology. Its flagship sports app aims to redefine the market by addressing critical user needs, such as real-time performance analytics, seamless social sharing, and compatibility with over 50 tracking devices, including wearables like Garmin. The app is designed to handle ambitious usage metrics, including a projected user base of 10 million within the first year, with peak concurrent users exceeding 100,000 during major events like the Boston Marathon.
The company currently relies on AWS cloud services but faces challenges with scalability and operational costs during peak loads. To address these issues, the CTO, Elaine Taylor, is leading efforts to design a database architecture that prioritizes scalability, reliability, and data security, while staying within a $2 million budget. The solution must also anticipate future growth, such as live-streaming workouts and AI-driven analytics, ensuring compliance with GDPR regulations and supporting advanced features.
You will step into the role of an IT consultant specializing in database architecture. Your task is to advise the CTO, Elaine Taylor, on designing a scalable, secure, and cost-effective database solution for the company’s ambitious sports app. Through a one-on-one real-time chat, you will analyze the company’s requirements, constraints, and future growth considerations. You will then propose and justify a tailored database architecture solution, evaluating SQL versus NoSQL approaches, addressing trade-offs, and aligning the proposal with technical and budgetary priorities. Your ability to communicate clearly, prioritize key considerations, and defend your recommendations will be critical to shaping the company’s technical strategy.
- Engage in a real-time chat with Elaine Taylor to understand the company’s requirements and constraints.
- Analyze the technical and budgetary needs to identify key priorities for the database architecture.
- Propose a specific database solution, justify your choice between SQL and NoSQL, and address Elaine’s concerns about scalability, security, and cost-effectiveness.
- Demonstrate clear communication and decision-making skills by defending your recommendations and aligning them with the company’s goals.