Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, sumit.

Asked: September 15, 2015 - 5:37 am UTC

Last updated: September 18, 2015 - 4:31 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi,
As a fresher i got the job in a MNC company for a DBA its a big role that i have got.
But i was expecting for a developers job. I have done DBA's job for last 10 months and came to know that i am not enjoying in supporting.for the reason-
1)Working in shifts
2)No creative tasks
3)NO fix shifts and weekoffs
4)NO festival holidays
So i was thinking to switch as pl/sql developer. Can you tell me what kind of task they do ,what can be the further scope,What other languages can i learn along with pl/sql

Important - Will i be count as a fresher again if I switch from DBA to pl/sql.

Give me some more ides from you about pl/sql as i dont know much about it rather than just cwriting pl/sql code.

and Chris said...

If you've never worked as a developer before, then yes, switching will very likely mean you're a fresher again.

As a developer then your primary task will be writing code! The exact nature of tasks will depend upon the company you join, your level of experience, etc. It could include working with customers, systems design or just cranking out code. It's very situation dependent.

Some thoughts from Tom on learning about Oracle:

http://asktom.oracle.com/Misc/the-keys-to-oracle.html

Rating

  (5 ratings)

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

Comments

Sh?@t

P, September 15, 2015 - 1:51 pm UTC

I DO love "No creative" and *boring* tasks (if in the Oracle field, all the better), but just can't find an Oracle related job like that (at least these days)!

Cheers

Apex

Tony Quinn, September 15, 2015 - 2:07 pm UTC

I left Operational DBA roles when I had a chance to develop an Oracle Application Express application (which is PL/SQL). Never looked back, Apex is all PL/SQL and great fun, glad I made the break.

sumit gupta, September 15, 2015 - 4:22 pm UTC

can you tell me comparing this two jobs which is more stable in nature of working.I am really confused....Is there anything I would be worrying about after leaving DBA.
Or can you just list benefits for being as pl/sq developer over DBA.
Chris Saxon
September 16, 2015 - 4:22 am UTC

Really depends on what you *like*

Here's an old post from a friend Doug about development DBA's

https://www.simple-talk.com/sql/database-administration/what-use-is-a-development-dba/

but it talks about the relationship between the two.

But in my view - forget about "stability" and the like.

Do what you love !

sumit gupta, September 16, 2015 - 6:03 am UTC

Thanks all for your great help .
Now I have decided to jump in pl/sql.
1)Just need to Know should I go for OCA?
2) Can someone tell me what is the further scope after pl/sql, what things I can learn further(language,advance,etc).
Connor McDonald
September 18, 2015 - 4:31 am UTC

I think any certification exam is a good thing, but perhaps not for the reasons you might be thinking.

They are good means of working out what subject areas you need to improve on. I dont believe in the power of the certificate you get, but more the power of applying yourself to gain more knowledge.

In terms of extending your scope, start with the Concepts guide and the Developer Guide. Its an awesome way of coming up to speed with development features.

sumit gupta, September 16, 2015 - 7:03 am UTC

Just need to know what is oracle apex does it require pl/sql knowledge.
Connor McDonald
September 17, 2015 - 6:41 am UTC

Here's the home page

http://www.oracle.com/technetwork/developer-tools/apex/overview/index-155186.html

Here's some learning examples you can look through

https://apexapps.oracle.com/pls/apex/f?p=44785:1:0

And here's a good book on it

"Expert Oracle Application Express" 2nd edition.

Having PLSQL knowledge will help, but you can at least get up and running with Apex without too much needed.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.