Skip to content

PostgreSQL backups, restore testing and disaster recovery plan

Field
DevOps
Maximum volume
19 days
Target market
Belgium
Reference
PCT-2026-10-CYPC-SHRN

Skills sought

  • Database administration
  • Disaster recovery
  • Backup and restore

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

A Belgian software company runs a platform for the transfer of passive rights (the right to a share of the revenue of a business) between client-sellers and buyers, with a network of lobbyist-facilitators. Its PostgreSQL database enforces row-level security (RLS) and documents are encrypted.

Tasks

  • Audit the backups, replicated outside the database: coverage, frequency, retention, access.
  • Automate restore tests on an isolated database, with integrity checks.
  • Write the disaster recovery plan: scenarios, data-loss and downtime objectives, roles, procedure.
  • Check the RLS policies after a restore.

Deliverables

  • Audit report listing gaps and proposed fixes.
  • Tested restore scripts and the log of a full recovery drill, with measured durations.
  • Recovery plan agreed with the team.

Profile

Seasoned PostgreSQL administrator: logical and physical backups, point-in-time recovery, RLS, shell and SQL scripting; 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