PostgreSQL Freelance Jobs

Job Description:

We are looking for an experienced mobile app developer or development team to build a robust and user-friendly mobile application for a medical transportation service. The app should function similarly to Uber but cater to the specific needs of coordinating transportation for patients requiring medical care across multiple locations, with varying schedules and specialist needs.

Key Features of the App:

1. Patient Scheduling & Management:

Organize daily schedules for multiple patients.

Plan trips based on patients' appointments, pickup locations, and destinations.

Include return trips where necessary.

2. Driver & Vehicle Coordination:

Optimize daily schedules based on available drivers and vehicles.

Assign drivers to routes depending on patient demand and geographic proximity.

3. Route Optimization:

Efficiently organize routes to minimize travel time and costs.

Integrate with mapping APIs for real-time navigation.

4. Real-Time Tracking & Notifications:

Track driver locations.

Send notifications to patients and drivers for pickups and drop-offs.

5. Admin Panel:

Manage and monitor drivers, vehicles, schedules, and patients in real time.

Generate reports for analytics and insights.

6. User Access Levels:

Separate interfaces for administrators, drivers, and patients.


Technology Requirements:

Mobile platforms: iOS and Android.

Backend: Cloud-based solution for scalability (AWS, Firebase, or similar).

Database: MySQL, PostgreSQL, or similar.

Integration with mapping APIs like Google Maps or Mapbox.

Your Qualifications:

Proven experience developing similar applications (e.g., ride-hailing or scheduling apps).

Strong knowledge of backend and frontend frameworks.

Familiarity with real-time tracking and route optimization.

Excellent communication skills and ability to work collaboratively.


Deliverables:

1. Fully functional mobile applications (iOS & Android).


2. Admin panel with complete functionality.


3. Source code and documentation.


4. Deployment to app stores.


Project Timeline:

We aim to launch the app within 1- 3 months.

Budget:

Please propose the budget that will allow to di that.

Skills: Android, Smartphone, Mobile App Development, Android App Development, User Profile Creation, iOS, Tablet, User Authentication, iOS Development

Project Overview
We are building a robust, scalable online origination tool for private equity deal sourcing. The tool will centralise company data scraped from Yellow Pages and True Local, enrich it with email addresses using Hunter.io, and provide a user-friendly interface to search, view, and export data. It will integrate with tools such as Outlook, a CRM (Affinity PE), and Company360 for seamless deal origination workflows.

We have existing Python scripts for scraping data from Yellow Pages and True Local. Now, we need an experienced developer or team to help us complete the project by handling data consolidation, enrichment, frontend and backend development, and integration.

Scope of Work

1. Import Scraped Data into SQL Database
Objective: Consolidate all scraped data into a centralised SQL database for storage and easy access.

- Export data from the completed Python scripts (Yellow Pages and True Local) in CSV format.
- Clean and deduplicate the data (e.g., using `Company Name + Location` as a unique identifier).
- Import the cleaned data into a SQL database with the following schema:
```sql
CREATE TABLE companies (
id SERIAL PRIMARY KEY,
company_name TEXT NOT NULL,
industry TEXT,
location TEXT,
phone TEXT,
website TEXT,
hunter_email TEXT,
hunter_email_type TEXT,
hunter_confidence INT,
hunter_verified BOOLEAN DEFAULT FALSE,
source TEXT,
date_scraped DATE,
UNIQUE (company_name, location)
);
```
- Track imported data in a `scrape_history` table to avoid duplication:
```sql
CREATE TABLE scrape_history (
id SERIAL PRIMARY KEY,
industry TEXT,
location TEXT,
date_scraped DATE
);
```

2. Hunter.io Integration for Email Enrichment
Objective: Automatically retrieve email addresses from company websites to enrich the data.

- Extract domains from the `website` field for companies without an email (`hunter_email IS NULL`).
- Use Hunter.io’s API to query domains and retrieve:
- Email address.
- Email type (e.g., "generic" or "personal").
- Confidence score.
- Update the `companies` table with enriched email data.
- Log API calls in a `hunter_api_logs` table for auditing:
```sql
CREATE TABLE hunter_api_logs (
id SERIAL PRIMARY KEY,
company_id INT REFERENCES companies(id),
domain TEXT,
email TEXT,
response JSONB,
date_searched TIMESTAMP DEFAULT NOW()
);
```

3. Develop Live Scraping Feature
Objective: Enable on-demand scraping for new industries or locations.

- Build a backend scraping service that accepts parameters (e.g., Industry, Location) via an API.
- Check the `scrape_history` table before initiating scraping to prevent duplication.
- Store new results directly in the `companies` table and update the `scrape_history` table.

4. Build / Use a Searchable Tool
Objective: Provide a user-friendly interface to search, filter, and view company data.

- Design a search interface with filters for:
- Industry
- Name
- Location (city, suburb, state)
- No. Employees
- Year founded
- Confidence Score (for Hunter.io emails)
- Display results in a clean, paginated table format with options to:
- Export results to CSV or Excel.
- View detailed company profiles, including enriched email data
- use AI and Outlook integration to email the contact

5. Finalise Backend Functionality
Objective: Ensure robust backend logic for managing data and integrations.

- Set up APIs for CRUD operations (Create, Read, Update, Delete) on the `companies` table.
- Build endpoints for:
- Interacting with Hunter.io.
- Supporting frontend features like live search and export.
- Triggering live scraping services.

6. Design the Web Interface
Objective: Create a professional and intuitive web application for the tool.

- Use modern frontend frameworks (e.g., React.js or Angular) to build the UI.
- Implement responsive design for desktop and mobile devices.
- Ensure seamless integration with backend APIs for real-time data access.

7. Host the Tool on the Web
Objective: Make the tool accessible online.

- Deploy the backend and database on a cloud platform (e.g., AWS, Google Cloud, or Azure).
- Use a CDN (Content Delivery Network) to host the frontend for fast loading.
- Secure the application with HTTPS and authentication mechanisms (e.g., OAuth2).

8. Integrations and Deployment
Objective: Finalise integrations and deploy the tool.

- **Outlook Integration**:
- Draft and send emails.
- Tag and track email replies to company which is displayed when clicking a company profile.
- automate follow up email if no response
- reply and organise meetings
- outreach based on criteria e,g. Industry and location, no. Emails a day etc.
- turn AI off and on
- Use AI to manage
- **CRM Integration** (Affinity PE):
- Automatically update CRM records with enriched data and outreach activity.
- **Company360 Integration**:
- Retrieve financial and director details for companies.
- Conduct final testing and deploy the tool to production.

9. Integrate custom news filtering based on criteria which is displayed on the interfsce
---

What We Provide
- Python scripts for scraping data from Yellow Pages and True Local.
- Access to API's

---

Final Deliverable
- A centralised, online tool for managing, enriching, and visualising company data, complete with live scraping, email enrichment, and integrations for deal origination.

---

Skills Required
- Python (for data processing and API integration).
- SQL (database design and management).
- Web development (React.js, Angular, or similar frontend frameworks).
- Cloud hosting (AWS, Google Cloud, or Azure).
- API integration (Hunter.io, Outlook, CRM, and Company360).

---

Timeline
Expected completion within 6-10 weeks.

---

Budget
Please provide your proposal with an estimated cost and timeline.

