this post was submitted on 02 Apr 2025
5 points (100.0% liked)

Hacker News

1160 readers
286 users here now

Posts from the RSS Feed of HackerNews.

The feed sometimes contains ads and posts that have been removed by the mod team at HN.

founded 6 months ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] voracitude@lemmy.world 2 points 6 days ago (7 children)

My problem is that I can't trust it not to hallucinate something that I can't catch it on. If it tells me something wrong, and I don't catch it, that might stick and be really hard to unlearn. It's more like a study guide that's only semi-reliable, and I don't like unreliable information.

[–] HK65@sopuli.xyz 2 points 6 days ago (6 children)

What exactly are you trying to learn by the way? Web dev or more backend stuff? Systems and infra programming?

There are a lot of guided resources that can take you through learning that don't involve generating a lot of random text.

[–] voracitude@lemmy.world 1 points 3 days ago (5 children)

That's probably part of the issue too - no direction. I think I'd enjoy working with databases, so I've been thinking about DBA; I just have no idea what the day to day looks like for a database admin and the unknown is scary. I'm quite familiar with HTML already at an intermediate level, but I think I want to stay away from having to write JavaScript for production, so almost definitely not web dev 😅

[–] HK65@sopuli.xyz 2 points 2 days ago (1 children)

I worked as a DBA for a while, I got into it by getting into a niche database system (Apache Cassandra) at a startup for a PoC and then the local megacorp was desperately needing someone with that experience.

The day-to-day was mostly these things:

  • Organizing and educating outsourced teams in India for routine maintenance tasks, mostly by writing "do this then this" style docs for them
  • Act as L3 support when stuff broke - this one was rare, I was once paid a day of overtime because someone messed up a migration, took the whole global system offline, and I had to sit there see stuff come back again when they fixed it
  • Write automation for automated deployment into Microsoft Azure, imagine writing Ansible code and Terraform
  • Make architecture diagrams and plans and help debug developers' harebrained attempts at using the database for things that it was not made for, but they wanted it on their CV

It was a very slow job, with nothing to do all December - since there was a code freeze - for example. That said, it's essential to understand Linux on a deeper level to be a DBA, like one interview question was "you have a 2TB disk with 400 gigs of data on it, yet the OS is complaining that the disk is full, what is the likely issue and how do you debug it".

[–] voracitude@lemmy.world 1 points 2 days ago* (last edited 2 days ago) (1 children)

Thank you for that write-up! Understanding Linux more deeply isn't a barrier to me. I'm now quite certain DBA is my next goal - it really does sound like an evolution of what I've been doing so far. I'll look around on Coursera for some certs that might convince my current employer I'm serious about helping manage the database.

Also, since it was offered I'll take it as a bit of practice:

  • fsck
  • reserved space (e.g. system files, backups, hidden partition)
  • hidden or deleted files that are in use
  • incorrect mount
  • simultaneous access from multiple mounts (?)
  • Permissions (?)

Question mark against things that seem like possible causes, but I'm not sure if they are. Most of these would probably show the space as used rather than free, but did I miss checking anything major that I wouldn't find with a bit of searching?

[–] HK65@sopuli.xyz 1 points 2 days ago (1 children)

You are bringing up good approaches and you would have been hired if you could explain how you would start to troubleshoot some of those issues.

The answer to the problem that this team ran into was that you can actually run out of inodes in a filesystem if you have a very large number of relatively small files, and that might show up as failed writes that can make a program like a DBMS say "the disk is full".

Regarding getting hired though, I have no idea about the market and pay nowadays especially wherever you are. I hope it's good for you, it was certainly good for me in the 2010s in Eastern Europe, but I've heard it's shit everywhere these days.

[–] voracitude@lemmy.world 1 points 1 day ago (1 children)

Thank you! One more question: "explain" has always tripped me up. How much detail is necessary, vs too much, for a technical interview? Because in my mind "fsck" is self-explanatory, as would be "check the inode count". Should I cover everything like I'm explaining it to a new user, or is there a baseline skill level I'm expected to address?

[–] HK65@sopuli.xyz 1 points 1 day ago

Usually what I would do is start with a baseline summary, and then either dive into a step-by-step on how you would go about solving the problem, or just ask if they want a deeper explanation.

The big secret of tech interviews I found was that if the interviewer should actually be on your side. From their perspective, the point is to fill the vacancy as soon as feasible and if you can't cut it, they will have to sit in the same chair yet again. If you are not sure what kind of answer they need, like "Should I cover everything like I’m explaining it to a new user", you can just go and ask them, they should be happy to help. To me, it would even present professionalism, that you are trying to tailor your response to your audience.

Of course, there are always going to be weirdos who when they get the thinnest veneer of power, will either mess with you for the sake of it, or "show off their 1337 h4x0r skillz", but my advice to that is that just stay unfazed, and do your best.

And all in all, it's going to be a numbers game, in every interview round. Rejections don't mean shit when HR departments insist on collecting hundreds of CVs before calling in and hiring the person who applied first anyway. Even if you get in, and don't get selected, it doesn't even mean that the other candidates were better, it's just someone jumped the bar earlier. Keep trying and good luck! BTW feel free to bother me with stuff relating to this, I'm happy to answer if I can.

load more comments (3 replies)
load more comments (3 replies)
load more comments (3 replies)