Interview questions

Database Administrator Interview Questions

Essential Database Administrator interview questions on performance tuning, backup strategies, security, and high availability for hiring skilled DBAs.

What's here

12 Database Administrator interview questions, grouped into 3 areas: technical questions, behavioral questions and situational questions. Each one comes with why it is worth asking and what a strong answer contains, so the same question can be scored the same way by different interviewers.

Include a practical SQL performance tuning exercise with real execution plans
Test backup and recovery knowledge with scenario-based questions about data loss situations
Assess experience with specific database platforms relevant to your environment

Read the full article ↓

Database Administrators manage, optimize, and secure an organization's databases to ensure data integrity, availability, and performance. These questions evaluate expertise in database design, performance tuning, backup and recovery, and security practices.

Technical Questions

Assess the candidate's database management expertise, query optimization, and architecture knowledge.

1
How do you approach performance tuning a slow-running SQL query on a table with millions of rows?
Why ask it
Query optimization is one of the most critical and frequent DBA responsibilities.
What to look for
Execution plan analysis, index optimization, query rewriting, statistics updates, partitioning strategies, and understanding of query optimizer behavior.
2
Explain your backup and disaster recovery strategy for a mission-critical production database.
Why ask it
Data protection is the most important responsibility of a DBA.
What to look for
Full and incremental backup schedules, point-in-time recovery capability, off-site replication, regular restore testing, RPO/RTO definitions, and automated backup verification.
3
Compare the trade-offs between vertical and horizontal scaling for database workloads.
Why ask it
Tests understanding of database scaling strategies for growing applications.
What to look for
Vertical scaling simplicity vs limits, horizontal scaling complexity with sharding, read replicas for read-heavy workloads, and modern managed database scaling options.
4
How do you implement and manage database security including access control and encryption?
Why ask it
Database security is critical for protecting sensitive organizational data.
What to look for
Principle of least privilege, role-based access control, transparent data encryption, audit logging, SQL injection prevention, and compliance with data protection regulations.

Cohesyve

Screen Database Administrator candidates before you ask any of these

Cohesyve builds a Database Administrator assessment from your job description so interview time goes to people who have already shown they can do the work.

Try it free →Book a 30-min demo

Behavioral Questions

Evaluate incident response, collaboration, and communication skills.

5
Tell me about a time when a database outage occurred during business hours. How did you handle it?
Why ask it
Database outages have high business impact and test composure and technical skill under pressure.
What to look for
Calm incident response, quick diagnostic steps, clear communication with stakeholders, efficient resolution, and post-incident improvements.
6
Describe how you have worked with development teams to improve database performance of their applications.
Why ask it
DBAs must collaborate with developers who may not understand database optimization.
What to look for
Educating developers on efficient query patterns, establishing database coding standards, proactive query review, and collaborative optimization sessions.
7
How do you handle requests from different teams for conflicting database changes?
Why ask it
Tests ability to manage competing priorities and maintain database stability.
What to look for
Change management process, impact assessment, testing in non-production environments, scheduling during maintenance windows, and communicating trade-offs to stakeholders.
8
Tell me about a proactive improvement you made to database infrastructure before a problem occurred.
Why ask it
Evaluates proactive monitoring and capacity planning habits.
What to look for
Monitoring trend analysis, capacity planning, proactive index maintenance, performance baseline establishment, and anticipating growth-related issues.

Situational Questions

Present database management scenarios to assess decision-making and technical depth.

9
Your primary database server shows signs of impending disk failure during peak business hours. What do you do?
Why ask it
Tests ability to make critical decisions under time pressure with high stakes.
What to look for
Verify with monitoring tools, initiate failover to replica if available, alert stakeholders, plan emergency maintenance, and ensure backups are current.
10
A developer accidentally ran a DELETE statement without a WHERE clause in production. How do you recover?
Why ask it
Tests backup and recovery skills in an emergency scenario.
What to look for
Assess the extent of data loss, use point-in-time recovery from most recent backup, restore to a staging environment first to verify, and implement safeguards to prevent recurrence.
11
You need to migrate a legacy Oracle database to PostgreSQL with minimal downtime. How do you plan this?
Why ask it
Database migrations are complex projects requiring careful planning and execution.
What to look for
Schema conversion strategy, data type mapping, stored procedure rewriting, dual-write period, data validation, application compatibility testing, and cutover plan.
12
Query performance has degraded by 40% over the past month with no schema changes. What do you investigate?
Why ask it
Tests systematic diagnostic approach for gradual performance degradation.
What to look for
Statistics staleness, index fragmentation, data growth patterns, resource contention, parameter sniffing, concurrent workload changes, and hardware resource utilization trends.

Running the interview well

1Include a practical SQL performance tuning exercise with real execution plans
2Test backup and recovery knowledge with scenario-based questions about data loss situations
3Assess experience with specific database platforms relevant to your environment
4Evaluate understanding of both relational and NoSQL databases and when to use each
5Test knowledge of database automation and Infrastructure as Code for database provisioning

Common questions

What database platforms should DBA candidates know?

This depends on your stack, but versatile candidates know at least one commercial RDBMS (Oracle, SQL Server) and one open-source option (PostgreSQL, MySQL). Cloud database experience (RDS, Cloud SQL, Aurora) is increasingly important.

How important are cloud database skills for DBAs?

Very important in 2025. Most organizations use or are migrating to cloud-managed databases. DBAs should understand auto-scaling, serverless databases, managed backups, and cloud-specific optimization strategies.

Should DBAs have programming skills beyond SQL?

Yes. Scripting skills (Python, PowerShell, Bash) are essential for automation. Understanding of application development helps DBAs collaborate with development teams and identify application-level database issues.

Cohesyve · Skill assessments for hiring

Assess Database Administrator candidates before you interview them

Cohesyve turns a job description into a role-specific assessment with a scoring rubric. Each candidate gets a different version, so questions cannot be shared between applicants.

1,500+

assessments completed

50%

faster time-to-hire

90%

completion rate

5 min

from JD to assessment

No credit card · 10 free candidates · Plans sized to your hiring volume

For candidates

Preparing for a Database Administrator role yourself? Practise on the same AI job simulations companies use — 5 free assessments a month, no card required.

From the blog