SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Interview question :critical issue faced by dba


Interview question :critical issue faced by dba

Author
Message
vsamantha35
vsamantha35
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1669 Visits: 719
Hi Experts,

I need some guidance on this.

Recently I have attended a job interview for sql server database administration and was asked to speak about one of the critical issue you have faced as a dba. I have explained of one of the issue I had faced in my environment. I spoke of database was suspect and I was able to recover from backups and I have explained the root cause of the issue stating that it was disk issue which caused the problem and told that we replaced the disk and we are able to restore the tlog backups + taillog backup and I was able to bring the database online.

I don't know why the interviewer wasn't impressed with the answer.

I want to know from exceptional dba's, normally when they ask such questions, what kind of answers or scenarios are they looking for ?

Appreciate your inputs.
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)

Group: General Forum Members
Points: 98061 Visits: 33014
A safe recovery from a possible outage is a great story. I'm not sure why they were unimpressed. Maybe it was delivery. Maybe they were hoping for something more spectacular. I haven't been asked that question, but I can talk through a number of bad days as a DBA, what we did wrong, what we did right, what was changed in the process. Maybe you needed more drill down along those lines.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
quackhandle1975
quackhandle1975
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4208 Visits: 1242
vsamantha35 (7/3/2014)
Hi Experts,

I need some guidance on this.

Recently I have attended a job interview for sql server database administration and was asked to speak about one of the critical issue you have faced as a dba. I have explained of one of the issue I had faced in my environment. I spoke of database was suspect and I was able to recover from backups and I have explained the root cause of the issue stating that it was disk issue which caused the problem and told that we replaced the disk and we are able to restore the tlog backups + taillog backup and I was able to bring the database online.

I don't know why the interviewer wasn't impressed with the answer.

...


Have you tried to contact the interviewer to find out why he wasn't impressed with your answer? That would be my first action.

qh

Who looks outside, dreams; who looks inside, awakes. – Carl Jung.
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)

Group: General Forum Members
Points: 98061 Visits: 33014
quackhandle1975 (7/3/2014)

Have you tried to contact the interviewer to find out why he wasn't impressed with your answer? That would be my first action.

qh


That might not work well. Back when I was doing lots and lots of interviews, I never communicated directly with the interviewees. And, even when we got requests for feedback, legal required that we simply say that the person didn't fit our needs at this time.

If you can get it, great, but I would assume you'll never hear back.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Beatrix Kiddo
Beatrix Kiddo
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6875 Visits: 4830
Perhaps they try to look neutral during an interview?

I'm definitely not calling myself an exceptional DBA, but it's an interesting topic. I think your answer sounds fine, but maybe they were also looking for you to develop your answer a bit further, and show how you have changed policy and practice where you work, to try to mitigate against the chance of it happening again (rather than simply being reactive).
quackhandle1975
quackhandle1975
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4208 Visits: 1242
Grant Fritchey (7/3/2014)
quackhandle1975 (7/3/2014)

Have you tried to contact the interviewer to find out why he wasn't impressed with your answer? That would be my first action.

qh


That might not work well. Back when I was doing lots and lots of interviews, I never communicated directly with the interviewees. And, even when we got requests for feedback, legal required that we simply say that the person didn't fit our needs at this time.

If you can get it, great, but I would assume you'll never hear back.


Fair point, yes interview feeback can be a libelous minefield! The OP 's question is a tad vague and was just trying to ascertain why he thought the interviewer was unimpressed.

qh

Who looks outside, dreams; who looks inside, awakes. – Carl Jung.
vsamantha35
vsamantha35
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1669 Visits: 719
I did tried to follow up with HR couple of times via email requesting for feedback. No response.

Again, as Grant mentioned I should have dig more deeper and make up a story and should have mentioned that to be proactive, i had setup alerts for corruptions errors , turn on page verify to checksum , configured dbmail... so on and so forth.

But thanks your inputs. I can do better for future interviews. Special thanks to Grant. Thank you all.
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)SSC Guru (98K reputation)

Group: General Forum Members
Points: 98061 Visits: 33014
vsamantha35 (7/3/2014)
... make up a story ...


Let me first assume this is just an "English as a second language" moment and point out that "make up a story" would mean to invent one, to imagine a scenario. So, assuming that's not what you mean, I'd just advise you to not use that phrase in this area.

Now, let's also assume it is what you meant. Don't! If you just make up a story, a good interviewer is likely to spot it. Heck, even when I make up stories for some of the fiction articles I write, I base the technical stuff on things I've actually seen and done. They need to know what you know and understand what you've done and how you've done it. They're not hiring you for your ability to make up a story. But, the ability to tell a story with lots of details is something they are hiring your for.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
vsamantha35
vsamantha35
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1669 Visits: 719
Hi Grant,

Don't take me wrong. I apologize if I used a wrong language or words. I used those lines , so that I need to explain it in more detailed and in terms of business impact and HA perspective. Once I am back from the interview I felt that I explained him in a very straight forward way...

Sometimes, I get the impression that the interviewers are expecting specific answer what they faced in their specific env and if they arent getting the answer, they start judging the people that this person doesn't know sql. I have also seen situations where the interviewers are so bad that they have already selected a guy from his circle and taking interviews just for the sake of taking the interview.

My personal take on this is, I would expect interviwer check the basics and take it from there. Try to grab as much info what the candidate knows abt sql server and should see the approach she is taking and not looking for answers!!
Again this is compeletely my personal opinion...
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)

Group: General Forum Members
Points: 66341 Visits: 18570
vsamantha35 (7/3/2014)

Sometimes, I get the impression that the interviewers are expecting specific answer what they faced in their specific env and if they arent getting the answer, they start judging the people that this person doesn't know sql. I have also seen situations where the interviewers are so bad that they have already selected a guy from his circle and taking interviews just for the sake of taking the interview.



I would agree with some of that. I have seen both problems as an interviewee.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search