Senior Database Developer Interview Questions | Glassdoor

Senior Database Developer Interview Questions

15

Senior database developer interview questions shared by candidates

Top Interview Questions

Sort: Relevance Popular Date

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 Answer

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.

Why do you want to work for JP Morgan Chase.

1 Answer

Your last position was in Access?

1 Answer

No question is unexpected, just get familiar with SQL

Usually questions related to the technology you are being interviewed for. It was technical questions related to the Oracle database and questions related to the experience.

Basic questions about tables, triggers, sql performance tuning

2 hrs sql test is on a computer where the database is build and the questions to related to the data in the tables.

There really weren't any difficult interview questions

110 of 15 Interview Questions