For students and early-career professionals

Database Administrator

Manages databases to keep data organized, backed up, and available for systems.

14 chapters · About 3 months · 15–30 min a day

Start this plan free →

Chapter 1 is free.

Skills

14 skills, and what you'll learn in each

Each skill is a few short lessons, then practice. You rate yourself at the start and again at the end.

Core to the job

Chapter 2

Monitoring

Fix a noisy alert and rank alerts by user harm

What you'll learn

  • Metrics logs traces
  • Four golden signals
  • Actionable alert
  • Service level objective

Practice

  • Turn a storage growth table into a warning worth waking up for20 min

Chapter 3

Incident response

Build an incident timeline from logs and write plain updates

What you'll learn

  • User impact first
  • Mitigate before root cause
  • Blameless post-mortem
  • Incident command roles

Practice

  • Analyze How a Company Communicates During an Outage15 min
  • Write an on-call handoff note15 min

Chapter 3

Backup and recovery

Agree acceptable data loss, then time a restore from backup

What you'll learn

  • Recovery objectives
  • Backup types
  • Where the copy lives
  • Retention choices
  • The restore test

Practice

  • Set the Two Recovery Numbers for Three Services25 min

Chapter 6

Databases and SQL

Write SQL to filter and join data, and design tables

What you'll learn

  • Tables and relationships
  • Joins and groups
  • Index trade-offs
  • Query plan
  • Lock behaviour

Practice

  • Decide which of six indexes to drop20 min
  • Write the safe order for a column change on a busy table25 min

Chapter 7

Scripting

Write a script that checks disk space and warns you

What you'll learn

  • Script arguments
  • Error handling
  • Input checks
  • Readable scripts

Practice

  • Write a Script That Checks Disk Space and Warns You20 min

Chapter 7

Access management

Choose the least access that works and flag broad permissions

What you'll learn

  • Identity and access
  • Least privilege
  • Role-based access
  • Multi-factor authentication
  • Federation trust
  • Access audit

Practice

  • Answer three database access requests with the least access that works20 min
  • Audit a sample IAM permissions set20 min

8 more in the plan

Troubleshooting systemsWork through a website fault in order instead of guessingCh 2

What you'll learn

  • USE method
  • Testable hypothesis
  • One variable
  • Symptom timeline

Practice

  • Review a small schema and propose 3 improvements25 min
  • Analyse a slow query plan30 min
  • Read four database errors and say what you would check first25 min
LinuxManage files and who can open them using short commandsCh 6

What you'll learn

  • Filesystem map
  • File permissions
  • Pipes and filters
  • Process signals
GitSave clear changes to a project's history and request reviewCh 7

What you'll learn

  • Change states
  • Short-lived branches
  • Merge conflict
  • Useful commit message
  • Pull request review

Practice

  • Practise a small Git branching workflow30 min
Problem solvingTest each possible cause of a problem instead of guessingCh 8

What you'll learn

  • Problem vs symptom
  • Clean problem splits
  • Root cause
  • Deciding under uncertainty

Practice

  • Separate the Problem from the Symptom10 min
Adapting to changeTry a new tool and describe how you handled changeCh 8

What you'll learn

  • Change vs your response
  • The messy in-between
  • Not there yet
  • Real change vs a feeling
CommunicationRewrite an update for two different readers, cutting extra linesCh 9

What you'll learn

  • Lead with the point
  • Match detail to the reader
  • Said versus heard
  • Specific feedback

Practice

  • Write a Six-Line Delay Message10 min
Working with othersContribute to group work, ask for help and credit teammatesCh 9

What you'll learn

  • Early team friction
  • Clear ownership
  • Challenge ideas, not people
  • Lead or follow

Practice

  • Write a Request That Makes It Easy to Say Yes10 min
Documenting infrastructure workWrite a task guide and draw how system parts connectCh 10

What you'll learn

  • Runbook purpose
  • Decision record
  • Document type
  • Current version

Your plan

Chapter by chapter.

14 chapters, in this order. Chapter 1 is free.

