Need a Google Cloud & PostgreSQL DevOps engineer to run a 5-stage production DB backup runbook: read-only preflight check, GPG public-key encrypted dump, isolated Docker restore test, and verified upload of 9 objects to a private GCS bucket.
₹600-1500 INR
Posted 1 minute ago
•
Ends in 6 days
₹600-1500 INR
Paid on delivery
Job Post: GCP & PostgreSQL DevOps Specialist — Runbook Execution & Encrypted Backup Project Overview We are looking for an experienced Google Cloud Platform (GCP) and PostgreSQL DevOps engineer to execute a structured, 5-stage production database verification, GPG-encrypted export, isolated restore test, and private Google Cloud Storage (GCS) upload for our Node.js/PostgreSQL application *Batkahi*. All bash scripts (`[login to view URL]` through upload) are already prepared; we need a disciplined operator to execute them cleanly under strict milestone gates and zero-trust security practices. Scope of Work & Milestones Milestone 1 — Preflight Inspection Only (`[login to view URL]`): Connect via least-privilege IAM to our GCP project (`coral-computing-zv9wh`), run the read-only preflight verification script to confirm Cloud SQL instance details, active databases, PostgreSQL version, and local disk capacity, and deliver the preflight report for founder sign-off before proceeding. Milestone 2 — GPG-Encrypted Export & Isolated Restore Verification: Upon written approval of the preflight report, execute the encrypted export using our provided GPG Public Key only, then perform an isolated restore into a separate temporary test environment to verify data integrity and table row counts without touching production. Milestone 3 — Private Bucket Upload & Final Verification: Once the isolated restore is verified, upload the encrypted bundle and confirm all 9 required objects (archives, checksums, and manifests) are present and verified in the designated private GCS bucket, followed by clean teardown of temporary local files. Mandatory Security & Operational Rules 1. Zero-Trust Key Handling: You will only receive a GPG public key. You will never ask for or handle our GPG private key or passphrase. 2. Strict Gatekeeping: No export or upload commands may be executed until the `[login to view URL]` report is reviewed and approved. 3. Live Verification: Steps 4 and 5 (isolated restore check and 9-object bucket verification) will be reviewed over a brief live screen-share. Required Qualifications * Proven hands-on experience with Google Cloud SQL (PostgreSQL), `gcloud` CLI, IAM permissions, and GCS private buckets. * Strong command-line fluency in Linux bash scripting, `pg_dump` / `pg_restore`, SHA-256 checksums, and GPG asymmetric encryption. * Available for overlap during IST business/evening hours. To Apply, Please Answer This Screening Question: In our runbook, we encrypt the database dump with GPG before uploading to GCS, and we verify the backup via an isolated restore first. Why do we use only the recipient's GPG public key during encryption, and how do we prevent an isolated restore from accidentally colliding with our live production database?
Project ID: 40817950
About the project
1 proposal
Open for bidding
Remote project
Active 21 secs ago
Place your bid
Bid amount Email addressBenefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
1 freelancer is bidding on average ₹1,050 INR for this job


Linux command-line capability and Node.js backend experience make me well suited to execute a prepared backup runbook with the discipline your production database requires. I understand the required separation between read-only preflight, approved export, isolated restore, and private GCS verification, and I am available for overlap with US, UK, and Australian business hours. GPG encryption uses only the recipient’s public key so the backup can be encrypted for the intended recipient without exposing or handling the private key or passphrase; only the corresponding private key can decrypt it. The restore must use a separate temporary PostgreSQL environment, isolated credentials and connection target, never the production host or database, with production access limited to the approved read/export stages. My Linux skills support careful bash-based execution, checksum verification, cleanup, and adherence to each approval gate, while my Node.js backend background helps me work confidently around application database environments. I can execute the runbook carefully under its zero-trust rules and participate in the live verification of the isolated restore and required bucket objects.
内容来自 Freelancer News,版权归原作者所有。
阅读原文 ↗