Pipeline run

{
  "final_skills": [
    {
      "is_primary": true,
      "skill_name": "PostgreSQL"
    },
    {
      "is_primary": true,
      "skill_name": "PostgreSQL 14"
    },
    {
      "is_primary": true,
      "skill_name": "PostgreSQL 15"
    },
    {
      "is_primary": true,
      "skill_name": "Streaming Replication"
    },
    {
      "is_primary": true,
      "skill_name": "Logical Decoding"
    },
    {
      "is_primary": true,
      "skill_name": "Failover Orchestration"
    },
    {
      "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": "Online ALTER TABLE"
    },
    {
      "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": "Capacity Planning"
    },
    {
      "is_primary": true,
      "skill_name": "Storage Growth Forecasting"
    },
    {
      "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": "Aurora"
    }
  ],
  "jd_role": {
    "display_name": "PostgreSQL Database Administrator",
    "rationale": null,
    "role_aliases": [
      "DBA",
      "Database Administrator",
      "PostgreSQL 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": [
      "DBA",
      "Database Administrator",
      "PostgreSQL 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": 174
      },
      {
        "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": 63
      }
    ],
    "urls": []
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "10fe640e-fa44-45c3-98a7-dd271756ec8e",
  "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.6177
          },
          {
            "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.5679,
        "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.563
          },
          {
            "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.5249
          },
          {
            "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.462
          }
        ],
        "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.1395,
        "slug": "devops-engineer",
        "total_count": 43
      },
      {
        "display_name": "Cloud Architect",
        "kra_matches": null,
        "matched_count": 4,
        "matched_skills": [
          "Ansible",
          "Datadog",
          "Grafana",
          "Terraform"
        ],
        "role_id": 9,
        "score": 0.093,
        "slug": "cloud-architect",
        "total_count": 43
      },
      {
        "display_name": "Backend Developer",
        "kra_matches": null,
        "matched_count": 3,
        "matched_skills": [
          "Grafana",
          "PostgreSQL",
          "S3"
        ],
        "role_id": 1,
        "score": 0.0698,
        "slug": "backend-engineer",
        "total_count": 43
      },
      {
        "display_name": "ML Engineer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          "S3",
          "Terraform"
        ],
        "role_id": 3,
        "score": 0.0465,
        "slug": "ml-engineer",
        "total_count": 43
      },
      {
        "display_name": "Data Engineer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          "Row-level security",
          "S3"
        ],
        "role_id": 2,
        "score": 0.0465,
        "slug": "data-engineer",
        "total_count": 43
      }
    ]
  },
  "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.95,
    "is_new_role": false,
    "llm2_fired": true,
    "llm2_reasoning": "The JD centers on operational database administration, performance tuning, backups, monitoring, and on-call responsibilities, which align closely with a DevOps Engineer\u2019s core duties.",
    "new_role_display_name": null,
    "new_role_slug": null,
    "queued": false,
    "reasoning": "LLM2 picked devops-engineer (confidence 0.95)"
  },
  "stage5_updates": {
    "centroid_n_after": 41,
    "centroid_updated": true,
    "collision_log_id": null,
    "new_kra_attached": null,
    "new_skills_attached": [
      {
        "is_primary": true,
        "queue_id": 2154,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Streaming Replication",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2155,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Logical Decoding",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2156,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Failover Orchestration",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2157,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "EXPLAIN ANALYZE",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2158,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "VACUUM",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2159,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Autovacuum",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2160,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "pg_dump",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2161,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "pg_basebackup",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2162,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "WAL Archiving",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2163,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Point-in-Time Recovery",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2164,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Liquibase",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2165,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Flyway",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2166,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Online ALTER TABLE",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2167,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "pg_stat_statements",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2168,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "auto_explain",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2169,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "shared_buffers",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2170,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "work_mem",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2171,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "max_connections",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2172,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "checkpoint_timeout",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2173,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "OLTP",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2174,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Role-Based Access Control",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2175,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Capacity Planning",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2176,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Storage Growth Forecasting",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2177,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Linux",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2178,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Ubuntu",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2179,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "RHEL",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2180,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Shell Scripting",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2181,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "PgBouncer",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2182,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Patroni",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2183,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "repmgr",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2184,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "pg_repack",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2185,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "AWS RDS",
        "status": "pending"
      },
      {
        "is_primary": true,
        "queue_id": 2186,
        "role_display_name": "DevOps Engineer",
        "role_slug": "devops-engineer",
        "skill_name": "Aurora",
        "status": "pending"
      }
    ],
    "queue_entry_id": null,
    "v3_pipeline_triggered": false,
    "v3_role_slug": null,
    "v3_run_id": null
  }
}

{}

{}