Thank you very much , Dennis and Alberto
I have compiled answer for my question.Please correct me or make it more meaningful
- which type of things you will analyze about the database from your previous dba...when he is leaving and you are coming into the picture?
- Get the list of databases running
- Get the sys password of each database.
- Get the list of schemas available in each database.
- Must get the schema architechture and an overview of it.
- Backup plan and Schedule,Storage information,
- Try to know which type of disasters are happend with DB,It might happen again so is there any documents abt this?
- what you will do first when you join into the job regarding the database?
- Get the feed back from users regarding database performance.
- Enlist the weak performing areas either at report side or forms side.
- Get a general overview through v$system_events, v$sysstat view.
- More precisely generate a statspack report and study it throughly.
- What type of reports you can give to(Project Manager) about Database?
- Give a performance overview of the databases to ur proj. manager.
- Possible causes of performance issues like bad SQL, shortage of memory etc.
- Capacity Planning,Growth analysis,DB health report
- what type of documentation you will keep as a dba about project?
You must keep the schema design documents, the data entry ratio on every object. Your recommendations, whether the object should be Cluster or IOT etc.
- if new project came to your company..how can you planned and designed the database and what type of reports you will give to your project manager?
Alberto Dell'Era <alberto.dellera_at_gmail.com> wrote:
I agree, looks like they want to put you in charge,
giving you responsibility for some system(s).
They seem to know their job.
On 12/15/06, Dennis Williams wrote:
> Murtuja,
> These sound like really insightful interview questions. You should
> definately consider working for this person. Answer these questions as
> straightforwardly and honestly as you can. your answers to these quesions
> will clearly demonstrate whether you have only mastered the technical
> aspects of being a DBA or the whole job.
--
Alberto Dell'Era
"Per aspera ad astra"
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 15 2006 - 06:11:08 CST