Adjust GraphQL Types and Forms after Database Changes hourly

Digital Platform Stealthode c/o Kinky Illustrators HQ: Berlin, Berlin, Germany Remote job May 23

What You're Getting Into:

You're working on our talent management platform with a React/Next.js frontend, GraphQL API, and SQLite backend. The codebase is well-structured but currently broken due to database schema changes that haven't been propagated through the type system.

Your Mission:

Restore full application functionality by synchronizing TypeScript interfaces, GraphQL schemas, and React components with the updated database structure.

Acceptance Criteria / Success Metrics:

  1. ✅ Application compiles without TypeScript errors
  2. ✅ All forms work correctly (registration, profile creation, job posting)
  3. ✅ Data flows properly from database to UI
  4. ✅ User can complete core workflows end-to-end

Key Project Characteristics:

  1. Strongly Typed: Everything uses TypeScript with strict typing
  2. GraphQL First: All data flows through GraphQL resolvers
  3. Form-Heavy: Lots of complex forms with validation
  4. Modular: Well-organized component structure
  5. Production-Grade: Professional codebase with proper error handling

Starting Point:

Begin with the database structure analysis in src/core/db/structure.ts and work your way up through the type system following the provided checklist.

Support Resources:

  1. Complete file structure provided above
  2. Detailed step-by-step checklist
  3. Technical implementation guide
  4. Common issue patterns and solutions

This is a systematic refactoring task that requires attention to detail and methodical execution, but the codebase is well-organized and the path to resolution is clearly defined.

Root Cause:

Database structure changes have broken the type consistency chain throughout the entire system.

Impact:

  1. ❌ GraphQL types are outdated
  2. ❌ Forms not working correctly
  3. ❌ TypeScript errors in components
  4. ❌ Queries/Mutations failing

Objective:

Restore full functionality to the skillfolio application by updating all GraphQL types, schemas, and components to match the new database structure.

Prerequisites:

  1. Intermediate to advanced TypeScript knowledge
  2. Understanding of GraphQL schemas and resolvers
  3. React/Next.js experience
  4. Familiarity with form handling (Formik)

🔧 Development Environment Setup

Prerequisites

  • Node.js 16+ installed
  • TypeScript knowledge (intermediate level)
  • GraphQL familiarity
  • React/Next.js experience

More details after NDA and an detailed exchange.

Requirements
Availability:
Hourly contract
Experience levels:
Expert (5+ yrs)
Languages:
German, English

$18/hr