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
Sr Database Engineer Interview Questions
90 sr 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?
how will you implement transaction in SSIS
Was quizzed mostly on my RDBMS concepts and scripting knowledge.
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 EngineerDatabase EngineerTechnical AnalystSenior Database DeveloperSenior Database AdministratorSenior Oracle Database AdministratorDatabase Administrator Oracle DbaOracle Applications Database AdministratorSenior Data Warehouse ArchitectSenior Data EngineerPlsql DeveloperOracle Database AdministratorData Warehouse ArchitectDatabase Administrator IiSenior Oracle Applications Database AdministratorDeveloper It ApplicationsSenior Data Stage DeveloperOracle Database Administrator Developer