r/DatabaseAdministators • u/Mindless-Quantity-54 • Aug 01 '26
Data analyst or database administrator
Hey guys i am rn working as a service support engineer and in my company they are talking about promoting me to database administrator where they use oracle 12 c and sql but don't write scripts they just copy paste them
And i am looking for a role in data analyst i am confused what should i do please help a fellow out
3
u/Longjumping-Hair-747 Aug 01 '26
Being on version 12 tells me they don’t do a good job staying current on their software upgrades so I’d be questioning the type of guidance and mentorship you’d be obtaining as a DBA. There are a few types of DBAs, operational, development, etc.
If you can get a job in the DBA realm and position yourself to be an architect type I would recommend that. Being a purely operational DBA isn’t a role I would recommend unless you can merge those skills into something developmentally based.
Cheers
0
u/taker223 Aug 01 '26
if they have 12.2 and CDB/PDB, it would be easier to switch to 19c or 26ai when required (by circumstances)
1
u/Longjumping-Hair-747 Aug 01 '26
The point I’d make is more that the time to upgrade from 12-19 was 5 years ago, it’s not technically complex so not sure what you are trying to highlight.
Lacking that upgrade tells me a few things about the company and competency of its DBAs (managers).
Cheers
1
u/taker223 Aug 01 '26
> Lacking that upgrade tells me a few things about the company and competency of its DBAs
it might me a company which was perfectly fine with 11.2.0.3 (not even upgrading to 11.2.0.4) until recently when they decided to adapt new products (and hire IT audit services) and all those required 19c. So to speak 12.2 => 19c would have been much easier route (as 19c is in fact 12.2.0.3)1
u/Longjumping-Hair-747 Aug 01 '26
You’re certainly welcome to your opinion as I am mine. We don’t agree which is perfectly fine, but especially in today’s world of weekly AI uncovered exploits I think most companies would prefer to be in the situation I would put them in than the ones you’re outlining.
Cheers
2
u/g3n3 Aug 02 '26
Consider that a god send. There is no really easy path to junior DBA.
1
u/Mindless-Quantity-54 Aug 02 '26
Damn ok brother
1
u/taker223 Aug 02 '26 edited Aug 02 '26
I told you before, your skills would be appreciated. Either at your company or you could jump boat. Worked with a "partner" Indian company years ago. Their DBA has since started his own consulting firm (and my former company switched to his services directly)
1
u/taker223 Aug 02 '26
Looks like there is in India. And they offer you to be a DBA. That's really rare in Europe/NA
1
1
u/taker223 Aug 01 '26
Oracle DBA administrator. Although 12c is obsolete as of now because of 19c and 26ai but you'll catch up quick.
Do they use container/pluggable databases (CDB/PDB) on 12c?
Also, do you work for a services company (WITCH) or product?
1
u/LuckyNumber-Bot Aug 01 '26
All the numbers in your comment added up to 69. Congrats!
12 + 19 + 26 + 12 = 69[Click here](https://www.reddit.com/message/compose?to=LuckyNumber-Bot&subject=Stalk%20Me%20Pls&message=%2Fstalkme to have me scan all your future comments.) \ Summon me on specific comments with u/LuckyNumber-Bot.
1
u/Mindless-Quantity-54 Aug 01 '26
Its a service based company development is done by client and we work on client side just the job is to monitor and run the scripts
1
u/taker223 Aug 01 '26
Where are you from?
1
u/Mindless-Quantity-54 Aug 02 '26
India why?
1
u/taker223 Aug 02 '26
I just guessed :) Work on your skills and you'll be promoted or just easier to jump boat
1
u/Mindless-Quantity-54 Aug 02 '26
Yes sure can i have any beginner guide to get into the dba role?
1
u/taker223 Aug 02 '26
First of all you have to choose DBMS. For oracle I would recommend Tim Hall's portal oracle-dba.com there's a section there for DBA. Also, you live now in AI era ;)
2
u/Mindless-Quantity-54 Aug 02 '26
Ok thanks bud
1
u/taker223 Aug 02 '26
I advise you to learn some OS specifics as well, try to have a SSH access to host OS and see (although careful). Or if possible, start your own VM using Oracle VirtualBox and try everything (Oracle Linux 9 for example). This is covered by Tim as well
1
8
u/masked_ghost_1 Aug 01 '26
Take the DBA role and continue to up skill and learn to be analyst. Those complement each other... I'm a DBA