Competencies: Databases > Relational Databases

PostgreSQL

Advanced features, extensions, JSONB, full-text search, performance tuning, replication

Critical

Backend Developer, DBA, Data Engineer

MySQL/MariaDB

Storage engines, replication, query optimization, backup strategies

High

Backend Developer, DBA

SQLite

Embedded database, WAL mode, concurrent access, when to use SQLite

Medium

Backend Developer, Mobile Developer

SQL Server

T-SQL, stored procedures, SSRS, SSIS, Always On availability groups

Medium

Backend Developer, DBA

Transactions & ACID

Isolation levels, locking, deadlocks, transaction design, two-phase commit

Critical

Backend Developer, DBA

Query Optimization

Execution plans, index selection, query rewriting, statistics, hints

Critical

Backend Developer, DBA

Indexing Strategies

B-tree, hash, GiST, GIN indexes, covering indexes, partial indexes

Critical

Backend Developer, DBA

Database Design

Normalization, denormalization, constraints, referential integrity

Critical

Backend Developer, DBA, Data Architect

Stored Procedures & Functions

PL/pgSQL, T-SQL procedures, triggers, user-defined functions

Medium

Backend Developer, DBA

Database Replication

Primary-replica, multi-master, synchronous/asynchronous, failover

High

DBA, SRE, Infrastructure Engineer

To be populated

 — 

 — 

 — 

 —