bluedoor data·H-1B Jobs API·bluedoor.sh ->

Home / Companies / DBAFFINITY LLC

DBAFFINITY LLC H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
DBAFFINITY LLC
DBAFFINITY, DBAFFINITY LLC
36125FY2016 to FY2024
Latest decision 2024-09-06
13DATABASE ADMINISTRATOR
8 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings36
Certified LCAs36
Denied LCAs0
Role titles12
Worksites5
Latest decision2024-09-06
USCIS approvals13
USCIS denials2

Aliases and source names

AliasesSource NamesSources
DBAFFINITY, DBAFFINITY LLCDBAFFINITY LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
DATABASE ADMINISTRATOR15-11418$60,549$63,000
SOFTWARE DEVELOPER15-11325$86,590$0
DATABASE ARCHITECT15-11994$85,000$0
QUALITY ASSURANCE ANALYST15-11993$70,000$0
Windows System Admin15-1142.00
Network and Computer Systems Administrators
3$85,000$86,500
LINUX AND WINDOWS SUPPORT ENGINEER15-1142
NETWORK AND COMPUTER SYSTEMS ADMINISTRATORS
2$81,266$98,030
LINUX SYSTEM ADMIN15-11422$88,878$90,000
SOFTWARE DEVELOPERS, APPLICATIONS15-11322$86,590$0
Windows System Admin15-1244.00
Network and Computer Systems Administrators
2$86,500$86,500
NETWORK AND COMPUTER SYSTEMS ADMINISTRATORS15-1142
NETWORK AND COMPUTER SYSTEMS ADMINISTRATORS
1$81,266$98,030

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
DublinOH4301723763,00002,0162,018
HarrisburgPA171106279,37395,5762,0222,024
KirklandWA980334281,26699,2992,0182,020
Santa ClaraCA950542188,87890,0002,0182,018
AtlantaGA303031160,54963,0002,0182,018

Full company payload

Company IDcompany:dbaffinity
NameDBAFFINITY LLC
Normalized Namedbaffinity
Source Company Idscompany_dol_oflc_lca_dbaffinity_llc, company_uscis_h1b_datahub_dbaffinity_llc_tax_7033
Source NamesDBAFFINITY LLC
AliasesDBAFFINITY, DBAFFINITY LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "DBAFFINITY LLC"
  ],
  "dba_names": [
    "DBAFFINITY"
  ],
  "name_variants": [
    {
      "value": "DBAFFINITY LLC",
      "filing_count": 25,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DBAFFINITY",
      "filing_count": 11,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DBAFFINITY LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7033",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 36,
  "case_count": 36,
  "role_title_count": 12,
  "worksite_count": 5,
  "total_workers": 36,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-17",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-09-06",
  "certified_count": 36,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 29,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 7,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 36,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 30,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 13,
  "total_denial": 2,
  "fiscal_years": [
    "2017",
    "2018",
    "2019",
    "2020",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Dublin"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 5,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_dbaffinity_llc_tax_7033_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_016081"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Dublin"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 3,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_dbaffinity_llc_tax_7033_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_017288"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Dublin"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 3,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_dbaffinity_llc_tax_7033_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_017102"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Dublin"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_dbaffinity_llc_tax_7033_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_013315"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Dublin"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43017"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_dbaffinity_llc_tax_7033_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_014648"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "DUBLIN OH 43017",
      "city": "Dublin",
      "state": "OH",
      "postal_code": "43017",
      "filing_count": 36,
      "case_count": 36,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-09-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "HARRISBURG PA 17110",
      "city": "Harrisburg",
      "county": "Dauphin",
      "state": "PA",
      "postal_code": "17110",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-09-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "KIRKLAND WA 98033",
      "city": "Kirkland",
      "county": "King",
      "state": "WA",
      "postal_code": "98033",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-01-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DUBLIN OH 43017",
      "city": "Dublin",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43017",
      "filing_count": 23,
      "case_count": 23,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SANTA CLARA CA 95054",
      "city": "Santa Clara",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "95054",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-06-05",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ATLANTA GA 30303",
      "city": "Atlanta",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30303",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-10-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 5,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}
Geography
{
  "states": [
    "OH",
    "PA",
    "WA",
    "CA",
    "GA"
  ],
  "cities": [
    "Dublin",
    "Harrisburg",
    "Kirkland",
    "Santa Clara",
    "Atlanta"
  ],
  "postal_codes": [
    "43017",
    "17110",
    "98033",
    "95054",
    "30303"
  ],
  "top_markets": [
    {
      "city": "Dublin",
      "state": "OH",
      "postal_code": "43017",
      "lca_count": 23,
      "role_title_count": 7,
      "wage_low_min": 63000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Harrisburg",
      "state": "PA",
      "postal_code": "17110",
      "lca_count": 6,
      "role_title_count": 2,
      "wage_low_min": 79373,
      "wage_high_max": 95576,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Kirkland",
      "state": "WA",
      "postal_code": "98033",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 81266,
      "wage_high_max": 99299,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Santa Clara",
      "state": "CA",
      "postal_code": "95054",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 88878,
      "wage_high_max": 90000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Atlanta",
      "state": "GA",
      "postal_code": "30303",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 60549,
      "wage_high_max": 63000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 23,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "5415",
      "filing_count": 7,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 60549,
  "annualized_high_max": 99299,
  "annualized_low_avg": 80615.3333333333
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 70000,
    "wage_high_max": 0,
    "wage_low_avg": 75000
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 63000,
    "wage_high_max": 0,
    "wage_low_avg": 72428.5714285714
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 14,
    "case_count": 14,
    "role_title_count": 8,
    "worksite_count": 4,
    "wage_low_min": 60549,
    "wage_high_max": 98030,
    "wage_low_avg": 84920.0714285714
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 81266,
    "wage_high_max": 98030,
    "wage_low_avg": 81266
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 83366,
    "wage_high_max": 99299,
    "wage_low_avg": 83366
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 85000,
    "wage_high_max": 86500,
    "wage_low_avg": 86000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 86500,
    "wage_high_max": 86500,
    "wage_low_avg": 86500
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 86500,
    "wage_high_max": 86500,
    "wage_low_avg": 86500
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 79373,
    "wage_high_max": 95576,
    "wage_low_avg": 79373
  }
]
Links
{
  "roles": "/v1/roles?company=DBAFFINITY%20LLC",
  "wages": "/v1/wages?company=DBAFFINITY%20LLC",
  "trends": "/v1/trends?company=DBAFFINITY%20LLC"
}
Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=dbaffinity+llc&limit=5JSON