Skip to Main Content

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, parag.

Asked: December 12, 2005 - 10:40 am UTC

Last updated: December 15, 2005 - 5:08 pm UTC

Version: 9.2

Viewed 1000+ times

You Asked

Hi Tom,

I found technology is changing very fast including Oracle. For e.g Oracle 9i to Oracle 10g there are some major changes.

According to you which skills set oracle DBA should focus more to have hot market value in future say after 3-4 years ? and

Which skills/languages knowledge will become mandatory along with oracle dba skills ? ( for e.g. do you think java/html/xml strong basic concepts/programming knowledge are "must" for the future ? )

regards & thanks
pjp

and Tom said...

I found technology is changing very fast including Oracle.

I've been finding that for the last 40 years, but only because that is as long as I've been around (eg: the pace of change has been the pace of change for quite a while...)


The most important skill set?

o commonsense
o flexibility
o willingness to change
o excitement about learning new things
o not being afraid to say "what I did 5 years ago bears no resemblance to what I do today and hopefully none to what I do one year from"
o good communication skills

and - the ability to recover a database (not backup, RECOVER - recovery is the only thing you cannot get wrong!)


languages (java), file formats (xml), simple markup things that most people don't even code by hand anymore (html) - all useful, but you'll learn a couple of languages, more than a few file formats, and forget things like how to write html many times in the next 3 or 4 years....

Rating

  (15 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Could not agree more

A reader, December 12, 2005 - 1:11 pm UTC

It is very sad that too many IT employees lack most (if not all) of these skills.

Skill for future

Laxman Kondal, December 12, 2005 - 2:11 pm UTC

Hi Tom

If IDE tools are getting smart and intelligent why do need to hand code, there must be something behind this when you say:

"simple markup things that most people don't even code by hand anymore (html"

Could you please make it bit simple please to understand.

Thanks and regards.

Tom Kyte
December 12, 2005 - 2:28 pm UTC

I have not hand coded an HTML file in a long long time. I use Word, Dreamweaver, or some other tool to create html files for me.


html is *not code*

html is simple markup.

"very helpful"

Jeremy, December 12, 2005 - 3:13 pm UTC

I found this answer "very helpful". :) Just wanted to say I think that this is great advice. Those are exactly the qualities that will make you a very valuable asset to any employer; they'll want to keep you around. (And if they don't then I think you could probably find a better place to work anyway...) Those are the things I look for during interviews. Funny thing, I think a lot of that has just as much to do with character as it does with technical "skills".

but comparing you to Einstein?

Dean, December 12, 2005 - 6:27 pm UTC

Love the site and the whole-truth advice you give, thanks for keeping it up. Saw you compared in the same sentence as Einstein on this blog dratz.wordpress.com/2005/12/12/managing-you-career-pt5or-twin-peaks/

While I'm not sure tuning the CBO is on par with splitting the atom, you do offer powerful and actionable advice (dangerous in the wrong hands?).

Isn't it amazing how many people backup their databases but STILL can't recover them? Or even try until it's too late.


Tom Kyte
December 12, 2005 - 7:25 pm UTC

... you do offer powerful and actionable advice (dangerous in the wrong hands?). ...


indeed, I worry about that sometimes. It is why I many times ask "why" first.

Is this advise applies only for DBA's?

Muhammad Ibrahim, December 12, 2005 - 9:12 pm UTC

Dear Tom,

Thanks for a valuable advise!

small doubts :-)

1) Is Knowing HTML will be usefull if you start using HTMLDB?
2) How about future if we learn HTMLDB?
3) Java (so many things in java). Just core java enough or J2EE?

Regards,
Ibrahim

Tom Kyte
December 13, 2005 - 8:41 am UTC

This advise applies to the person serving food in a restaurant, a manager, a programmer, a DBA, a school teacher, <any occupation pretty much goes here>

1) knowing a little html won't be a bad idea for htmldb but it is not a pre-requisite.

2) what about it (the future). HTMLDB is an application development tool, having knowledge of it, how it works, when to use it - won't hurt you.

3) I believe that you can learn a tiny bit of java, but you won't be marketable as a java developer really. J2EE is a 'career path', it'll take a while to get your arms around it.

Skills for future

S.P.Darshan, December 12, 2005 - 11:54 pm UTC

Dear Tom,

Thaks for your answers. "but you'll learn a couple
of languages". You have mentioned couple of languages. What are they?

Tom Kyte
December 13, 2005 - 9:14 am UTC

I don't know, they haven't been invented yet.

some of mine so far have been

cobol
rpg
pl/i
sas (I was known as the "sas master" before I got into SQL ;)
jcl
tcl
rexx
exec
exec-2
pascal
lisp
prologue
C
C++
SQL (dialects for ingres, informix (various dialects, every database from them was a little different), sqlserver (sybase), sqlserver (ms), db2, sql/ds, oracle, sqlbase - at least, might be missing some)
PL/SQL
T-SQL
68000 assembler
too many shell's to remember
awk
java


probably others, don't remember them all anymore. Oh and the API's I've learned over time.


When I learned PL/I - some of those languages did not yet exist, some had existed for years.

