Careers › IT & Cloud Infrastructure › Database Administrator
For students and early-career professionals
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.
What's in the plan
Practice 16 practice tasks Tasks from the real work of the job, 10 to 30 minutes each
Projects 2 projects you keep PostgreSQL schema, backup drill, and a query tuning write-up Architecture write-up: explain a system you built
Interview 20 interview questions Practise your answers, with feedback
People 4 people to reach Who they are, with 4 messages ready to send
Also: choose your route in (3 credentials compared, none required) and 3 life skills courses.
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 systems Work through a website fault in order instead of guessing Ch 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 Linux Manage files and who can open them using short commands Ch 6 What you'll learn
Filesystem map File permissions Pipes and filters Process signals Git Save clear changes to a project's history and request review Ch 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 solving Test each possible cause of a problem instead of guessing Ch 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 change Try a new tool and describe how you handled change Ch 8 What you'll learn
Change vs your response The messy in-between Not there yet Real change vs a feeling Communication Rewrite an update for two different readers, cutting extra lines Ch 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 others Contribute to group work, ask for help and credit teammates Ch 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 work Write a task guide and draw how system parts connect Ch 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 Start Free
2 ~1 wk Spot faults early and find their cause Skills
3 ~1 wk Restore data and service after an outage Skills
4 1–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
11 1–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
14 on 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 Check alerts, storage, and replication status; handle any urgent incidents Review slow queries and tune indexes or settings with developers Run or verify backups, restore tests, and maintenance jobs Join change meetings for releases, upgrades, and access requests Tools Databases: PostgreSQL, MySQL, Microsoft SQL Server Query tools: SQL, EXPLAIN plans Monitoring: Grafana, Prometheus Backup tools: pg_dump, mysqldump Scripting: Python, Bash Version control: Git Cloud 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 Life skills in this plan: Networking · Job interviews · Job search
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.
Already have an account? Sign in