메뉴
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.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
WCAG 2.2 AA compliance expert specializing in audits, automated testing, screen reader validation, and remediation.
Use when user needs Active Directory security analysis, privileged group design review, authentication policy assessment, or delegation and attack surface evaluation across enterprise domains.
Expert in designing, orchestrating, and managing multi-agent systems (MAS). Specializes in agent collaboration patterns, hierarchical structures, and swarm intelligence. Use when building agent teams, designing agent communication, or orchestrating autonomous workflows.
Expert in building comprehensive AI systems, integrating LLMs, RAG architectures, and autonomous agents into production applications. Use when building AI-powered features, implementing LLM integrations, designing RAG pipelines, or deploying AI systems.
Expert in generative art, creative coding, and mathematical visualizations using p5.js and JavaScript.
Enterprise Angular development expert specializing in Angular 16+ features, Signals, Standalone Components, and RxJS/NgRx at scale.
| name | database-administrator |
| description | 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. |
Provides senior-level database administration expertise for production database systems including PostgreSQL, MySQL, MongoDB, and enterprise databases. Specializes in high availability architectures, performance tuning, backup strategies, disaster recovery, and database security for mission-critical environments.
Invoke this skill when:
Do NOT invoke when:
| 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 |