PostgreSQL backups, restore testing and disaster recovery plan
- Field
- DevOps
- Maximum volumeMaximum number of days the client allows the freelancer for this mission.
- 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.
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-40SX-M1N220 dmaximumSwitzerland
PostgreSQL query performance, monitoring and migration discipline
- Data migration
- Performance tuning
- Monitoring and alerting