Thread: want to be a dba


Permlink Replies: 25 - Pages: 2 [ 1 2 | Next ] - Last Post: May 22, 2007 11:44 PM Last Post By: dhimant19
algojo5

Posts: 17
Registered: 09/18/05
want to be a dba
Posted: Oct 9, 2005 8:42 PM
Click to report abuse...   Click to reply to this thread Reply
hi all,

currently i am working on oracle collab suite 10g on RHEL4, but i always wanted to be an oracle dba. i'm thinking of getting myself certified -OCA as my first step & look for jr dba positions, but i'll still suffer from the chicken and egg syndrom.. can somebody give some advice pls. i need to figure out a way. any help/advice is much appreciated

my experience:
1. 1 yr - internal audit (no IT job but i need to eat)
2. 2 yrs - IT support (oracle 8i, e-business suite 11i - financials, purchasing, PC support. have to quit because IT dept are forced to do non-IT stuff -- there goes my dba plan
- learned sql, oracle basics, internals,backup, patching, functional here.
3. 1 month - joined a new company (linux house, open source products, oracle partner). oracle collab suite is the only oracle product they sell. joined because don't have much choice & always wanted to stick with oracle. learned installation ocs 10g, database 10g, AS architecture - all on RHEL4

am i on the right turf?
DBMS Direct

Posts: 4,641
Registered: 10/07/99
Re: want to be a dba
Posted: Oct 10, 2005 5:00 AM   in response to: algojo5 in response to: algojo5
Click to report abuse...   Click to reply to this thread Reply
1. 1 yr - internal audit (no IT job but i need to eat)
2. 2 yrs - IT support (oracle 8i, e-business suite 11i - financials, purchasing, PC >>support. have to quit because IT dept are forced to do non-IT stuff -- there goes >>my dba plan
<<<<<<<<

This is a personal comment:
I believe some people make mistakes and waste a lot of time and money trying to move without knowing they are sitting on the right stuff.

And this is a personal opinion:
If I were in your position, I would stick or go back to 2 above (not the job, but the skill/expertise) and then expand my knowlege as Oracle Financials Functional Consultant within e-Business Suite since you already have the audit/financial background. Then look for jobs in that area rather than DBA. If not Functional, then Applications DBA will be better.

I guess there are a lot of people in this forum who want to move from DBA to Functional Consultant or Application DBA, but have not got the knowledge.

As I said these are personal comments and opinion.

All the best
MarkDPowell

Posts: 4,054
Registered: 12/07/98
Re: want to be a dba
Posted: Oct 10, 2005 9:18 AM   in response to: DBMS Direct in response to: DBMS Direct
Click to report abuse...   Click to reply to this thread Reply
There is a lot more work for application developers and Vendor Application experts like SAP or Oracle Applications including Financials than there are DBA jobs these days.

The experience from your second position may look good to a lot of potential employers though depending on the level of detail and amount of non-IT tasks involved it may or may not have been a good learning experience.

I would stick with job 3 for a while. I suspect that many people in a hiring position would feel better about making a job offer to someone with a record of staying put for a couple of years rather than only a couple of months.

HTH -- Mark D Powell --
APC

Posts: 10,438
Registered: 08/27/03
Re: want to be a dba
Posted: Oct 11, 2005 5:29 AM   in response to: algojo5 in response to: algojo5
Click to report abuse...   Click to reply to this thread Reply
but i always wanted to be an oracle dba.

This thread and a couple of other recent postings in a similar vein have prompted me into some extended musing on why people want to be a DBA. See my blog if you're interested.

Cheers, APC
N Gasparotto

Posts: 19,247
Registered: 08/22/02
Re: want to be a dba
Posted: Oct 11, 2005 5:58 AM   in response to: APC in response to: APC
Click to report abuse...   Click to reply to this thread Reply
Andrew,

Your article is very interesting, indeed.

Nicolas.
MarkDPowell

Posts: 4,054
Registered: 12/07/98
Re: want to be a dba
Posted: Oct 11, 2005 6:12 AM   in response to: N Gasparotto in response to: N Gasparotto
Click to report abuse...   Click to reply to this thread Reply
Agreed the blog article is a decent read.

IMHO -- Mark D Powell --
algojo5

Posts: 17
Registered: 09/18/05
Re: want to be a dba
Posted: Oct 11, 2005 8:17 PM   in response to: algojo5 in response to: algojo5
Click to report abuse...   Click to reply to this thread Reply
thanks 4 all ur posting

The experience from your second position may look good to a lot of potential employers though depending on the level of detail and amount of non-IT tasks involved it may or may not have been a good learning experience
<<<

this is what I do in my previous company. there are huge amount of non-IT tasks involved i must say.. :
IT:
apps dba (support), contracts

non-IT:
secretarial jobs, purchasing executive, corporate risk management, operations etc

IT dept is rather small, only doing support. all developments are outsourced. then the mgmt sees that IT dept got nothing to do when everything is working fine. maybe these sr managers see IT is only about internet, email and repairing PC..

i really love the job, but concurrently my time was wasted on other things. i cannot claim i have extensive knowledge being apps dba. in the mean time finding jobs as apps dba / dba is hard with minimal knowledge and exp, while devoting most of my time doing those non-IT things will get me nowhere.

i would stay if i could focus being apps dba there. there are tonnes of things to be learned. but sometimes life just pushes your around.. or maybe it's just the taste of life

i'm searching & applying for jr apps dba post, even though i'm new here. not a good attitude though. currently concentrating on oracle collaboration suite, during me free time i will educate myself and prepare for certification. and hopefully will let me get what i want. this is what i'm planning rite know.

i always wanted to be successful in my career. i also have ambition like all u guys do. any opinion & suggestions are most welcome. guidance and ideas etc are very much appreciated. thanks
MarkDPowell

Posts: 4,054
Registered: 12/07/98
Re: want to be a dba
Posted: Oct 12, 2005 1:09 AM   in response to: algojo5 in response to: algojo5
Click to report abuse...   Click to reply to this thread Reply
The great majority of people hired into entry DBA positions have development experience, usually with several of the tools in use at the hiring site. Very few people can train to do DBA work and then just find a position without previous developer experience since at many sites most of the job is working with the development/support staff.

HTH -- Mark D Powell --
APC

Posts: 10,438
Registered: 08/27/03
Re: want to be a dba
Posted: Oct 12, 2005 2:05 AM   in response to: MarkDPowell in response to: MarkDPowell
Click to report abuse...   Click to reply to this thread Reply
The great majority of people hired into entry DBA positions have development experience

Yes and the rest usually come in through being a sysadmin. It is interesting that now there is a third route - application server, not least because this tool uses a database for some of its functions. AS underpins Collab Suite, so I would have thought the current position is a possible springboard into a fully-fledged DBA role.

Cheers, APC
MarkDPowell

Posts: 4,054
Registered: 12/07/98
Re: want to be a dba
Posted: Oct 13, 2005 8:36 AM   in response to: APC in response to: APC
Click to report abuse...   Click to reply to this thread Reply
But how much DBA work (creating objects, making db backup, practicing restore and recovery, SQL tuning) would an web server administrator ever do? We dumped the web server on the System Administrators. All they have to do is stop and restart application support tasks and update a file (usually jar file) every now and then that the developers provide to them.

HTH -- Mark D Powell --
amirrjn

Posts: 354
Registered: 02/26/05
Re: want to be a dba
Posted: Oct 13, 2005 9:37 AM   in response to: algojo5 in response to: algojo5
Click to report abuse...   Click to reply to this thread Reply
In my case even I do that type of sysadmin tasks as well.

Amir,
Oracle Certfied
algojo5

Posts: 17
Registered: 09/18/05
Re: want to be a dba
Posted: Oct 14, 2005 2:40 AM   in response to: algojo5 in response to: algojo5
Click to report abuse...   Click to reply to this thread Reply
Yep, collab suite used AS architecture, but very minimal DBA works involved..

I do have a litle faith that this AS/OCS can be a stepping stone to be not a full-fledged, but for junior position. I've seen somewhere in this forum a support staff >> AS developer>> Jr DBA. don't know how he did it though..

Certification may not be so valuable but it can force me to selfstudy and practise. But where can i get the dba exp? voluntary works might help. Is there any other way?
N Gasparotto

Posts: 19,247
Registered: 08/22/02
Re: want to be a dba
Posted: Oct 14, 2005 2:55 AM   in response to: algojo5 in response to: algojo5
Click to report abuse...   Click to reply to this thread Reply
You need opportunity...

Nicolas.
Warren Tolentino

Posts: 4,899
Registered: 11/22/02
Re: want to be a dba
Posted: Oct 14, 2005 7:30 AM   in response to: APC in response to: APC
Click to report abuse...   Click to reply to this thread Reply
Andrew, your blog is very interesting.
APC

Posts: 10,438
Registered: 08/27/03
Re: want to be a dba
Posted: Oct 14, 2005 9:54 AM   in response to: MarkDPowell in response to: MarkDPowell
Click to report abuse...   Click to reply to this thread Reply
But how much DBA work (creating objects, making db backup, practicing restore and
recovery, SQL tuning) would an web server administrator ever do? We dumped
the web server on the System Administrators

Well obviously YMMV applies here. Some shops have sysadmins, DBAs, network engineers and app server guys in separate units, maybe in separate offices. At the other extreme in smaller places they all share the same pair of pants (because they are the same person, no aspersions on personal hygiene habits of admin people intended). But I have come across several places where these tech-y infrastructure roles are lumped into one unit, with at least the possibility of cross-fertilisation of experience and even job-swapping.

Managing a career transition is a tricky thing to pull off. It's relatively easy to persuade somebody to give us another job doing what we do already. It's much harder to get a job doing something different. How do we cross that gap? By impressing the manager of our current role with our talents in that role while also demonstrating an aptitude for our target role to whoever has the power to put us into that job. And if you find out how to that let me know :P

Cheers, APC
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums