Overview

Database Administrator Jobs in Ai, Aceh, Indonesia at OpenSkills

Title: Database Administrator

Company: OpenSkills

Location: Ai, Aceh, Indonesia

← All career guides

Data and AI

Database Administrator

Secures, operates, tunes, protects, and recovers production database systems.

Find relevant jobs→Print learning guideOpen Hitchhiker’s guide→

Skill coverage

100%

8 of 8 skills

Course coverage

65%

31 of 48 courses

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 31

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.

01

Database foundations

4 capabilities

  • Relational design

Importance: Essential (5 of 5)

Understands schemas, normalization, constraints, and data integrity.

Course coverage

  • Database Fundamentals
  • PostgreSQL Fundamentals
  • Relational Database Design
  • Database Normalization
  • SQLite, MySQL Fundamentals, Schema Migration and Change Management (planned)
  • SQL

Importance: Essential (5 of 5)

Queries and administers relational database systems effectively.

Course coverage

  • SQL Fundamentals
  • Database Privilege and Access Control, Stored Procedures, Triggers, and Database Programming, Schema Migration and Change Management, SQL Execution Plans and Query Tuning (planned)
  • Transactions and concurrency

Importance: Essential (5 of 5)

Manages isolation, locking, consistency, and concurrent workloads.

Course coverage

  • Database Transactions and Concurrency
  • TiKV
  • Connection Pooling and Concurrency at Scale, Deadlocks and Lock Contention Troubleshooting, Distributed Transactions and Two-Phase Commit (planned)
  • Indexing and performance

Importance: Essential (5 of 5)

Diagnoses query behavior and tunes indexes, plans, and resources.

Course coverage

  • Database Indexing
  • Database Performance Tuning
  • Database Partitioning and Sharding Strategies, SQL Execution Plans and Query Tuning (planned)

02

Database operations

4 capabilities

  • Backup and recovery

Importance: Essential (5 of 5)

Meets recovery objectives through tested protection and restore procedures.

Course coverage

  • Database Backup and RecoveryFree
  • Data Recovery
  • Database Failover and Disaster Recovery Drills, Point-in-Time Recovery Techniques (planned)
  • High availability

Importance: Essential (5 of 5)

Designs replication, failover, and maintenance for service continuity.

Course coverage

  • Database High Availability
  • Database Partitioning and Sharding Strategies, Database Replication Strategies, Database Failover and Disaster Recovery Drills, Multi-Region Database Architecture (planned)
  • Database security

Importance: Essential (5 of 5)

Protects database identities, privileges, encryption, auditing, and data.

Course coverage

  • Database Security
  • Database Privilege and Access Control, Database Auditing and Compliance, Database Encryption and Key Management (planned)
  • 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
  • Microsoft SQL Server
  • MongoDB Fundamentals
  • MySQL Administration
  • Neo4j Fundamentals
  • Oracle Database
  • PostgreSQL Administration
  • Vector Databases
  • Distributed SQL Databases (planned)

Learning path

Relevant courses

Print all introsPrint all cheatsheets

Core foundations

The concepts this role is built on.

  • Database Backup and RecoveryFree
  • Database Fundamentals
  • Database High Availability
  • Database Indexing
  • Database Performance Tuning
  • Database Security
  • Database Transactions and Concurrency
  • Platform Administration
  • PostgreSQL Fundamentals
  • Relational Database Design
  • SQL Fundamentals
  • Database Partitioning and Sharding Strategies, Database Privilege and Access Control, Database Replication Strategies, Stored Procedures, Triggers, and Database Programming (planned)

Supporting knowledge

Adjacent knowledge that improves day-to-day judgment.

  • Column-Family Databases
  • Data Recovery
  • Database Normalization
  • Document Databases
  • Graph Databases
  • Key-Value Databases
  • NoSQL Fundamentals
  • Redis Fundamentals
  • TiKV
  • Time-Series Databases
  • Connection Pooling and Concurrency at Scale, SQLite (planned)

Specializations

Deeper paths for particular environments or directions.

  • Apache Cassandra Fundamentals
  • AWS Databases
  • Cloud Databases
  • Microsoft SQL Server
  • MongoDB Fundamentals
  • MySQL Administration
  • Neo4j Fundamentals
  • Oracle Database
  • PostgreSQL Administration
  • Vector 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, Multi-Region Database Architecture, MySQL Fundamentals, Point-in-Time Recovery Techniques, Schema Migration and Change Management, SQL Execution Plans and Query Tuning (planned)

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.

Open job search→

Keep exploring

More in Data and AI

  • Data Scientist→
  • Machine Learning Engineer→

Apply

Upload your CV/resume or any other relevant file. Max. file size: 800 MB.