What does a Database Administrator do?
A Database Administrator keeps an organization's databases available, fast, recoverable, and secure, and makes sure the data inside them survives failures, mistakes, and change.
Hire for the production environment the DBA will protect. High availability, disaster recovery, performance, security, and backup matter more than how many database products a resume lists.
Responsibilities
The role covers installation, configuration, patching, upgrades, monitoring, tuning, access control, backup, recovery, and capacity planning across one or more database platforms. Senior DBAs also design high-availability architecture and lead migrations.
Keep data available and recoverable
Design and operate high-availability and disaster-recovery configurations, run backups, and prove that restores actually work.
Meet the recovery time and recovery point objectives the business depends on.
Keep databases fast
Monitor workloads, tune queries and indexes, manage storage and memory, and plan capacity before performance problems reach users.
Work with developers to fix inefficient queries at the source.
Keep data secure
Manage access, roles, encryption, auditing, and patching so sensitive data stays protected and compliant.
Support audits with evidence of who can reach what data and how changes are controlled.
What environment will the DBA own?
The same title covers very different jobs. Before writing the description, define the environment the hire inherits.
- Platforms and versions. SQL Server, Oracle, PostgreSQL, MySQL, or a mix, and whether older versions still need support.
- Hosting model. On-premises, self-managed in the cloud, managed services such as Amazon RDS or Azure SQL, or a hybrid of all three.
- Availability and recovery targets. How much downtime and data loss the business can tolerate, and how those targets are tested.
- Compliance obligations. HIPAA, PCI DSS, SOX, or other requirements that shape access, encryption, auditing, and retention.
- Change ahead. Planned upgrades, consolidations, or migrations to the cloud or to a different platform.
A DBA who will support five mission-critical Oracle databases with strict recovery targets is a different hire from one who will manage dozens of small PostgreSQL instances on a managed service.