Senior database developer Interview Questions

65

Senior Database Developer interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Zeta Global
Senior Database Developer was asked...September 1, 2014

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

Camelot Integrated Solutions

What makes you feel you Are different from many programmers out

1 Answers

Thinking Out of Box

Lumeris

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

Morningstar

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

J.P. Morgan

Why do you want to work for JP Morgan Chase.

1 Answers

It is one of the best banks to work for and believes in investing in cutting edge technology Less

Amazon

Imagine implementing a Tic-Tac-Toe game with board size n rows and columns, how to check for a win after every move in O1 time?

1 Answers

Came up with an algorithm whereby the board position can be looked up in an array which immediately tells if that position completes a line, or two partial lines. The line structures exist in a hash table and are updated incrementally with each turn. In this way the board can be billion x billion squares but the look-up time complexity to check for a win is still O1. Less

Unilog Content Solutions

1. Introduce yourself 2. What are your strengths and weakness 3. Why do you choose this role 4. How do you justify this position if we hire you 5. How you can automate the file processing 6. Tell me couple of scenarios where you have used the triggers 7. Write the general syntax for procedure 8. How do you implement equi-width histograms 9. Usage of aggregate functions 10. CASE vs DECODE with examples

1 Answers

I answer all the questions in a very beautiful way with the perfect example from the previous experience. Less

BNY Mellon

Plsql performane tuning techs

1 Answers

Explain plan, sql trace, etc

Moody's Analytics

Specific questions on Data Migrations, Data Loads, Database tuning

1 Answers

Use case based scenario with examples, tools and technologies solving the business problems, various approaches to solve the problem. Less

EVERSANA

Given a real time scenario and asked to write query.

1 Answers

Instead of query output interviewers was more focused on logical thinking

Viewing 1 - 10 of 65 Interview Questions

See Interview Questions for Similar Jobs

database developersenior sql developer