RE: DBA Interview Questions

You'd think so. I reviewed 9 resumes today and they have everything but = the kitchen sink in them. I had to make a spreadsheet and score them on = what I thought was important for my shop which was none of the below = with the exception of Enterprise Manager. If you are an Oracle DBA I = hope you could handle OEM.

Everything you mentioned below was in these guys resumes.=20

What I thought was important was:

Certification - We have a common body of knowledge that Oracle thinks is = important. I don't know that it is all important but Oracle thinks so. Data Warehouse - Very different from OLTP. Many Oracle features only = make sense or are useful in DW. You have to know which ones. Routine Prod DBA work (hands on). When you read enough resumes you can = tell who does it and doesn't. One guy never once mentioned tuning or = backup and recovery. He was all about facts and dimensions, = requirements, modeling etc. Thats not who I want in here on a weekend = trying to recover our database.
Physical/Logical - Can actually design a database or can implement = something someone else had designed. Can insert a reality check into an = architects plan.
Windows (nice)- No ksh, csh, etc, needed. Can you edit the registry? = Manage services? Locate and read the application logs? Informatica (nice)- Common frame of reference with Informatica = developers.
Cognos (nice) -=20

-----Original Message-----

From: Lyndon Tiu [mailto:ltiu_at_alumni.sfu.ca] Sent: Wednesday, November 24, 2004 4:21 PM To: dofreeman_at_state.pa.us
Cc: ryan_gaffuri_at_comcast.net; Oracle-L (E-mail) Subject: Re: DBA Interview Questions

Question:

If one is an Oracle DBA, does this mean the person is expected to know:

PL/SQL
9iAS
HTML DB
ISQLPlus
XSQL
Enterprise Manager
Designer
Forms
Reports
11i
(essentially everything Oracle)

or just the plain Oracle database alone?

--

Lyndon Tiu
--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 24 2004 - 15:30:19 CST