RE: Case study for interviewing Oracle DBA

Hi,

IMHO, if you want to hire a JUNIOR dba that is because you have the idea = to give a specific formation to this person, so most that thecnical = skill, I'd look for attitude skills, I know the person needs some basic = oracle skills, but most of all, you need to look for a person who is = really trying to change the word "junior" for "middle" or "senior" on = his/her resume, on some months/years.

Here are a few sugestions:

Look for the following skills:

• Knowledge on basic oracle concepts (That's what junior's know, is up = to you determine the level and depth of this point)
• Commitment, (are you aware a dba has to work afterhours or weekend for = maintenance tasks, backups, etc?)
• Documentation skill, (a dba who knows how to document is an ordered a = logical thinking person)
• What do you do when you don't know how to solve something? Where do = you look? What are the steps you follow? What resoruces you know? Who do = you ask for help?
• Self learning attitude. How do you plan to become a middle-senior DBA?
• Interact and share with team members. (are you a team role player? how = do you achieve this?)
• Ability to work under pressure. (attitude to deal with many users = screaming to you when the db is down)
• Pro-active, identify needs and problems and provide solutions. (what = do you do to achieve this?)

regards,
GAP -----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Shannon St. Dennis Sent: Viernes, 25 de Febrero de 2005 02:22 p.m. To: oracle-l_at_freelists.org
Subject: Case study for interviewing Oracle DBA

We are currently starting the process of interviewing/hiring a junior dba.
=20
My boss would like me to come up with a small case study (1/2 hour or less - no reference materials) to help determine the actual level of experience the applicants have.
=20
The interview plan is :
=20
Applicant comes in and is given the case study to work on for 1/2 hour.
After the 1/2 hour, interview starts. During the interview, the applicant will have to present his/her case study. =20
Does anyone have any ideas on a good simple case study example? =20
Shannon St. Dennis
Database Administrator
City of Regina
(306) 777-7415 (phone)
(306) 777-6804 (fax)
sstdennis_at_regina.ca
=20
The degree of normality in a database is inversely proportional to that of its DBA

DISCLAIMER: The information transmitted is intended only for the addressee and may contain confidential, proprietary and/or privileged material. Any unauthorized review, distribution or other use of or the taking of any action in reliance upon this information is prohibited. If you received this in error, please contact the sender and=20 delete or destroy this message and any copies. =20

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l