Terraform + GitHub Actions Matrix for 200 RDS Instances, S3 Sync & Cost-Aware Slack Alerts

Job Overview

Budget

$950.00

Level

Senior

Location

United Kingdom

Job Posted

26 Sep, 2025

Category

backup

Total Proposals

0

Job Description

 Factory-Scale Pain

You manage 200 RDS instances across dev, staging, prod accounts. Click-ops backups happen “when someone remembers”; holiday weekends = no backups; finance screams when manual snapshot costs spike +38 %. You want a factory-pattern that spins backups like CI jobs, tracks cost, and never sleeps.

Factory KPIs You Will Hit

  • 100 % backup coverage within 4 h window.
  • Cost per snapshot tracked + Slack alert if >15 % spike.
  • Zero manual clicks after Day-5; GitOps only.

Factory-Floor Scope I Will Build

  • Terraform Factory Module
    • Matrix loop over 200 RDS ARNs ( fed from AWS Config export ).
    • Snapshot lifecycle : retain 7 days, cross-region copy to S3 Glacier.
    • Cost tag : BackupFactory=true → Cost Explorer breakdown.
  • GitHub Actions Matrix Pipeline
    • Cron 04:00 UTC → strategy.matrix parallel ( max 20 jobs ).
    • Step: create snapshot → wait Available → export to S3 (parquet).
    • Cache AWS credentials with OIDC ( no long-lived keys ).
  • Cost-Aware Observability
    • Lambda Cost Anomaly → compares today vs 7-day average; >15 % → Slack #cost-guardrails.
    • Grafana bar chart : snapshot count, GB, cost per env.
  • Drift Guard & Manual Override
    • Terraform plan on PR → fails if manual snapshot detected.
    • Emergency workflow_dispatch button → creates on-demand snapshot with approver review.
  • Compliance Evidence
    • CSV backup register : db-id, snapshot-id, start-time, cost, status.
    • Signed SHA-256 manifest stored in immutable S3 bucket.

Deliverables

  • Terraform module ( reusable ) + GitHub Actions YAML.
  • Cost-anomaly Lambda ( Python zip ) + Grafana dashboard JSON.
  • CSV evidence + signed manifest + Cost Explorer screenshot.

Why Only a Senior Build-Engineer

  • Built 3 auto-factories for FinTechs ( 500+ DBs ).
  • FinOps certified → cost visibility is a feature, not an after-thought.
  • 30-day cost anomaly tuning included ( shared Slack ).

Skills

  • Backup automation tools and technologies

Tags

Backup automation tools and technologies

Author Spotlight

Liam O'Sullivan

Liam O'Sullivan

Client

No description available.

Related Jobs

1 year ago Senior
$70.00 Hourly

We are hiring a Business Continuity Planner to develop a comprehensive strategy for maintaining operations during disrup...

Risk assessment and analysis
View More
1 year ago MidLevel
$65.00 Hourly

We are looking for a Backup Automation Specialist to automate and optimize our data backup processes. This role involves...

Backup automation for different backup types (e.g., file backup, database backup, application backup)
View More
1 year ago MidLevel
$60.00 Hourly

We are seeking a Data Recovery Expert to implement and manage data recovery solutions, ensuring data can be restored eff...

Data recovery tools and technologies
View More
1 year ago MidLevel
$60.00 Hourly

We are hiring a Backup Security Analyst to secure our backup systems, ensuring data integrity and protection against ran...

Backup data encryption
View More
Liam O'Sullivan

Liam O'Sullivan

United Kingdom


Member Since
Oct 26, 2024
Total Created Jobs
6