Website Analysis & Design Specialist / Oracle

{
  "content_hash": "f381b80a8483a0fe8d86ff7c0947d15d4da2c4cef851bfcb9ac4abfa1e1522d2",
  "source_hash": "59c54f20f20564608a827ea7af34ed8beaf4257ddb92cb2323bdffe7dccd2b2e",
  "last_changed_at": "2026-05-31T17:43:32.892Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Albany, NY, United States",
    "city": "Albany",
    "region": "NY",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T20:31:16.738Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "Albany, NY, United States",
      "city": "Albany",
      "region": "NY",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": null,
  "salary_period": "day",
  "workplace_type": null,
  "salary_currency": null
}

{}

{
  "id": "743999659429806",
  "ref": "https://api.smartrecruiters.com/v1/companies/360itprofessionals1/postings/743999659429806",
  "name": "Website Analysis & Design Specialist / Oracle",
  "uuid": "bb2f5a56-ed89-425d-b0cf-65975d44fe1c",
  "detail": {
    "id": "743999659429806",
    "name": "Website Analysis & Design Specialist / Oracle",
    "uuid": "bb2f5a56-ed89-425d-b0cf-65975d44fe1c",
    "jobAd": {
      "sections": {
        "jobDescription": {
          "text": "<p><strong><span>PSB job description for your reference:</span></strong><span></span></p><p><strong><span>Job Title: </span></strong><b><span>Website Analysis &amp; Design Specialist / Oracle</span></b></p><p><b><span>Duration: </span>08 month contract</b></p><p><b><span>Location: </span>Albany NY</b></p><p><strong><span></span></strong></p><p><strong><span>Position Requirements/Technical Skills:</span></strong></p><p><span> <strong><span>Project Scope- duties of position</span></strong></span></p><p><span><span>·<span>         </span></span></span><span>Medical Malpractice Data Collection System (MMDCS).</span></p><p><span><span>·<span>         </span></span></span><span>Under Section 315(b) of the New York State Insurance Law, Hospitals, Insurance Companies, and certain Health Care Practitioners are required to report all malpractice claims within 90 days. The current Medical Malpractice Data Collection System (MMDCS), developed in 2002, is an outdated system which places a high burden on DOH staff and the claim reporters, requiring large numbers of staff to manually enter data into the system.</span></p><p><span><span>·<span>         </span></span></span><span>The Department of Health has a need to readdress the processes, and systems involved in the reporting of Medical Malpractice claims. A new comprehensive system to track all malpractice claims and related data needs to be designed and implemented. The system needs to support centralized intake to employ consistent investigation criteria and permit the automated identification of duplicative entries. The system needs to allow for prompt research and retrieval of accurate information from stakeholders, and to allow DOH to accurately report out on the data that is collected.</span></p><p><span> </span></p><p><strong><span>Daily Tasks will include but are not limited to the following:</span></strong><u><span> </span></u></p><p><span><span>·<span>         </span></span></span><span>Analysis and design of websites and data collection systems, including the transformation of legislative requirements into system functionality.</span></p><p><span><span>·<span>         </span></span></span><span>Designs system architecture and user interface.</span></p><p><span><span>·<span>         </span></span></span><span>Responsible for software development tasks including coding, testing, and implementation.</span></p><p><span><span>·<span>         </span></span></span><span>Prepares technical and user documentation.</span></p><p><strong><span></span></strong></p><p><strong><span>PART A:  The ONE MANDATORY REQUIREMENT:</span></strong><u></u></p><p><strong><span>Expert Level</span></strong><u><span> </span></u></p><p><span> <strong><span>PART B:   Requested Desirable Qualifications:  The numbered qualifications below are not mandatory, but candidates should meet or exceed in duration and skill set target asked for, at least 3 of numbers 1 through 5. </span></strong></span></p><p><span><span>·<span>         </span></span></span><span>84 Months Experience developing Oracle PL/SQL using advanced PL/SQL programming techniques.</span></p><p><span><span>·<span>         </span></span></span><span>84 Months Experience using Oracle development tools such as SQL Plus, SQL Developer, and SQL Loader for programming and maintaining applications.</span></p><p><span><span>·<span>         </span></span></span><span>48 Months Experience with designing and implementing logical and physical database models, experience with concepts such as indexes, primary keys, foreign keys, and constraints.</span></p><p><span><span>·<span>         </span></span></span><span>48 months Experience performing Extract, Transform, and Load (ETL) techniques.</span></p><p><span><span>·<span>         </span></span></span><span>24 months Experience optimizing, performance tuning, and debugging PL/SQL.</span></p>",
          "title": "Job Description"
        },
        "qualifications": {
          "text": "",
          "title": "Qualifications"
        },
        "companyDescription": {
          "text": "<p><b>360 IT Professionals</b><span> is a </span><b>California base Minority Business Enterprise</b><span> specializing in the field</span><br /><span>of IT Consulting and Staffing. Since our Inception we have been providing </span><span>industry leading IT solutions for Staffing and Software Development. We have </span><span>more than </span><b>30 IT Staffing Services contracts</b><span> across USA and working </span><span>closely with </span><b>Fortune 500 Companies</b><span> and </span><b>Key Private sector Agencies.</b><b> </b><span>We </span><span>are providing staffing support to more than </span><b>10 State Customers</b><span> across USA </span><span>and have successfully </span><b>staffed for more than 260 roles in last 6 months.</b><br /></p>",
          "title": "Company Description"
        },
        "additionalInformation": {
          "text": "<p><b>Local candidates preferred. Immediate interview and placement! any visa status</b><br /></p>",
          "title": "Additional Information"
        }
      }
    },
    "jobId": "0b3b8d82-cff4-4632-a735-bcd76b2f695e",
    "active": true,
    "company": {
      "name": "360 IT Professionals",
      "identifier": "360ITProfessionals1"
    },
    "creator": {
      "name": "",
      "avatarUrl": ""
    },
    "jobAdId": "0f0be295-6dee-443f-b193-fdb1eb0ad072",
    "applyUrl": "https://jobs.smartrecruiters.com/360ITProfessionals1/743999659429806-website-analysis-design-specialist-oracle?oga=true",
    "function": {
      "id": "information_technology",
      "label": "Information Technology"
    },
    "industry": {
      "id": "it_and_services",
      "label": "Information Technology And Services"
    },
    "language": {
      "code": "en",
      "label": "English",
      "labelNative": "English (US)"
    },
    "location": {
      "city": "Albany",
      "hybrid": false,
      "region": "NY",
      "remote": false,
      "country": "us",
      "latitude": "42.6525793",
      "longitude": "-73.7562317",
      "fullLocation": "Albany, NY, United States"
    },
    "refNumber": "REF3064I",
    "postingUrl": "https://jobs.smartrecruiters.com/360ITProfessionals1/743999659429806-website-analysis-design-specialist-oracle",
    "visibility": "PUBLIC",
    "customField": [
      {
        "fieldId": "COUNTRY",
        "valueId": "us",
        "fieldLabel": "Country/Region",
        "valueLabel": "United States"
      },
      {
        "fieldId": "58b7e5aae4b0885c92cd9c20",
        "valueId": "default",
        "fieldLabel": "Brands",
        "valueLabel": "360 IT Professionals"
      }
    ],
    "referralUrl": "https://jobs.smartrecruiters.com/external-referrals/company/360ITProfessionals1/publication/bb2f5a56-ed89-425d-b0cf-65975d44fe1c?dcr_ci=360ITProfessionals1",
    "defaultJobAd": true,
    "releasedDate": "2017-09-08T13:35:07.000Z",
    "experienceLevel": {
      "id": "mid_senior_level",
      "label": "Mid-Senior Level"
    },
    "typeOfEmployment": {
      "id": "contract",
      "label": "Contract"
    }
  },
  "company": {
    "name": "360 IT Professionals",
    "identifier": "360ITProfessionals1"
  },
  "jobAdId": "0f0be295-6dee-443f-b193-fdb1eb0ad072",
  "function": {
    "id": "information_technology",
    "label": "Information Technology"
  },
  "industry": {
    "id": "it_and_services",
    "label": "Information Technology And Services"
  },
  "language": {
    "code": "en",
    "label": "English",
    "labelNative": "English (US)"
  },
  "location": {
    "city": "Albany",
    "hybrid": false,
    "region": "NY",
    "remote": false,
    "country": "us",
    "latitude": "42.6525793",
    "longitude": "-73.7562317",
    "fullLocation": "Albany, NY, United States"
  },
  "refNumber": "REF3064I",
  "department": {},
  "visibility": "PUBLIC",
  "customField": [
    {
      "fieldId": "COUNTRY",
      "valueId": "us",
      "fieldLabel": "Country/Region",
      "valueLabel": "United States"
    },
    {
      "fieldId": "58b7e5aae4b0885c92cd9c20",
      "valueId": "default",
      "fieldLabel": "Brands",
      "valueLabel": "360 IT Professionals"
    }
  ],
  "defaultJobAd": true,
  "releasedDate": "2017-09-08T13:35:07.000Z",
  "detail_errors": [],
  "experienceLevel": {
    "id": "mid_senior_level",
    "label": "Mid-Senior Level"
  },
  "typeOfEmployment": {
    "id": "contract",
    "label": "Contract"
  }
}