Intervooh · Interview questions by job · Data & AI
Database Administrator interview questions (2026)
Database Administrator interviews in the UK are assessed on backup, recovery & availability, performance tuning, security & access control, usually across 3 stages — phone or video screen, then panel interview, then technical interview or test. The 12 questions below are the ones actually asked, each with what a strong answer does.
Researched, current questions asked in real database administrator interviews in the UK (Data & AI), with what a strong answer actually does. Questions marked 2026 are the newer, AI-era questions employers now ask. Last reviewed 2026-07-22.
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
How a database administrator interview usually runs
- Phone or video screen
- Panel interview
- Technical interview or test
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.
How to prepare for a database administrator interview in the UK
UK DBA roles skew SQL Server and Oracle in enterprises, with growing PostgreSQL and cloud-managed estates — expect scenario questions (corruption, slow query, failed job) rather than definition quizzes. Financial services and public sector will press on audit trails, access reviews and GDPR retention.
How Data & AI interviews are run in 2026
- Technical screens increasingly allow — or expect — an AI assistant for SQL and Python; live rounds then verify depth by making you reason out loud, so practise narrating your analysis without a keyboard.
- Case-style business scenarios ('retention dropped eight points — investigate') now carry as much weight as syntax questions; structured thinking beats memorised definitions.
- Take-home tasks are routinely followed by a live walkthrough and challenge round, because a polished take-home is now assumed to be AI-assisted.
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. It never writes your answers for you.
Related Data & AI roles
- AI Engineer interview questions
- Analytics Engineer interview questions
- BI Analyst interview questions
- Data Analyst interview questions
- Data Engineer interview questions
- Data Scientist interview questions
- Machine Learning Engineer interview questions