Starting to feel like a parrot since I’ve recommended this book a few times already on HN but Designing Data Intensive Applications [0] is a great starting resource. I’m not affiliated in any way just a happy reader.

[0] https://dataintensive.net/