James Junior profile image

Getting That First Oracle DBA Job

New Update: Ebook Is Available

In the 5 years since I wrote this advice for new Oracle DBA's, I learned so much more. In response to the demand for this information, I have decided to write "Landing Your First Oracle DBA Job"

This isn't a "Lets Learn Oracle" product, but will focus exclusively on how to go from nothing to landing an Oracle DBA job as a new fish. I am spilling every thing I know into it. Interested? Then go get our copy now at http://jamesajr.com/

I am an Oracle Certified Professional, and I worked as an Oracle DBA for a major corporation. Before I was an Oracle DBA, I was writing and doing IT related stuff on the side. I became frustrated at the amount of money that I was pulling in, so I went online to check the current salary averages for different IT occupations. I was amazed to see that, according to Payscale.com, Oracle DBA's command an annual salary from $56,000 to $118,000. From that point on, I made up my mind that I was going to become an Oracle DBA.

Getting that first DBA job is rough; the problem is that nobody wants to hire an inexperienced DBA. It is a paradox almost, you cannot get a job without experience, yet you can get experience without the job. Taking the certification tests and studying the books is one thing, actual fieldwork is an altogether separate issue. When I took the tests to become Oracle certified, I constantly studied groups of questions that were on previous tests. Inevitably, some of those exact same questions were on the tests when I took them. This part of becoming an Oracle DBA is where you learn the concepts of database administration. You learn what Oracle is, what a database is comprised of, and how it operates. Once you get the fundamentals down and pass the tests, practice with a bunch of dummy databases. Concentrate on the following things:

1) Installing Oracle Database 8,9,10 - many new DBA's do not learn how to install Oracle because they think it is easy and that they will not be doing many installs. The fact is that learning how to install Oracle Database on a multitude of different operating systems is a valuable skill. You should practice doing the installs on operating systems such as Unix, Linux, AIX, Windows, and Sun Solaris. Also, be sure to practice installing older versions of Oracle such as 8i and 9i. These might be old versions but many databases are still using them. I was surprised at how many servers were running 8i when I started my first DBA job. I was a little worried because I had no prior experience using Oracle 8i. I knew nothing about the install requirements so I had to wing it as I went along.

Things turned out ok, but if I had practiced installing 8i when I was studying, I would have been much better prepared. If you only have one computer, like me, then you can download VMWare Player free and use virtualization to act as a second computer for installing Oracle. You treat the virtual machine as if it was just another computer, only you can access it from your Windows machine. It is a good idea to read over some of the installation and operation documents on VMWare's website in case you haven’t used virtualization before. A very useful site that I use just for this purpose is Easy VMX Creator. It is a site that can generate a virtual machine for you that is then loaded into VMWare; the best part is that you can fill out all the options at your discretion. It lets you specify the size of the hard drives you want on the virtual machine, as well as the memory and the Guest O/S version. After filling out all the info, you can just submit it and the site generates a zip file that you can then download to your computer and start it up with the VMWare Player. You can use virtualization for sharpening all of your database skills in fact. It is even possible, I know because I did it, to setup a 2-node Oracle RAC environment using an external IEEE1394 hard drive as the shared storage. You can setup the whole environment using VMWare Virtual Machines for each of your nodes. Beware though; this setup makes a significant impact on your computer's performance. You should only setup one virtual machine at a time unless your computer is very fast and has a lot of RAM to work with.

2) Import/Export - I cannot emphasize these tools enough. Newer versions of Oracle have newer tools called Data Pump Import/Export. It is just like the regular version but only more robust. Their outputs are NOT compatible however, so if you export with regular export then you must import with regular import. When you are working as a DBA in a production environment where you are managing 5 to 10 servers, each will probably have a dozen or so databases on them. This is a large-scale production environment. There will generally be some test databases, some development databases, and of course some production databases. Database refreshes will be very common. Quite often, you will be asked to import a dump file (name used for the output of the export tool) of one of the test databases into one of the production databases. This could be for any number of reasons, maybe one of the developers "blew up" the database, an affectionate term for rendering the database useless, and he needs to bring it back to a previous state. Import/Export is the perfect utility for this, so you should learn it and become familiar with its use. Learn all the different parameters that better facilitate the Import/Export process. Most environments that have a team of DBA's working on them will usually have a set of shell scripts located somewhere on the server to automate things like refreshes and restores. You would be doing yourself a favor if you went online and looked at a few examples of some of them, knowing the basic layout of a shell script will help you adapt to anything new.

