Principal Engineer / Technical Architect Needed for AWS Lambda Project Setup with Prisma, API Gateway, and PostgreSQL Integration -- 2
Budget: $250 – $750 AUD
### **Project Title:**
**Principal Engineer / Technical Architect Needed for AWS Lambda Project Setup with Prisma, API Gateway, and PostgreSQL Integration**
### **Project Description:**
We are seeking a highly skilled Principal Engineer or Technical Architect with expertise in AWS Stack, TypeScript, and scalable architectures. The ideal candidate will have extensive experience in designing and deploying robust serverless applications that are secure, scalable, and maintainable.
### **Scope of Work:**
1. **Directory Structure Setup:**
- The provided codebase includes a directory structure as an **example**. We are looking for ideas and best practices to build a scalable system. Below is the suggested directory structure:
```bash
my-serverless-project/
├── src/
│ ├── lambdas/
│ │ ├── lambda1/
│ │ │ ├── handler.ts
│ │ │ ├── index.ts
│ │ └── lambda2/
│ │ ├── handler.ts
│ │ ├── index.ts
│ ├── common/
│ │ ├── prismaClient.ts
│ │ └── util/
│ │ ├── logger.ts
├── prisma/
│ ├── schema.prisma
├── node_modules/
├── tsconfig.json
├── package.json
└── serverless.yml
```
- **Objective**: Organize the existing code or propose an improved structure to fit into a scalable system, ensuring that common utilities, the Prisma client, and Lambda functions are correctly set up to work together.
2. **Prisma and PostgreSQL Integration:**
- The project involves working with 8-19 Prisma schema tables, which will be shared across all Lambda functions.
- Connect the Lambda functions to a PostgreSQL database using Prisma.
- Secure the database connection with appropriate networking configurations (e.g., VPC, security groups).
- Demonstrate the Lambda functions performing CRUD operations on the PostgreSQL database.
3. **AWS Lambda Setup:**
- Implement and deploy 6-8 Lambda services (functions) using the provided or suggested structure.
- Ensure the Lambda functions can call one another to perform operations.
- Implement the necessary code to support inter-Lambda communication and API Gateway integration.
4. **API Gateway Configuration:**
- Configure AWS API Gateway to expose the Lambda functions via RESTful endpoints.
- Support multiple HTTP methods (GET, POST, PUT, DELETE) as required.
- Ensure that API Gateway and Lambda integration is seamless, secure, and supports easy updates.
5. **Security and Networking:**
- Set up a secure environment for the Lambda functions, including appropriate IAM roles and policies.
- Configure networking to ensure secure communication between the Lambdas and the PostgreSQL database.
- Implement best practices for security, including encryption at rest and in transit, and secure environment variable management.
6. **Deployment Automation:**
- Create an automated deployment pipeline that allows easy deployment from the local development environment (VS Code).
- Use the Serverless Framework or AWS SAM to manage the deployment process.
- Ensure that the deployment process is parameterized and supports different environments (e.g., dev, staging, production).
### **Deliverables:**
- A fully functional and secure AWS serverless application deployed and connected to a PostgreSQL database.
- Complete setup and configuration of AWS Lambda, API Gateway, and networking components using the provided or improved directory structure.
- A production-ready system where 6-8 Lambda services are stitched together to interact with 8-19 Prisma schema tables.
- Documentation on how to:
- Develop, test, and deploy the application from a local development environment.
- Configure API Gateway and Lambdas for additional endpoints or functionalities.
- Manage database connections and Prisma schema updates.
- A short demonstration or walkthrough of the deployed solution.
### **Skills Required:**
- **Principal Engineer / Technical Architect Level Expertise**
- AWS Lambda
- AWS API Gateway
- Serverless Framework / AWS SAM
- Prisma ORM
- PostgreSQL
- TypeScript
- Networking & Security (VPC, IAM, etc.)
- DevOps (CI/CD, automated deployments)
- Familiarity with VS Code for development and deployment
- **Proven Experience in Scalable Architectures and Applications**
### **Additional Notes:**
- The freelancer will be provided with a codebase that includes Lambda functions, Prisma schema, and other necessary components. The main task is to stitch this code together into a working system that can be deployed to AWS.
- The provided directory structure is just an example. We are looking for your expertise and ideas to build a scalable, maintainable, and secure system.
- The solution should be designed with scalability, security, and ease of maintenance in mind.
- Familiarity with best practices for AWS Lambda and API Gateway is essential.
**Principal Engineer / Technical Architect Needed for AWS Lambda Project Setup with Prisma, API Gateway, and PostgreSQL Integration**
### **Project Description:**
We are seeking a highly skilled Principal Engineer or Technical Architect with expertise in AWS Stack, TypeScript, and scalable architectures. The ideal candidate will have extensive experience in designing and deploying robust serverless applications that are secure, scalable, and maintainable.
### **Scope of Work:**
1. **Directory Structure Setup:**
- The provided codebase includes a directory structure as an **example**. We are looking for ideas and best practices to build a scalable system. Below is the suggested directory structure:
```bash
my-serverless-project/
├── src/
│ ├── lambdas/
│ │ ├── lambda1/
│ │ │ ├── handler.ts
│ │ │ ├── index.ts
│ │ └── lambda2/
│ │ ├── handler.ts
│ │ ├── index.ts
│ ├── common/
│ │ ├── prismaClient.ts
│ │ └── util/
│ │ ├── logger.ts
├── prisma/
│ ├── schema.prisma
├── node_modules/
├── tsconfig.json
├── package.json
└── serverless.yml
```
- **Objective**: Organize the existing code or propose an improved structure to fit into a scalable system, ensuring that common utilities, the Prisma client, and Lambda functions are correctly set up to work together.
2. **Prisma and PostgreSQL Integration:**
- The project involves working with 8-19 Prisma schema tables, which will be shared across all Lambda functions.
- Connect the Lambda functions to a PostgreSQL database using Prisma.
- Secure the database connection with appropriate networking configurations (e.g., VPC, security groups).
- Demonstrate the Lambda functions performing CRUD operations on the PostgreSQL database.
3. **AWS Lambda Setup:**
- Implement and deploy 6-8 Lambda services (functions) using the provided or suggested structure.
- Ensure the Lambda functions can call one another to perform operations.
- Implement the necessary code to support inter-Lambda communication and API Gateway integration.
4. **API Gateway Configuration:**
- Configure AWS API Gateway to expose the Lambda functions via RESTful endpoints.
- Support multiple HTTP methods (GET, POST, PUT, DELETE) as required.
- Ensure that API Gateway and Lambda integration is seamless, secure, and supports easy updates.
5. **Security and Networking:**
- Set up a secure environment for the Lambda functions, including appropriate IAM roles and policies.
- Configure networking to ensure secure communication between the Lambdas and the PostgreSQL database.
- Implement best practices for security, including encryption at rest and in transit, and secure environment variable management.
6. **Deployment Automation:**
- Create an automated deployment pipeline that allows easy deployment from the local development environment (VS Code).
- Use the Serverless Framework or AWS SAM to manage the deployment process.
- Ensure that the deployment process is parameterized and supports different environments (e.g., dev, staging, production).
### **Deliverables:**
- A fully functional and secure AWS serverless application deployed and connected to a PostgreSQL database.
- Complete setup and configuration of AWS Lambda, API Gateway, and networking components using the provided or improved directory structure.
- A production-ready system where 6-8 Lambda services are stitched together to interact with 8-19 Prisma schema tables.
- Documentation on how to:
- Develop, test, and deploy the application from a local development environment.
- Configure API Gateway and Lambdas for additional endpoints or functionalities.
- Manage database connections and Prisma schema updates.
- A short demonstration or walkthrough of the deployed solution.
### **Skills Required:**
- **Principal Engineer / Technical Architect Level Expertise**
- AWS Lambda
- AWS API Gateway
- Serverless Framework / AWS SAM
- Prisma ORM
- PostgreSQL
- TypeScript
- Networking & Security (VPC, IAM, etc.)
- DevOps (CI/CD, automated deployments)
- Familiarity with VS Code for development and deployment
- **Proven Experience in Scalable Architectures and Applications**
### **Additional Notes:**
- The freelancer will be provided with a codebase that includes Lambda functions, Prisma schema, and other necessary components. The main task is to stitch this code together into a working system that can be deployed to AWS.
- The provided directory structure is just an example. We are looking for your expertise and ideas to build a scalable, maintainable, and secure system.
- The solution should be designed with scalability, security, and ease of maintenance in mind.
- Familiarity with best practices for AWS Lambda and API Gateway is essential.