Tell me about a time you had to handle a high-priority production issue.

Explain how you triaged the problem, what criteria you used to prioritize actions, and how you communicated updates to stakeholders to manage expectations.

Describe a conflict in a team you resolved.

Highlight your approach to listening, finding common ground, and documenting decisions to prevent recurrence.

Explain ACID vs BASE and where each applies.

Clarify core guarantees, give concrete scenarios, and discuss when eventual consistency is acceptable for application needs.

Describe indexing strategies and trade-offs for OLTP vs OLAP.

Discuss when to use B-tree, bitmap, or columnstore indexes, and the impact on write latency and read performance.

You notice a sudden production outage due to degraded performance; what steps do you take first?

Perform immediate triage to restore service, communicate status, and begin root-cause analysis while preserving data integrity.

A schema change is requested during peak hours; how do you handle it without disrupting users.

Assess risk, propose a low-risk approach (e.g., rolling changes, feature flags), and schedule a fallback plan.

Interview prep

Database Administrator interview questions

Interviews for this role typically probe your practical experience with database systems, including reliability, performance, and operational governance. Expect to justify trade-offs, demonstrate problem-solving under pressure, and show how you communicate with stakeholders.

See live database administrator jobs

Behavioural questions

1
Tell me about a time you had to handle a high-priority production issue.
What they're looking for: Explain how you triaged the problem, what criteria you used to prioritize actions, and how you communicated updates to stakeholders to manage expectations.
2
Describe a conflict in a team you resolved.
What they're looking for: Highlight your approach to listening, finding common ground, and documenting decisions to prevent recurrence.
3
How do you stay organized when managing multiple databases and tasks?
What they're looking for: Show your workflow, tooling, and prioritization methods that keep you aligned with SLAs and audit requirements.
4
Give an example of advocating for best practices when others bypass controls.
What they're looking for: Demonstrate how you diplomatically champion standards, implement guardrails, and measure compliance.
5
Describe a mistake you learned from in operations.
What they're looking for: Own the mistake clearly, focus on root cause, corrective actions, and how you strengthened processes to prevent repetition.
6
How do you handle on-call responsibilities and associated stress?
What they're looking for: Outline your incident protocol, stress coping strategies, and how you balance speed with quality in restorations.

Role-specific questions

1
Explain ACID vs BASE and where each applies.
What they're looking for: Clarify core guarantees, give concrete scenarios, and discuss when eventual consistency is acceptable for application needs.
2
Describe indexing strategies and trade-offs for OLTP vs OLAP.
What they're looking for: Discuss when to use B-tree, bitmap, or columnstore indexes, and the impact on write latency and read performance.
3
How do you design a backup strategy and how do you test restores?
What they're looking for: Cover RPO/RTO targets, full/incremental/differential backups, and practiced restore drills with validation.
4
What is your experience with replication (async/sync) and failover handling.
What they're looking for: Explain topology choices, consistency considerations, failover automation, and testing procedures.
5
How do you monitor DB performance; tools and metrics you rely on.
What they're looking for: Mention key metrics (latency, throughput, waits), tooling, and how you translate data into actionable improvements.
6
Explain normalization vs denormalization and when to apply denormalization.
What they're looking for: Define normal forms, justify denormalization for read-heavy paths, and discuss caching or materialized views as alternatives.
7
How do you perform capacity planning and growth projections for databases.
What they're looking for: Describe workload modeling, trend analysis, hardware/software scaling options, and risk-based planning.
8
What are common SQL tuning techniques and how do you approach a slow query.
What they're looking for: Outline execution plans, indexing, query rewrite, statistics maintenance, and testing impact in a staging environment.

Situational questions

1
You notice a sudden production outage due to degraded performance; what steps do you take first?
What they're looking for: Perform immediate triage to restore service, communicate status, and begin root-cause analysis while preserving data integrity.
2
A schema change is requested during peak hours; how do you handle it without disrupting users.
What they're looking for: Assess risk, propose a low-risk approach (e.g., rolling changes, feature flags), and schedule a fallback plan.
3
You need to migrate a database to a new version with minimal downtime; what's your plan?
What they're looking for: Choose a strategy (phased cutover, blue/green or shadow migration), test thoroughly, and ensure rollback readiness.
4
Your backup job starts failing; how do you troubleshoot and fix it quickly?
What they're looking for: Check job logs, verify media availability, validate retention policies, and implement a temporary recovery path while correcting root cause.
5
You are asked to implement encryption at rest; what steps do you take?
What they're looking for: Define scope, select encryption key management, ensure compliance with policies, and test performance impact and key rotation.
6
During a compliance audit, how would you demonstrate change auditing and access controls?
What they're looking for: Show how you capture change history, enforce least privilege, and provide sanctioned reports and traceability.

Sample STAR answer outlines

STAR — Situation, Task, Action, Result — keeps a behavioural answer focused. Use these outlines as a shape for your own examples, not a script.

Explain backup strategy and how you test restores.

Situation: In a previous role, we faced tight RPO requirements and needed reliable recovery.
Task: Design a backup plan that met RPO/RTO while minimizing storage and disruption.
Action: Implemented a tiered backup approach with daily full backups, log backups every hour, and automated integrity checks; established quarterly restore drills in a staging environment.
Result: Achieved verified recoveries within the target window and reduced time to restore by validating restore procedures ahead of incidents.

Describe replication and failover handling.

Situation: We needed zero-downtime failover for a mission-critical database tier.
Task: Choose replication topology and define failover automation.
Action: Set up asynchronous replication to a standby node, implemented automated failover with health checks, and documented rollback procedures.
Result: Failover occurred smoothly during a simulated outage with no data loss and minimal user impact.

Troubleshoot a failing backup job.

Situation: A nightly backup job started failing after a server patch.
Task: Identify the root cause and restore backups without delay.
Action: Checked logs, verified path permissions, reconfigured the job to use a valid retention period, and ran a manual test restore to confirm integrity.
Result: Automated backups resumed successfully with no data loss and a permanent fix implemented in the job configuration.

Rehearse out loud before the real thing

Answer these questions in an AI mock interview and get feedback on each response.

Check your CV first

Your next opportunity starts here

Prepare, apply, track, interview and get hired — all from one platform, with AI in your corner.

Download app

Or sponsor Premium for someone who's job hunting →

Database Administrator interview questions

Behavioural questions

Tell me about a time you had to handle a high-priority production issue.

Describe a conflict in a team you resolved.

How do you stay organized when managing multiple databases and tasks?

Give an example of advocating for best practices when others bypass controls.

Describe a mistake you learned from in operations.

How do you handle on-call responsibilities and associated stress?

Role-specific questions

Explain ACID vs BASE and where each applies.

Describe indexing strategies and trade-offs for OLTP vs OLAP.

How do you design a backup strategy and how do you test restores?

What is your experience with replication (async/sync) and failover handling.

How do you monitor DB performance; tools and metrics you rely on.

Explain normalization vs denormalization and when to apply denormalization.

How do you perform capacity planning and growth projections for databases.

What are common SQL tuning techniques and how do you approach a slow query.

Situational questions

You notice a sudden production outage due to degraded performance; what steps do you take first?

A schema change is requested during peak hours; how do you handle it without disrupting users.

You need to migrate a database to a new version with minimal downtime; what's your plan?

Your backup job starts failing; how do you troubleshoot and fix it quickly?

You are asked to implement encryption at rest; what steps do you take?