CREATE BLOG dbo.SqlServer

I recently was asked to help someone prepare for a job interview and, during our discussions, I came up with a list of a few job interview questions that might be asked of a junior-level database administrator (DBA). Instead of posting them all at once and not being able to answer them(it's a mighty long list), I'm going to post them individually so that I can give the answer(s) that I would like to hear if I were the interviewer. It's going to take a while to go through all of these - there are over 30 questions total - so to read them all, you'll have to go through each post.

Now, these are *my* answers and this is what *I* would look for so I can't say at all whether or not these are the answers that someone else would want to hear. The more you understand the nuances of the question, the better you can tailor your answers to what the interviewer wants to hear.

What? You didn't like that last part? Well that's what it's all about, isn't it - giving the interviewer the answer they want to hear? We're talking about a junior-level DBA position here - not a senior-level person who has 10 years experience and whose skills are extremely desirable by just about anyone - they can pick and choose the job they want. Someone wanting to break into database administration at the junior-level cannot be so picky all the time...

I'm going to break these into different sections:

• Datatypes
• Normalization and Relational Theory
• Table Design
• Disaster Recovery
• Importing and Exporting Data
• Queries and T-SQL Programming
• Database Administration
• and more.

Stay tuned and we'll get started with our first post!

# posted by Scott Whigham @ 8:51 AM