[GIDS] Rewrite Terraform to Current Standards

[JoeTice]

Context: This issue was formerly part of this epic: Ensure all existing infra is in Terraform, tickets have been restructured to remove nested epics.

Description

Based on the review of the existing Terraform configurations, this ticket involves rewriting and updating the Terraform code to align with the latest standards and best practices. This effort aims to enhance maintainability, scalability, and compliance.

See:

• Terraform Standard - Confluence.
• Atomic Repository Concepts and practices - Confluence

---

Tasks

• Create fresh Terraform in GIDS Repo (i.e. pull in PG resource)
• Ensure correct resources are in the GIDS repo
  • Create and apply db TF resource
  • Create and apply EKS clusters TF resource (per env)
  • Apply a stubbed-out helm chart

Acceptance Criteria

• The Terraform codebase is updated and standardized according to the latest best practices.
• All changes are compatible with the current version of Terraform and have been tested for functionality.
• Appropriate resources are defined in Terraform
• Appropriate Terraform resources are applied to multiple environments

[ryan-mcneil]

PR created with scaffolded TF files

department-of-veterans-affairs/gibct-data-service#1123

[ryan-mcneil]

Update: A have a few commits terraforming the DB and couple resources on that PR and am awaiting some feedback on how to proceed. I've blocked this card with the linked Exploration card, to give me some room to do a few tutorials on Terraforming EKS/Helm for some better context on all of the moving pieces