◆ Information Technology

What a database administrator
really does.

20 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.

20evidenced tasks
69,990in the US (2025)
$104,620median pay / year
7systems it runs on
See the 20 tasks ↓Open in the atlasThe full career map →
This is what one task looks like here
Secure database access
Audit all production accounts and revoke unused logins, enforce role-b…4 sources agree

The shape of the day

tap a movement to see its tasks

Which one is you, right now?

Pick the moment · no score, no sign-up
Which moment is you right now?
Whichever you pick, the task behind it opens below.

The work, task by task

20 tasks
Hands on the work14
Manage computer databases+
Reconcile table growth and index usage across the primary cluster, compress cold partitions, apply the planned patch to the maintenance node, and update the database inventory and capacity forecasts for next quarter.
escoonetwiki3 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Install database software+
Install the new database engine on the two production servers, configure storage paths and memory settings for the customer_orders cluster, run the post-installation schema validation, and report completion to Maya by Friday afternoon.
jdwiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Perform database tuning and indexing+
Analyze the slow queries on the sales reporting instance, add or rebuild indexes on the top three offending tables, adjust memory and parallelism settings, run the regression test workload, and log the changes in the DBA ticket for Paul.
jdonet2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Backup database data+
Create a full backup of the inventory database to the archival storage location, verify checksums, rotate the daily backup set keeping seven versions, and email the backup report and restoration test results to Operations.
jdwiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Plan capacity for databases+
Estimate storage, IOPS and CPU headroom for the three production clusters for the next 12 months based on last 18 months' growth, include monthly projected thresholds that trigger shard addition or instance resize, and produce an action timeline for procurement and migration.
wiki
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Recover data after failures+
Restore the latest validated full backup and apply incremental logs to rebuild the sales and ledger tables to the point-of-failure, verify row counts and checksum against the pre-failure snapshot, then document the steps and hours for postmortem.
wiki
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Design database structures+
Design normalized and partitioned schema for the customer orders system to support 200 million rows, include indexing strategy, retention policy, and a migration plan that keeps nightly ETL windows under two hours.
onetwiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Troubleshoot database issues+
Investigate the weekend slowdowns on the reporting cluster: gather recent query plans, top wait events, node resource stats, and the error logs, then propose immediate mitigation and a durable fix for next sprint.
jdwiki2 agree
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed. Helpful?
Watch and assess2
Grow the practice2
Keep it safe1
Work with people1

What the work runs on

named inside the evidenced tasks
4 tasksApache Kafkasimulates production change-data-capture and replication flows to validate transactional integrity and latency during tests
3 tasksAnsibleautomates credential rotation and pushes role and policy changes across database hosts
3 tasksApache Hadoophandles large-scale storage management, partition compression, and batch maintenance tasks across the cluster
3 tasksApache Cassandrastores and queries large distributed datasets where index and compaction tuning are applied
3 tasksApache Hiveused for diagnostic queries and analyzing query plans on large analytic datasets
2 tasksAmazon Elastic Compute Cloud EC2provisions and configures the servers where the database engine will be installed
2 tasksApache Airfloworchestrates diagnostic tasks and scheduled checks that the junior staff will run as part of troubleshooting workflows
Browse every evidenced software task →

The same task, four heights

this page is height one
ExecuteDo today's task, with fewer mistakesyou are here → ImproveMake it easy for the next person to acceptin the atlas → DecideWork out the right move when it is unclearin the atlas → BecomeLearn the pattern so it stops coming backin the atlas →

Can AI actually do this job?

the honest answer

It can

where it genuinely helps
  • Explain the theory behind the work
  • Draft, tidy and structure your writing
  • Rehearse a hard conversation before you have it
  • Build a study plan that fits your gaps

It cannot

where it stops, completely
  • Be in the room where a database administrator actually works
  • Carry the responsibility when the call is wrong — that weight stays yours
  • Notice what no one wrote down: the hesitation, the thing left unsaid
  • Live with the outcome

What the work pays

