1. questions on database components like sga,pga, bg processes ,undo ,redo and their internals. 2. RAC architecture and how it works. 3. postgres concepts and its internals 4. Some basic questions on python scripting
Senior Database Engineer Interview Questions
90 senior database engineer interview questions shared by candidates
Stupid questoins were asked. Architectural differences were asked.
How does MySQL replication work? What tuning variables affect MySQL? How do you determine why a SQL query is taking a long time to run? How do you skip major version upgrades with as little downtime as possible? What status variables tell you if the buffer pool is thrashing?
Was quizzed mostly on my RDBMS concepts and scripting knowledge.
how will you implement transaction in SSIS
General questions regarding business processes and development. Questions were not in line with the job description.
Tell me your experiences, the tech stack you use, do you data model. Take home - (1) write a SQL statement to put a score/metric together (2) write a Python script that reads a text file, counts the words, and gives back a text file with the word counts. Added complexity - spread the processing over 10 nodes.
Current work-related questions, nothing too fancy.
Why did you apply for this position?
Do you know what is time series data and have you had experience with it?
Viewing 51 - 60 interview questions
See Interview Questions for Similar Jobs
Senior Database DeveloperSenior Oracle Database AdministratorSr Database EngineerDatabase EngineerSenior Sql DeveloperSql Database EngineerSenior Database AdministratorTechnical AnalystPlsql DeveloperEtl DeveloperDatabase ArchitectSenior Data EngineerPl Sql DeveloperJunior Oracle Database AdministratorSenior Sql Server Database AdministratorDeveloper It ApplicationsSql DeveloperSenior Sql Database Administrator