1~1 wk

See what database administrator work involves

StartFree
2~1 wk

Spot faults early and find their cause

Skills
3~1 wk

Restore data and service after an outage

Skills
41–2 wks

Build a database and tune its queries

Project
5~1 wk

Talk to a working database administrator

People
6~1 wk

Run databases on Linux with SQL

Skills
7~1 wk

Automate access control with versioned scripts

Skills
8~1 wk

Solve problems when plans change

Skills
9~1 wk

Make yourself understood across a team

Skills
10~1 wk

Document systems so others can follow

Skills
111–2 wks

Write up a system you built

Project
12~1 wk

Answer the questions interviewers ask

Interview
13~1 wk

Decide how you will get in

Decide
14on your timeline

Send your first applications

Apply

The job

What a Database Administrator does

Keeps an organizations databases fast, secure, and reliable so apps and teams can store and use data without downtime.

The work

  • Design database structures to fit app and reporting needs
  • Set up users, roles, and permissions to protect sensitive data
  • Monitor performance and tune queries, indexes, and storage
  • Plan and test backups and restores to prevent data loss
  • Diagnose outages and fix database errors under time pressure
  • Coordinate upgrades, patches, and migrations with engineering teams
  • Automate routine maintenance jobs and health checks
  • Document standards and teach teams how to use databases safely

A typical day

  1. Check alerts, storage, and replication status; handle any urgent incidents
  2. Review slow queries and tune indexes or settings with developers
  3. Run or verify backups, restore tests, and maintenance jobs
  4. Join change meetings for releases, upgrades, and access requests

Tools

Databases: PostgreSQL, MySQL, Microsoft SQL ServerQuery tools: SQL, EXPLAIN plansMonitoring: Grafana, PrometheusBackup tools: pg_dump, mysqldumpScripting: Python, BashVersion control: GitCloud databases: Amazon RDS, Azure SQL Database

Ways in

There is more than one route.

Ways to study

  • Bachelors degree in computer science, information systems, or software engineering
  • Diploma or certificate in database administration or IT infrastructure
  • Online courses focused on SQL, database design, and operations
  • Apprenticeship style training in IT operations or platform teams

How people get their first job

  • Build a small database project with backups, roles, and monitoring and publish notes
  • Start in IT support or operations and take on database maintenance tasks
  • Apply for database or platform internships that include on-call shadowing
  • Earn a vendor-neutral SQL certification or a cloud database fundamentals cert
  • Contribute to a team by writing runbooks for backups, restores, and upgrades

How the work is changing

What AI is doing to this role

How AI is changing this role · one of 6 tasks we track

Monitor performance and plan capacity

Sped up a lot

What AI does

Azure SQL automatic tuning adds and drops indexes on its own.

Still yours

You still judge real load, cost and how much headroom to buy.

Reviewed September 2026

In the app · Premium

The rest is in the app

  • How AI affects the other 5 tasks
  • Whether this job is growing or shrinking
  • How hard the first job is to get
  • Similar roles that are easier to get into
  • Updated every month, with sources
See it in the app →

How we rate a job →

Already working

Already a Database Administrator?

Plan your move to Senior DBA: 10 chapters that end with a strong case for your next review.

Grow in the role →

Other roles in IT & Cloud Infrastructure

Questions

Questions about this plan

How long does it take to become a database administrator with Welica?

The plan is 14 chapters, 3 months at 15 to 30 minutes a day. You can go faster or slower; the plan moves with you.

Do I need a degree?

Not always. Common routes are bachelors degree in computer science, information systems, or software engineering, diploma or certificate in database administration or IT infrastructure, online courses focused on SQL, database design, and operations, or apprenticeship style training in IT operations or platform teams.

What is free?

Chapter 1, See what database administrator work involves, is free for good. Premium unlocks the rest of the plan.

Start the Database Administrator plan.

Chapter 1 free. About 15 to 30 minutes a day.

Start on web Continue your session Download for MacMac Get the iPhone appiPhone Get it on Google PlayAndroid