Skip to content

PostgreSQL backend: business engine, API and row-level security

Field
Development
Maximum volume
63 days
Target market
France
Reference
PCT-2026-10-J1PV-YZWH

Skills sought

  • Authentication and authorisation
  • PostgreSQL
  • Automated testing

Target increased daily rate · Development

€1,700 to €2,900 excl. VAT per day

Benchmark for this role. The increased daily rate is a target written into the contract, mission by mission, paid in two stages with no guaranteed date: it is not a promise of income.

Mission brief

Context

Belgian publisher of a B2B SaaS platform for collaboration between companies and independent professionals (contracts, assignment tracking, e-invoicing). Business engine in PostgreSQL with row-level security (RLS), server functions in Deno.

Tasks

  • Write the SQL migrations for new business rules, replayable on an empty database.
  • Write RLS policies per role and prove every denied access with a test.
  • Build Deno server functions: API endpoints, background jobs, calls to Stripe and to a Peppol access point.
  • Cover each rule with Vitest and SQL tests.

Deliverables

  • Merged migrations and functions, with continuous integration green.
  • A rights matrix per role and per table, consistent with the RLS policies.
  • A technical note per change: schema, edge cases, rollback.

Profile

Advanced PostgreSQL (RLS, functions, indexes, transactions), server-side TypeScript, Deno a plus. Fluent French, technical English.

Terms

Remote from France, working language French. The stated volume is a ceiling, with no set working hours.

What is public

The field, skills and maximum volume are public. Details are open to members of the programme concerned.

The Pacto framework

  • You remain an independent company. You sign directly with the company, on the programme’s contract templates.
  • Your clients pay you directly, from their account to yours. Pacto takes no commission on your missions, your invoices or your balances.
  • The increased rate is a target, agreed mission by mission with each client and written into your contract. It is not a promise of income.

Discover the freelancer offer

Apply for this mission

Details are open to members of the programme concerned.

Become a member to applyAlready a member? Apply from my workspace (new tab)

Other missions in Development

Back to the missions list