J'ai postulé en ligne. Le processus a pris 2 semaines. J'ai passé un entretien chez ETS (Princeton, NJ) en juin 2015
Entretien
Not difficult. 6 people came for the in person interview. 2 managers. Director might come as well if he is in the office. Not hard at all but not easy as well.
Oracle Related. Troubleshooting, backups, patching etc
Describe various oracle states
How to change sql plan
What are optimizer hints and how to use them
Why use RMAN catalog
Connection pooling
J'ai postulé via un recruteur. Le processus a pris 1 jour. J'ai passé un entretien chez ETS en févr. 2015
Entretien
There was a very intense Q&A session on extremely detailed questions about why Oracle does what it does executing SQL code. It appeared right away there are serious issues with the application code and the DBA's spend most of their time chasing down badly written SQL.
Questions d'entretien [1]
Question 1
Explain why the Oracle Cost Based Optimizer chooses the execution plans for SQL and explain the different options used and what their impact is on performance?