3) RMAN - Recovery Manager is one of the reasons that Oracle is still going strong. No other database software, at least in my opinion, can come close to the power of RMAN. Yet it is simple to use, well the commands are simple anyway, learning how it functions is quite a bit more complicated. Depending on the methods of the DBA's where you work, you might not even have to worry about ever using RMAN. Some DBA's just use Import/Export and that is it. Some accounts do not call for anything more or simply do not want to pay for the labor involved. Regardless of whether or not you will use it at your work place, learning RMAN is an investment in your future. It is a marketable skill and looks great on your resume. Many people say they know how to use RMAN but when it really comes down to it, they know very little. The more you know about RMAN, the better, plain and simple.

4) Oracle Enterprise Manager - also known as OEM for short. OEM is a nifty little tool that can do many things, including making your life easier. Being that OEM is a graphical display; you can do all kinds of administrative tasks with a few clicks of a mouse that would normally require you to write out multiple lines of SQL code. You can use OEM as a starting point whenever you want to do anything to the database. It has some nice performance analysis tools that you can use to see how the database is performing on a regular basis, in real time. OEM has a couple versions. Database Control is OEM for a single database on a single server. Grid Control, its newest feature, can be used to administer multiple databases on multiple servers all from one screen. As you could probably imagine, Grid Control is also a marketable skill and it pays to learn the ins and outs of it.

5) Unix Commands - Often overlooked, this seemingly minor skill can have a drastic impact on your work as a DBA, as well as your reputation. When I first started learning Oracle, I had hardly ever used Unix in my life. Note that when I use the word Unix, I mean all variations of it (Linux, AIX, Solaris etc.). Thankfully, I learn new things very quickly. With a bit of studying and practicing with VMWare, I was using Unix commands like a true veteran in a few weeks. If the Oracle databases that you will be working are on Unix based servers, and there is a great chance they will be, then you will need to learn a bunch of commands to assist you in navigating your way through the directory structure. I am not going to start listing them here, but the few basic ones you should start with are ones like ls, cp, cd, rm, vi, more, ps, and top.These are the just a few basic commands but they are vital to an Oracle DBA. The best thing to do is buy the Unix for Oracle DBA's Pocket Guide from Amazon; it is an immensely useful resource. I cannot tell you how many times I have had to leaf through that book to find a certain command or option that I wanted to use. It is specifically for Oracle DBA's and you cannot beat it for $9.95.

