I applied in-person. The process took 1+ week. I interviewed at Oracle (Pleasanton, CA) in Nov 2011
Interview
It began with a phone interview with them feeling me out and me doing the same. Then a 1 on 1 Interview with another consultant a few day later giving me more detail about the position, Last a Panel interview with the Management staff grilling me with questions.
2 rounds of technical - They will ask all the technical questions based on your resume. Quite difficult
1 Manager Round - They will ask technical questions and managerial questions
Interview mostly they will ask the basics but from each and every topic for Oracle DBA like configuration, architecture, RMAN, EXP/IMP, Performance Tuning, RAC, Golden Gate, Exadata and Cloud platform question etc.
There was 2 technical interview and one managerial round. L1 round was with some Java coding using stream and theoretical questions and L2 round was more about the scenario based questions