bluedoor data·Job Postings API·bluedoor.sh ↗

HomeCompaniesUsitsolutionsincOracle / PL/SQL Developer only w2 candidate can apply

Oracle / PL/SQL Developer only w2 candidate can apply

Usitsolutionsinc · Lansing, MI, United States · Active · SmartRecruiters

Job facts

FieldValue
CompanyUsitsolutionsinc
TitleOracle / PL/SQL Developer only w2 candidate can apply
Normalized title-
Department / teamConsulting
LocationLansing, MI, United States
Work model-
Employment typeContract
Salary-
Statusactive
ATS providerSmartRecruiters
Posted / first seen2017-05-07 / 2026-05-31
Changed / last seen2026-06-01 / 2026-06-06

Related slices

PageWhat it containsOpen
Company jobsActive postings from Usitsolutionsinc.Open
Company breakdownsRole, location, ATS, and work model facets for this company.Open
ATS provider jobsActive postings observed through SmartRecruiters.Open
Provider filtered searchThe same provider as a filtered job collection.Open
City jobsActive postings in Lansing.Open
Department jobsActive postings in Consulting.Open
Lifecycle eventsOpen, update, close, and reopen events for this posting.Open
Original postingCanonical source or apply URL captured from the ATS.Open

Linked records

CompanyUsitsolutionsinc
Sourcec04e57a5-48fa-47a5-b65e-ad86d62de15f
ATS providerSmartRecruiters

Full job record

Job IDca3c679cbb1e48eaeeece6da25e9f997c09a3943
Org ID5fc046c1-d977-424e-a30f-c7fbf4d866c8
Source IDc04e57a5-48fa-47a5-b65e-ad86d62de15f
Board IDc04e57a5-48fa-47a5-b65e-ad86d62de15f
Providersmartrecruiters
Provider Job Key115424532
TitleOracle / PL/SQL Developer only w2 candidate can apply
Normalized Title
Statusactive
Activeyes
Location TextLansing, MI, United States
DepartmentConsulting
Team
Employment Typecontract
Workplace Type
Remote Policy
CountryUnited States
RegionMI
CityLansing
Salary Raw
Salary Min
Salary Max
Salary Currency
Salary Period
Source URLhttps://jobs.smartrecruiters.com/usitsolutionsinc/115424532-oracle-pl-sql-developer-only-w2-candidate-can-apply
Apply URLhttps://jobs.smartrecruiters.com/usitsolutionsinc/115424532-oracle-pl-sql-developer-only-w2-candidate-can-apply
First Seen At2026-05-31 17:43:57Z
Last Seen At2026-06-06 10:55:39Z
Last Checked At2026-06-06 10:55:39Z
Last Changed At2026-06-01 10:29:29Z
Inactive At
Source Posted At2017-05-07 03:10:55Z
Source Updated At
Raw Payload Uris3://job-postings-prod-raw-590183727216/raw/provider=smartrecruiters/board=usitsolutionsinc/date=2026-06-06/2026-06-06T10-55-11-358Z-5b67109a95bbb487c253eb3707f1080574de71cc936f89f1689e5e9bb339f697.json
Event Fields
{
  "content_hash": "3b794898d84c5ad0a52401e7d90873a2e3cc7aa6b4c33efeb3d06ad5715f1c81",
  "source_hash": "6eaefbb281891bd98473b9b550b893372330088b17b6099f93e56c82edddf1b1",
  "last_changed_at": "2026-06-01T10:29:29.852Z",
  "active_status": "active"
}
Parsed Structured
{
  "language": "en",
  "location": {
    "raw": "Lansing, MI, United States",
    "city": "Lansing",
    "region": "MI",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T10:55:39.113Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Lansing, MI, United States",
      "city": "Lansing",
      "region": "MI",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": null,
  "salary_currency": null
}
Extensions
{}
Native Structured
{
  "id": "115424532",
  "ref": "https://api.smartrecruiters.com/v1/companies/usitsolutionsinc/postings/115424532",
  "name": "Oracle / PL/SQL  Developer only w2 candidate can apply",
  "uuid": "ce5cde2a-4854-449d-956c-159cdd769c0a",
  "detail": null,
  "company": {
    "name": "US IT Solutions Inc",
    "identifier": "USITSolutionsInc"
  },
  "creator": {
    "name": "Matt Turner"
  },
  "jobAdId": "074638fc-e0bd-4bd9-b9d3-92eb4cbe8bb5",
  "function": {
    "id": "consulting",
    "label": "Consulting"
  },
  "industry": {
    "id": "it_and_services",
    "label": "Information Technology And Services"
  },
  "language": {
    "code": "en",
    "label": "English",
    "labelNative": "English (US)"
  },
  "location": {
    "city": "Lansing",
    "hybrid": false,
    "region": "MI",
    "remote": false,
    "country": "us",
    "latitude": "42.73253499999999",
    "longitude": "-84.55553470000001",
    "fullLocation": "Lansing, MI, United States"
  },
  "refNumber": "REF93G",
  "department": {},
  "visibility": "PUBLIC",
  "customField": [
    {
      "fieldId": "58bef078e4b0f0244ea9c3e1",
      "valueId": "default",
      "fieldLabel": "Brands",
      "valueLabel": "US IT Solutions Inc"
    },
    {
      "fieldId": "COUNTRY",
      "valueId": "us",
      "fieldLabel": "Country/Region",
      "valueLabel": "United States"
    }
  ],
  "defaultJobAd": true,
  "releasedDate": "2017-05-07T03:10:55.000Z",
  "detail_errors": [],
  "experienceLevel": {
    "id": "executive",
    "label": "Executive"
  },
  "typeOfEmployment": {
    "id": "contract",
    "label": "Contract"
  }
}
Get this page with API

Rendered from the bluedoor Job Postings API. Reproduce it:

GET https://api.bluedoor.sh/job-postings/v1/jobs/ca3c679cbb1e48eaeeece6da25e9f997c09a3943?include=descriptionJSON
GET https://api.bluedoor.sh/job-postings/v1/orgs/5fc046c1-d977-424e-a30f-c7fbf4d866c8JSON
GET https://api.bluedoor.sh/job-postings/v1/sources/c04e57a5-48fa-47a5-b65e-ad86d62de15fJSON
GET https://api.bluedoor.sh/job-postings/v1/jobs/ca3c679cbb1e48eaeeece6da25e9f997c09a3943/eventsJSON