question

skorasika avatar image
skorasika asked

what are the critical issue you faced as a dba

Hi All 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.
interview-questions
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
Most of the days, crazy things won't happen. But when they do, it's your job as a DBA to have planned also for an unexpected scenario. You should plan for most scenarios, have routines for them and most importantly test your routines by simulating the unexpected events. If you do that, unexpected events (even those which you do NOT have routines for) will appear less critical. There will Always be a DBA who have experienced cooler disasters than yourself. But that's not really a measure of how good a DBA you are. If you know that your routines are slightly better than your SLA, you'll have the ability to stay calm during what might seem to be a disaster to someone else. I would want to hire a person who can do that. Not necessarily a DBA who have experienced an explosion in a datacenter :)
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.