Of course there are a million different things that you can work on to become a great Oracle DBA, but the above suggestions will help you build a solid foundation. Once you have your Oracle Certification and have become somewhat proficient at the basics you can then start applying for Oracle DBA jobs. Job seeking is always an uphill battle so do not get discouraged. The more interviews you get under your belt the better you will become at answering the employer's questions. Expect to hear no, or rather nothing at all, many times before getting a real shot at a job. You would have laughed your head off if you had heard my first interview. It was a telephone interview; many initial interviews are on the phone so employers can weed out the weak candidates without having to waste anyone's time. I was as green as a dollar bill, but eager to get the job. The employer was looking for a DBA with good performance tuning skills, something that I (or many other DBA's) did not possess at the time. One thing I learned from scaling the Oracle job market is that employers frequently do not know what they want; they just know that they need an Oracle DBA. Therefore, what they do is copy and paste a bunch of desired skills from other company's job ads and try to customize it for their own ad. Therefore, what you should do is apply for any position that has the words Oracle Database anywhere in the description. The number of them that just need a regular DBA, but don't write that in their ad, will amaze you.

When I first got on the phone with the interviewer, he said there were multiple people in the room and that I was on speakerphone. Great, as if I was not nervous enough. They asked me question after question and I bombed, mostly because I was a fish out of water, and wanted to impress. There is a first time for everything, so I cut myself some slack and moved on. I went through another three interviews before I got my first position. I learned that you must prepare yourself to answer basic questions about Oracle. What employers will do is copy questions from a website or book that they read, one that details how to conduct an Oracle interview. All you have to do is the same thing, find all the questions you can and write them down. I wrote them on 3x5 index cards, the question on the front and the answer on the back. They will ask what a redo log is, what a deadlock is, what to do first if the database is slow, and things of that nature. Take your flash cards and run through them until you can recite the answers verbatim. You will find yourself eager to answer their questions once you get in the interview, this is confidence. When you are confident in a job interview, it will show, and employers want to hire confident people, not someone who is afraid to talk because they might make a fool of themselves.

There are many places online where you can seek employment as an Oracle DBA. The popular ones are Dice.com, Yahoo Hot Jobs, Monster.com, and Indeed. You should sign up for free member accounts at these sites, and post your resume for prospective employers and recruiters to read. Be careful what you wish for though, if you do not want a million recruiters calling your house everyday then don’t make your phone number public. If you like, you can request that all responses be by email only. Whatever makes you comfortable.

Do yourself a favor and utilize the free resume writing resources that most of the job sites have these days. With all the free knowledge available, there is no excuse for a poorly written resume any longer. Make sure you submit a concise, well-written resume without grammatical and spelling errors. Employers will dismiss your resume once they see a spelling mistake, without giving it a second thought, so make sure you proofread your resume well. You should also have someone else read it before you submit it; another pair of eyes is sometimes the best prevention tool.

When it comes down to it, you can achieve anything you want if you really put your mind to it. A career as an Oracle DBA is something to be massively proud of, and there is no reason why you cannot have it. I hope this article has helped you in your quest to become an Oracle DBA, even if in just a small way, and I wish you the best of luck on your journey.

Oracle 11g For Dummies
Oracle 11g For Dummies
Amazon Price: $15.57
List Price: $29.99

 Last updated on February 13, 2014

Useful {4}Funny Awesome {1}Beautiful {1}Interesting {1}

Comments 69 comments

Thanks  5 years ago

Hello James,

I have to tell you that when I read this article I felt really identified with your story because is so similar to mine, I have 21 years old, actually I am working in a web design company but i really like the databases, i work with mysql and postgres but would like to learn oracle, i want to be an Oracle DBA, I know i have to read and to practice so much its a big deal i am arranged to do it, i hope you can help me with readings, examples, i will appreaciate that.

Thank you very much.

Enjoy every day.

James 5 years ago

Yes, becoming an Oracle DBA is not easy, but it is very possible. If you have experience with other databases (ie MySQL, DB2 etc.) then you already have knowledge of what Oracle is based on, they are all RDBMS relational databases when it comes down to it. SQL is SQL no matter what you use it on. My number one tip for someone who is just starting out would be to get VMWare and practice installing Oracle and creating databases, learning how to do exp/imp, shell scripts, tasks that the DBA does everyday. I say that because knowledge of these things is what will get you the job, other specialized knowledge will help you keep it. Best of luck to you in all your endeavors, if I can be of any assistance in any way by all means ask.

SPRATAP 5 years ago

James,

Could you please help me solving my below mentioned question.

Currently me working with the Backoffice of an Multinational Company in india & wants to move for Oracle DBA. But affraid for steps becouse i dont have any knowledge about DBA.

The second thing is, i wanna shift from india to other countries like US & UK, can i?

And the last one is the packege from employer will worth to move.

Please help to answer me.

Very confused.

Thaks

SPratap

Jim 5 years ago

SPratap,

My first question for you would be what is your current job now? What do you do on a daily basis, do you have any Oracle experience? If you were very experienced in other computer areas then it would be much easier than if you had no advanced computer skills.

As far as you working in the US and coming over from India, to be honest I know nothing about immigration policies or visas and such so I can't be much help to you in that department.

Lastly, I really haven't a clue if your employment package is worth it, I would need to know what it is before I could comment on it. If you want to explain it to me I would gladly give you my opinion on it. More information is needed to give you an honest informed answer to your questions.

Jim

SPratap 5 years ago

Dear Jim,

First of all thank you so much to answer my Q.

Sencond thing is me current work is with Data's of Excel files and have good knowledge in operating system & hardware.

As i have completed 2 years of IT course & 1 year of practice in a company, i am having a well knowledge in computers like (hardware, operating system & foxpro)

Very frank at the last, that i am getting around 2724/-GBP in india for my current job.

Also one more question is : now i am of 24 & can spend 2 more years for my better future. Now thinking to move for oracle, will it worth to move by package & by carieer.

Please help me solving this questions.

Thanks a ton.

sPratap

Megan 5 years ago

Hi James,

Thank you for your excellent article. I enjoyed a lot reading it. You have a very smooth and nice way to your writing, which makes it easy to read and understand. I am a Certified Oracle DBA myself and have no working experience. I am looking for an entry level DBA position. Thank you for the tips. I will start utilizing your suggestions. My E-Mail Address is: mojgha@yahoo.com.

Best Regards,

Megan

Krishna 5 years ago

Hi

James its one of the best real life experience guide for a new DBA. Can you please give some web id where dummy databases are availabe for practice.

Thanks

Krishna

Alfred George 5 years ago

Hello James,

Thank you so much for your info l'am a jr DBA myself and am looking for a job now l have an interview on monday am nervous this is my first time as a DBA l went to school in Lamham MD 5 months what can do to get my first DBA job my email add is ade2580@yahoo.com

srinivas 5 years ago

James ,

very very nice Hub,

it helps alot for who wants become DBA.

Sejal 5 years ago

Hello James,

Very much informative and detailed article. very happy to read the whole article as I am also newbi Oracle DBA. Thank you so much by writing this article.

Logicbench profile image

Logicbench 5 years ago from Arlington, Virginia

I'm not a coder myself, but I'v been a recruiter in that area. You Oracle guys and gals are all very distinct from the Microsoft crowd :)

work online data entry 5 years ago

Thanks for the hub i'm in the IM marketing field but very interested in coding.. just doing research. Great Hub!

Marcos 5 years ago

How did you get you first ORACLE DBA job? How many times were did you failed interviews

Jennifer Woo 4 years ago

Hi James and Everyone!

This article is very helpful for me (even everyone) to be a oracle DBA, start looking for first oracle job and keep focusing on study.

Despite I am old(29 yrs old) and female restarting my new career, it was very impressed to give me encouragement.

I am in Korea at the moment and I also have oracle certified but no working experience. n I have worked in other industry so far; even i graduated computer sicence degree.

My plan is I am going to find first oracle job in Australia. Even if I am not an English native speaker, i wil do my best untill i get the job!!

Let's share new n fresh information. my email is jiwstar@hotmail.com

Cheers

liveinoracle 4 years ago

Great man Nice to see ur attitude towards oracle

selvakumar 4 years ago

very nice article..thanks wasted 4 months.. didnt get job .. now i understand ..guys dont go to oracle dba field without experience (>2years)..

saish 4 years ago

hey , i really liked the article by you . I am a B.E 2008 passout , i got a trainee job in SISL but due to global recession me along with others were laid off, Now i am plannin to do an OCA 9i certification course .Please tell me if this wil help me to get an entry level job as a DBA , what other things should i know to increase my chances to get a job in the same field

saish 4 years ago

please also tell me if it could be easy to get that first DBA job ,please reply at teli.saishanker@gmail.com

Kingsley Tagbo 4 years ago

James, thanks for giving us a summary of how to get the first oracle DBA job.

I agree with you that the challenge facing a lot of newbie DBAs is the challenge of how to get credible, hands-on DBA experience.

Like you said, it is the classic chicken and egg which came first situation ... newbie Oracle DBAs need that first job to get hands-on experience and they are trapped because IT employers are so unwilling to give an IT worker that first break without the requisite hands-on experience.

What a dilemma!

How did you solve that James?

James Junior profile image

James Junior 4 years ago from New York, NY Hub Author

Wow, so many comments! Sorry if I left some of you hanging there, honestly I forgot about this hub for a while, been so busy. It sucks to see so many people out of work. Truth be told, I might be looking for a job in a few weeks myself. My company is centralizing all it's support into the midwest so unless I want to move into the sticks, I am stuck. Well, I am not moving anywhere. I am not that inexeprienced Oracle DBA anymore looking to break into the market. I have multiple years of managing huge production Oracle accounts, I am talking 2 and 300 databases. RAC, Data Guard, Grid Control, Disaster Recovery, you name it and I have done it at this place. Since I got here I have been working 60 hour weeks non stop.

For all of you who are out of work and wondering if an Oracle Certification will get you the next great job: man, that is a tough one really, I would hate to discourage you and tell you it can't be done. I did it, and the market sucked then too, and I was inexperienced, but still managed to get through. Luck? Somewhat, I believe you create your own luck. Lazy people with no motivation don't get lucky job offers out of nowhere. People who bust their ass everyday hitting the bricks looking for work are the ones who eventually catch a break.

Here is one way you could go. Get the Oracle Certification, then start looking for a DBA job. If the market in your area is real bad and you have zero results, start looking for MIS support jobs. Jobs like that can be easy to get if you have the right timing. Usually, the MIS Director just needs a warm body who can fix printers, get a new network whip down to the mail room, surf porn during lunch, normal office stuff. From there you can romance the in house DBA, if he/she is not an idiot. Tell them that you want to be a DBA and that you think they are a genius. Most people love to hear their favorite topic of conversation...themselves. From there, you can gradually get real world Oracle experience.

If not, there is always Barber college, or Clown camp.

JJ

Tanmay 4 years ago

Hi......

I really liked ur article and enjoyed reading it....

Its great to know that u are successfully working as Oracle DBA (thats my dream too !)

Basically I pursuing Computer Engg. (BE Comps) and have interest in databases....and so I was thinking of taking up Oracle certification, but I have few queries . I want u to guide me in shaping my career as DBA

1 : Will my qualification BE Computer + OCP DBA fetch good position in IT sector ?

2 : I Have lot of interest in DBs can u advice me the certification that I should target....currently I am thinking of OCP 9i....What current market expects ?

3 : Which areas should I target ...I mean mining, warehousing or other(plz specify) ?

4 : I m from India and have dream of working in countries like US, UK, Australia.....will this help me in fulfilling my dream ?

Please advice and suggest me on the above queries...

Please leave/mail ur feedback at MY ID : tannytsk@yahoo.co.in

THANX FOR SPENDING UR VALUABLE TIME :)

I HOPE UR ADVICE WILL HELP ME IN ACHIEVING AND FULFILLING MY DREAM AND SHAPING MY CAREER

WAITING FOR UR REPLY

BEST LUCK

Harbinder Singh 4 years ago

Dear JJ,

I would really like to thanks you for writing such a good article. i am 31 and still looking for job. I am broken and shattered. I have done a bit of all like c, C++, VB.NEt, Web Designing, Dreamweaver, PHP etc. But now I have made up my mind to do something seriouslly. I am very afraid of programming. I have chosen Oracle DBA to try seriusly. Is there any programming in that? kindly advice me from where I start learning Oracle and get a break in the industry. i have done my bachelors and masters degree in computers. I have no experience. but you must agree that a journey of thousand miles must begin with a single step. kindly spare some time to reply me. My email id is :> i_will_act_now@yahoo.com Hope you will reply and bless me.

Athar 4 years ago

Dear James;

I must appreciate the way you explain your experience, i am also looking for my OCP in 10g, i think your tips and guidelines will help the people who are interested in Oracle.As far as getting a job as an Orcale professional - a tough task, just keep on shearing

Thanks for article :)

Nash 4 years ago

Hi James,

First of all I would like to Thank you for posting such an excellent and a very helpful information on how to go about preparing well for an Oracle Dba job, especially for people who entering into this field for the first time and have no prior experience.

I have about 7 years of work experience, starting as a customer exec, next to tech support for Windows xp. I have knowledge in basic networking and hardware(CCNA certified), Redhat Linux(completed course not yet certified), Windows OS knowledge and recently completed a course on Oracle 9i and got OCP certification. I am also very much interested to switch my career as an Oracle Dba. But certain things are haunting me.. such as first my age-Iam 30, second i have only a graduation in Business Management and finally have no prior experience as an oracle Dba.

Will these be major disadvantages or can these be overcome by showing confidence and strong technical knowledge during interviews.. Plz advice..

Thank You very again

Nash.

Ashok Vyas 4 years ago

Hi James,

Really Good Article! Thanks for it. It proves the very old proverb that success can only be achieved by hardwork and there is no other shortcut.

Thanks once again

Ashok

James Junior profile image

James Junior 4 years ago from New York, NY Hub Author

I gotta tell you guys, one thing you learn after being a DBA for a period of time, is that there is no substitute for experience. I laugh and chuckle when I think about the things I didn't know a while back, because they are second nature to me now. I was lucky enough to get on an account with many many production databases, and now I have been appointed Senior Oracle DBA of this account. It is good and I enjoy the work, long hours though, but I don't mind.

kcranu 4 years ago

Hi,

I am 38 years old female and having 10 experience in marketing field and don't have any experience in IT sector, now i would like to change my career to IT sector and wants to do Oracle DBA . My questions are

1. Is it possible for me learn at this age without any IT knowledge ( only knows Ms Office)

2. If i learn will i get a job at this age? Can i able to sustain?

3. Main question is How to start and wants to learn from scratch point. Any websites are available with dummy databases to learn and wants to develop practical knowledge.

4. Can i learn through online or have to join any course, if atall i have to join what are the basic course i have take and how long it will take and cost also.

kindly help me.

my mail id : kcranu@gmail.com

Thanks and Regards,

Anu

Akshay 3 years ago

Hi james...

just went through your article and experiences the way you became a DBA.... I'm also going through the same rough phase of not getting a job as an Oracle DBA...I'm practicing all the skills through vmware and when i saw your article i felt happy that at least I'm on the right track...anyways after reading your article it has just boosted my confidence level.....and it was great reading your article

Anupam Thakur 3 years ago

James, you will be really surprised to know that today (June 05, 2010), I am really in a frustrated mood when I failed to crack my first interview as an Oracle DBA. I have completed all my 3 papers and was confident enough to face the interview. But when I faced the examiner, everything went wrong, I was not able to answer to the point and everything got messed up.

I came home and was thinking of my drawbacks as an Oracle DBA and searching on the internet to find the remedies. Suddenly I found your article and it boosted me and I became confident enough to face my next interview with full confidence.

Thanks for your article!

Sean 3 years ago

Hi James,

Your article is very well writen and indeed boosted many to see in direction which they failed.

Age factor plays a role in IT career,if you do not mind at what age did you manage to get into Oracle Enterprise employment.

Please mail to sjk29@live.co.uk.

Many Thanks in Advance.

Anriaa 3 years ago

Hi, I am 35 years old, mother, working in an Airline in India, Thinking about changing my carier in to IT and thinking about doing unix and orale, please let me know is it worth a try i do ahve a knowledge of computer i am have not done maths after my 10th std ,that is way back.... please help me if i can take the ourse and become DBA??? my main aim is to get into USA , due to my family situation , guys girls please help me..... and motivate me....

PHjrDBA 3 years ago

Hi James,

Thanks for you for this page titled "Getting That First Oracle DBA Job" now I have a good motivation, I was lost for about 3 years working as Jr. DBA, because the training I've asked before I get into this company was not given to me, but now that I read your simple story, it's motivate me again to pursue my career as a DBA, I'll start to buy a new personal PC with high specs in order for me to start all over again to fully understand the oracle DBA, thanks James, your a great motivator.. I'll visit your site everyday

PHjrDBA

James Junior profile image

James Junior 3 years ago from New York, NY Hub Author

Well, seems like every DBA I know is unemployed. I will be as well pretty soon. I am not moving out to the middle of nowhere to keep my job, I can't leave my family at this point in my life. Well, I hope all of you succeed and get that job, I hope I do as well. My chances are much better now that I have experience, way better than last time.

PHjrDBA 3 years ago

well James Good luck to all of us, hoping that we find the better place of DBA

PHjrDBA

rajesh pikku 3 years ago

Hi

I am agree with above comments. iam senior dba in orange business service gurgaon mnc company based on france.

oracle dba is not magic, it is lot of expeirance and hard work ,daily we learn some thing. in math some formula is there but in oracle milion of different type of error. so we learn just experince and hard working.

PHjrDBA 3 years ago

Hi rajesh

aside from James Tips, can you give us also? or can you give us and NEWBIE advice on how can we hook that DBA job

Regards,

PHjrDBA

mamun3d profile image

mamun3d 3 years ago

Swapnil Pimple 3 years ago

hi James thank u for your help nice article buddy

plz help to decide that,

i complete my OCP cource in Oracle 9i but can i complete my certification with 10g because everybody talking abt that oracle 9i is outdated

plz help me and give your suggestion

sneezee 3 years ago

wow this is such a inspiring blog. I am currently 22 (turning 23) and already facing a crisis in my life. I am in 10k debt and dropped out of college cause of my lazy ways. I've always been interested in computers but was studying medicine in college because it was what my family was pushing me towards. I've made bad decisions in my lifetime, but really want to turn it around. I want to be successful and live a happy life with long term gf but won't be able to if I don't get my life back on track. I want to be a DBA...is there any DBA here that can help me get my life back on track? I will forever be in your debt. I just need some questions answered. Please email me at sneezee2009@yahoo.com. I hope someone sees this post and be my savior.

Yashica Paul 3 years ago

hey James. I m OCA now,and preparing for OCP.I will become an Oracle DBA next month. Today in early moring,I was serching whether Girls can become efficient DBA or not??

The first link I got was yours. James,please tell me,,,m searching for job.I m an under-graduate now.How should I prepare for Interview?????Actually there is lot to learn In Oracle 10g,how should I start getting efficiency in my work???

I want to Join top MNCs...plz help...please

Yashica Paul 3 years ago

hey James. I m OCA now,and preparing for OCP.I will become an Oracle DBA next month. Today in early moring,I was searching whether Girls can become efficient DBA or not??

The first link I got was yours. James,please tell me,,,m searching for job.I m an under-graduate now.How should I prepare for Interview?????Actually there is lot to learn In Oracle 10g,how should I start getting efficiency in my work???

I want to Join top MNCs...plz help...please

Suraj kaushik 3 years ago

HELLO SIR I HAVE DONE BSE IT.WHAT FUTURE ME IN ORECAL DBA. I AM FIRSTRETSID SO PLEASE ME SIR.

Neddie 3 years ago

Thank you James, this Blog almost 2 years old or more and is still as valued today as it was when you first wrote it. I just got OCA 11g certified last week and have been thinking of the next step, looked over the internet for job the are there but all asking for experience. So I google to know what I should do next. I am 32 going to 33 in 6 months time and I don't think ago is a factor to anything I want to do in life. I just want to Thank you for your great advice.... this has changed the way I was thinking and is going to help develop the skills I need to get my first job as a DBA. God bless. I will like a personal mail from you mine is geraldobi@ymail.com

dipali 3 years ago

thank u so much . i'm too an m.sc(biochem) done b.ed, then wanted to change field. so did c-dac then teaching software sub and oracle. did oca certi of 9i oracle. i am a fresher in it industry will i get a job in database industry and i have a fly. i'm female 37 yrs of age. a daugh small who needs me can i get a part tie job. kindly do help do i need to do dot net too ? your article was very inspirational. i thought i was alone at such an age changing career. my email id is dipali20@yahoo.com. looking forward for the answer.

AARAV 3 years ago

Dipali,, you will surely not get a job in IT.

try to do couple of more Master degrees...

it always suprise me that how can we do masters in a subject we are not interested..

first be commited what u wanna do..

kumar 2 years ago

i want to become oracle dba and i m studing oracle 9i what else i have to study

thanx

Stephanie 2 years ago

The jobs are there. I sent my resume to Oracle a few weeks ago and got a phone interview today. I start with them on the 13th. I have zero DB experience and little knowledge. They are training me from scratch and all that they required is a 6 month contract at 15 an hout. Pay is so-so but the certifaction/training I will receive is priceless.

The jobs are out there! It was ironic because I was just offered a job 15 minutes before Oracle called me and now I ended up with two. Working with Oracle directly will be a shaining light at the end of that dark jobless tunnel.

Best of luck to you all who are searching and stay strong because something wonderful is right around the corner for us all!

Neeraj Gautam 2 years ago

Thank u so much James for that article. Thanks a tonn. I m a B.E 2010 passout and currently taking classes from SQL Star International,Delhi (India) for my OCA & OCP certifications. As u rightly said Oracle is so vast, so i was not getting the idea where to start from. Now u've shown us the path, i'll surely make my mark. Thank u so much sir for being an inspiration. I just have one query:-

"How important it is to be fluent in PL/SQL to become a successful Oracle DBA ?"

(Any suggestions from any of my friends are welcome)

James Junior profile image

James Junior 2 years ago from New York, NY Hub Author

Stephanie,

Best of luck on your DBA position. You are right, the jobs are out there; however, commuting either sucks, costs too much, or is impractical for many jobs that are available. Unless you live in a big city, positions that fit your skills exactly are at a premium. I would say that companies never hire stupid people for DBA's, but that would be a huge lie. I am amazed at how so many companies hand over millions of dollars of revenue and equipment to completely incompetent people. :)

Not that you are stupid or anything, I mean the opposite actually, that those with talent will eventually break through, every time.

Thanks Mukesh!

Neeraj,

Knowing SQL is critical, and if an experienced DBA sees that you need to lookup every line of a script just to know what it is, then he right away knows that you are not experienced. If you were, SQL would become a second language. I would use flash cards to memorize the most practical ones. Practice backups, installs, and etc. to get used to the cmd prompt. You should have no trouble doing it, SQL is not hard to get to know.

James

Sri 2 years ago

Hi,

I did BE (E&E)& MBA(HR)field.Currently am working in HR field from past 2 years.now i would like to change my career to IT sector and wants to do Oracle. Kindly suggest me which course(Oracle DBA,9i,10g) i need to choose in oracle and how i need to prepare for learning and to get job as fresher.

Please email me at koripalli.sri20@gmail.com

Thank u.

Ashwyn 2 years ago

Hello James,

I am a fresher and after many tries I have successfully landed myself with a job as an Oracle DBA.

Now, I am from EC engineering stream..however i was able to convince the interviewers that i would be able to get into such an environment in which i have no experience.

I am to start my 3 months training course from next week..and i would be glad if you could help me out with this...

I am sure that most of the things will be covered during the training period but what should i prepare before hand so that things go smoothly during the training period..considering the fact that i have limited knowledge about the necessary skills required...(as i am from EC background).

please do mail me at - shrestha.ashwyn@gmail.com

Ankita 2 years ago

Hey james nice article...

but i have so many doubts...As

I am 2010 pass out, done my B.E-IT.

then after i did Oracle from sqlstar... before joining it i asked them the scope of dba...

Now am OCA certified. almost 1.5 yr is completed for my graduation. nd almost 10 months for my oracle certification...

but still am not getting the job...

coz as fresher it is difficult to get into it...

Now am confused... plz help me...

can i go for OCP certification ??

or can i change the track n move on with developer profile..???

coz i hav already lost d value of my degree(B.E.), so now it is impossible to get into any company... so am totally depend on oracle...

plzz suggest me... Totally frustrated....

Ankita 2 years ago

plz reply...on my id

my email id is cooldd531@gmail.com

thanks... :)

Choosy 2 years ago

Hi James,

Thanks for the article,its a great one!I have a Diploma in Statistics/Computer and have so much love and passion for IT stuffs.I'm currently working in a bank as credit officer,but my IT dream keeps coming.I want to know,since i dont have a first degree(Bsc) 'll getting oracle certification(DBA) affect me negatively or postively in terms of job haunting?Pls your advice 'll go a long way,so here is my email:born2great@yahoo.co.uk,THANKS...

Anuj 2 years ago

thanks for sharing your experience with us . i am doing my ocp certification and yours tips would really help me prepare myself.

Qamar 2 years ago

James Junior,

All I could say is if you did it anyone one do it. Thank you for great inspiration detail article Oracle DBA. After reading your experience I am pretty optimistic I will study hard and very soon becomes another Oracle DBA soon. Please wait for my post after getting a job as Oracle DBA.

santosh shiggavi 2 years ago

Hello sir

I am santosh pursuing BCA final year degree , i am very interested in Oracle topic,your article encourages for juniors to get some ideas and also get interest towards oracle

Sir please give your e-mail address

else

send mail to this address

santoshshiggavi148@gmail.com

please sir

sudhakar 23 months ago

Hi James,

I appreciate that you answer all the questions which are asked by unknown people.

Regarding me, i changed my career from domain to domain, basically i was in mechanical stream, then to BPO and KPO and currently working for IT stream supporting BPO (infrastructure outsourcing).

In my organization people are skilled compared to me in work wise, even though i have 13yrs of experience this field is new to me. I Analyzed and came to conclusion of doing oracle DBA from NIIT as It does not require any other skill set apart from SQL as far as I understood. My concern is doing DBA 10g available in market is good, spending money for the course and as a fresher to they encourage in the market. Please reply me on my personal id sudhakar5478@gmail.com

guna 23 months ago

sir i need oracle dba 1year resume model...plz send gunatga@gmail.com

Vishal Shirke 22 months ago

vdsi2011@gmail.com

HI JAMES

FOR ME THIS IS INSPIRATION.VERY NICE ARTICAL & YOUR HARDWORK.

WHEN I WAS IN B.E LAST YEAR I DECIDED TO DO DBA BUT AFTER COMPLETION OF EXAMS I LOST MY WAY & GOT JOB WHICH WAS NOT TOTALLY RELATED TO DATABASE.NOW I AM DOING SAME JOB BUT ALSO COMPLETING OCP COURSE PLUS TAKING ON JOB TRANING FROM ONE OF DBA IN MY COMPANY.I WISH, NEXT 3-4 MONTH DEFINATLY I WILL GET BEST PAY DBA JOB.K THANKS FOR ARTICAL AGAIN.

Dan 22 months ago

Hi James

I have a degree in IT and at the moment Im working with MySQL databases, I have limited knowledge however I managed to use master-master replication on 2 databases to create backups if one goes down.

Ive just applied for a masters degree on databases and with that comes oracle certification. My course is 3 years. When it finishes I will be 30. I plan on testing my own oracle databases to gain experience too.

Is 30 too old to go start to be an oracle dba?

Thanks

Dan

rajiv 22 months ago

Enjoyed reading this

Twisha 18 months ago

I am the student of final year of B.E. E & C and beginner of Oracle please explain me which exam of schedule of OCA & OCP i have to give to become oracle DBA.

ahmad 17 months ago

i am saddam mulla n i'm pursuing BCA final year with DBA (OCA) course so plz send the 2 year exp. resume at ahemad.saddam25@gmail.com....

meet 16 months ago

hi,

i am oracle dba certifition , plsq developer . i am b.a arts graduated.

my oracle dba course complete 2nd year but my last year percent is very poor (47%) . can any company job in oracle dba/developer.

....plz any advices.

kannan 12 months ago

Hi

i am doing my odba, is that possible to get a job for bsc(s.a) because all the guys are from BE and B Tech and mcas

pls give suggestion and advice to improve myself

devibala.A 6 months ago

I am 32 years old female and having 10 experience in data entry field and don't have any experience in coding IT sector,

now i would like to change my career to IT sector and wants to do Oracle DBA . My questions are

1. If i learn will i get a job at this age? Can i able to sustain?

2. Will my qualification B.Sc Computer + OCP DBA fetch good position in IT sector ?

3. I Have lot of interest in DBs can u advice me the certification that I should target....currently I am thinking of OCP 9i....What current market expects ?

4. Which areas should I target ...I mean mining, warehousing or other(plz specify) ?

5. Main question is How to start and wants to learn from scratch point. Any websites are available with dummy databases to learn and wants to develop practical knowledge.

6. Can i learn through online or have to join any course, if atall i have to join what are the basic course i have take and how long it will take and cost also.

7. I m from India and have dream of working in countries like US, UK, Australia.....will this help me in fulfilling my dream ?

kindly help me.

my Email ID is devibala.sathya@gmail.com

surya 7 weeks ago

Hi james, presently I am working as software developer in n PHP and mysql from last 2.5 years. Due to some personal problem I was unable to do certifications. I love to work with oracle database, and have very good knowldge of sql and plsql. Now I am preparing for OCA and OCP for PLSQL developer. Can I get a good salary job in this new profile after certification.

Piyali 4 weeks ago

Hi james thanx for all info well I am a software student pursuing 1st year of engineering I ll start mysql in next semester so my question is should I start oracle right now I mean before mysql or I should start learning oracle along with mysql.

thanx

    Sign in or sign up and post using a HubPages account.

    8192 characters left.
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your Hubs or other sites.


    Like This Hub?
    Click to Rate This Article
    Please wait working