Skills: Python, PostgreSQL, React.js, API, Cloud

We are looking for an experienced developer to create a system that integrates contact leads into our cold email platform, leveraging AI to enhance lead enrichment and ensure data accuracy. The system will provide users with a database of leads and allow them to import, enrich, and utilize these leads for email campaigns.

Key Responsibilities:
Lead Integration:

Develop a backend system to integrate leads from external sources (e.g., CSV files, API integrations).
Ensure seamless importing and validation of contact lists.
AI-Powered Lead Enrichment:

Use AI models (e.g., OpenAI, Hugging Face, or custom-trained models) to enrich leads with additional information:
Job titles, industries, company size, location, and LinkedIn profiles.
Implement algorithms to deduplicate and clean lead data.
Lead Filtering and Segmentation:

Add functionality for users to filter and segment leads based on criteria (e.g., job title, location, industry).
Allow bulk tagging and grouping of leads.
API Integration:

Integrate with external lead data providers (e.g., Apollo.io, Clearbit, Hunter.io).
Provide users access to a large lead database with search and filtering capabilities.
Dashboard and Reporting:

Create a dashboard to display imported and enriched leads with detailed insights.
Include reports showing lead engagement (e.g., response rates, opens, clicks).
Deliverables:
Fully functional backend for importing and enriching contact leads.
AI-powered lead enrichment system with real-time updates.
APIs for integrating third-party lead data providers.
A basic UI for importing, filtering, and managing leads.
Documentation for all features and APIs.
Technical Requirements:
Backend Technology:
Preferred: Python (Flask/Django), Node.js, or Ruby on Rails.
AI Integration:
Use OpenAI API, Hugging Face Transformers, or similar for enrichment tasks.
Train or fine-tune models if necessary to match specific enrichment needs.
External APIs:
Integrate with lead providers like Apollo.io, ZoomInfo, Clearbit, or Hunter.io.
Database:
Use PostgreSQL, MongoDB, or similar to store and manage enriched leads.
Frontend (Optional):
If UI development is included, use React.js, Vue.js, or similar.
Additional Requirements:
Ensure compliance with data protection laws (e.g., GDPR, CCPA).
Familiarity with handling large datasets and optimizing for performance.
Prior experience with AI-based data enrichment or CRM platforms.

Preferred Qualifications:
Strong experience with AI/ML frameworks and API integrations.
Knowledge of B2B lead generation and enrichment tools.
Proven ability to build scalable systems for handling large datasets.

Skills: Lead Generation, Email Marketing, List Building

We are seeking a skilled developer to build Email Deliverability Optimization features for our cold email platform. The focus will be on ensuring high inbox placement by implementing tools to analyze email content, validate recipient addresses, and monitor email health.

This project excludes email warming functionality, as it is being developed separately.

Key Responsibilities:
Spam Analysis:

Implement a spam-checking tool to analyze email content for spam triggers.
Provide a detailed score/report with actionable suggestions to improve deliverability.
Email Address Validation:

Integrate email verification to ensure recipient addresses are valid and active.
Features to include syntax checking, domain validation, and mailbox pinging (SMTP verification).
Blacklisting and Reputation Monitoring:

Develop a system to monitor sender domains and IPs against major email blacklists.
Notify users if their domain or IP is flagged.
Error Handling and Reporting:

Handle and log email delivery issues (e.g., bounced emails, blocked addresses).
Generate detailed reports to help users troubleshoot issues.
Health Dashboard:

Create a dashboard to show metrics like bounce rate, delivery rate, and spam rate.
Allow users to track their email campaign health over time.
Deliverables:
Fully functional backend modules for spam analysis, email validation, and reputation monitoring.
Integration-ready APIs to connect with the rest of the platform.
A basic UI design for the health dashboard (optional if not part of the scope).
Documentation for all implemented features.
Technical Requirements:
Backend Technology:
Preferred: Python (Flask/Django), Node.js, or Ruby on Rails.
Email Validation:
Use APIs like ZeroBounce, Hunter.io, or open-source libraries.
Implement SMTP-based mailbox pinging for live validation.
Blacklist Monitoring:
Use services like Spamhaus, MXToolbox, or similar.
Fetch and monitor blacklist data programmatically.
Spam Analysis:
Integrate with open-source tools like SpamAssassin or use proprietary algorithms.
Database:
Use PostgreSQL or MongoDB to store validation results and monitoring data.
Additional Requirements:
Must follow best practices for email compliance (e.g., CAN-SPAM Act).
Familiarity with sender reputation factors (DKIM, SPF, DMARC).
Ensure modularity for easy integration with other features in the future.

Skills: Email Deliverability

We are looking for an experienced developer to create an Email Automation Engine capable of connecting with email providers (e.g., Gmail, Outlook, custom SMTP) and sending cold email campaigns efficiently. This will be the foundation of a larger cold email automation platform.

Key Responsibilities:
Email Connection:

Integrate with Gmail, Outlook, and custom SMTP services.
Support OAuth 2.0 authentication for secure account linking.
Email Sending Logic:

Build a system to schedule and send emails in bulk while respecting rate limits.
Implement retry mechanisms for failed emails.
Campaign Management:

Enable users to create, edit, and delete email campaigns.
Allow upload of recipient lists (CSV format) with basic validation.
Email Template Support:

Create a dynamic email template feature with placeholders (e.g., FirstName, Company.
Support basic HTML email content.
Error Handling and Logging:

Implement robust error handling for common email delivery issues (e.g., authentication failures, rate limits).
Create logs for sent, failed, and retried emails.
Deliverables:
A fully functional backend system for email automation, meeting the requirements above.
API documentation for connecting the email engine with a frontend system.
Basic testing to ensure email sending works across all integrated email providers.
Technical Requirements:
Backend Technology:
Preferably Python (Flask/Django) or Node.js.
Email Integration:
Gmail API, Outlook API, and SMTP protocols.
Database:
Use PostgreSQL or MySQL to store campaign data and logs.
Authentication:
OAuth 2.0 for Gmail/Outlook connections.
Username/password support for SMTP.
Deployment:
Code must be ready for deployment on a cloud environment (AWS/GCP/Azure).
Additional Requirements:
Must adhere to anti-spam regulations (e.g., CAN-SPAM Act).
Knowledge of email deliverability best practices (e.g., rate limiting, avoiding blacklists).
Experience with similar projects is a plus.

WEB Services need to be integrated
Will dicuss over meeting

Skills: MySQL, TypeScript, JavaScript, Node.js, MongoDB, React, PHP, React Native, PostgreSQL, Ruby on Rails, Vue.js, UX & UI, Tailwind CSS, Golang, Rust

We are seeking an expert in PostgreSQL to assist in designing a robust and efficient database structure for our AI application. The ideal candidate will have extensive experience in database design and optimization, particularly in relation to AI data handling requirements. You will collaborate with our development team to ensure the database supports the application's performance and scalability needs. If you have a strong background in PostgreSQL and a passion for innovative tech solutions, we would love to hear from you!

Skills: PostgreSQL, PostgreSQL Programming, Python, Database Design, SQL

I have a timescaleDB and I am running a websocket client that is performing operations on the database. currently the database CPU is operating at 97% and the the websocket client is dropping the connection and getting this error

connection error: connection closed

I want to optimize the database and resolve this issue.

Skills: PostgreSQL, TimescaleDB

Overview:
We are a SaaS company expanding our eSignature platform with a new Verbal Consent feature. The solution must handle both Inbound (consumer calls a generated number/PIN, TTS validates identity, then reads terms) and Outbound (system calls consumer, verifies identity, reads terms). After the consumer confirms with “yes,” a thank-you message is played, and the call ends. This project will be paid via milestones.

Responsibilities:

Design & UI/UX: Deliver a polished, user-friendly interface.
Development: Build a ready-for-production Verbal Consent microservice using Python (Django Rest Framework), PostgreSQL, React, and Next.js.
Telephony Integration: Implement Twilio or Sinch (including TTS) to handle concurrent inbound/outbound calls.
Infrastructure & Scalability: Utilize Docker and a microservices architecture to ensure high availability and scalability.
Integration & Support: Assist in merging the feature into our current platform and provide post-delivery support.

Skills: Django Stack, rest Framework, microservices , Twilio, Sinch

Looking for Odoo Developer with good technical and functional knowledge

Skills: Odoo, Python, Odoo Development, PostgreSQL, API, Python Script, Odoo Administration, Odoo Architect, JavaScript

We are currently looking for a skilled Laravel PHP & Frontend developer to join our team (No Agencies). As a Laravel developer, you will be responsible for developing and maintaining our web applications, ensuring they are secure, efficient, and user-friendly. You should have a strong understanding of Laravel framework, PHP programming, and excellent problem-solving skills. The ideal candidate should also have experience with front-end technologies such as HTML, CSS, and JavaScript.

Responsibilities:
- Develop and maintain web applications using Laravel framework
- Collaborate with the team to design and implement new features
- Can make clean user interfaces
- Delivers clean PR's with clean commits.
- Optimize application performance and ensure scalability
- Troubleshoot and debug issues
- Conduct code reviews and provide constructive feedback

Requirements:
- Proven experience as a Laravel PHP developer
- Strong knowledge of PHP programming
- Familiarity with front-end technologies (HTML, CSS, JavaScript)
- Good understanding of relational databases (MySQL, PostgreSQL)
- Ability to work independently and as part of a team
- Works fast, accurate.
- Knows how to leverage AI tools. We don't work as in 2016. If you are still stuck in 2016, don't apply.
- Excellent problem-solving skills
- Can deliver tested, clean and targeted pull requests. No spaghetti code generators.


Apply only if you're talented. If you are not exceptional, don't apply as you are wasting your own time. The interview will require a live coding test. Don't apply if you cannot share screen & open your webcam for a live test. We don't discriminate based on gender or nationality. We only care about your skills and ability to execute. If you are not exceptional, just did a bootcamp or don't code every day, this job is not for you. We are a strong engineering team making amazing projects for our clients. We are seeking true talent.

Skills: PHP, Laravel, MySQL, UI/UX Prototyping

I'm experiencing a connection error trying to connect to my on-premises PostgreSQL server through a Cloudflare tunnel. The server isn't behind any firewall or similar security measures, so I'm puzzled as to why this is happening.

- Ideal Skills: understanding of PostgreSQL, Cloudflare, and networking.
- Outcome: I need a professional who can diagnose the problem and provide a solution.

Skills: Windows Desktop, System Admin, Network Administration, PostgreSQL Administration

Context
We have an Odoo 14 community service deployed at ubuntu server using PostgreSQL, Odoo14, NGINX stack, we have around 30 db running at the same db/odoo service , this dbs are really light and low used, but a couple of them had been growing to hundred of thousands records , we are experiencing some problematic issues when performing server actions involving this records at this dbs:
1) Some actions that should take some minutes never ends (this have been tested on copies of this dbs in a stand alone local env)
2) Total collapse of service when trying to access any Odoo db (from Odoo logs no errors can be seen) but when trying to access db urls we just get a blank screen
3) When updating modules that creates or updates a colum of a model where some DBs have a high amount of records, all dbs reflect problem described at point 2

What we need
We need an expert opinion over our Odoo/NGINX/PostgresQL configuration parameters or even something else that is causing this problems and how to solve them.

Skills: Linux System Administration, System Administration, Odoo, ngninx

I'm looking for a skilled web developer with experience in building e-commerce platforms. I have used Lovable to create a backend and front end prototype that I want to have the developer use. The application will be centered around selling physical goods which are furniture, so an understanding of this market would be advantageous. Essential features include a user-friendly online catalog that the admin will use to enter the items and authentication for each user, with shopping cart and robust inventory management system. Knowledge of creating a seamless, secure, and efficient online shopping experience is critical.

here is the information:

Frontend Development:

React.js (18.x) - The core framework used
TypeScript - For type-safe development
Vite - For build tooling and development server
Tailwind CSS - For styling and responsive design
Shadcn/UI - For pre-built UI components
React Router - For client-side routing
Tanstack Query (React Query) - For data fetching and state management
Backend Development:

Supabase - For backend services including:
Authentication
Database management (PostgreSQL)
File storage
Real-time subscriptions
SQL - For database queries and management
Edge Functions - For serverless backend logic

Skills: PHP, JavaScript, Website Design, eCommerce, HTML

Project Overview:
We are seeking an experienced Full-Stack Web Developer to design and develop a comprehensive AI-powered content creation and social media management platform. This platform aims to empower small businesses, content creators, and e-commerce businesses with advanced tools for AI-driven content generation, scheduling, analytics, and trend insights.

Responsibilities:

Platform Development:

Build a responsive and user-friendly web-based platform integrating advanced AI tools for content creation.

Develop a robust backend system capable of handling complex AI integrations and content scheduling.

Content Generation:

Implement AI functionality to:

Generate short-form videos and reels tailored to platforms like TikTok, Instagram, and YouTube.

Create engaging captions, hashtags, and post templates optimized for various social media platforms.

Produce blog posts, email drafts, and marketing materials using AI tools.

Social Media Scheduling:

Develop a calendar-based scheduling tool for automated posting on platforms such as Instagram, TikTok, Facebook, LinkedIn, and YouTube.

Enable bulk scheduling and provide reminders for manual interventions when necessary.

Analytics and Performance Tracking:

Create a dashboard to track analytics, including engagement rates, impressions, and follower growth.

Integrate AI tools to provide actionable insights and recommendations for content optimization.

Bot Training and Customization:

Design a system to train an AI-powered bot to understand and learn about specific products and services.

Enable the bot to analyze trends and generate relevant content based on user-provided data and market dynamics.

Trend Analysis and Insights:

Integrate tools to monitor trending topics, hashtags, and viral content across platforms.

Build an AI-powered suggestion engine to propose content ideas based on emerging trends.

Security and Scalability:

Ensure the platform is secure and scalable to accommodate future growth and user needs.

Implement robust user authentication and data encryption.

User Support and Tutorials:

Provide built-in tutorials, guides, and a support system to help users maximize platform features.

Required Skills and Expertise:

Technical Skills:

Proficiency in front-end and back-end development (e.g., HTML, CSS, JavaScript, React/Vue, Node.js, Python/Django/Flask).

Experience with AI/ML frameworks (e.g., TensorFlow, PyTorch, OpenAI GPT APIs).

Knowledge of database management systems (e.g., PostgreSQL, MongoDB).

Familiarity with APIs for social media platforms (e.g., Instagram Graph API, TikTok API).

Expertise in video editing and AI video generation tools (e.g., ffmpeg, OpenCV, or similar libraries).

AI Integration:

Experience with natural language processing (NLP) and trend analysis.

Ability to train AI models for content generation using proprietary data.

Project Management:

Proven experience in building scalable, multi-functional platforms.

Ability to communicate complex technical details to non-technical stakeholders.

Preferred Qualifications:

Experience in developing SaaS platforms.

Knowledge of social media marketing trends and tools.

Familiarity with analytics frameworks (e.g., Google Analytics, custom reporting).

Deliverables:

A fully functional master demo account showcasing core platform features.

AI-powered content and video generation tools.

Calendar-based scheduling system with posting automation.

Analytics dashboard with performance tracking and actionable insights.

Customizable bot training for specific content creation needs.

Comprehensive documentation and user manuals.

Thorough testing and debugging to ensure smooth functionality.

Skills: Content Writing, Social Media Marketing, Artificial Intelligence, Social Media Management, Marketing Strategy, Search Engine Optimization, Graphic Design, API, API Integration, Web Development

We are seeking a skilled backend developer to create a user profile and matchmaking system using PostgreSQL, AWS EC2, S3, and MongoDB. The ideal candidate will also be responsible for API creation to facilitate seamless integration with our existing infrastructure. We have a Figma design that will guide the development process. This project aims to enhance user engagement and improve our matchmaking capabilities. If you have experience working with these technologies and a passion for building robust backend solutions, we want to hear from you!

Skills: PHP, JavaScript, Web Development, MySQL, API

Job Title:
Developer Needed for AI Sales Agent with Plug-and-Play Integration

Job Description:
I am looking for a skilled developer to build a lightweight AI Sales Agent focused on automating sales processes with simple, plug-and-play integrations. The system should be user-friendly, allowing customers to subscribe, integrate, and start using it independently.
This project is perfect for developers who are passionate about building AI tools on a budget while maintaining high-quality outcomes.

Project Scope:
1. AI-Powered Sales Agent:
Develop a conversational AI engine for sales-specific tasks like:
Answering customer queries.
Sending automated follow-ups.
Scheduling meetings.
2. Basic Integration Framework:
Build easy-to-configure integrations for:
CRM tools: HubSpot or Zoho.
Calendars: Google Calendar.
Email platforms: Gmail or Outlook.
Use RESTful APIs or Webhooks for compatibility.
3. User Dashboard:
Develop a simple dashboard for managing:
Leads and conversations.
Integration settings.
Ensure a clean and responsive design.
4. Deployment:
Host on AWS or similar cloud platforms.
Ensure it is lightweight, cost-efficient, and scalable for initial use.

Key Features:
Conversational AI: Responds naturally to basic sales queries.
Basic Integrations: Prebuilt connectors for popular tools.
Task Automation: Automate follow-ups and reminders.
Simple Interface: Easy-to-use dashboard for non-technical users.

Skills Required:
Python Programming
Machine Learning and NLP Basics (e.g., GPT or BERT APIs)
FastAPI or Flask Framework
RESTful API Development
Frontend Development (React.js or HTML/CSS/JavaScript)
Database Management (PostgreSQL or SQLite)
AWS Services or Affordable Cloud Hosting

Expectations:
Deliver an MVP within 2 weeks.
Code should be modular, scalable, and well-documented.
Provide at least one round of revisions after delivery.

Skills: AI Agent Development, AI App Development, AI Builder, AI Chatbot, Front-End Development, Arabic English Accent, Natural Language Processing, Containerization

Description:
We are building an AI-powered platform for SMBs to streamline sales and customer support on WhatsApp. We’re seeking a skilled Full-Stack Developer to help us build an MVP over the next three months.

Scope of Work:
1/ Frontend Application
- Develop a simple, responsive chat interface: Figma IS ready. Chat List Screen: Active threads, search, filters, and tags (e.g., “Needs Attention”).
2/ Integrate WhatsApp Business API for real-time messaging workflows.
3/ Set up Shopify Integration:
Fetch products, orders, and customer data via Shopify API.
4/ Orchestrate LLM workflows:
Automate FAQs and product inquiries.
Escalate complex queries to human agents.
Set up authentication system with OAuth and role-based permissions.

5/ Key Features:
Real-time WhatsApp messaging.
Integration with Shopify for product and customer data.
Basic AI workflows (FAQs and sales inquiries).
Authentication and role-based access control.


6/ Tech Stack:
Languages: JavaScript, TypeScript.
Frameworks: React, Node.js, PostgreSQL.
APIs: WhatsApp Business API (360dialog), Shopify API.
LLM Frameworks: OpenAI, Llama, or RAG live data.
Duration:

Looking for:
- Strong experience with full-stack development.
- Expertise in API integrations (WhatsApp, Shopify).
- Familiarity with AI workflows (preferred).
- Ability to architect scalable and maintainable solutions.

Skills: JavaScript, Node.js, API, API Integration, React, Artificial Intelligence, API Development, TypeScript, WhatsApp

Overview:
We are a SaaS company expanding our eSignature platform with a new Verbal Consent feature. The solution must handle both Inbound (consumer calls a generated number/PIN, TTS validates identity, then reads terms) and Outbound (system calls consumer, verifies identity, reads terms). After the consumer confirms with “yes,” a thank-you message is played, and the call ends. This project will be paid via milestones.

Responsibilities:

Design & UI/UX: Deliver a polished, user-friendly interface.
Development: Build a ready-for-production Verbal Consent microservice using Python (Django Rest Framework), PostgreSQL, React, and Next.js.
Telephony Integration: Implement Twilio or Sinch (including TTS) to handle concurrent inbound/outbound calls.
Infrastructure & Scalability: Utilize Docker and a microservices architecture to ensure high availability and scalability.
Integration & Support: Assist in merging the feature into our current platform and provide post-delivery support.

Skills: API, Twilio API, Django Stack

We are seeking an experienced Lead Front End Developer to spearhead the development of our innovative Ad Tech SaaS platform. The ideal candidate will have a strong background in frontend technologies and be able to collaborate closely with product managers and designers and back end developers to create an exceptional user experience. If you have a passion for cutting-edge technology and a track record of delivering high-quality software, we want to hear from you!

About Us:
We are an AI-driven performance marketing company specializing in innovative tools that streamlines and enhances paid search and social ads. Our flagship product is a Google paid search automation tool that simplifies researching, analyzing, and creating Google AdWords campaigns. as well as as Meta creative analytics tools. We have a robust GTM product and an internal management system already in place, we are focused on improving and building out new features with a sleek, client-facing front end.

Role Overview:
We are seeking a highly skilled Front-End Developer to implement our pre-designed client-facing interface as well as influence the design with function. This role involves creating a functional and intuitive front end that integrates seamlessly with our backend API and supports advanced features like Google?Facebook/Tiktok/etc API integration, user permissions, and notifications and more.

Key Responsibilities:
Develop and implement the front end based on provided designs.
Integrate features such as:
Authentication (sign-in functionality).
Full CRUD operations for user and campaign management.
Ensure smooth communication between the front end and backend API layer.

Requirements:

