Intervooh · Interview questions by job
Database Administrator interview questions (2026)
Researched, current questions asked in real database administrator interviews (Data & AI), with what a strong answer actually does. Questions marked 2026 are the newer, AI-era questions employers now ask.
Build my free day-by-day prep plan →
Tell it the company, role and date; it does the rest. Free, no card.
What they assess
- Backup, recovery & availability
- Performance tuning
- Security & access control
- Automation & cloud
The questions to expect
Walk me through your backup strategy — and the last time you actually tested a restore.
The second half is the real question. Untested backups aren't backups — describe your restore drills, RPO and RTO in plain terms.
A production database is corrupted at 9am on month-end. Talk me through your first hour.
Communicate first, then assess scope, then restore to a point in time — narrating who you'd tell and when is half the marks.
A critical query got slow overnight with no code change. How do you diagnose it?
Execution plan, statistics, parameter sniffing, index health, blocking, what else changed on the server — a stated order shows method.
When does adding an index make things worse?
Write-heavy tables, maintenance overhead, the optimiser ignoring it, duplicate near-identical indexes. A real cleanup story lands well.
How do you manage who can access what in your databases — and how would you evidence it in an audit?
Least privilege via roles, no shared accounts, regular access reviews, logged changes. The audit angle matters in UK regulated sectors.
Tell me about something you automated that used to be manual DBA toil.
Patching, health checks, restore tests, provisioning — quantify the hours saved and errors removed. Modern DBAs script themselves out of toil.
Describe a time you pushed back on a change that put data at risk.
Being the calm 'no' is part of the job. Show you offered a safer path rather than just blocking, and what the outcome was.
Tell me about a database migration you led. What went wrong, and how did you handle it?
Every migration has a wobble — rehearsals, rollback plans and honest lessons are what interviewers want to hear about.
Why database administration? What keeps this work interesting for you?
Custodianship is a fine answer: you like being the person the data is safe with. Add what you're learning to stay current.
With managed cloud databases and AI tuning advisors, where does the DBA still add value?2026
The role shifts up: architecture, cost control, recovery design and judging the advisors' advice. Sound like someone riding the change.
Walk me through a piece of analysis or a model that changed a business decision.
Name the decision, not just the deliverable. The strongest answers end with what the business did differently and what that was worth.
Tell me about a time a stakeholder challenged your numbers. How did you respond?
Show you checked before defending. Being openly willing to find your own error is what builds trust in your numbers.
Preparation notes
[object Object]
Turn this into a plan
A list of questions is a start; a programme is what changes the outcome. Intervooh builds a day-by-day plan for your exact database administrator interview — company research, story building with an AI coach, spoken practice with delivery feedback, and scored mock interviews.