System Design Interview: Software, DB schema and API design

5.0(3)
W. Ian Douglas
1h 10m
System Design Interview: Software, DB schema and API design
About this listing

One-hour system design problem for software-based system design, such as planning out one or two software services, API design, etc.

Talk to your recruiter about what kind of system design you should expect for your interview to choose the right session with me. If you are expecting an infrastructure-based system design (eg, planning out multiple services, databases, queues, etc) then you should book a different session with me.

I'll work with you through one of several unique system design prompts of things I've actually built over my career in the tech industry. The interview will focus a lot on critial thinking and asking the right kinds of requirements gathering, maybe a bit of database schema design. We might get into optimizations and capacity planning as time allows.

I've conducted over 2,000 mock interviews over the past 7 years, including system design for backend AND frontend/mobile developers. I've been a lead technical interviewer since 2007, an industry programmer since 1996, and I've been a software educator since 2014. I can switch from "interviewer" to "coach" if you need more mentoring. Send me a message ahead of time on the platform if you'd like more of a "coaching" session.

In this session, we'll spend a few minutes on introductions, I'll find an appropriate challenge for you based on your goals, we'll spend about 45 minutes on the system design, and a few minutes on verbal feedback. All notes I share verbally are also provided in written form as well.

You can connect with me on LinkedIn, Twitter and Twitch with the username iandouglas736.

About the Provider
Interviewing since 2022
113 reviews
Block
United States
Working in the industry since 1996 in DevRel/Full-Stack/DevOps/DBA/SRE roles, also been in several manager/director level roles in charge of hiring and building interview teams. I've been interviewing people for 15+yrs, conducted 2300+ mock interviews on platforms like this, and live-stream regularly on interview preparation, behavioral questions, resume reviews, and more at twitch.tv/iandouglas736
5.0(3 reviews)
Vincent Buscarello
5.00
11th Mar 2025
Very helpful!
Ri t
5.00
16th Apr 2024
Great feedback!
Gloria Wang
5.00
6th Feb 2024
2nd session with Ian already, great coaching / feedback already. Ian is super knowledgable about API design & best practices :)
$125.00
Choose a date to see available time slots
Mo
Tu
We
Th
Fr
Sa
Su
Time zone

Available time slots
7:30 PM to 8:40 PM
8:00 PM to 9:10 PM
8:30 PM to 9:40 PM
9:00 PM to 10:10 PM
9:30 PM to 10:40 PM
Cancellation Policy
• Cancel within 24 hours after the booking is accepted to get a full refund.• Requesting for a reschedule is free.Learn more
Any doubts on the interview? Let's talk