Convex Backend Optimization, Cron Jobs, and Data Structure Fixes -- 2

I have a production app running on Next.js 16 with React 19 (all in TypeScript) backed by Convex and secured with Convex Auth. The most urgent pain-point is our cron layer—jobs fail to run on schedule, they sometimes crash mid-execution, and when they do complete they eat up more resources than they should.

While you focus on that, I’d also like you to streamline the database schema to remove redundant data, and jump into a few serverless functions: some need patching, a couple still need to be written.

What I need from you
• Triage and stabilise every scheduled task so it fires exactly when configured.
• Track down and remove the execution errors that currently kill certain runs.
• Optimise the code and queries inside each job for faster, lighter execution.
• Propose and apply schema migrations that eliminate unnecessary duplication without breaking existing queries.
• Fix the identified functions and add the new ones; all code in clean, typed, test-covered PRs.

Workflow & tools
Private GitHub repo, Convex CLI, Docker-based dev environment, CI on GitHub Actions. Familiarity with Convex’s scheduling helpers, database schema syntax, and typical Next.js build pipelines will let you move fast.

When you reply, please tell me the earliest moment you can jump in and roughly how much time you can commit this week. I’m ready to share full error logs, schema diagrams, and function specs as soon as we connect.