Hacker News new | ask | show | jobs
by web3-is-a-scam 725 days ago
Yes. I’d consider myself an “intermediate” DBA but I can command an insane salary and I have people tripping over themseves to hire me.

Nobody cares about SQL until it takes 15 seconds to load your user facing login dashboard.

3 comments

100% this. I heard a fun saying when I became a professional dev:

“When you’re fed up of keeping up just retire in to SQL, it’s the best pension there is”

What level of optimizations do you normally need in those cases? Just adding an index, removing subqueries or something more complex?
“it depends”

but in all seriousness, it depends. adding an index. removing/consolidating indexes. breaking the queries down into individual UoW and forcing intermediate materialization. identifying platform-specific optimization barriers. rearranging sufficiently complex query semantics to force behavior you expect.

99% of the cases i’ve personally had to resolve over the last 15 years have been the result of sql hero queries that try to do everything all at once. this is exacerbated by orms that generated bad sql but was acceptable at low cardinalities. under scaled-up concurrency and data volumes they can’t deliver the necessary performance anymore.

Where do you find insane salaries for DBAs?