	AllExperts > Oracle
	Search

Volunteer
Answers to thousands of questions

Home · More Oracle Questions · Answer Library

· Encyclopedia ·

Oracle - about interview

Expert: Peter Choi - 6/4/2006

Question
Hi peter choi,

How are you. This is nageswara rao Bollu.

my qualification is m.sc(chemistry), and i did

post graduate diploma in computers . I want to

become a good ORACLE DBA. What type of course

i have to take and in what way i can prepare

for interviews and how can i exist in the

project and i have no personal computer

at home , is there any need to use personal

computer for practice ON UNIX. I have knowledge

on windows NT.I Know 0racle 7.3 version. what

versions i have to update. is there any need to

learn data ware housing and application dba.

communication point of view what can i improve

if you don't mind please send your

experiences those are useful for me and also

send me some suggestions to become a great

Orcle DBA So that i hope great thankful to you.

REGARDS,.

NAGESWARA BOLLU.

Answer
Good day sir,

To become an Oracle DBA, you need to understand the functionalities and capabilities of Oracle 9i and/or 10g RDBMS. These are the two most current and widely used Oracle Database software world wide. There are only a smaller subset of Oracle 7 and 8i users.

A good DBA must be very fluent in the following functional or technical area:

- Basic Database Administration (i.e. have the skills and abilities to maintain an existing database, including backup, recovery, creating new databases, archiving, tuning the database, monitoring for growth, sizing and storage estimation, etc.);

- SQL (i.e. be capable of wriuting simple and complex SQL and PL/SQL);

-Performance and Tuning. You must be capable of understanding the perfomance impact of a given SQL and be able to tune it using tools such as EXPLAIN PLANS, TKPROF and/or other thrid party tools. You must be able to trouble shoot and help re-rwite some ofthe queries if required. Sometimes, you may need to create an index instead.

If you want to specialize in specific fields, then you can look into Data Warehousing, Portal (with Oracle Application Server); Reporting, front end development (using JDeveloper), Discoverer (Business Intelligence / data mining), etc. I would make sure that you have the fundamental background before embarking on such specialzed areas.

There are many self-learning text books that you may purchase, borrow from you local library, online (www.orafaq.com is a great place to start; and otn.oracle.com is the official repository of all Oracle documents).

It is preferable that you get some ahnds-on practice with Oracle before you goto any ofthe interviews. Interviewers look for knowledge, skills and most often expereience. A DBA must be able to handle him/herself in a stressful environment.

I hope this gives you some ideals. Hope this helps.

Peter

Add to this Answer Ask a Question