I found the SB Navigator plugin solved the weirdness of navigating a schema. I've been using DataGrip for Oracle and MySQL a lot lately and absolutely love it!
Honestly, I really love it. Yea, there can be insane deadlines and it can be frustrating work, but it's so satisfying overall. In my job, I get a lot of freedom to do my own things here and there, and we're getting into a major rewrite of internal systems to use Azure. Currently it's a huge amount of fun.
If there is a bug list handy, I find tackling a few small ones is often an excellent way to get to know a codebase. It also gives some good insight into the codebase's quirks and oddities.