Core Front-End Skills:
Proficiency in JavaScript (React) react-router, formik, Chartjs, typescript, mobx,,
Strong HTML and CSS skills.
Familiarity with jQuery.

Additional Technical Knowledge:
Knowledge with GoLang (to collaborate with backend developers).
Understanding of Docker for containerized deployment.
Knowledge of Google Cloud services.

Database and Tools:
Experience with PostgreSQL.
Familiarity with Retool for internal tools development.
API Integration:
Expertise with Google APIs (AdWords, Maps, Places).

Preferred Qualifications:
Proven experience in building client-facing SaaS platforms.
Pro activeness and strategic thinking. Bring up issues to the team if you see something
Strong problem-solving skills and ability to work independently.
Excellent communication skills for collaboration with cross-functional teams.
Proactivity in task management and resolution
Being independent and responsible for following common UI guidelines and best practices

Skills: HTML, CSS, Web Development, JavaScript, formik, chartjs, HTML5, SaaS, Landing Page

Develop software to search for quant (quantitative analyst) job postings on career websites, curate them in an admin portal for review, and post approved jobs to specific Slack channels. The tool should support admin-defined keyword searches, flexible Slack channel posting, and backend management with enterprise-grade security.

Key Responsibilities:
Job Search Automation:

- Create a tool to scrape or use APIs from career websites to search for quant job postings.
- Implement an efficient scheduling mechanism to fetch newly posted jobs in real-time or near-real-time without overloading job sites.
- Allow admin-defined keywords to customize job title searches dynamically.

Admin Portal Development:

- Develop a secure web-based admin portal with the following features:
- - Job Review and Approval: Display fetched jobs for admin review and approval.
- Job Customization:
- - Mark jobs as "Promoted" or from a "Partner Company".
- - Add or modify keywords for job searches.
- - Assign Slack channels for posting.
- Dashboard: Show pending jobs, search activity logs, and posted job summaries.

Slack Integration:

- Post approved jobs to designated Slack channels in a structured format, including:
- - - A job summary.
- - - A link to the original posting.
- Notify a private admin Slack channel when new jobs are pending approval.

Infrastructure and Security:

- Build AWS-based compute resources for scalable processing and real-time updates.
- Ensure compliance with best practices to avoid overwhelming job sites (rate-limiting, caching).
- Integrate SAML SSO authentication tied to the quantminds.com domain for secure portal access.

Performance Optimization:

- Ensure high reliability and low latency for fetching, processing, and posting jobs.
- Design the tool to support real-time or frequent updates without delays.

Required Skills:
Web Scraping and API Integration:
- Expertise in tools like BeautifulSoup, Scrapy, Selenium, or equivalent.
- Familiarity with career website APIs and data extraction methodologies.

Backend Development:
- Proficiency in backend frameworks (Django, Flask, Node.js, etc.).
- Experience in developing admin portals with CRUD functionalities.
-Knowledge of Slack API for channel integration and messaging.
- Experience with AWS services (EC2, Lambda, S3, etc.) for scalable processing.
- Proficiency in relational and non-relational databases (PostgreSQL, MongoDB, etc.).
- Hands-on experience implementing SAML SSO and secure domain-restricted access.
- Knowledge of CI/CD pipelines and containerization (Docker, Kubernetes).

Deliverables:
- Fully functional job aggregation tool with an admin portal.
- Slack integration for job postings and admin notifications.
- AWS-based infrastructure setup for scalable processing.
- Documentation and training material for system maintenance and admin operations.

Skills: API, API Integration, JavaScript, Node.js, React, Python, Web Application

We are seeking an experienced consultant to assist with migrating our application from SQL Server to PostgreSQL. The current setup uses Access as a front end, and we also plan to transition this to a Python-based application. The ideal candidate will have a strong background in database management, migration processes, and Python development. Your expertise will help us ensure a smooth transition with minimal downtime and data integrity. If you have a proven track record in similar projects, we would love to hear from you!

Skills: PostgreSQL, PostgreSQL Programming, SQL, Ruby, Ruby on Rails

# Important: Every proposal will be reviewed thoroughly. There is no need to max out your connections.

#### Inclusivity and Equal Opportunity Statement

We are committed to fostering an inclusive and diverse work environment. This job opportunity is open to all individuals, regardless of gender, race, ethnicity, religion, sexual orientation (LGBTQIA+), disability, or any other characteristic protected by law. We celebrate diversity and are dedicated to creating an environment of respect, collaboration, and equal opportunity. Discrimination of any kind will not be tolerated.

------------

### Project Overview

We are seeking highly skilled freelancers to develop a mobile application that serves as a hybrid of an e-commerce platform and a delivery service tailored for Brazilian restaurants. The project will span up to 12 months, divided into 36 milestones, ensuring structured progress and timely delivery.

------------

### Monitoring Requirements and Use of AI

- AI-Assisted Development: The use of AI-assisted tools for coding is allowed and encouraged, provided it enhances productivity and integrates seamlessly into the developer's workflow. AI tools should act as a support mechanism to accelerate tasks and improve efficiency, not as a replacement for core development work. Selected developer(s) must possess the skills to deliver high-quality code independently without relying entirely on AI.

- Project Monitoring: Development progress will be monitored via Notion, utilizing a Kanban board for effective task management.

- Initial Phase Meetings: During the first three months, one-hour weekly meetings will be scheduled with our DevOps engineer, company CEO, and CTO to discuss progress, challenges, and next steps. These meetings will be compensated at a predetermined rate of $15 per hour.

------------

### Work Division and Budget Allocation

We offer three options for collaboration, allowing flexibility in team composition:

#### Option 1: Two Freelancers

1. Frontend Developer (30% of the Budget - $2,250.00)
- Responsibilities:
- Develop a responsive UI/UX using React Native, ensuring pixel-perfect alignment with our Figma mockups.
- Ensure cross-platform compatibility, adhering to Apple App Store and Google Play Store guidelines for performance, security, and UI standards.
- Test and debug on iOS and Android using emulators, prioritizing Mac M1, M2, or newer silicon hardware for iOS virtual device testing via Xcode.
- Optimize for mobile devices, with optional support for tablet screens using React Native Dimensions API.
- Implement smooth animations, transitions, and gestures with React Native Reanimated and Gesture Handler.
- Integrate APIs using Axios or Fetch, ensuring robust error handling and CORS compliance.
- Incorporate features like biometric authentication, push notifications, and adaptive layouts.

2. Backend/Cloud Developer (70% of the Budget - $5,250.00)
- Responsibilities:
- Design a scalable backend system using Golang or Python with a modular architecture.
- Build secure RESTful APIs or GraphQL endpoints for frontend integration.
- Optimize relational databases (PostgreSQL, MySQL) with advanced techniques like indexing, partitioning, and transaction handling.
- Deploy and manage backend services using AWS EC2 instances for compute scalability, ensuring load balancing with Auto Scaling Groups.
- Utilize AWS Lambda for serverless workflows, SNS/SQS for messaging, and API Gateway for request routing.
- Establish CI/CD pipelines and apply DevOps practices for automated and efficient deployments.
- Implement secure authentication with OAuth 2.0, JWT, and AWS Cognito.
- Monitor and debug performance using AWS CloudWatch, X-Ray, and other diagnostics tools.

#### Option 2: Three Freelancers

