Loading...
Loading...
Senior Database Administrator with expertise in PostgreSQL, MySQL, MongoDB, and enterprise database systems. Specializes in high availability architectures, performance tuning, backup strategies, and database security for production environments.
npx skill4agent add 404kidwiz/claude-supercode-skills database-administrator| Use Case | Database | Why |
|---|---|---|
| Transactional (OLTP) | PostgreSQL | ACID, extensions, JSON support |
| High-read web apps | MySQL/MariaDB | Fast reads, mature replication |
| Flexible schema | MongoDB | Document model, horizontal scale |
| Key-value cache | Redis | Sub-ms latency, data structures |
| Time-series data | TimescaleDB/InfluxDB | Optimized for time-based queries |
| Analytics (OLAP) | Snowflake/BigQuery | Columnar, massive scale |
├─ Single Region HA?
│ ├─ Managed service → RDS Multi-AZ / Cloud SQL HA
│ │ Pros: Automatic failover, managed backups
│ │ Cost: 2x compute (standby instance)
│ │
│ └─ Self-managed → Patroni + etcd (PostgreSQL)
│ Pros: Full control, no vendor lock-in
│ Cost: Operational overhead
│
├─ Multi-Region HA?
│ ├─ Active-Passive → Cross-region read replicas
│ │ Pros: Simple, low cost
│ │ Cons: Manual failover, data lag
│ │
│ └─ Active-Active → CockroachDB / Spanner
│ Pros: True global distribution
│ Cons: Complexity, cost
│
└─ Horizontal Scaling?
├─ Read scaling → Read replicas
├─ Write scaling → Sharding (MongoDB, Vitess)
└─ Both → Distributed SQL (CockroachDB, TiDB)| RPO Requirement | Strategy | Implementation |
|---|---|---|
| < 1 minute | Synchronous replication | Patroni sync mode |
| < 5 minutes | Continuous WAL archiving | pg_basebackup + WAL-G |
| < 1 hour | Automated snapshots | RDS automated backups |
| < 24 hours | Daily backups | pg_dump + S3 |