Node + Postgres AWS DevOps

I have a production-ready Node.js application backed by PostgreSQL and now need a complete, automated DevOps workflow on AWS. Everything must live in the cloud, and I specifically want the workload to run on EC2 instances and/or an ECS or EKS cluster—no Lambda in this stack.

The assignment covers the full lifecycle: infrastructure provisioning, build and test automation, continuous delivery, monitoring, and rollback strategy. Infrastructure-as-code (Terraform or CloudFormation) is essential so I can reproduce the environment from scratch. A secure, highly available Postgres setup—preferably Amazon RDS with multi-AZ—is required, alongside a VPC, subnets, and the usual security groups.

Please containerise the Node service, wire up a CI pipeline (GitHub Actions, GitLab CI, or CodeBuild/CodePipeline—whichever you believe suits the stack best), and have every push to the main branch trigger a build, unit tests, an image push to ECR, and a deploy to the running ECS/EKS service or EC2 autoscaling group.

Deliverables
• IaC scripts for all AWS resources (EC2/ECS/EKS, networking, RDS, IAM)
• Dockerfile and app container images stored in ECR
• CI/CD pipeline definition with automated tests and zero-downtime deploys
• CloudWatch (or Prometheus/Grafana) metrics, basic alerts, and log aggregation
• A concise README explaining how to spin everything up, promote between environments, and perform a rollback

Work is done when I can run the IaC, commit code, and watch the service roll out end-to-end with no manual intervention.