Database Administrator Interview Questions

3,075 database administrator interview questions shared by candidates

How do you tune your queries? How do you troubleshoot SSRS performance issues? Tell me the HA/DR planning options you've done so far? Questions related to query optimization, SQL server perfomance enhancements, data modelling/design, Report design and development, implementation of security features...etc
avatar

SQL Database Administrator Developer

Interviewed at Ventera

4.4
Nov 10, 2018

How do you tune your queries? How do you troubleshoot SSRS performance issues? Tell me the HA/DR planning options you've done so far? Questions related to query optimization, SQL server perfomance enhancements, data modelling/design, Report design and development, implementation of security features...etc

It's 10am on Wednesday morning and you get a call from 2 users saying a report they run daily that normally takes 5 mins to run, has been running for the past 30 mins. Q. What questions would you ask ? How would you go about resolving the situation ? Q. How would you identify fragmentation ? How would you resolve it ?

Oracle Database Administrator

Interviewed at AppsTech

4.2
Sep 24, 2015

It's 10am on Wednesday morning and you get a call from 2 users saying a report they run daily that normally takes 5 mins to run, has been running for the past 30 mins. Q. What questions would you ask ? How would you go about resolving the situation ? Q. How would you identify fragmentation ? How would you resolve it ?

Viewing 1471 - 1480 interview questions

Glassdoor has 3,075 interview questions and reports from Database administrator interviews. Prepare for your interview. Get hired. Love your job.