1. Frontend Developer (30% of the Budget - $2,250.00)
- Responsibilities:
- Develop the mobile frontend using React Native, optimized for smartphones, with optional adjustments for tablet screens.
- Test and debug on iOS virtual devices via Xcode, prioritizing Mac silicon hardware.
- Handle API integrations using Axios or Fetch, ensuring error handling and compliance with standards.
- Add mobile-specific features like push notifications, biometric authentication, and adaptive layouts.
- Use React Native Reanimated and Gesture Handler to implement animations and gestures.

2. Backend Developer (40% of the Budget - $3,000.00)
- Responsibilities:
- Build and optimize the backend architecture to support business-critical workflows such as order processing and delivery management.
- Manage real-time data via WebSockets or Socket.IO for features like live delivery tracking.
- Implement secure APIs, focusing on error handling, rate limiting, and caching with tools like Redis or Memcached.
- Use AWS EC2 instances for scalable hosting, with robust integration into Auto Scaling Groups and Elastic Load Balancing.
- Incorporate secure authentication using OAuth 2.0, JWT, and AWS Cognito.

3. Cloud Computing Specialist (30% of the Budget - $2,250.00)
- Responsibilities:
- Bridge the backend and frontend with AWS services like AppSync, API Gateway, and Lambda.
- Deploy AWS EC2 instances for backend processing with high availability and scalability.
- Use EventBridge, SNS, and SQS for event-driven architectures and background task management.
- Optimize cloud infrastructure using AWS CloudFormation or Terraform for Infrastructure as Code (IaC).
- Secure the infrastructure with AWS IAM, KMS, and TLS certificates.
- Monitor systems using CloudWatch, X-Ray, and Elastic Load Balancer metrics.

#### Option 3: One Fullstack Developer

1. Fullstack Developer (100% of the Budget - $7,500.00)
- Responsibilities:
- Frontend Development:
- Build a responsive UI/UX using React Native, ensuring adherence to Figma mockups.
- Ensure cross-platform compatibility and compliance with app store guidelines.
- Test on both iOS and Android using simulators, prioritizing Mac silicon hardware for iOS testing.
- Integrate APIs using Axios or Fetch, ensuring reliability and CORS compliance.
- Add advanced features like animations, push notifications, and adaptive layouts.

- Backend Development:
- Design a modular backend architecture in Golang or Python.
- Develop and document APIs, focusing on security and scalability.
- Use PostgreSQL or MySQL databases with advanced indexing and data integrity techniques.
- Manage backend compute needs with AWS EC2 instances, paired with Auto Scaling Groups and Elastic Load Balancers for fault tolerance.

- Cloud Computing and Integration:
- Use AWS Lambda, SNS, and SQS for event-driven processing.
- Set up AppSync or API Gateway to connect the frontend and backend securely.
- Implement monitoring and tracing with CloudWatch and X-Ray.
- Optimize cloud resources with CloudFormation or Terraform for IaC.
- Deliver global content using AWS CloudFront, ensuring low latency.

### Technical Specifications

#### Frontend Development (React Native)
- Develop a responsive and intuitive UI/UX adhering to Figma mockups.
- Integrate mobile features like biometric authentication and adaptive layouts.
- Implement internationalization (i18n) to support Portuguese and Spanish localization.

#### Backend Development (Golang or Python)
- Build APIs using Golang or Python, optimizing database operations with PostgreSQL or MySQL.
- Host services on AWS EC2 instances, ensuring scalability with Auto Scaling Groups.

#### Cloud Computing and AWS Integration
- Deploy serverless workflows with AWS Lambda and integrate with API Gateway.
- Use SNS, SQS, and EventBridge for task management and notifications.
- Monitor infrastructure with AWS CloudWatch, X-Ray, and Elastic Load Balancers.
- Ensure security with AWS IAM and encryption via KMS.

------------

### Compliance and Standards

- App Store Compliance: Adhere to Apple App Store and Google Play Store policies, including privacy guidelines, secure data handling, and user permission management.
- Payment Security: Maintain PCI DSS compliance for secure payment handling during in-app purchases.
- Privacy Standards: Implement app tracking transparency for iOS and appropriate user consent flows for Android.
- Security Best Practices: Ensure secure API communication using OAuth 2.0, JWT, and TLS encryption.
- Localization Standards: Prepare the application architecture to support seamless integration of translated content, ensuring that UI elements and error messages can be dynamically adjusted based on language settings.
- LGPD Compliance: Ensure compliance with Brazil's General Data Protection Law (Lei Geral de Proteção de Dados, LGPD), focusing on user consent management, secure data storage, and adherence to data protection principles. For further information on LGPD, please refer to the official resource: ["https://iapp.org/resources/article/brazilian-data-protection-law-lgpd-english-translation/";"https://en.wikipedia.org/wiki/General_Personal_Data_Protection_Law"]

------------

### Development Guidelines

- Code Quality: Ensure clean, modular, and well-documented code for maintainability.
- Version Control: Use best practices for version control with platforms like GitHub or GitLab.
- CI/CD: Implement continuous integration and continuous deployment pipelines using tools like AWS CodePipeline, Docker, and Kubernetes.
- Testing: Utilize automated testing frameworks for both frontend and backend to ensure reliability and performance.
- AI Tools: Use AI tools responsibly to augment development without compromising quality or slowing progress.
- Extensibility: Plan for future feature enhancements and integrations, ensuring the application is scalable and adaptable.
- Localization Integration: Develop the frontend with the capability to integrate translation methods, enabling future localization efforts by specialized translation teams.

------------

### Bonus and Additional Terms

- Bonus Payment: Bonuses can be pre-negotiated and will be based on milestone achievements, exceptional performance, or early delivery. These terms will be discussed and agreed upon before the start of the contract.

------------

### Freelancer Screening and Evaluation

To ensure the highest standards of professionalism, technical capability, and legal compliance, we have implemented a thorough and transparent selection process. The selected candidate will be required to meet the following criteria:

1. Online Coding Test
Candidates must complete an online coding test tailored to their area of expertise (Frontend, Backend, Cloud Computing, or Fullstack). This evaluation process will employ advanced integrity measures, including:

- Webcam Monitoring: Continuous video monitoring to verify the candidate’s identity and prevent impersonation.
- Screen Sharing: Real-time observation of the candidate’s desktop to ensure that only authorized activities occur during the test.
- Secure Test Environment: The test will be conducted on a locked-down platform designed to restrict unauthorized activities or internet searches during the assessment.
- Acknowledgment of Terms: The candidate must agree to the online test terms and conditions prior to participation. This agreement will include clauses on intellectual property, confidentiality of test materials, and penalties for any attempt to compromise test security.

2. Non-Disclosure Agreement (NDA)
Before gaining access to any proprietary information, the selected freelancer must sign a legally binding Non-Disclosure Agreement (NDA). This agreement will be structured to ensure enforceability across jurisdictions and will include the following:

- Verified Digital Signature: The NDA must be signed using a secure e-signature platform recognized under e-signature laws such as the U.S. ESIGN Act, EU eIDAS Regulation, or equivalent standards in other jurisdictions.
- Confidentiality Clause: A detailed definition of what constitutes confidential information, including but not limited to trade secrets, business plans, source code, and client data.
- Duration of Obligation: Confidentiality obligations will extend beyond the duration of the contract, typically for 3-5 years, or indefinitely for trade secrets.
- Jurisdiction and Governing Law: The agreement will specify the governing law (e.g., the jurisdiction of the hiring organization) and the exclusive venue for legal disputes.
- Arbitration Clause: Disputes will first be subject to arbitration in a neutral forum to ensure an efficient resolution, reducing potential litigation costs.

The NDA will include clauses for the following:

- Injunctions: Immediate legal action to prevent further breaches.
- Liquidated Damages: Pre-determined penalties for breaches of confidentiality.
- Legal Expenses: The breaching party will be liable for all costs associated with enforcing the agreement.

3. Results and Compliance Monitoring
Once the selection process is complete, successful candidates will proceed to onboarding, where compliance mechanisms will be enforced to ensure adherence to both performance and confidentiality standards:

- Access Control: Project-specific access will be granted on a need-to-know basis through secure platforms with audit trails.
- Encrypted Communication: All project communication will take place using end-to-end encrypted tools.
- Regular Compliance Reviews: Periodic checks will verify that the freelancer complies with all contractual and legal obligations.

------------

#### Legal Recourse for Breach
In the event of non-compliance with the test terms, NDA, or other agreements:

- Immediate Termination: The contract will be terminated without compensation.
- Damages and Compensation: The freelancer will be liable for any financial or reputational damage caused to the organization.
- Cross-Border Enforcement: If the freelancer resides in another jurisdiction, enforcement will be pursued through applicable international frameworks such as:
- The Hague Convention on the Recognition and Enforcement of Foreign Judgments.
- Bilateral treaties for mutual enforcement of court rulings, where applicable.

By participating in this process, candidates explicitly consent to these terms and acknowledge the legal and professional standards required for the role. Failure to meet these requirements will result in disqualification or, if discovered post-hiring, termination and possible legal action.

------------

### Freelancer Questions

To assess the qualifications and experience of potential freelancers, please answer the following questions relevant to your expertise:

#### Frontend Developer
1. React Native Implementation: How do you ensure pixel-perfect implementation of designs in React Native? Can you provide examples where you translated complex Figma mockups into production-level apps?
2. Cross-Platform Testing: Explain your experience in testing and debugging on both iOS and Android platforms. How do you handle platform-specific bugs efficiently?
3. Performance Optimization: Describe your approach to optimizing mobile applications for performance. What tools or libraries have you used to reduce rendering cycles and improve responsiveness?
4. Feature Integration: How do you integrate features like biometric authentication, push notifications, and adaptive layouts in a React Native app?
5. Animations and Gestures: Have you worked with animations and gestures using libraries such as React Native Reanimated or Gesture Handler? Provide an example of an interactive UI you’ve developed using these tools.

#### Backend Developer
1. API Design: Can you describe your experience in designing and implementing RESTful APIs or GraphQL endpoints? How do you ensure scalability and maintainability in your API design?
2. Database Management: Explain your knowledge of relational database design (e.g., PostgreSQL, MySQL). Have you implemented advanced features such as indexing, partitioning, or transaction handling?
3. Authentication Mechanisms: What is your experience with authentication mechanisms such as OAuth 2.0, JWT, and role-based access control? Share a relevant project example.
4. Event-Driven Architecture: How have you utilized event-driven architectures in your past projects? For instance, using tools like AWS SNS/SQS or Apache Kafka.
5. Monitoring and Debugging: Discuss how you debug and monitor backend systems for performance and reliability. What tools (e.g., Sentry, Logstash, Grafana) have you used?

#### Cloud Computing Specialist
1. Serverless Architecture: Describe your experience with AWS Lambda and its role in serverless architectures. How have you optimized its usage for scalability and cost-effectiveness?
2. API Integration: Explain your approach to integrating AWS AppSync or API Gateway with backend services to support secure and efficient communication with frontend applications.
3. Event-Driven Systems: Have you implemented event-driven systems using SNS, SQS, or EventBridge? Provide a project example where these tools played a critical role.
4. Security and Compliance: How do you ensure security and compliance in a cloud infrastructure? Discuss your experience with AWS IAM, KMS, and TLS encryption.
5. Monitoring Tools: Describe your experience with AWS monitoring and diagnostics tools such as CloudWatch, X-Ray, or Elastic Load Balancer metrics.

#### Fullstack Developer
1. End-to-End Development: Can you walk us through a project where you developed both the frontend (React Native or similar) and backend (Golang or Python)? How did you manage integration challenges?
2. API Design for Mobile Apps: Describe your approach to designing APIs for a mobile app that ensures seamless data flow and optimized performance.
3. Security Implementation: What is your experience in implementing end-to-end security for mobile applications, including secure API communication and OAuth 2.0 authentication?
4. Cross-Platform Optimization: How do you optimize and test mobile apps for cross-platform performance while ensuring backend scalability and cloud integration? Provide an example.
5. AWS Deployment: Discuss a project where you deployed a fullstack application on AWS infrastructure. What services did you use, and how did you ensure cost-efficiency and scalability?

------------

### Additional Notes

- Language and Communication: All communication, code, and project documentation will be conducted in English. Proficiency in English is required to ensure clear and effective collaboration.

- Preferred Timezones: We prefer freelancers based in the following timezones to facilitate synchronous communication and collaboration:
- GMT-5
- GMT-4
- GMT-3
- GMT-2
- GMT-1
- GMT+0
- GMT+1
- GMT+2
- GMT+3

- Localization Integration: The frontend must be prepared to integrate with translation methods, as a specialized company will be responsible for converting the frontend and error texts to Brazilian Portuguese and Spanish. Developers should implement internationalization (i18n) best practices, ensuring that all UI components and messages can be easily localized without requiring significant codebase changes.

- App Scope: The app's primary scope is for mobile phones, with optional adjustments for tablet support using responsive layouts. Focus should remain on mobile optimization to ensure a seamless user experience across a variety of smartphone devices.

- Hardware Requirements for Frontend Developers: Developers working on the frontend are preferred to have access to Mac M1, M2, or newer silicon hardware to efficiently test the app on iOS virtual devices via Xcode. This is critical for ensuring compatibility and performance on iOS platforms.

- Collaboration and Professionalism: The development process emphasizes collaboration, transparency, and continuous improvement, fostering a positive and productive working relationship. All communications should be conducted respectfully, innovatively, and humbly, ensuring a professional and non-offensive interaction environment.

- Communication: All project meetings, discussions, and communications will be conducted through Upwork's chat platform to ensure proper tracking and documentation, as required by Upwork’s policies. Any professional updates, task assignments, and project development materials will be shared and managed through Notion and GitHub, with the understanding that this will remain separate from client communication on Upwork. This approach ensures full compliance with Upwork's guidelines for secure and transparent communication, as well as maintaining a clear and organized record of all project-related activities.

------------

### Compliance with International Trade Regulations

To comply with international trade regulations and ensure adherence to global standards, the hiring party must reside in a country that is not subject to United States or international embargoes as of December 2024. This includes restrictions enforced by organizations such as the United Nations, European Union, or World Trade Organization. Engaging with individuals or entities from embargoed regions is prohibited to maintain compliance with applicable laws and standards.

------------