two countries, two different measures

United States

this exact occupation · BLS 2025
  • $104,620 a year — the middle: half earn more, half earn less
  • The lowest tenth earn near $60,230; the top tenth near $163,320
  • 69,990 people employed in this occupation

India

the occupation GROUP, not this job · PLFS via ILOSTAT 2025
  • ₹38,298 a month — the median for Professionals, the group this work sits in
  • India publishes pay by broad occupation group, so this covers many jobs besides this one. It is a shape, not a salary.
read this carefullyThese two numbers are not comparable and must not be converted into each other. One is a yearly figure for this job alone; the other is a monthly figure for a whole family of jobs. What travels between them is the pattern, not the amount: experience lifts pay almost everywhere.

Where the evidence lives

open any of it yourself
O*NETThe US Department of Labor's own record of this job9 of these tasks ESCOThe European skills and occupations register3 of these tasks Job descriptionsReal postings, in the wild11 of these tasks WikipediaHow the world describes this work9 of these tasks US Bureau of Labor StatisticsPay and employment, by occupation2025 figures UK NOS TECHDUDB2Create databases to store and retrieve datanational standard UK NOS ESKIDMS3LDatabase management software LEGACYnational standard

Close to this work

7 nearby
Information TechnologyDevops Engineer20 evidenced tasks Information TechnologySystems Engineer20 evidenced tasks Information TechnologyNetwork Engineer20 evidenced tasks Information TechnologyNetwork Administrator20 evidenced tasks Information TechnologyIt Support Specialist20 evidenced tasks Information TechnologyHelpdesk Technician20 evidenced tasks Information TechnologySolutions Architect20 evidenced tasks

Questions people actually ask

A typical day mixes routine checks and problem fixes. You start by monitoring database performance (CPU, queries, storage), review overnight backups, and check alerts from monitoring tools. Expect to tune slow queries, apply an urgent patch, or help a developer who broke a deployment.

Afternoons often include planning: capacity forecasting for growth, designing a new table or index, and writing runbooks for recovery steps. You also train users or junior staff and may join incident calls if a failure occurs.

Learn both relational and distributed systems. Start with a relational engine (MySQL, PostgreSQL) and one big distributed system listed above, like Apache Cassandra for wide-column stores and Apache Hive for big-data queries on Hadoop.

Also get comfortable with supporting tech: Apache Kafka for streaming data, Apache Airflow for job scheduling, and cloud basics like Amazon EC2. Knowing Ansible for automation and patching helps you manage many servers quickly.

You use Ansible to install database software, push security patches, and keep configuration consistent across nodes—so you don't hand-edit dozens of servers. Ansible reduces human error during upgrades and installs.

Airflow schedules and monitors ETL jobs, like loading data into Hive or triggering Cassandra repairs. Use Airflow for repeatable testing, backups, and recovery workflows so they run on time and you can replay failures.

According to the U.S. Bureau of Labor Statistics (BLS), about 69,990 people were employed as database administrators and database architects in 2025. The median pay was $104,620 per year, the lowest tenth earned $60,230, and the top tenth earned $163,320.

Salaries vary by location, experience, and technology (cloud or big-data roles often pay more). Use the BLS data above to set expectations for offers and negotiate.

A DBA focuses on installation, security, backups, tuning, downtime minimization, and recovery of databases (tasks like patching, indexing, and capacity planning). You manage the database as an operational service.

A data engineer builds data pipelines and transformations (using tools like Kafka and Airflow) and designs schemas for analytics. There’s overlap—DBAs often work with data engineers on Hive, Kafka, and Hadoop systems—but the DBA is responsible for availability and recovery.

You must be good at backups and recovery: perform and test full restores, use high-speed transaction recovery techniques, and minimize downtime. Practically, know how to run restores on replicas and validate data after failure.

Also master performance tuning (indexes, query plans), install and patch database software safely, and use monitoring and automation (Ansible, Airflow). Strong troubleshooting, reading logs, and writing clear runbooks for incident and problem management are essential.