Skip to contentSkip to footer

Senior Database Developer Interview Questions

Salaries
Interviews

86 senior database developer interview questions shared by candidates

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??
avatar

SQL Database Administrator/Senior Developer

Interviewed at Morningstar

3.8★
Apr 4, 2011

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??

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.
avatar

Senior Database Developer

Interviewed at Lumeris

3★
Jul 13, 2016

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. 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
avatar

Senior Database Developer Lead

Interviewed at Unilog Content Solutions

3.5★
Nov 8, 2020

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

Viewing 1 - 10 interview questions

Glassdoor has 86 interview questions and reports from Senior database developer interviews. Prepare for your interview. Get hired. Love your job.