Interview questions
Database Administrator Interview Questions
12 Database Administrator interview questions on skills, past work and real situations, with what a strong answer sounds like. For interviewers and candidates.

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
Cohesyve finds, contacts and tests Database Administrator candidates on the real work, then ranks them for these interviews. 14-day free trial for 10 candidates, not charged until it ends.
Preparing for this interview yourself? Practise it free →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.
Before the Database Administrator interviews, see who can do the work
Cohesyve finds and contacts Database Administrator candidates from your job description and tests each one on an AI job simulation of the role, so these questions go to a ranked shortlist. 14-day free trial for 10 candidates, not charged until it ends.
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.
Save these questions for the Database Administrator candidates who can do the work
Cohesyve takes your Database Administrator job description, finds candidates, reaches out to them and runs an AI job simulation of the real work, then returns a ranked shortlist.
1,500+
assessments completed
50%
faster time-to-hire
5 min
from JD to assessment
14-day free trial · 10 candidates · Not charged until the trial ends
Preparing for a Database Administrator interview yourself? Practise on an AI job simulation of the role. 3-day free trial, cancel anytime.
From the blog