Senior database engineer Interview Questions
142
Senior Database Engineer interview questions shared by candidates
How would you deal with a developer who writes bad code?
2 Answers↳
I personally would offer advice and point at similar solutions. I would not be confrontational and sort it out at release time if it was really bad. Perhaps I might want to inform my manager but this is down to level of competence. Nobody is ever wrong in my book, it all boils down to experience. Less
↳
Tell them "You see all those tasks we have outsourced to India? Do you want yours to be as well? Write better code" Writing readable code is essential, writing efficient code even more so. If a developer cannot do that properly, they need a good scare. Less
General questions about database and Systems Engineering. They were especially interested in flexibility to perform other tasks than the main purpose for the job. They were looking for a good variety of skills.
1 Answers↳
Interview on a floor with White Marble and large windows. Office space for the actual work is much less attractive. Less
In a nutshell: Will you move from your present position to our company for 4/5ths of your current salary?
1 Answers↳
Ha ha ha ha.
What considerations need to be made before partitioning a table in SQL Server
1 Answers↳
How the partition will interact with the indexing and query profile of the table
The HR questions were standard questions about my overall experience. I talked with several members of the development team. There were not really any specific technical questions, but mostly overall descriptions of what the job would entail. The hiring manager did ask a few technical questions but they were fairly simple. The hiring process has since changed, at least in the group I was in. The process is much more strict and the interviews are much more technical.
1 Answers↳
As indicated, questions were very simple
We have data that gets loaded once a week. With that in mind we have an application that clients enter search data in to and then SQL has to dynamically build a statement that has 25 different data points/relationships. It works fine, but takes upwards of 30 seconds to return the data to the client. You can not change the existing schema, but you can however add to it. Indexes are already present and optimized on all the different tables. What could you do to make this process much faster??
1 Answers↳
Without being able to restructure the existing schema your only choice is to de-normalize the data. When the data gets loaded on that weekly schedule, also build a flat table so there are no relationships being built. Less
