Q

Oracle DBA interview questions

A SearchOracle.com user asks what questions they can expect in an interview for the position of a DBA.

I have two years of experience in J2EE and PL/SQL technologies. I recently completed my Oracle 10g (OCA) and (OCP) database administration certifications. I have an interview next week for the role of DBA. What are the possible questions I can expect?
Unless this is an entry-level DBA position, you can probably expect a lot of questions about your lack of experience as a DBA. Having the certifications will certainly help you combat this with the fact that you are well-educated and well-versed in database administration. However, you may encounter a lot of real-world type questions designed to trip you up. For example, "Explain how you would go about escalating an iTAR with Oracle" or "Describe a time when you had to recover a database." You might be able to combat the latter with your knowledge and describe a scenario when you would need to recover and how you would go about it.

On the non-technical skills end, you may encounter questions like:

  • Describe your strengths.
  • Describe your weaknesses (often the hardest to talk about).
  • Talk about a time when you went above and beyond to succeed.
  • Talk about a time when you failed. What did you learn?
  • Why did you / are you leaving your current job?

For more advice, you can read my series on becoming an Oracle DBA here at SearchOracle.

I hope this helps and good luck!

This was first published in May 2008

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close