{
  "id": "skill-area:database-migrations-zero-downtime",
  "_kind": "SkillArea",
  "_file": "domain/skill-areas/database-migrations-zero-downtime.yaml",
  "_cluster": "domain",
  "attributes": {
    "displayName": "Zero-Downtime Database Migrations",
    "description": "Executing schema changes without downtime: expand/contract patterns,\nonline DDL, lock-aware migrations, dual writes, backfill strategies,\nand feature-flagged read-path swaps. Covers Postgres (CONCURRENTLY,\nNOT VALID -> VALIDATE) and MySQL (gh-ost, pt-online-schema-change).\n",
    "domains": [
      "domain:devops",
      "domain:data-engineering"
    ],
    "requiresStackParts": [
      "stack-part:relational-database"
    ],
    "prerequisiteSkillAreas": [
      "skill-area:postgres-tuning"
    ],
    "expertiseLevels": [
      "intermediate",
      "expert"
    ]
  },
  "outgoingEdges": [
    {
      "from": "skill-area:database-migrations-zero-downtime",
      "to": "domain:devops",
      "kind": "applies_to",
      "attributes": {
        "confidence": "primary"
      }
    },
    {
      "from": "skill-area:database-migrations-zero-downtime",
      "to": "stack-part:relational-database",
      "kind": "uses_stack_part"
    },
    {
      "from": "skill-area:database-migrations-zero-downtime",
      "to": "skill-area:postgres-tuning",
      "kind": "requires_skill_area"
    }
  ],
  "incomingEdges": [
    {
      "from": "skill-area:zero-downtime-deployment",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "recommended"
      }
    },
    {
      "from": "skill-area:database-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "recommended"
      }
    },
    {
      "from": "skill-area:backend-data-persistence",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "prerequisite_for_learning",
      "attributes": {
        "strength": "recommended"
      }
    },
    {
      "from": "stack-part:relational-database",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "stack_part_used_by",
      "attributes": {}
    },
    {
      "from": "stack-profile:strangler-fig-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area"
    },
    {
      "from": "skill:database-migrations",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "addresses",
      "attributes": {}
    },
    {
      "from": "lib-agent:code-migration-modernization--data-integrity-validator",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-agent:code-migration-modernization--database-migration-orchestrator",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:code-migration-modernization--cloud-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--configuration-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--data-format-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--database-schema-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--documentation-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--integration-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--language-version-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--logging-observability-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--migration-testing-strategy",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--performance-optimization-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--serverless-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:code-migration-modernization--ui-framework-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.5
      }
    },
    {
      "from": "lib-process:web-development--postgresql-database-design",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-skill:code-migration-modernization--data-migration-validator",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:code-migration-modernization--etl-pipeline-builder",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-skill:code-migration-modernization--query-translator",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-skill:code-migration-modernization--schema-comparator",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-skill:web-development--mongodb",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "lib-skill:web-development--postgresql",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "lib_requires_skill_area",
      "attributes": {
        "weight": 0.7
      }
    },
    {
      "from": "role:database-administrator",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "role:fullstack-engineer",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "role:backend-engineer",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_expertise",
      "attributes": {}
    },
    {
      "from": "workflow:database-migration-cutover",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:data-warehouse-schema-governance",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:schema-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:cross-team-integration-testing",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:database-index-optimization",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:payment-reconciliation-audit",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:clinical-trial-data-management",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:schema-migration",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    },
    {
      "from": "workflow:cross-team-integration-testing",
      "to": "skill-area:database-migrations-zero-downtime",
      "kind": "requires_skill_area",
      "attributes": {}
    }
  ]
}