Skip to content

PostgreSQL query performance, monitoring and migration discipline

Field
DevOps
Maximum volume
20 days
Target market
Switzerland
Reference
PCT-2026-10-40SX-M1N2

Skills sought

  • Data migration
  • Performance tuning
  • Monitoring and alerting

Target increased daily rate · DevOps

€1,700 to €3,000 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 platform for the transfer of passive rights (the right to a share of the revenue of a business) linking client-sellers, buyers and lobbyist-facilitators. Its Deno server functions and public REST API query a PostgreSQL database protected by row-level security (RLS).

Tasks

  • Measure expensive queries, then propose indexes, rewrites or RLS policy adjustments.
  • Set up monitoring: locks, connections, slow queries, table growth, alerts.
  • Formalise migrations: review, testing before rollout, a scripted rollback for each schema change.

Deliverables

  • Before/after report on the queries addressed, backed by execution plans.
  • Monitoring dashboard and configured alert rules.
  • Migration guide, applied to one real schema change.

Profile

PostgreSQL specialist: execution plans, query statistics, indexing, locking, RLS; SQL and automation scripts; French or English.

Terms

Remote, French or English. 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 DevOps

Back to the missions list