I don't understand how ACID (atomicity, consistency, isolation, and durability) critical systems, like banks, can agree and decide what my account balance looks like at any given moment? Or is my bank account actually just a single SQL database row somewhere with no read/write replicas?
I have recently joined a team of scientists where my job is to help them do their work efficiently. There's a lot of inefficiencies in what they do, but also a ton of external dependency. I am having a hard time wrapping my head around everything and struggling to understand what projects/solutions to come up with to solve their long term problems. Should I start with automating small redundant tasks? I fear that I will miss out the bigger picture that way. Do I be patient and let the ideas come to me naturally? I feel like the other SDEs on the team already have sort of "taken" the "big" obvious projects. I'm worried that I'll be unable to have my own impactful project and will be left doing small tasks.