Relational design
Importance: Essential (5 of 5)
Understands schemas, normalization, constraints, and data integrity.
← All career guides8 of 8 skills48 of 48 courses
Data and AI
Database Administrator
Secures, operates, tunes, protects, and recovers production database systems.
Skill coverage
100%
Course coverage
100%
Skill coverage shows how much of the role's capability map already has a published course. Course coverage shows how much of the mapped course pipeline for this role has shipped.
- Role skills
- 8
- Published coverage
- 8
- Relevant courses
- 48
Capability map
Skills
Importance describes how central each capability is to the role. Course coverage shows where you can build the skill in the current OpenSkills catalog.
Relational design: 4 more courses
SQL: 2 more courses
Transactions and concurrency: 2 more courses
Indexing and performance: 1 more course
Backup and recovery: 1 more course
High availability: 2 more courses
Database security: 1 more course
Platform administration: 16 more courses
- Graph Databases
- Key-Value Databases
- NoSQL Fundamentals
- Redis Fundamentals
- Time-Series Databases
- Apache Cassandra Fundamentals
- AWS Databases
- Cloud Databases
- Distributed SQL Databases
- Microsoft SQL Server
- MongoDB Fundamentals
- MySQL Administration
- Neo4j Fundamentals
- Oracle Database
- PostgreSQL Administration
- Vector Databases
Database Administrator capability map
- Database Administrator
- Database foundations
- Database operations
- Backup and recovery
- High availability
- Database security
- Platform administration
- Platform Administration
- Column-Family Databases
- Document Databases
- +16 more
- Graph Databases
- Key-Value Databases
- NoSQL Fundamentals
- Redis Fundamentals
- Time-Series Databases
- Apache Cassandra Fundamentals
- AWS Databases
- Cloud Databases
- Distributed SQL Databases
- Microsoft SQL Server
- MongoDB Fundamentals
- MySQL Administration
- Neo4j Fundamentals
- Oracle Database
- PostgreSQL Administration
- Vector Databases
01
Database foundations
4 capabilities
SQL
Importance: Essential (5 of 5)
Queries and administers relational database systems effectively.
Transactions and concurrency
Importance: Essential (5 of 5)
Manages isolation, locking, consistency, and concurrent workloads.
Indexing and performance
Importance: Essential (5 of 5)
Diagnoses query behavior and tunes indexes, plans, and resources.
02
Database operations
4 capabilities
Backup and recovery
Importance: Essential (5 of 5)
Meets recovery objectives through tested protection and restore procedures.
High availability
Importance: Essential (5 of 5)
Designs replication, failover, and maintenance for service continuity.
Database security
Importance: Essential (5 of 5)
Protects database identities, privileges, encryption, auditing, and data.
Platform administration
Importance: Essential (5 of 5)
Operates at least one production database platform deeply.
Course coverage
- Platform Administration
- Column-Family Databases
- Document Databases
- Graph Databases
- Key-Value Databases
- NoSQL Fundamentals
- Redis Fundamentals
- Time-Series Databases
- Apache Cassandra Fundamentals
- AWS Databases
- Cloud Databases
- Distributed SQL Databases
- Microsoft SQL Server
- MongoDB Fundamentals
- MySQL Administration
- Neo4j Fundamentals
- Oracle Database
- PostgreSQL Administration
- Vector Databases
Learning path
Relevant courses
Core foundations
The concepts this role is built on.
- Database Backup and Recovery
- Database FundamentalsFree
- Database High Availability
- Database Indexing
- Database Partitioning and Sharding Strategies
- Database Performance Tuning
- Database Privilege and Access Control
- Database Replication Strategies
- Database Security
- Database Transactions and Concurrency
- Platform Administration
- PostgreSQL Fundamentals
- Relational Database Design
- SQL FundamentalsFree
- Stored Procedures, Triggers, and Database Programming
Supporting knowledge
Adjacent knowledge that improves day-to-day judgment.
Specializations
Deeper paths for particular environments or directions.
- Apache Cassandra Fundamentals
- AWS Databases
- Cloud Databases
- Database Auditing and Compliance
- Database Encryption and Key Management
- Database Failover and Disaster Recovery Drills
- Deadlocks and Lock Contention Troubleshooting
- Distributed SQL Databases
- Distributed Transactions and Two-Phase Commit
- Microsoft SQL Server
- MongoDB Fundamentals
- Multi-Region Database Architecture
- MySQL Administration
- MySQL Fundamentals
- Neo4j Fundamentals
- Oracle Database
- Point-in-Time Recovery Techniques
- PostgreSQL Administration
- Schema Migration and Change Management
- SQL Execution Plans and Query Tuning
- Vector Databases
HOWTOs
Concrete operational procedures from the courses on this page.
- How to migrate a relational database to Amazon RDS or Aurora with DMS at near-zero downtime
Moving a live relational database onto RDS or Aurora with an AWS DMS full-load-and-CDC task: the schema and index work around the load, the CDC latency gate that decides when a cutover is safe, and the reverse replication path that keeps rollback open.
AWS Databases
- How to restore an Amazon RDS or Aurora database to a point in time after data corruption
Recovering from a bad write by restoring RDS or Aurora point-in-time recovery into a new instance beside the untouched source, validating the restore time, and choosing between a full cutover and a selective repair.
AWS Databases
- How to ship a breaking schema change with zero downtime using expand and contract
Making a backward-incompatible column, table, or store change safe to ship while old and new application code run at once, by staging it across several releases that each stay compatible with the one before.
Schema Migration and Change Management
- How to recover from a failed or partially applied migration
What to do when a migration run fails partway, times out, or succeeds without being recorded and the schema, data, and migration history no longer agree: re-establishing the true state and moving forward without editing an applied migration.
Schema Migration and Change Management
- How to run an online schema change without long locks
Altering a large, busy table without the maintenance window a plain ALTER would need, covering when the database engine can do the change natively and when a copy-and-swap tool is the safer route.
Schema Migration and Change Management
Put the map to work
Find Database Administrator roles.
Search multiple job sources at once with queries tailored to this career, then use the skill map above to evaluate what each role actually asks for.