We look forward to collaborating with talented and dedicated professionals who are passionate about creating impactful mobile applications. If you meet the qualifications and are excited about this project, please apply with your detailed responses to the above questions.

Skills: React Native, Amazon Web Services, Python, Golang, Relational Database

A mobile app has been built for the salon industry, we need the app database to be analysed for optimization and performance opportunities.

Skills: SQL, PostgreSQL, PostgreSQL Programming, Performance Optimization, Database Management, Database Administration

We are seeking an experienced data engineer to create a fully functional data extraction pipeline from PostgreSQL to Amazon Redshift. The ideal candidate will optimize and extend our existing AWS Glue setup and provide comprehensive documentation of the entire process. This project requires a strong understanding of data engineering principles and experience with cloud-based data solutions.
Current Project Setup:
1. Redshift: Already operational.
2. PostgreSQL: Fully configured and set up.
3. AWS Glue: Available but needs extension and optimization.

Note: This is a quick task that needs to be done within a period of max 3 days. All other setup is done, just needs the data extraction pipeline to be setup.

Skills: ETL Pipeline, PostgreSQL Programming, Python, PostgreSQL, Amazon Redshift

We are seeking a Full-Stack Developer (Backend-Focused) to join our team and contribute to building and maintaining the backend architecture of our platform while also collaborating with the frontend when needed.

Responsibilities:
- Develop, maintain, and optimize scalable backend systems using Django and PostgreSQL.
- Design and implement robust RESTful APIs and support WebSocket for real-time communication.
- Collaborate with the team to integrate backend systems with the frontend built using Next.js and other frameworks.
- Leverage Elastic Search for efficient querying and search functionalities.
- Participate in pair programming and code reviews to ensure the quality and maintainability of code.
- Implement and integrate AI/ML models to enhance platform capabilities.

Qualifications:
- Strong experience in Django and PostgreSQL development.
- Proficiency in RESTful API and WebSocket development.
- Experience with full-stack technologies, especially Next.js.
- Familiarity with Elastic Search, Mapbox, and D3.js is a plus.
- Basic understanding of AI/ML integration in web applications.
- Strong collaboration skills, including experience with pair programming and Agile teams.
- Excellent communication skills, including comfort with video-on camera meetings.
- Ability to work independently and in a team environment while meeting deadlines.
- Prior experience in fitness, health tech, or similar domains.
- Experience integrating GPT-4 or similar AI technologies into applications.


If you are passionate about building innovative platforms and meet the qualifications above, we’d love to hear from you.

Skills: React, Django, API, API Integration, Python

We are seeking a highly skilled MERN Stack Developer with expertise in Prisma ORM and database migration to join our team. The ideal candidate will be responsible for diagnosing, resolving, and optimizing database migration issues within our existing Prisma and MongoDB/PostgreSQL setup. This role requires strong analytical skills, deep technical knowledge of the MERN stack, and the ability to deliver efficient, scalable, and robust solutions.

Skills: JavaScript, React, CSS

RAG Chatbot developer
Technical Stack:
- Frontend: React + Next.js
- Backend: Python FastAPI
- Vector DB: ChromaDB/Pinecone
- LLM: OpenAI GPT-4
- Document Processing: Langchain

Core Features:
- Document upload & processing (PDF, DOCX, TXT)
- Vector embedding generation and storage
- Interactive Q&A interface with source citations
- Basic user authentication and management
- Real-time progress tracking and error handling

Timeline:
- Core RAG pipeline: 2 weeks
- Frontend & UI: 2 weeks
- Testing & Deployment: 2 weeks

Required Skills:
- Python/FastAPI experience
- React/frontend development
- Vector DB implementation
- RAG architecture knowledge
- AI/LLM integration experience

Deliverables:
- Working RAG web application
- API documentation
- Deployment guides
- Basic user documentation

Please include:
1. RAG implementation experience
2. Relevant project examples
3. Development cost estimate
4. Proposed timeline

Looking for developers with proven experience in building production-ready RAG systems.

Skills: Java, JavaScript, Python, Django, PostgreSQL

I am looking for a highly skilled web developer with expertise in the following areas:

1. Front-End Development: Proficiency in HTML, CSS, JavaScript, and frameworks like React, Angular, or Vue.js for creating responsive and user-friendly interfaces.
2. Back-End Development: Experience with server-side languages such as Node.js, PHP, Python, Ruby, or Java for building robust and scalable functionality.
3. Database Management: Familiarity with database systems like MySQL, PostgreSQL, or MongoDB for secure and efficient data storage and retrieval.
4. API Integration: Knowledge of creating and integrating APIs to ensure smooth communication between systems.
5. Authentication Systems: Experience in building secure login and user authentication processes.
6. Search and Matching Algorithms: Understanding of building or implementing algorithms for efficient user interaction and functionality.
7. Responsive Design: Ability to create websites that work seamlessly on all devices and screen sizes.
8. Security Best Practices: Awareness of secure coding practices to protect user data and prevent vulnerabilities.

Preferred Skills
-Experience with cloud platforms like AWS, Google Cloud, or Azure.
-Knowledge of modern UI/UX design principles.
-Familiarity with version control systems like Git.
-Ability to provide ongoing maintenance and support after the project is complete.

If you have these skills and can deliver high-quality work, please apply!

NOTE: I am expecting everything to be done in one month maximum, this is mandatory, thanks!

Skills: Web Development, Web Application, Web Design

Description:
We are seeking an experienced no-code/low-code developer to collaborate on the live development of a micro SaaS platform. This project involves building a scalable web app with a user and partner dashboard, leveraging Replit for rapid development and deployment. If you are passionate about creating innovative solutions and thrive in collaborative live build sessions, we want to hear from you!

Responsibilities:

Lead the live build and development of a micro SaaS platform using Replit.
Design and implement a user-friendly dashboard for both users and partners.
Integrate third-party APIs, OAuth, and other SaaS tools.
Configure and optimize database solutions (e.g., PostgreSQL or similar).
Incorporate AI-driven features using OpenAI API or similar frameworks.
Troubleshoot and solve challenges in real-time during live sessions.
Ensure scalability and performance optimization of the platform.
Requirements:

Proven experience with no-code/low-code platforms, preferably Replit.
Strong understanding of front-end tools (React, HTML/CSS).
Experience with backend integration and API development.
Familiarity with database management (PostgreSQL or similar).
Knowledge of AI frameworks like OpenAI API is a plus.
Excellent problem-solving skills and ability to collaborate in live build sessions.
Strong communication skills and attention to detail.
Preferred Qualifications:

Experience with SaaS development and deployment.
Understanding of user experience (UX) and interface design (UI).
Background in collaborative, fast-paced environments.
Project Timeline:
This is a time-sensitive project, and we’re looking to begin immediately. The initial phase is focused on building and launching the core features.

Why Join Us?
This is an exciting opportunity to work on an innovative micro SaaS project with significant growth potential. Your contributions will be instrumental in shaping the platform’s success and scalability.

How to Apply:
Please submit your resume, portfolio, or examples of previous no-code/low-code projects you’ve completed. In your proposal, include:

Your experience with live build sessions.
Relevant tools or technologies you’ve used.
Availability to start and estimated timeline for initial deliverables.
We look forward to collaborating with you!

Skills: Replit, AI Integration, Real-time collaboration