Pipeline run

{
  "final_skills": [
    {
      "is_primary": true,
      "skill_name": "PostgreSQL"
    },
    {
      "is_primary": true,
      "skill_name": "Streaming Replication"
    },
    {
      "is_primary": true,
      "skill_name": "Logical Decoding"
    },
    {
      "is_primary": true,
      "skill_name": "EXPLAIN ANALYZE"
    },
    {
      "is_primary": true,
      "skill_name": "VACUUM"
    },
    {
      "is_primary": true,
      "skill_name": "Autovacuum"
    },
    {
      "is_primary": true,
      "skill_name": "pg_dump"
    },
    {
      "is_primary": true,
      "skill_name": "pg_basebackup"
    },
    {
      "is_primary": true,
      "skill_name": "WAL Archiving"
    },
    {
      "is_primary": true,
      "skill_name": "S3"
    },
    {
      "is_primary": true,
      "skill_name": "Point-in-Time Recovery"
    },
    {
      "is_primary": true,
      "skill_name": "Liquibase"
    },
    {
      "is_primary": true,
      "skill_name": "Flyway"
    },
    {
      "is_primary": true,
      "skill_name": "Datadog"
    },
    {
      "is_primary": true,
      "skill_name": "pg_stat_statements"
    },
    {
      "is_primary": true,
      "skill_name": "auto_explain"
    },
    {
      "is_primary": true,
      "skill_name": "Grafana"
    },
    {
      "is_primary": true,
      "skill_name": "shared_buffers"
    },
    {
      "is_primary": true,
      "skill_name": "work_mem"
    },
    {
      "is_primary": true,
      "skill_name": "max_connections"
    },
    {
      "is_primary": true,
      "skill_name": "checkpoint_timeout"
    },
    {
      "is_primary": true,
      "skill_name": "OLTP"
    },
    {
      "is_primary": true,
      "skill_name": "Role-Based Access Control"
    },
    {
      "is_primary": true,
      "skill_name": "Row-Level Security"
    },
    {
      "is_primary": true,
      "skill_name": "HashiCorp Vault"
    },
    {
      "is_primary": true,
      "skill_name": "Linux"
    },
    {
      "is_primary": true,
      "skill_name": "Ubuntu"
    },
    {
      "is_primary": true,
      "skill_name": "RHEL"
    },
    {
      "is_primary": true,
      "skill_name": "Shell Scripting"
    },
    {
      "is_primary": true,
      "skill_name": "PgBouncer"
    },
    {
      "is_primary": true,
      "skill_name": "Patroni"
    },
    {
      "is_primary": true,
      "skill_name": "repmgr"
    },
    {
      "is_primary": true,
      "skill_name": "pg_repack"
    },
    {
      "is_primary": true,
      "skill_name": "Terraform"
    },
    {
      "is_primary": true,
      "skill_name": "Ansible"
    },
    {
      "is_primary": true,
      "skill_name": "AWS RDS"
    },
    {
      "is_primary": true,
      "skill_name": "Amazon Aurora"
    }
  ],
  "jd_role": {
    "display_name": "PostgreSQL Database Administrator",
    "rationale": null,
    "role_aliases": [
      "PostgreSQL DBA",
      "Database Administrator",
      "DBA"
    ],
    "role_archetype": "Engineering",
    "slug": ""
  },
  "nano_parsed": {
    "JD_type": "pass",
    "about_company": null,
    "certifications": [],
    "company_name": "DataBank Holdings",
    "ctc": null,
    "domain": {
      "primary": {
        "aliases": [
          "ITES",
          "BPO"
        ],
        "domain": "IT Services \u0026 Consulting"
      },
      "secondary": null
    },
    "education": [],
    "experience": {
      "max": null,
      "min": 6,
      "raw": "6+ years"
    },
    "job_locations": [
      {
        "aliases": [
          "Hyderabad, India"
        ],
        "city": "Hyderabad",
        "country": "India",
        "state": null,
        "work_mode": null
      }
    ],
    "role": "PostgreSQL Database Administrator",
    "role_aliases": [
      "PostgreSQL DBA",
      "Database Administrator",
      "DBA"
    ],
    "role_archetype": "Engineering",
    "roles_and_responsibilities": [
      {
        "bullet_count": 0,
        "heading": "About the Role",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "Lead PostgreSQL DBA responsible for",
          "last_5_words": "and on-call response."
        },
        "text": "Lead PostgreSQL DBA responsible for the operational health of 80+ production PostgreSQL clusters across our customer data platform. You will own day-to-day database operations, performance tuning, schema migrations, and on-call response.",
        "word_count": 40
      },
      {
        "bullet_count": 9,
        "heading": "Key Responsibilities",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "Administer PostgreSQL 14/15 clusters,",
          "last_5_words": "and write post-mortems"
        },
        "text": "- Administer PostgreSQL 14/15 clusters, including streaming replication, logical decoding, and failover orchestration\n- Perform query plan analysis with EXPLAIN ANALYZE, tune indexes, optimize VACUUM and autovacuum parameters\n- Manage backup strategy: pg_dump, pg_basebackup, WAL archiving to S3, and point-in-time recovery rehearsals\n- Plan and execute schema migrations using Liquibase or Flyway with zero-downtime techniques (online ALTER TABLE)\n- Monitor PostgreSQL with Datadog, pg_stat_statements, auto_explain, and custom Grafana dashboards\n- Tune server parameters: shared_buffers, work_mem, max_connections, checkpoint_timeout for OLTP workloads\n- Implement role-based access control, row-level security, and integrate with HashiCorp Vault for secret rotation\n- Lead capacity planning, storage growth forecasting, and Postgres version upgrade roadmaps\n- Respond to on-call pages for database incidents, conduct root cause analysis, and write post-mortems",
        "word_count": 164
      },
      {
        "bullet_count": 5,
        "heading": "Required Qualifications",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "6+ years administering production PostgreSQL",
          "last_5_words": "Terraform, Ansible, and AWS RDS/Aurora"
        },
        "text": "- 6+ years administering production PostgreSQL at scale\n- Deep expertise in query optimization, replication, and backup/recovery on PostgreSQL\n- Strong Linux sysadmin skills (Ubuntu/RHEL), shell scripting\n- Experience with PgBouncer, Patroni, repmgr, pg_repack\n- Familiar with Terraform, Ansible, and AWS RDS/Aurora",
        "word_count": 56
      }
    ],
    "urls": []
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "9684dec3-ff6c-407d-a11c-3fe8e7f8d265",
  "stage3_signals": {
    "alias_found": false,
    "alias_match_roles": [],
    "kra_match_roles": [
      {
        "display_name": "Fullstack Developer",
        "kra_matches": [
          {
            "kra_text": "Designs and queries relational databases like PostgreSQL and document stores like MongoDB, writing migrations, indexes, and optimized queries.",
            "sentence": "Deep expertise in query optimization, replication, and backup/recovery on PostgreSQL",
            "similarity": 0.6178
          },
          {
            "kra_text": "Designs and queries relational databases like PostgreSQL and document stores like MongoDB, writing migrations, indexes, and optimized queries.",
            "sentence": "Lead PostgreSQL DBA responsible for the operational health of 80+ production PostgreSQL clusters across our customer data platform.",
            "similarity": 0.568
          },
          {
            "kra_text": "Designs and queries relational databases like PostgreSQL and document stores like MongoDB, writing migrations, indexes, and optimized queries.",
            "sentence": "6+ years administering production PostgreSQL at scale",
            "similarity": 0.518
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 15,
        "score": 0.568,
        "slug": "full-stack-engineer",
        "total_count": null
      },
      {
        "display_name": "DevOps Engineer",
        "kra_matches": [
          {
            "kra_text": "Provisions and manages cloud infrastructure on AWS, Azure, or GCP using Terraform or CloudFormation to enforce infrastructure-as-code standards.",
            "sentence": "Familiar with Terraform, Ansible, and AWS RDS/Aurora",
            "similarity": 0.6239
          },
          {
            "kra_text": "Responds to deployment failures, infrastructure incidents, and environment misconfiguration issues to restore service availability and prevent recurrence.",
            "sentence": "Respond to on-call pages for database incidents, conduct root cause analysis, and write post-mortems",
            "similarity": 0.5631
          },
          {
            "kra_text": "Responds to deployment failures, infrastructure incidents, and environment misconfiguration issues to restore service availability and prevent recurrence.",
            "sentence": "You will own day-to-day database operations, performance tuning, schema migrations, and on-call response.",
            "similarity": 0.457
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 10,
        "score": 0.548,
        "slug": "devops-engineer",
        "total_count": null
      },
      {
        "display_name": "Backend Developer",
        "kra_matches": [
          {
            "kra_text": "Investigates and resolves production incidents, API bugs, and service degradation through root cause analysis, hotfixes, and post-mortems.",
            "sentence": "Respond to on-call pages for database incidents, conduct root cause analysis, and write post-mortems",
            "similarity": 0.628
          },
          {
            "kra_text": "Identifies and resolves backend performance bottlenecks through query optimization, indexing strategies, connection pooling, and distributed caching with Redis.",
            "sentence": "Deep expertise in query optimization, replication, and backup/recovery on PostgreSQL",
            "similarity": 0.5248
          },
          {
            "kra_text": "Writes database access logic including SQL queries, ORM mappings, stored procedures, and migration scripts for relational databases like PostgreSQL and MySQL.",
            "sentence": "Lead PostgreSQL DBA responsible for the operational health of 80+ production PostgreSQL clusters across our customer data platform.",
            "similarity": 0.4907
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 1,
        "score": 0.5479,
        "slug": "backend-engineer",
        "total_count": null
      },
      {
        "display_name": "Cybersecurity Engineer",
        "kra_matches": [
          {
            "kra_text": "Leads security incident response investigations including forensic analysis, malware triage, containment actions, and post-incident remediation coordination.",
            "sentence": "Respond to on-call pages for database incidents, conduct root cause analysis, and write post-mortems",
            "similarity": 0.6006
          },
          {
            "kra_text": "Reviews and enforces access control policies, privilege escalation procedures, role-based access control, and identity governance workflows.",
            "sentence": "Implement role-based access control, row-level security, and integrate with HashiCorp Vault for secret rotation",
            "similarity": 0.5455
          },
          {
            "kra_text": "Leads security incident response investigations including forensic analysis, malware triage, containment actions, and post-incident remediation coordination.",
            "sentence": "You will own day-to-day database operations, performance tuning, schema migrations, and on-call response.",
            "similarity": 0.4177
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 5,
        "score": 0.5213,
        "slug": "cybersecurity-engineer",
        "total_count": null
      },
      {
        "display_name": "Cloud Architect",
        "kra_matches": [
          {
            "kra_text": "Designs backup policies, cross-region replication, and disaster recovery runbooks to meet defined RTO and RPO targets for critical workloads.",
            "sentence": "Manage backup strategy: pg_dump, pg_basebackup, WAL archiving to S3, and point-in-time recovery rehearsals",
            "similarity": 0.548
          },
          {
            "kra_text": "Defines cloud adoption roadmaps, lift-and-shift vs. refactor migration strategies, and landing zone architectures for workloads moving to AWS, Azure, or GCP.",
            "sentence": "Familiar with Terraform, Ansible, and AWS RDS/Aurora",
            "similarity": 0.4731
          },
          {
            "kra_text": "Defines cloud adoption roadmaps, lift-and-shift vs. refactor migration strategies, and landing zone architectures for workloads moving to AWS, Azure, or GCP.",
            "sentence": "Lead capacity planning, storage growth forecasting, and Postgres version upgrade roadmaps",
            "similarity": 0.4621
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 9,
        "score": 0.4944,
        "slug": "cloud-architect",
        "total_count": null
      }
    ],
    "skill_match_roles": [
      {
        "display_name": "DevOps Engineer",
        "kra_matches": null,
        "matched_count": 6,
        "matched_skills": [
          "Ansible",
          "Datadog",
          "Grafana",
          "HashiCorp Vault",
          "S3",
          "Terraform"
        ],
        "role_id": 10,
        "score": 0.1622,
        "slug": "devops-engineer",
        "total_count": 37
      },
      {
        "display_name": "Cloud Architect",
        "kra_matches": null,
        "matched_count": 4,
        "matched_skills": [
          "Ansible",
          "Datadog",
          "Grafana",
          "Terraform"
        ],
        "role_id": 9,
        "score": 0.1081,
        "slug": "cloud-architect",
        "total_count": 37
      },
      {
        "display_name": "Backend Developer",
        "kra_matches": null,
        "matched_count": 3,
        "matched_skills": [
          "Grafana",
          "PostgreSQL",
          "S3"
        ],
        "role_id": 1,
        "score": 0.0811,
        "slug": "backend-engineer",
        "total_count": 37
      },
      {
        "display_name": "ML Engineer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          "S3",
          "Terraform"
        ],
        "role_id": 3,
        "score": 0.0541,
        "slug": "ml-engineer",
        "total_count": 37
      },
      {
        "display_name": "Data Engineer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          "Row-level security",
          "S3"
        ],
        "role_id": 2,
        "score": 0.0541,
        "slug": "data-engineer",
        "total_count": 37
      }
    ]
  },
  "stage4_decision": {
    "alias_collision_detected": false,
    "case": "F",
    "chosen_role": {
      "display_name": "DevOps Engineer",
      "kra_matches": null,
      "matched_count": null,
      "matched_skills": null,
      "role_id": 10,
      "score": 0.548,
      "slug": "devops-engineer",
      "total_count": null
    },
    "confidence": 0.92,
    "is_new_role": false,
    "llm2_fired": true,
    "llm2_reasoning": "The role requires deep expertise in PostgreSQL operations, performance tuning, replication, backup/recovery and on-call incident response, which aligns closely with a DevOps Engineer\u2019s responsibilities rather than a Fullstack Developer\u2019s.",
    "new_role_display_name": null,
    "new_role_slug": null,
    "queued": false,
    "reasoning": "LLM2 picked devops-engineer (confidence 0.92)"
  },
  "stage5_updates": {
    "centroid_n_after": 38,
    "centroid_updated": true,
    "collision_log_id": null,
    "new_kra_attached": null,
    "new_skills_attached": [
      {
        "is_primary": true,
        "queue_id": 1974,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Streaming Replication",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1975,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Logical Decoding",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1976,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "EXPLAIN ANALYZE",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1977,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "VACUUM",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1978,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Autovacuum",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1979,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "pg_dump",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1980,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "pg_basebackup",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1981,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "WAL Archiving",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1982,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Point-in-Time Recovery",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1983,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Liquibase",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1984,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Flyway",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1985,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "pg_stat_statements",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1986,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "auto_explain",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1987,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "shared_buffers",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1988,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "work_mem",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1989,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "max_connections",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1990,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "checkpoint_timeout",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1991,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "OLTP",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1992,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Role-Based Access Control",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1993,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Linux",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1994,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Ubuntu",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1995,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "RHEL",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1996,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Shell Scripting",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1997,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "PgBouncer",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1998,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Patroni",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 1999,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "repmgr",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2000,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "pg_repack",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2001,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "AWS RDS",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2002,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Amazon Aurora",
        "status": "pending"
      }
    ],
    "queue_entry_id": null,
    "v3_pipeline_triggered": false,
    "v3_role_slug": null,
    "v3_run_id": null
  }
}

{}

{}