{
  "id": "1952105292757771332",
  "hourlyBudgetMin": {
    "rawValue": "25.0",
    "currency": "USD",
    "displayValue": "25.0"
  },
  "hourlyBudgetMax": {
    "rawValue": "75.0",
    "currency": "USD",
    "displayValue": "75.0"
  },
  "ciphertext": "~021952105292757771332",
  "title": "Help deploy a web app using Railway and Vercel",
  "description": "Description:\nI’m looking for a developer who can help deploy a web app using Railway for the backend and database, and Vercel for the frontend.\n\nThe backend is built in .NET and currently set up to use SQL Server, but I want to migrate it to PostgreSQL on Railway. The frontend is built in Next.js and is already hosted on Vercel.\n\nWhat needs to be done:\n\nUpdate the backend to work with PostgreSQL instead of SQL Server\n\nEnsure the backend is fully deployed and connected to the PostgreSQL database on Railway\n\nMake sure the frontend and backend are working together as expected\n\nRequirements:\n\nExperience with Railway and Vercel\n\nExperience with .NET and PostgreSQL\n\nStrong understanding of full-stack deployment\n\nLet me know your experience and how soon you could get started.",
  "createdDateTime": "2025-08-03T20:32:25+0000",
  "duration": "ONGOING",
  "durationLabel": "More than 6 months",
  "engagement": "Less than 30 hrs/week",
  "amount": {
    "rawValue": "0.0",
    "currency": "USD",
    "displayValue": "0.0"
  },
  "recordNumber": "1021063726",
  "experienceLevel": "EXPERT",
  "category": "web_mobile_software_dev",
  "subcategory": "web_development",
  "freelancersToHire": 1,
  "relevance": {
    "id": "0",
    "effectiveCandidates": 0,
    "recommendedEffectiveCandidates": 0,
    "uniqueImpressions": 0,
    "publishTime": null,
    "hoursInactive": 0
  },
  "enterprise": false,
  "relevanceEncoded": "{\"position\":\"2283\"}",
  "totalApplicants": 22,
  "preferredFreelancerLocation": null,
  "preferredFreelancerLocationMandatory": false,
  "premium": false,
  "clientNotSureFields": null,
  "clientPrivateFields": null,
  "applied": false,
  "publishedDateTime": "2025-08-03T20:32:25+0000",
  "renewedDateTime": null,
  "occupations": {
    "category": {
      "id": "531770282580668418",
      "prefLabel": "Web, Mobile & Software Dev"
    },
    "subCategories": null,
    "occupationService": null
  },
  "job": {
    "id": "1952105292757771332",
    "workFlowState": {
      "closeResult": null,
      "status": "ACTIVE"
    },
    "activityStat": {
      "applicationsBidStats": {
        "avgRateBid": {
          "rawValue": "35.08",
          "currency": "USD",
          "displayValue": "35.08"
        },
        "minRateBid": {
          "rawValue": "15.0",
          "currency": "USD",
          "displayValue": "15.0"
        },
        "maxRateBid": {
          "rawValue": "73.0",
          "currency": "USD",
          "displayValue": "73.0"
        },
        "avgInterviewedRateBid": {
          "rawValue": "32.57142857142857",
          "currency": "USD",
          "displayValue": "32.57142857142857"
        }
      },
      "jobActivity": {
        "lastClientActivity": "2025-08-04T07:24:22.187Z",
        "totalRecommended": 8,
        "invitesSent": 5,
        "totalInvitedToInterview": 7,
        "totalHired": 0,
        "totalUnansweredInvites": 1,
        "totalOffered": 0
      }
    },
    "classification": {
      "category": {
        "id": "531770282580668418",
        "ontologyId": "upworkOccupation:webmobileandsoftwaredev",
        "type": [
          "OCCUPATION"
        ],
        "entityStatus": "ACTIVE",
        "preferredLabel": "Web, Mobile & Software Dev",
        "definition": null,
        "createdDateTime": "2018-08-20T19:39:33+0000",
        "modifiedDateTime": "2023-12-19T19:18:21+0000"
      },
      "subCategory": {
        "id": "531770282584862733",
        "ontologyId": "upworkOccupation:webdevelopmentsubcategory",
        "type": [
          "OCCUPATION"
        ],
        "entityStatus": "ACTIVE",
        "preferredLabel": "Web Development",
        "definition": null,
        "createdDateTime": "2018-09-24T11:14:40+0000",
        "modifiedDateTime": "2023-07-10T17:01:25+0000"
      }
    }
  },
  "client": {
    "memberSinceDateTime": null,
    "totalHires": 44,
    "totalPostedJobs": 42,
    "totalSpent": {
      "rawValue": "26634.68",
      "currency": "USD",
      "displayValue": "26634.68"
    },
    "verificationStatus": "VERIFIED",
    "location": {
      "city": "The Woodlands",
      "country": "United States",
      "timezone": "America/Sao_Paulo",
      "state": "TX",
      "offsetToUTC": "Americas"
    },
    "totalReviews": 24,
    "totalFeedback": 4.58,
    "companyRid": "0",
    "companyName": null,
    "edcUserId": "0",
    "lastContractPlatform": null,
    "lastContractRid": "0",
    "lastContractTitle": null,
    "hasFinancialPrivacy": false
  },
  "activityStat": {
    "jobActivity": {
      "lastClientActivity": "2025-08-04T07:24:22.187Z",
      "invitesSent": 5,
      "totalInvitedToInterview": 7,
      "totalHired": 0,
      "totalUnansweredInvites": 1,
      "totalOffered": 0,
      "totalRecommended": 8
    }
  }
}