• Weirdest interview I ever had was 4 hours long. They flew me out to their city, put me up in the local Hilton, rented a car for me for the day, and took me out to lunch as part of it, but then, during the interview, it went like this:

    Manager draws some boxes and lines on a whiteboard, tells me it's a diagram of the company firewall and DMZ, and asks me what's wrong with it. I tell him I don't know, I'm a DBA, and don't normally configure firewalls and DMZs. There have always (in my prior jobs) been other people who handled that. He spends the next 15 minutes asking me things like, "so you've never worked for a company with a data-driven web-presence?", and grilling me on firewalls, DMZs, load ballancer and other external security measures, despite my answer to pretty much every question being "I don't know. I'm not familiar with this particular subject."

    A while later, after some softball questions about things I could actually answer, their Oracle DBA (they use both products) gets up, draws a diagram on the whiteboard, with backup plans and some basic ETL flows. It was pretty clear that it was missing log backups on key databases, and I expected the question to be something like "what's missing here". Instead it was, "So, we don't do log backups on our mission-critical data. Under what circumstances would that be okay?"

    I replied with some options about recovering data from ETL sources, possible use of replication or mirroring instead of PIT-restores, and a few essoteric possibilities that were "out there" a bit, but possible. It turned out the answer they were looking for was "It's okay to lose mission-critical data if you don't have enough disk space for the log backups". That's not really how they worded it, but that's what it boiled down to.

    I hope, to this day, they were just trying to get a shock reaction out of me. I think I did stare at him for a few seconds with my eyes a bit wide. I don't think my jaw actually physically hit the floor, but it may have.

    (As a note, data is either mission-critical, meaning losing it would critically harm the business, or it's non-mission-critical, and losing it is business-acceptable. Can't be both ways.)

    It gets better.

    At the end of the interview, as always, I was asked if I had any final questions. Every interview ends that way, right? So I did my usual, and asked, "Am I leaving you with any questions or concerns about my ability to do the job we're talking about here?" The answer was, "Well, you seem pretty arrogant. Have you ever made any friends?"

    It gets better.

    They made me an offer about 10 minutes later, while I was driving back to the airport to fly back home. A very high-pay offer, and generous moving/relocation expenses.

    (I turned them down. Between the weird questions, and some distinctly odd behavior while we were at lunch, they could have offered twice what they did and I still would have turned it down. But definitely an "interesting" interview.)

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon