ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Business and Employment»
  • Employment & Jobs

Getting That First Oracle DBA Job

Updated on February 13, 2014

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


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, 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, Yahoo Hot Jobs,, 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.


    0 of 8192 characters used
    Post Comment

    • profile image

      jagannath 2 years ago

      hi james,

      currently i am working as network engineer in a well known company in india. my concern is that i'm willing to be a oracle DBA. currently i use various oracle tools and also create queries of sql,pl/sql on my current job. all i need from you is a perfect suggestion how and from where should i begin to prepare to be a Oracle DBA.

      thanks !!

    • dhimanreena profile image

      Reena Dhiman 3 years ago

      Thanks for sharing your job experience in the Oracle industry. This post is very helpful for us.

    • profile image

      meet 3 years ago


      i am oracle dba certifition , plsq developer . i am 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.

    • profile image

      subbu 3 years ago


      Getting DBA job is Easy or Hard

    • profile image

      J@ye$h 4 years ago

      Hi James.. and everyone to say Hi..

      Thank You Very Much for this article,i have to say really need to this reality and all this knowledge,so thanks to once again..:)

    • profile image

      meet 4 years ago


      i am oracle dba certifition , plsq developer . i am 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.

    • profile image

      Piyali 4 years 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.


    • profile image

      surya 4 years 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.

    • profile image

      devibala.A 4 years 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

    • profile image

      kannan 5 years ago


      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

    • profile image

      meet 5 years ago


      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.

    • profile image

      ahmad 5 years 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

    • profile image

      Twisha 5 years 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.

    • profile image

      rajiv 5 years ago

      Enjoyed reading this

    • profile image

      Dan 6 years 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?



    • profile image

      Vishal Shirke 6 years ago

      HI JAMES



    • profile image

      guna 6 years ago

      sir i need oracle dba 1year resume model...plz send

    • profile image

      sudhakar 6 years 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

    • profile image

      santosh shiggavi 6 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


      send mail to this address

      please sir

    • profile image

      Qamar 6 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.

    • profile image

      Anuj 6 years ago

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

    • profile image

      Choosy 6 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,THANKS...

    • profile image

      Ankita 6 years ago

      plz reply...on my id

      my email id is

      thanks... :)

    • profile image

      Ankita 6 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....

    • profile image

      Ashwyn 6 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 -

    • profile image

      Sri 6 years ago


      I did BE (E&E)& MBA(HR)field.Currently am working in HR field from past 2 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

      Thank u.

    • James Junior profile image

      JA Junior 6 years ago from New York, NY


      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!


      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.


    • profile image

      Neeraj Gautam 6 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)

    • profile image

      Stephanie 7 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!

    • profile image

      kumar 7 years ago

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


    • profile image

      AARAV 7 years ago

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

      try to do couple of more Master degrees...

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

      first be commited what u wanna do..

    • profile image

      dipali 7 years ago

      thank u so much . i'm too an 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 looking forward for the answer.

    • profile image

      Neddie 7 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

    • profile image

      Suraj kaushik 7 years ago


    • profile image

      Yashica Paul 7 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

    • profile image

      Yashica Paul 7 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

    • profile image

      sneezee 7 years ago

      wow this is such an 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 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 I hope someone sees this post and be my savior.

    • profile image

      Swapnil Pimple 7 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

    • mamun3d profile image

      mamun3d 7 years ago

    • profile image

      PHjrDBA 7 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



    • profile image

      rajesh pikku 7 years ago


      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.

    • profile image

      PHjrDBA 7 years ago

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


    • James Junior profile image

      JA Junior 7 years ago from New York, NY

      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.

    • profile image

      PHjrDBA 7 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


    • profile image

      Anriaa 7 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 have 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....

    • profile image

      Sean 7 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

      Many Thanks in Advance.

    • profile image

      Anupam Thakur 8 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!

    • profile image

      Akshay 8 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

    • profile image

      kcranu 8 years ago


      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 :

      Thanks and Regards,


    • James Junior profile image

      JA Junior 8 years ago from New York, NY

      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.

    • profile image

      Ashok Vyas 8 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


    • profile image

      Nash 8 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


    • profile image

      Athar 8 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 :)

    • profile image

      Harbinder Singh 8 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 :> Hope you will reply and bless me.

    • profile image

      Tanmay 8 years ago


      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 :





    • James Junior profile image

      JA Junior 8 years ago from New York, NY

      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.


    • profile image

      Kingsley Tagbo 8 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?

    • profile image

      saish 8 years ago

      please also tell me if it could be easy to get that first DBA job ,please reply at

    • profile image

      saish 8 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

    • profile image

      selvakumar 9 years ago

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

    • profile image

      liveinoracle 9 years ago

      Great man Nice to see ur attitude towards oracle

    • profile image

      Jennifer Woo 9 years ago

      Hi James and Everyone!

      This article is very helpful for me (even everyone) to be an 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 until i get the job!!

      Let's share new n fresh information. my email is


    • profile image

      Marcos 9 years ago

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

    • profile image

      work online data entry 9 years ago

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

    • Logicbench profile image

      Logicbench 9 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 :)

    • profile image

      Sejal 9 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.

    • profile image

      srinivas 9 years ago

      James ,

      very very nice Hub,

      it helps alot for who wants become DBA.

    • profile image

      Alfred George 9 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

    • profile image

      Krishna 9 years ago


      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.



    • profile image

      Megan 9 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:

      Best Regards,


    • profile image

      SPratap 9 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.


    • profile image

      Jim 9 years ago


      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.


    • profile image

      SPRATAP 9 years ago


      Could you please help me solving my below mentioned question.

      Currently me working with the Backoffice of a Multinational Company in india & wants to move for Oracle DBA. But afraid 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.



    • profile image

      James 9 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.

    • profile image

      Thanks  9 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.


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: ""

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)