1st round : recruiter screen,
2nd round :(panel interview ,technical) : hiring manager + a DBA from the team. lasted almost 1hour>
questions like:
1)commands for datapump migrations, some parameters that can be used for performance improvement.
2)performance tuning questions(database is slow, a query is slow )
3) user managed backups , how would you do them
4) how to diagnose performance issues at host level (linux commands)
5) how do you ensure database security internally(concepts of least privileges, role based privileges)
3rd and final round on-site (hiring manager + IT head)
1 hour of cultural fit questions, very casual. conversational
1)talk about a time when you had to recover a production system. how did you work with the stakeholder s , how did you triage
2) Did you ever work with data breaches, what are some best practises you have implemented for data breaches.
3) How did you work in shared team environments in troubleshooting and addressing a broader system issue. what kind of things do you check to rule out a database issue.