Several Years ago, When I started to look for Oracle DBA jobs, I decided to get certified in Oracle 10g.
Over the next few days, I had downloaded all the free Oracle eBooks. Every day, I had diligently studied for 2-4 hours. I painfully memorized all the minutia about Oracle internal database views. I was even able to find some sample tests. So I studied them too. As expected, I passed the certification exam with flying colors.
A few days after getting my certification, I attended my first Oracle DBA interview. I had answered all the questions with a smug smile, thinking who would NOT want me ?
Not even 30 minutes after the interview, I received an email saying I was REJECTED.
Fast forward to now, I am on the other side of the table interviewing people for Jr. and Sr. Oracle DBA positions. And I clearly understand why I got rejected in my first interview.
Firstly, I did NOT try to understand the real issues one would encounter while ACTUALLY doing the work. For example, upgrading from Oracle 10g to 11g. People don’t care much how many certifications you have. They want to know that you’ve had enough hands on.
Secondly, I was not good at performance tuning or SQL tuning. 80% of the DBA interviews are performance tuning questions.
The mistake I did was that, like a good student, I was staring at eBooks instead of getting practical hands-on experience. Of course, this kind of preparation would have gotten me an A in school. But it wont work in the real world.
So Instead of spending many days & a lot of money on Oracle certifications, set up your own Virtual Box and start practicing on the following topics.
5 most important topics for Oracle Interviews
Performance Tuning / SQL Tuning
Real Application Clusters (RAC)
Oracle Golden Gate
And obviously you should know about Oracle Architecture. That forms the basis for everything else.
If you would like more of my help with shaping your Oracle DBA career, take this 2-minute survey please.
If you hate taking surveys, just leave a simple comment below about the single most challenging thing you face in learning or becoming an Oracle DBA now.