RE: RE: How do you conduct technical interviews ?
Date: Fri, 15 Aug 2008 09:19:24 -0400
I'm the only DBA for years and therefore I must have done all this stuff with the help of a lot of SR's and perusing forums and blogs (given time).... but I probably wouldn't stand a chance in your interview.
Dedicated, yes.,,, but the deer in the headlights thing is something I don't like... better suited to avoiding the emergency in the first place...
Perhaps I could get the job done... but just don't see myself coming out of your hiring process with all my feathers in tact.
:) Sure hope I'm not to self deprecating.... but it kind of sounds like the interviewee needs to declare that they will work 10, 12 or 24 hours/day, or whatever it takes, in high pressure for ever.... Perhaps work and life need a balance, and if there were two opportunities available, the good DBA might just choose a possible wife and kids to go along with life.
In my experience the more you get paid the less you do... :) Don't take that the wrong way, you get paid what your worth, but I've scrapped grease off of fast food restaurant floors for minimum wage, and its harder than being a dba, (among other jobs). From your standpoint obviously you want the best and no slacker.... but .... the best have choices.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of caseydyke_at_optusnet.com.au
Sent: Thursday, August 14, 2008 7:29 PM
Subject: Re: RE: How do you conduct technical interviews ?
It's rare that I get to keep up w/these list these days but the mail still flows and occassionally i have a peek. i'm responding to this thread b/c as a manager of a group of dba's, it's quite important to me and something i am pretty opinionated on.
we work in a reasonably high end environment for a very visible entity here in Australia. lots of big systems, big projects, big pressure and so on. we are highly projectised and delivery focused. we work in between networks, storage, OS and development groups. that's probably like quite a lot of groups out there, nothing out of the ordinary.
but what i feel as a hiring manager is it is *very* hard to find (i think reflecting the sentiment of the original poster) _that_ dba. you know, the one that goes the extra mile, doesn't faff around, gets the job done, takes it seriously.
over time i've managed to build an eclectic team makeup that meets our needs. but it hasn't been easy. i've turfed a number of dbas (we're all contractors so "turfed" (or boned in local nonmenclature) simply means no renewal) b/c their performance wasn't what i and the business required.
and so often i find people in interviews that are db "administrators" only. a lot know nothing about modelling. a lot really know nothing about development, storage and even core OS issues. certainly not all, but a lot. i also find some really just not good enough in a generic IT sense. limited peripheral knowledge.
mind you, some people that had that broad mix, simply did not perform. lots of good peripheral knowledge, but man o man delivering a project on time was just impossible. another example is of fantastic out of left field technical knowledge, but hopeless time management. leaving me picking up project pieces w/my head in my hands, yet reluctant to rant b/c i know the individual has "that idea" just waiting in the back of their head. i had one quite unique situation where i was told "my 4 hours are worth 8 from others". so late arrivals, long lunches and early departures were the norm. you're joking right? nope. boned.
maybe i am describing standard mgmt, but the main point is -- there is no silver bullet. it takes time to build a team and even the best hiring questions/practices might not be enough.
what i do look for is years in the game, peripheral knowledge and/or interest, detailed knowledge (yes, for what we do -- i expect this), SDLC understanding, programming of some nature, source control (!! geez i've banged my head against the wall b/c people just "bung" code in) opinions (opinions are very important to me), OS, storage and network knowledge. and a sharp troubleshooting ability/ethos. that's key too. lastly, commitment. define it. what does it mean to you. people w/out commitment don't work too well in our shop and i dare say we're not unique! quite often in interviews i go on gut feel. i rarely go in "prepared", i just fire away. we never do less than 2 interviews. and i always let other team members have a say. and more and more i am less dba question oriented (tell me about the FRA) and more peripheral question oriented (ie: describe, in reasonable detail, the ideal network setup for a 3 node rac cluster).
OCP doesn't play much of a role for me. it's *very* easy to determine what OCP means to a candidate. if someone looks me in the eye and says, "look, i got the OCP to challenge myself and ensure i kept up w/11g new features". bingo. that's it. very very very easy to determine whether it means anything. i've always been amazed at the hollow debate it initiates. to me it indicates motivation in the *right* candidate. little else in "other" candidates.
dunno if that helps and it's pretty long-winded so if you've made it down here, maybe it did. best of luck.
> Henry Poras <henry_at_itasoftware.com> wrote:
> I'd drop the experience part too. I've worked with DBA's with 5 years,
> years experience who learnt everything they knew in their first 3-6
> I've worked with DBA's with less than 1 year experience who were great
> knew a lot about handling problems. It all comes down to the person.
> opinion using OCP and experience as hiring criteria is just a CYA
> (it's not my fault they didn't work out, they had OCP and 10 years of
> experience). Experience (and even OCP) can be of benefit, but until
> more about the candidate you just can't tell.
> I like open ended questions (on going work issues???) just to see how
> would approach the problem, what different options they are aware of.