Skip to contentSkip to footer

Lead Database Engineer Interview Questions

Salaries
Interviews

53 lead database engineer interview questions shared by candidates

As this is for Lead Database Administrator role. Interviewer checked about the knowledge on Databases with advanced versions. Highlighted on basics and scenario-based questions. Building -2node rac culuster in 19c env Data guard exp- manulaly set up DG backup questions archive logs are not shipping issues network glich and listner status issue DB is large and backup is taking lot of time to completed- reasons to reduce the backup time to complete. Rman backup issue Data export and import issues. Monitoring the DB based on tools Versions/Rac nodes/active/passive rac configuration of rac node Mat view refresh/partitions Performance issue connectivity issues
avatar

Lead Database Administrator

Interviewed at Ness Digital Engineering

4★
Feb 16, 2024

As this is for Lead Database Administrator role. Interviewer checked about the knowledge on Databases with advanced versions. Highlighted on basics and scenario-based questions. Building -2node rac culuster in 19c env Data guard exp- manulaly set up DG backup questions archive logs are not shipping issues network glich and listner status issue DB is large and backup is taking lot of time to completed- reasons to reduce the backup time to complete. Rman backup issue Data export and import issues. Monitoring the DB based on tools Versions/Rac nodes/active/passive rac configuration of rac node Mat view refresh/partitions Performance issue connectivity issues

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

He started out by saying this would be a conversation, not an interview. We spent about 40 minutes talking at a general level about bank, the job and him. Spent about 10 minutes discussing my background. We touched on the importance of prayer to him, and two other team leads that report to him and their roles ant outlook.
avatar

Database Team Lead - Oracle

Interviewed at M&T Bank

3.3★
Feb 23, 2015

He started out by saying this would be a conversation, not an interview. We spent about 40 minutes talking at a general level about bank, the job and him. Spent about 10 minutes discussing my background. We touched on the importance of prayer to him, and two other team leads that report to him and their roles ant outlook.

Viewing 1 - 10 interview questions

Glassdoor has 53 interview questions and reports from Lead database engineer interviews. Prepare for your interview. Get hired. Love your job.