Home » RDBMS Server » Performance Tuning » you people can help me
you people can help me [message #141199] Fri, 07 October 2005 08:24 Go to next message
genialsenthil
Messages: 26
Registered: June 2005
Location: Chennai
Junior Member
hai
this senthil
i am oracle dba working in firm without a senior dba help
with 6 months experience and when wen to an interview i answer all the question and i can't
able to answer this

1.what is the first job of dba when he enters in the office
2.what is the day to day role of dba

plz help me by step by step process

Regards
Senthil Kumar
Re: you people can help me [message #141201 is a reply to message #141199] Fri, 07 October 2005 08:30 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
These are vague questions that are going to differ based on the environment and responsibilities of a specific position.

But the most crucial role of a production/infrastructure type DBA is recovery. Backup and Recovery...


Re: you people can help me [message #141294 is a reply to message #141199] Sat, 08 October 2005 03:23 Go to previous messageGo to next message
genialsenthil
Messages: 26
Registered: June 2005
Location: Chennai
Junior Member
thanks smartin for your reply,

and can u tell me
* what will you do
before starting ur database in the morning..
* what are things u will be doing in ur database
* what u will check when error happens

regards
senthil kumar
Re: you people can help me [message #141307 is a reply to message #141294] Sat, 08 October 2005 05:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SMartin presaged:
>>These are vague questions

More such questions.
>>* what will you do before starting ur database in the morning..
Do you start the database in morning and shut it down by end of business day?
And how/what can one do anything in/to the database ,before starting / opening the database?
Probably one could delete a datafile or two.
>>* what u will check when error happens
Well, anyone will 'check' for symptoms,analyze, and try to solve it.

Thanks & Regards




Re: you people can help me [message #141459 is a reply to message #141307] Mon, 10 October 2005 06:27 Go to previous messageGo to next message
genialsenthil
Messages: 26
Registered: June 2005
Location: Chennai
Junior Member
Hi
Mahesh Rajendran,

thanks for ur reply and u sent some of the some of the
Question
but plz can u tell me the work of an Oracle DBA in the office in the day begins and ends

1.what is the first job of dba when he enters in the office
[ answer me plz]
2.what is the day to day role of dba
[ answer me plz]

if u help me i can attened my next interview in good manner

regards
Senthil Kumar
waiting for ur reply
Re: you people can help me [message #141465 is a reply to message #141459] Mon, 10 October 2005 07:35 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Below Are the question and Answer in which You are intrested... and one thing more dont be thankfull to me for this question & answer because the owner of this question and Answer is FRANK NAUDE... Laughing

Personal Interview
This part of the interview question is not to be regarded as insignificant. If the interviewer asks you these questions take it as a sign that they are interested in you, your qualities, and how you interact with people throughout the day. Take it as an opportunity to prove that you have been around the block a few times, are willing to work with other people, and enjoy the job you do. Many times people see DBA types as stuffy and pointed, not willing to work with others, and only concerned with the database and its day-to-day operational needs. Put aside the needs of the database and talk about how you work with people and the different departments in the organization and are concerned with providing them with top notch database services.

1. What DBA activities did you to do today?
Wow, this is a loaded question and almost begs for you to answer it with "What DBA activities do you LIKE to do on a daily basis?." And that is how I would answer this question. Again, do not get caught up in the "typical" day-to-day operational issues of database administration. Sure, you can talk about the index you rebuilt, the monitoring of system and session waits that were occurring, or the space you added to a data file, these are all good and great and you should convey that you understand the day-to-day operational issues. What you should also throw into this answer are the meetings that you attend to provide direction in the database arena, the people that you meet and talk with daily to answer adhoc questions about database use, the modeling of business needs within the database, and the extra time you spend early in the morning or late at night to get the job done. Just because the question stipulates "today" do not take "today" to mean "today." Make sure you wrap up a few good days into "today" and talk about them. This question also begs you to ask the question of "What typical DBA activities are performed day to day within X Corporation?"

2. What is your typical day like?
If you spend enough time on question 1, this question will never be asked. It is really a continuation of question 1 to try and get you to open up and talk about the type of things you like to do. Personally, I would continue with the theme of question 1 if you are cut short or this question is asked later in the interview process. Just note that this question is not all geared toward the day-to-day operational issues you experience as a DBA. This question also gives you the opportunity to see if they want to know about you as an individual. Since the question did not stipulate "on the job" I would throw in a few items like, I get up at 5:00am to get into work and get some quiet time to read up on new trends or you help coach your son/daughter's soccer team. Just test the waters to what is acceptable. If the interviewer starts to pull you back to "job" related issues, do not go to personal. Also, if you go to the office of the interviewer please notice the surroundings, if there are pictures of his/her family, it is probably a good idea to venture down the personal path. If there is a fly-fishing picture on the wall, do not say you like deep-sea fishing. You get the picture.

3. What other parts of your organization do you interact with and how?
Again, if you have exhausted question 1 and 2 you may never get to this question. But if you have been apprehensive to opening up and explaining yourself, take note that you may have an issue and the interviewer might also be already getting tired of the interview process. If you get to this question consider yourself in trouble. You really need to forget all your hang-ups and start explaining what it is that you like to do as a DBA, and why you want to work for this particular company. You are going to have to reel this interviewer back into the interview process or you might not get to the true technical question part of the interview.

4. Do you consider yourself a development DBA or a production DBA and why?
I take this as a trick question and explain it that way. Never in my database carrier have I distinguished between "development" and "production." Just ask your development staff or VP of engineering how much time and money is lost if development systems are down. Explain to the interviewer that both systems are equally important to the operation of the company and both should be considered as production systems because there are people relying on them and money is lost if either one of them is down. Ok you may be saying, and I know you are, that we lose more money if the production system is down. Ok, convey that to the interviewer and you won't get anyone to disagree with you unless your company sells software or there are million dollar deals on the table that are expecting the next release of your product or service.

5. Are you a nuts-n-bolts DBA or a tools-n-props DBA
This question begs for me to give definition around the terms I basically group DBAs into. These are not good or bad groups but something I like to think about when talking to DBAs. A nuts-n-bolts DBA is the type that likes to figure out every little item about how the database works. He/she is a DBA who typically hates a GUI environment and prefers the command line to execute commands and accomplish tasks. A nuts-n-bolts DBA like to feel in control of the database and only feels comfortable at the command line and vi as an editor. The tools-n-props DBA is mostly the opposite of a nuts-n-bolts DBA, they like the feel of a GUI, the ease at which things can be accomplished without knowing much about the database. They want to get the job done with the least amount of intervention from having to figure out what everything is doing behind the scenes. Now the answer, I would explain myself as a combination of the two. I, having been in this business for over 20 years, have grown up in a command line era where the GUIs never seemed to work. There was high complexity in systems and not much good documentation on how things worked. Thus, I had to learn everything about most aspects of the database environment I was working in and thus became a nuts-n-bolts DBA. I was a true command line and vi bigot. Times have changed and the GUIs are very reliable, understand the environment they are installed on, and can generally get the job done quicker for individuals new to database administration. I too am slowly slipping over to the dark side of GUI administration. If you find yourself as a tools-n-props DBA, try to convey that you are aware of some tasks that require you to be a nuts-n-bolts DBA.

I hope this will help you lot...Wink

Regards
Always Friend Sunilkumar
Re: you people can help me [message #141964 is a reply to message #141465] Wed, 12 October 2005 22:09 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
David

Keywords: interview DBA fullresponse daytoday
Re: you people can help me [message #148660 is a reply to message #141964] Sat, 26 November 2005 00:33 Go to previous messageGo to next message
genialsenthil
Messages: 26
Registered: June 2005
Location: Chennai
Junior Member
Hai
martin
can u tell me what are daily job when u enter to ur office.

Thanks in advance
Senthil Kumar
Re: you people can help me [message #148689 is a reply to message #148660] Sat, 26 November 2005 06:03 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
@OP
Similiar Discussion here.
http://www.orafaq.com/forum/m/148687/42800/#msg_148687

>>can u tell me what are daily job when u enter to ur office.
You seem to interested in getting a specific response from others.
As said by all above, it depends. Did you ever read any of the above responses?
The question is a very generic one.
In my humble opinion, Concentrate on technical know how.

Topic closed & locked.

[Updated on: Sat, 26 November 2005 06:03]

Report message to a moderator

Previous Topic: Urgently required your opinion
Next Topic: statpack result not found
Goto Forum:
  


Current Time: Fri Mar 29 07:39:59 CDT 2024