PostgreSQL query performance, monitoring and migration discipline
- Field
- DevOps
- Maximum volumeMaximum number of days the client allows the freelancer for this mission.
- 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.
Apply for this mission
Details are open to members of the programme concerned.Once a member, you access the briefing, the client’s files, the Gantt chart and the Kanban board of the mission: all project management online on Pacto.
Other missions in DevOps
- DevOpsPCT-2026-10-DXVT-FNRZ18 dmaximumSwitzerland
DevOps: continuous integration, monitoring and disaster recovery
- Continuous integration
- Disaster recovery
- Monitoring and alerting
- DevOpsPCT-2026-10-CYPC-SHRN19 dmaximumBelgium
PostgreSQL backups, restore testing and disaster recovery plan
- Database administration
- Disaster recovery
- Backup and restore