Database Administrator Interview Questions

1.1The DBA role - responsibilities, types of DBA, and how the role differs by organisation size and platform

1.2Relational database fundamentals - tables, relationships, keys, normalisation, and the relational model

1.3Database architecture - instances, databases, schemas, tablespaces, and how a database server is structured

1.4Database management systems - differences between major platforms and the DBA knowledge required for each

2.1Database installation - planning, prerequisites, and a structured installation approach

2.2Post-installation configuration - memory, storage, network, and security settings for production readiness

2.3Database upgrades and patching - planning, testing, rollback strategy, and managing the maintenance window

2.4Database cloning and provisioning - creating new databases from templates or backups for development and testing

3.1Query optimisation - execution plans, index usage, and rewriting queries for performance

3.2Indexing strategy - types of indexes, when to use them, and the cost of over-indexing

3.3Wait event analysis - identifying the bottlenecks that slow down database operations

3.4Instance and memory tuning - configuring the database for optimal performance under the workload

4.1Backup strategies - full, incremental, differential, and log backups and designing a backup plan

4.2Recovery scenarios - point-in-time recovery, block corruption, and recovering from different failure types

4.3High availability - replication, clustering, and designing for zero unplanned downtime

4.4Disaster recovery - standby databases, failover testing, and meeting RTO and RPO requirements

5.1Database security principles - authentication, authorisation, and the principle of least privilege

5.2User and role management - creating accounts, assigning permissions, and auditing access

5.3Data encryption - transparent data encryption, column-level encryption, and protecting sensitive data

5.4Database auditing - audit trails, activity monitoring, and detecting suspicious behaviour

6.1Database storage management - data files, log files, temp space, and managing growth

6.2Storage performance - IOPS, throughput, and configuring storage for database workloads

6.3Capacity planning - forecasting storage growth, planning for peak load, and avoiding capacity crises

6.4Tablespace and file group management - adding space, moving data, and reorganising storage

7.1DBA automation - using scripting to eliminate repetitive tasks and reduce human error

7.2SQL scripting for DBAs - the queries and scripts every DBA uses daily for monitoring and maintenance

7.3Job scheduling - automating backups, maintenance jobs, and health checks

7.4Configuration management - managing database configuration at scale and detecting configuration drift

8.1Database monitoring - what to monitor, alert thresholds, and the tools used to do it

8.2Proactive performance monitoring - identifying problems before they impact users

8.3Capacity and growth monitoring - tracking trends and forecasting before hitting limits

8.4Incident response for databases - how DBAs respond to outages, corruption, and performance emergencies

9.1Cloud database services - managed database offerings, the DBA role, and what the cloud changes

9.2Database migration to cloud - assessment, planning, and executing a lift-and-shift or re-platforming

9.3Modern database architectures - distributed databases and when to use non-relational approaches

9.4DevOps and the DBA - database CI/CD, schema migration tools, and fitting the DBA into agile delivery

10.1Technical questions - performance tuning, backup and recovery, security, and high availability

10.2Scenario questions - how you handled an outage, a corruption event, or a performance crisis

10.3Platform-specific questions - demonstrating depth in the specific database technology the role requires

10.4Salary negotiation for DBA roles, evaluating a database environment, and questions that reveal the real operational maturity