Hello all, I have a non technical question that kind of puzzled my mind for the last little while. What's a true definition of a senior Oracle DBA? How are they different from intermediate DBA? Years? Age? Resposibility?
Printable View
Hello all, I have a non technical question that kind of puzzled my mind for the last little while. What's a true definition of a senior Oracle DBA? How are they different from intermediate DBA? Years? Age? Resposibility?
Simple, if I join the organization before you, I will be called Senior DBA and you will be Assistant DBA. ;)
Hi
If you know the answer to the following questions then you are a nominee for a senior DBA
Regards
Amar
PS: Just kidding dont take it too seriously. These are few things that a seniour DBA must know. So you can judge yourself.
Give one method for transferring a table from one schema to another:
What are some of the Oracle provided packages that DBAs should be aware of?
What is the proper method for disabling and re-enabling a primary key constraint?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
When should more than one DB writer process be used? How many should be used?
You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not?
What causes the “snapshot too old” error? How can this be prevented or mitigated?
A developer is trying to create a view and the database won’t let him. He has the “DEVELOPER” role that has the “CREATE VIEW” system privilege and SELECT grants on the tables he is using, what is the problem?
If you have an example table, what is the best way to get sizing data for the production table implementation?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
A user selects from a sequence and gets back two values, his select is:
SELECT pk_seq.nextval FROM dual;
What is the problem?
How can you determine if an index needs to be dropped and rebuilt?
How can you call a PL/SQL procedure from SQL?
"Information's pretty thin stuff unless mixed with experience." ~Clarence Day, The Crow's Nest
Yep and answer to such question comes with experience.
:-)
In simple words its like asking what is the difference between Vice President and Assitant Vice President. In my opinion, one is a bigger idiot than the other.
Which one *is* the bigger idiot? :DQuote:
Originally posted by quester
In simple words its like asking what is the difference between Vice President and Assitant Vice President. In my opinion, one is a bigger idiot than the other.
That's probably too close to call :DQuote:
Originally posted by dknight
Which one *is* the bigger idiot? :D
..and what about President then ?? :DQuote:
Originally posted by quester
In simple words its like asking what is the difference between Vice President and Assitant Vice President. In my opinion, one is a bigger idiot than the other.
That is not always true. I am a counterexample :-)Quote:
Originally posted by agasimani
Simple, if I join the organization before you, I will be called Senior DBA and you will be Assistant DBA. ;)
to be honest I dont know how you define a DBA now days, seems to many developers/analysts a DBA must know everything about Oracle, to management a DBA is just someone which looks useless and costs too much money
cheer up pando :-)
they cant survive without us...
May be its because now a days many of them states them as DBA without *really* understanding a term DBA which is quite broad in itself.. its like doing OCP as one of the academic career..Quote:
Originally posted by pando
to management a DBA is just someone which looks useless and costs too much money
I agree but may be the market demand caused this in the last couple of yearsQuote:
Originally posted by Sameer
May be its because now a days many of them states them as DBA without *really* understanding a term DBA which is quite broad in itself.. its like doing OCP as one of the academic career..
and thus ended up introducing new terms in the market as Senior/Junior DBA or Database operator :)Quote:
Originally posted by pando
I agree but may be the market demand caused this in the last couple of years
I never really understood what a Database operator means, what is his job? what's the difference between a database operator and a database administrator, when someone mentions database operator to me the first thing i can think of is a Data Entry guy (no offense).Quote:
Originally posted by Sameer
and thus ended up introducing new terms in the market as Senior/Junior DBA or Database operator :)
for instance if a guy plans a backup strategy, and writes the scripts he's a database administrator, but if a guy's role is to only make sure that backups are taken correctly, and that backups made are valid he's a Junior Database Administrator, i'd never call him a database operator.
Cheers.
Re prseidents and vice-presidents, if one idiot has prior experience of being an idiot, and the other idiot is new to idioting, does that affect who is the bigger idiot?
Hi,
what do you mean with DBA?
either
ORCode:Database Administrator ??
I want to know it, i cannot sleep anymore!!!Code:Database Assistant ??
Orca
;;;;;;--------------)))))))))))))))
Craig s mullins has written an excellent book about who or wjhat is a dba check out an excerpt...
http://www.dbazine.com/dba_1.html
I personally think that being dba is entirely upto you. Some dba's can make developers sh*t and others can give it a rahter bad name by like pando said someone who does nothing and costs money.
Well you gotta show all what you can do , but it's also dependent upon how is it politically allowed within your environment without burning edges here and there.
Example:
When i joined this firm the db's were running on no arch log mode with no record of backups anywhere. Well that was being done by a dba who was doing it remotely by a "hi-fi oracle partner" shop. I'd say you had a peasant sitting on the throne.
Such retards make a dba job look so darn easy and then they get fired/ or leave and the next dba(who'd do a great job) can clean up his trash and be treated like trash.
So be a dba or don't, don't just mess around with the job profile, the reverberations(good and bad) go beyond your imaginations.
Tarry
Maybe we need a new thread about crap DBA's.
Another Example:
I interviewed an applicant who listed their current job as DBA, but he did not know whether his databases were running CBO or RBO, and the backup recovery strategy was a nightly full export. H'mmm. Tough choice to make there.
Well, what was it: CBO or RBO? Don't leave us hanging like that.Quote:
Originally posted by slimdave
Maybe we need a new thread about crap DBA's.
Another Example:
I interviewed an applicant who listed their current job as DBA, but he did not know whether his databases were running CBO or RBO, and the backup recovery strategy was a nightly full export. H'mmm. Tough choice to make there.
It was never established during the interview what optimizer the databases used, and at that point I'd heard enough to be sure that this was not the fellow to be working on our data warehouse. Sorry, it'll remain a mystery.
Make the question harder next time.
"Do you use CBO or HBO?"
Hi,Quote:
Originally posted by slimdave
Maybe we need a new thread about crap DBA's.
Another Example:
I interviewed an applicant who listed their current job as DBA, but he did not know whether his databases were running CBO or RBO, and the backup recovery strategy was a nightly full export. H'mmm. Tough choice to make there.
this is a very good example for DBA's ( Database Assistant's )
Orca
thats very interesting! i think HBO will introduced in 10iQuote:
Originally posted by stecal
Make the question harder next time.
"Do you use CBO or HBO?"
by the way:
CBO = Calendar-Based Optimizer
RBO = Reality-Based Optimizer
Orca
:cool: