Terraform Infrastructure Setup in AWS

I'm in need of a skilled professional who can create a Terraform script to build my AWS infrastructure from scratch. Key Components: - The infrastructure should be deployed inside its own VPC in AWS - The infrastructure should deploy an RDS database, specifically MySQL, that is securely accessible from the backend and frontend servers, but not accessible from outside the VPC or internet. Instance size: [login to view URL], allocated storage: 100Gb. Admin user/password should be supplied as variables -- I will specify them in the command line. Also a separate user account should be created to access this database. The user should have read/write access, I will again supply the username and password via command line. - The solution should include a set of servers to run both backend and frontend services. I want to be able to make a small change in the script to scale up or down the number of servers. This servers need to run AWS Linux, Java 21, node js 12, and datadog agent. We will start with 1 EC2 instance but as I said I want to be able to change that value and scale up (or down as needed). - The EC2 instances need to upload a config file for Datadog agent, part of this we need to supply the datadog api_key, which will be supplied in the command line via variables. The script needs to update that key in the datadog config file. - There are also a few directories which need to be created under /etc/datadog-agent/conf.d/ and files which need to be added into these. For the purpose of this create the directory /etc/datadog-agent/conf.d/mysql.d/ and add under it a file called [login to view URL] . The file will be in the same directory as terraform script. - After configuring datadog-agent, the service needs to be restrted - Create a folder /var/log/my_log_folder and ensure that it's owned by ubuntu:ubuntu with read/write permissions - install a service under /etc/system.d/system -- effectively copy a file from the same directory as terraform script to the host and reload config ; this should install a service which then can be configured via systemctl command. - I need to be able to SSH into the servers - The use of an AWS Elastic Load Balancer is essential to manage the traffic effectively. The LB will do a liveness check on port 9001 with the servers and redirect to port 5000 on the servers. The LB needs to accept https and http and have a certificate installed for the domain i will supply - There is also a domain which needs to be set up via Route53 , and some records need to be created: for load balancer in particular: we will register app.<domain> to point to the LB - Also the RDS database should be registered in Route53 as db.<domain> - Each EC2 instance should also be registered in Route53 as host1.<domain> - The setup should be within the US East 2 (Ohio) region. - The VPC should be configured according to best practices and security standards. Skills and Experience: - Proven experience in Terraform is a must. Experience with similar projects is highly desirable. - Strong AWS knowledge is crucial, especially in setting up RDS instances, EC2 instances, VPCs, and Elastic Load Balancers. - A background in MySQL database management is necessary for setting up the RDS. This project demands careful planning, a high level of security implementation, and scalability considerations. I'm looking for someone who can deliver efficiently and effectively and who can walk me through some of the Terraform script and/or answer questions around it.