Wouldn't their description describe a Computer Operator not a DBA ... hence
Database Administrator administers/maintains the database ... this being
said they have to understand the database which includes / starts with the
schema.
William H Morris
Manager of Recovery Services
Information Management Solutions
(541) 752-5500 x 310
-----Original Message-----
From: Nicolas de Fontenay
[mailto:oracledba-ezmlmshield-x18326025.[Email address protected]
Sent: Tuesday, May 29, 2007 5:12 PM
To: LazyDBA Discussion
Subject: RE: DBA Interview Questions part 1
My god.
I wish I could ask this kind of question to a DBA.
In Thailand the first thing I ask is whether he knows what a schema is
:(
When we have been putting this kind of skills in our offer to a big
recruiting company they called us to say it was confusing (because it
looks like a mix of developer and sys admin too). When we asked them to
describe us what a DBA would be, they said it was someone to take the
tapes in and out (basically)...
We are still looking for this position -_-
Nico
-----Original Message-----
From: Sangster Simon
[mailto:oracledba-ezmlmshield-x58671658.[Email address protected]
Sent: Tuesday, May 29, 2007 8:44 PM
To: LazyDBA Discussion
Subject: RE: DBA Interview Questions part 1
Well that would be me failing lol :)
-----Original Message-----
From: Chalkline Margaret M (US SSA)
[mailto:oracledba-ezmlmshield-x1566954.[Email address protected]
Sent: 29 May 2007 14:41
To: LazyDBA Discussion
Subject: RE: DBA Interview Questions part 1
Hi Gordon,
Here is a rough compilation of the answers I got when I asked the LZDBA
group what questions we should ask a person who we are interviewing.
Thanks again to everyone who answered about a month ago.
Maggi
For a person who really claimed to be worked as DBA ask
* The procedure of installing oracle patches
If I am looking to hire an experienced dba, an area that I question is:
1. How many members do they usually put in a Redo log group?
2. to describe the process of changing the size of the Redo logs.
These two questions helps me to discover if they actually understand
what Redo Logs are for and how to manage them.
1. How would the DBA go about converting to a single database instead of
the fifty?
2. What would be the steps to ensure recovery of these 50 databases?
3. How to get out of the 8i environment? -- I know your company has the
most critical applications running on 8i and the COTS vendor has gone
out of business.
4. Why should not everyone get the DBA privilege? or root?
5. Why should the company actually do anything in MySQL?
5+ years experience
A) installing, upgrading, and supporting Oracle database software
B) Associated Oracle Technology stack in a multi-tier environment such
as database/applications/wed/reports, and optional/other server
environment
C) 10g, 9i product versions in UNIX environments is a must.
D) configuration, load balancing, backup/recovery, sizing and space
management, PL/SQL tuning, diagnostics, OEM and other tools.
E) Creating/managing/resolving Oracle TAR's
You can ask them to describe the steps they used the last time they
restored a database? This would provide an idea of whether or not they
have and could restore a database
How and when would they use partitioning? Tells a little of what they
know about partitioning
What sources other than Oracle Metalink do they use for reference?
Tells how resourceful they are.
What Oracle books do they have in their library? Tells if they are
continuously trying to learn on their own, the only way you can keep up.
I usually start with a real life scenario such as; a developer just came
up and said this query normally runs 15 minutes and today it has been
running for an hour and a half. Describe what you would do to see if
you could determine what might be causing the problem? Shows the
approach they take to problem resolution, tells whether or not they can
help a developer with a problem.
I have a friend who believes the best question is to ask them to diagram
on a white board the internal processes that Oracle goes through to
update or delete a record. Only heavy weights are likely to be able to
handle this one.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
************************************************************************
**
IMPORTANT NOTICE
This e-mail may contain information that is privileged, confidential or
otherwise protected from disclosure. It must not be used by, or its
contents
copied or disclosed to persons other than the intended recipient(s).
If you have received this e-mail in error, please notify us immediately
at
[Email address protected] and delete this e-mail from your system.
Any liability (in negligence or otherwise) arising from any third party
acting, or refraining from acting, on any information contained in this
e-mail
is excluded.
It is the responsibility of the recipient to ensure that this message
and its
attachments are virus free. UAP Limited are not responsible for any
reliance
placed on the information contained in this e-mail and excludes all
liability.
************************************************************************
**
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page