guess the future? never with accuracy.

Arm you with a way to be able to work in the future? Sure, see the list above and remember that everything you know for sure today will change tomorrow and be lessons learned in the future.

Meaning - gasp - my parents were actually right when they said "you'll see..."

And your reply yourself is commonsence :)

Kim Nørby Andersen, December 13, 2005 - 3:04 am UTC

In my humble opinion, a really good dba is part developer, and a really good developer is part dba. Thus they understand eachother and can make their days more effective. I think that is what Tom is trying to say, Darshan. It's not really important what language (.net/java/scripting/whatever), but to get a toolset that helps you going.

Just as long as you will not completely disregard a new feature/language/technology because what you have now is "good enough", you will be able to get going :)

For all technicians I would like to recommend "Pragmatic Programmer" as a book to read - it's a mindset that should enable you to automate your daily repetitive tasks (if you haven't done so) and get going.

Tom Kyte
December 13, 2005 - 9:23 am UTC

I've described in seminars that I think there are 4 kinds of people:

a) version 6 DBA's. They install software, they backup databases. Occasionally, they discover they can ever restore them - but many times not. They are not very helpful generally. I don't get along well with them. They will not survive much longer (they can be automated).

b) DBA/Developer - a person that is mostly DBA but can actually understand software development, the business, the needs. They are helpful, they've tested things. They can write some code in a pinch (hence they can automate stuff, help developers tune some SQL). They understand the physical schema and so on. They will survive for a long time - they are flexible, they get along well with others, they communicate, they make themselves useful.

c) Developer/DBA - a person that has taken the time to learn all of the tools they have available (their languages, their OS, their application server, their database). They use them all to their fullest. They do not like to write gobs of code, they pride themselves in being able to put together things that work quickly by taking what exists and using it to its fullest. They understand the bits they are pulling together.

d) Developer - code jockey. Loves their language, their language is the last language ever. I get along with them as well as a)


Unfortunately, too many teams are a) and d). Never works :(


But put an A/C team together or an B/D together - that is like "war"


B/C - perfect ;)

Skills,

Parag J Patankar, December 13, 2005 - 8:05 am UTC

Hi Tom,

I have understood from your answer is that following are the important things ( I will say personal qualities )
o commonsense
o flexibility
o willingness to change
o excitement about learning new things
o not being afraid to say "what I did 5 years ago bears no resemblance to what I
do today and hopefully none to what I do one year from"
o good communication skills

and - the ability to recover a database (not backup, RECOVER - recovery is the
only thing you cannot get wrong!)

Thanks for your answer. But will you throw some light on what technologies will be "HOT" in near future in terms of Oracle DBA job /market value ? ( 3-5 ) years ?

regards & thanks
pjp


Tom Kyte
December 13, 2005 - 9:40 am UTC

.... what technologies will
be "HOT" in near future in terms of Oracle DBA job /market value ? ...


All of them. And depending on your physical location on the planet - different technologies will be hotter than others on different places on the planet.



Crystal Ball?

A reader, December 13, 2005 - 8:57 am UTC

Tom -

When you get your Crystal Ball working (so you can see into the future about what is 'Hot' in technology), would you also look at the lotto numbers for Feb. 2007 and let me know what those are.
Then I'll know what's going to be 'Hot' in 2 years, and I'll be rich :-)

Parag - maybe you should concentrate on technology that you enjoy and are good at, as opposed to what is 'Hot' in the coming years. If you find something you like, keeping up with the changes won't be difficult because you'll be good at what you do and will welcome the changes.

Just my 2 cents.


Tom Kyte
December 13, 2005 - 9:49 am UTC

in Oracle 15 we might have perfected the flashforward query to go along with flashback queries. I cannot wait to hit the nasdaq tables with that one :)

The World Is Flat

A reader, December 13, 2005 - 2:44 pm UTC

Agree with everything Tom says. Heard the author of the book "The World is Flat" on NPR. He said with the world changing faster and faster, the best skill to develop in the future is "Learning how to learn." Might have to pick up that book someday as it supposedly discusses globalization, the speed of knowledge dissemination, and resulting competition.

A reader, December 13, 2005 - 10:55 pm UTC

Adding to Tom's list of a) category people these people have written lots of books(misleading info), self proclaimed best dbas and disagree even with facts.

Great minds . . .

DaPi, December 15, 2005 - 4:23 pm UTC

Tom Kyte
December 15, 2005 - 5:08 pm UTC

I have that bookmarked already - my blog topic for tomorrow :)

It freaked me out how close the "gists" were. I am thinking of going to a java conference (believe it or not) just to see her talk once and meet her in person.

Stepping back for the long view

Joel Garry, December 20, 2005 - 7:44 pm UTC

Ran across this: </code> http://www.pbs.org/cringely/nerdtv/ <code>

Concurrent Request

S. Velusamy Raja, January 06, 2006 - 12:12 am UTC

How to run a Concurrent Request from command line (OS).

Kindly explain with syntax.

Thanks in advance


Database designer

AD, May 16, 2006 - 4:54 pm UTC

Tom,

In your view what are the qualification a database designer must have.

Thanks for your time.

Regards