Optimize Your MySQL Freelance Project Search

ScaleAt runs AI-driven growth automation for med spas and aesthetic clinics. We sell a written performance guarantee, which means our backend cannot fail silently — a missed call or a broken retention sequence isn't a bug, it's a refund. We're building the full automation infrastructure (four "pillars": local-SEO/Maps, an AI voice front desk, an AI chat agent, and a patient-retention engine) on a self-hosted n8n + GHL + PostgreSQL stack.

We already have a detailed, day-by-day build plan and an AI coding agent producing the work. We need an engineer who can take that plan and make it real, correct, and bulletproof — and keep it running as we add clients.

This is not a drag-and-drop no-code role. The hard parts are backend correctness: idempotency, webhook signature verification, concurrency control, retries, and "does this actually still work today" monitoring.

What you'll own


Build and harden n8n workflows in queue mode (Redis), backed by PostgreSQL — not toy automations, production workflows with retries, backoff, and a central error-handling layer.
Wire integrations over REST APIs and webhooks: GoHighLevel (GHL), Retell AI (voice), SearchAtlas, DataForSEO, Anthropic Claude API, Slack/Twilio.
Make every handler idempotent and every inbound webhook signature-verified before it acts.
Implement concurrency control (e.g. Postgres advisory locks) so simultaneous events can't double-book a calendar.
Own the reliability layer: error-trapping, alerting, self-audits, daily/weekly health checks, Postgres backups, git-versioned workflow exports.
Work staging-first: test against a staging environment and force failure paths before anything touches a live client.
Drive an AI coding agent (Claude Code / Codex) to produce most of the code/config, then review, correct, and integrate it. Comfort directing and sanity-checking AI output is a core part of this job, not a nice-to-have.


Must-have


2+ years building real automation/integration workflows (n8n strongly preferred; Make/Zapier + scripting acceptable if the backend depth is there).
Solid PostgreSQL: schema design, upserts, indexes, advisory locks, basic query tuning.
Genuine understanding of APIs and webhooks: auth types (OAuth2, bearer, basic auth), retries/backoff, rate limits, and verifying webhook signatures (HMAC / Ed25519).
A working grasp of idempotency and race conditions — you can explain why "check availability + book" should be two steps, not one.
Comfortable on the command line, with git, and with a Linux VPS (Docker a plus).
Hands-on with AI coding tools (Claude Code, Codex, Cursor) and able to judge when their output is wrong.
Clear written English and the discipline to document what you build for a non-technical founder.


Strong plus


GoHighLevel (GHL) experience — SaaS mode, snapshots, custom fields, Conversation AI, calendars.
Retell AI or other voice-AI / telephony integration experience.
Healthcare-adjacent or HIPAA-aware work (we handle patient data; care here matters).
Local SEO tooling (SearchAtlas, DataForSEO) and prompt design for content generation.


How we work


The build follows a written, day-by-day plan with explicit "definition of done" checkpoints per phase.
Reliability is a first-class deliverable. "It worked once" is not done; "it survives a forced failure and tells us when it breaks" is done.
Nothing goes to production without passing staging tests and (for high-risk workflows) a second-person review.


Paid trial task (how we hire)

Instead of a long interview, we pay for a short, real task. Build a single n8n workflow that:


Receives an inbound webhook and verifies its signature before doing anything.
Upserts a row in PostgreSQL idempotently (running it twice with the same payload must not create duplicates).
Calls an external HTTP endpoint with 3 retries and exponential backoff.
On final failure, routes the error to a central error workflow that logs to Postgres and posts to Slack.


Deliver: the workflow JSON export + a 5-minute screen recording walking through how it handles (a) a duplicate webhook and (b) a forced failure. We pay for your time on this regardless of outcome.

• Include a link to your GitHub profile and/or website
• What frameworks have you worked with?
• Describe your recent experience with similar projects

Position: Freelance WordPress Developer

Experience: 5+ Years

Location: Remote

Employment Type: Freelance

About the Role
We are seeking an experienced, highly skilled Freelance WordPress Developer with 5+ years of hands-on experience designing, developing, and maintaining WordPress websites and applications. The ideal candidate should possess strong expertise in WordPress development, PHP programming, cloud infrastructure, and website performance optimization.

Key Responsibilities
Develop, customize, and maintain WordPress websites, themes, and plugins.
Build responsive, user-friendly, and high-performance web applications.
Integrate third-party APIs, payment gateways, and external services.
Optimize website speed, security, scalability, and SEO performance.
Troubleshoot, debug, and resolve technical issues efficiently.
Deploy and manage WordPress applications on cloud platforms such as AWS and Azure.
Collaborate with designers, project managers, and stakeholders to deliver high-quality solutions.
Ensure adherence to coding standards, best practices, and security guidelines.
Perform regular website maintenance, updates, and backups.

Required Skills & Qualifications
5+ years of professional experience in WordPress development.
Strong expertise in Core PHP and object-oriented programming.
Experience with custom theme and plugin development.
Proficiency in HTML5, CSS3, JavaScript, and MySQL.
Hands-on experience with AWS and Azure cloud platforms.
Knowledge of REST APIs and third-party integrations.
Experience with Git/version control systems.
Strong understanding of website performance optimization and security best practices.
Excellent problem-solving and communication skills.
Ability to work independently in a remote environment.

Preferred Qualifications
Experience with WooCommerce development and customization.
Knowledge of CI/CD pipelines and DevOps practices.
Familiarity with modern JavaScript frameworks is a plus.
Experience working with global or distributed teams.

Why Join Us?
Flexible remote work environment.
Opportunity to work on diverse and challenging projects.
Competitive freelance compensation.
Long-term collaboration opportunities.

My Joomla website has suddenly gone offline and is now returning an HTTP 500 Internal Server Error. It sits on a self-managed Linux server and, to the best of my knowledge, nothing was recently changed—no updates, no new extensions, nothing. I need the site brought back online quickly and, once it’s stable, the administrator login details verified or reset so I can access the backend again.

The task involves:
• Diagnosing the exact cause of the 500 error (log review, permission issues, mis-configured .htaccess, PHP fatal errors, etc.)
• Applying the fix so the front end loads normally and the Joomla admin panel is reachable
• Supplying working super-user credentials (or creating a new one) so I can log in and manage content
• A brief note outlining what was wrong and how you resolved it, for future reference

The server gives you full SSH access, Apache/Nginx logs, phpMyAdmin, and anything else you might need. Please be comfortable troubleshooting Joomla on Linux, working via the terminal, and keeping downtime to an absolute minimum.

Skills: PHP, Linux, Joomla, Troubleshooting, Apache, MySQL, Website Management, Web Hosting, Content Management System (CMS), System Administration

I need a clean, lightweight MLM application whose core is a genealogy module presented as a vertical tree. The visual should load quickly, scale smoothly as a network grows, and let any logged-in user click on a node to reveal member details—no drag-and-drop, no expand/collapse toggles, just a straightforward click-to-view experience.

I am not looking for a full-blown suite at this stage; commission tracking and automated notifications may be added later, but the very first milestone is the genealogy tree itself, wired to a simple member database and wrapped in an intuitive web interface.

Acceptance criteria
• Vertical genealogy tree renders correctly for unlimited depth
• Clicking a node opens a modal or side panel with that member’s profile data
• Responsive design so the tree is usable on desktop and mobile
• Clean code (Laravel or Node + React are fine; suggest what you prefer) with brief setup instructions in README.md

If you have an existing module that meets these points or can build one quickly, let’s get started right away.

Skills: PHP, JavaScript, MySQL, Node.js, Laravel, React.js, Web Development, API Development

My WordPress site is dragging its feet and I need it brought up to speed—literally—and locked down at the same time. The top priority is loading-speed optimization, with a specific focus on the database. I want slow queries identified, indices tuned, unused tables cleared out, and the overall structure streamlined so pages snap open instead of stalling.

Alongside that, I need solid security hardening: patching core and plugin vulnerabilities, tightening file permissions, installing a lightweight firewall, and setting up ongoing malware monitoring so I can sleep at night knowing the site is protected. If you discover that a bit of image compression or smart caching would give an extra kick, I’m open to it, but the database work comes first.

Because this is urgent, I’m looking to move ASAP and will make quick decisions.

Deliverables
• Optimised database with demonstrably faster query times and page loads
• Implemented security measures with a brief hand-off report of what was done and why
• Before-and-after performance and security benchmarks (GTmetrix or similar for speed; security scan report for hardening)

If you’ve tuned WordPress databases and tightened site security before, let’s get started right away.

Skills: PHP, Web Security, WordPress, MySQL, Database Administration, Website Optimization, Database Management, Performance Tuning

See attachment for the 2 stage PMS. The first stage is required for the MVP demo. In the MVP Demo we are aiming to show an Agentic AI working in autopilot mode with agents moving through the PMS and Access Control areas.

Designed and developed a complete enterprise-grade multi-vendor eCommerce platform with advanced marketplace functionality, customer management, inventory control, CRM integration, AI-powered features, and scalable architecture. The platform supports multiple product types including physical, digital, subscription, and auction-based products while providing secure authentication, role-based access control, and comprehensive analytics dashboards.

Key Features:

Multi-Vendor Marketplace with Vendor Dashboard & KYC Verification
Advanced Product & Inventory Management System
Order Processing, Returns & Refund Management
Multiple Payment Gateway Integrations (Stripe, PayPal, Razorpay, PayU, Cashfree, etc.)
Shipping Integration with Major Logistics Providers
Customer CRM & Loyalty Rewards System
AI-Powered Product Recommendations & Smart Search
Progressive Web App (PWA) Support
REST API Architecture for Mobile Applications
Advanced Analytics & Business Reporting
SEO Optimization & Content Management System
Enterprise-Level Security with 2FA, GDPR Compliance & Activity Monitoring

Technology Stack: Laravel, MySQL, REST API, PWA, AI Integration, Payment Gateway APIs, Shipping APIs, CRM Systems, Advanced Security Architecture.

Project Outcome: Built a scalable, high-performance enterprise eCommerce ecosystem capable of supporting thousands of products, vendors, customers, and transactions while maintaining security, speed, and seamless user experience.

Skills: PHP, Website Design, Software Architecture, eCommerce, MySQL, Laravel, REST API, AI Development

Project Title: Custom ERP & CRM System for Compression Garment Manufacturing Company

We are a healthcare manufacturing company specializing in custom-made medical compression garments. Our operations include doctor referrals, direct patient sales, field sales teams, in-house manufacturing, and after-sales support.

Current Scale:
• 25–30 orders per day
• 7 sales territories
• 2 managers and 6 sales representatives
• In-house production team
• 30+ products with 11 different measurement templates

We are looking to develop a custom web and mobile-based ERP/CRM system to digitize our complete workflow.

Required Modules:

1. Doctor CRM
• Doctor database and profiling
• Daily call reports (DCR)
• Visit tracking and follow-up reminders
• Referral analytics

2. Patient Management
• Patient profiles
• Duplicate detection based on mobile number
• Complete order and service history

3. Order Management
• Field order creation from Android and iPhone devices
• Multi-product orders
• Dynamic measurement forms (11 templates)
• Offline data capture with synchronization
• Manager approval workflow

4. Payments & Invoicing
• Partial and advance payment tracking
• GST invoice generation
• UPI payment integration
• Payment proof upload

5. Production Management
• Stage-wise production tracking
• Worker assignment
• Priority and urgency management
• Production timers and status monitoring

6. Delivery & Service
• Delivery tracking
• Refit management (6-month validity)
• Complaint management
• Patient feedback collection

7. Team Management
• Attendance with GPS
• Leave management
• Territory management

8. Communication
• WhatsApp integration for invoices, notifications, and follow-ups

9. Reporting & Dashboards
• Sales performance
• Doctor referral analytics
• Production analytics
• Collections and outstanding payments
• Territory-wise reporting

Technical Requirements:
• Mobile App (Android & iOS)
• Web Admin Panel
• Role-based access control
• Offline-first architecture
• Audit logs
• Scalable cloud-based solution

Please provide:

1. Estimated cost
2. Development timeline
3. Technology stack
4. Similar projects completed
5. Post-launch support plans
6. Source code ownership terms

Skills: PHP, Project Management, Mobile App Development, Android, CRM, ERP, MySQL, Software Development, Web Development, API Development

==Project Description==
We are a North American startup seeking the development of a modern, attractive, and highly intuitive website, optimized for maximum performance and minimal maintenance. The site must include advanced graphics, payment integrations, purchase workflows, automated communications, artificial intelligence features, and a robust client management system through CRM integration.

==Main Objectives==
Deliver a professional and user-friendly experience for all levels of users.

Implement purchase workflows with predefined packages, options to add services to existing packages, and standalone services.

Establish various external integrations (details disclosed only under NDA).

Provide a secure and personalized dashboard for registered clients, with 24/7 access to documents and order tracking.

Integrate an external CRM to manage client data and securely store documents.

Optimize the site for SEO and performance.

Use artificial intelligence to ensure every client interaction is personalized and automated, supporting the growth of our North American startup.

==Project Phases==
🔹 Phase 1 – Landing Page
Modern, responsive, and visually appealing design.

Contact and quotation forms.

WhatsApp connectivity.

Basic SEO integration.

🔹 Phase 2 – Integrations and Workflows
Purchase workflows:

Predefined packages.

Add-on services to existing packages.

Standalone (“à la carte”) services.

External integrations (generalist description only).

Payment systems (Stripe, PayPal).

Automated emails with PDF attachments.

Client dashboard:

Order progress tracking.

24/7 document downloads.

Automated notifications via email, SMS, and WhatsApp.

CRM integration:

Centralized client management.

Secure document storage.

Real-time synchronization with the dashboard.

🔹 Phase 3 – Artificial Intelligence Features
Intelligent recommendations: automated suggestions based on purchase history and browsing behavior (what clients bought, reviewed, or skipped).

Communication optimization: personalized emails, SMS, and WhatsApp messages sent at the optimal time, with content tailored to each client profile.

Document automation: automatic generation, validation, and organization of PDFs within the CRM.

Dynamic dashboard graphics: intelligent visualizations showing order progress and service recommendations.

AI chatbot/virtual assistant: 24/7 support guiding clients through purchase workflows and answering FAQs.

Error detection and alerts: automated identification of inconsistencies in orders or documents, with instant notifications.

==Freelancer Requirements==
Must be based in India.

Proven portfolio of similar projects.

Experience with payment integrations and workflow automation.

Knowledge of SEO and performance optimization.

Experience in dashboards, secure databases, and CRM connections.

Strong understanding of data security and document storage best practices.

Experience implementing AI-driven features in websites.

Ability to deliver in clear phases with defined deliverables.

Strong communication and availability for periodic reviews.

==Payment Terms==
Project divided into 3 phases with flat fee pricing per phase.

Freelancer must provide separate quotes for each phase.

Project Overview
Jamibadi is a property aggregator platform designed to simplify and streamline real estate management. The platform enables property owners, builders, brokers, and agents to manage and showcase properties while allowing users to search and enquire about available listings.
Project Scope 1. Admin Module
• Dashboard
• User Profile Management
• Property Listing Management
• Enquiry Management
• Reviews & Ratings Management • Reports & Analytics
2. Sub-Admin Module
• Limited administrative access
• User and property management support • Day-to-day operational management
3. Builder / Property Owner Module
• Account Registration
• Profile Management
• Property Listing Management • Lead & Enquiry Management
4. Agent / Broker Module
• Account Registration
• Property Management • Lead Tracking
• Enquiry Management
1
5. Frontend User Module Home Page
• Banner Section
• Property Highlights
• Testimonials
• News & Updates
• Call-to-Action Sections
Property Section
• Property Listings
• Advanced Search & Filters • Property Detail Pages
• Image & Video Gallery
Additional Pages
• About Us
• How It Works
• FAQs
• Terms & Conditions • Privacy Policy
• Refund Policy
• Listing Guidelines
Additional Features Analytics & Tracking
• Google Analytics Integration • Visitor Tracking
• Page View Monitoring
• Performance Tracking
Responsive Design
• Mobile-Friendly Design • Tablet Compatibility
• Desktop Compatibility


Technology Stack
• HTML5
• CSS3
• JavaScript
• Advanced PHP
• jQuery Ajax
• MySQL Database

Skills: PHP, JavaScript, Website Design, Graphic Design, MySQL, HTML5, HTML, Web Development, CSS3, jQuery

We Need to hosting Moodle Setup with AWS also setup a theme for our LMS and Customize our Logo and Branding Design. Also setup Some Demo Courses and Learning Materials also Need to Some Reports
How many users are access our LMS
How Many users are completed the Course.
Download Certificate

Looking for an experienced Linux System Administrator / DevOps Engineer to properly configure and harden a freshly provisioned, high-performance offshore VPS (FlokiNET) running Linux.
The server will eventually host a Kernel Video Sharing (KVS) CMS deployment. Your immediate task is to secure the OS, configure user privileges, and set up a highly optimised Nginx reverse proxy architecture sitting behind Cloudflare.

Scope of Work:
1. Server Hardening & Security:
Configure firewall rules (UFW/NFTables) to only accept incoming web traffic directly from Cloudflare’s IP ranges.
Secure SSH: Change default port, disable root login, and enforce key based/secured login parameters for our custom administrative user (⁠jerkadmin⁠).
Install and configure Fail2Ban.

2. Nginx Reverse Proxy & Environment Setup:
Install and optimise Nginx for media-heavy/streaming traffic parameters.
Configure Nginx server blocks to perfectly map ⁠jerkpod.com⁠ and ⁠[www.jerkpod.com](https://www.jerkpod.com)⁠.
Set up full SSL termination utilizing Cloudflare’s Origin Certificates (Strict Mode).

3. Prerequisite Stack Prep:
Prepare system packages, dependencies and basic optimization needed for a future PHP/MySQL-based media CMS deployment.

Requirements:
Proven track record with Ubuntu/Debian serveer administration and advanced Ngnx optimisation.
Deep understanding of Cloudflare proxy networking, WAF settings, and Origin SSL certificate integration.
Excellent communication and adherence to clean documentation practices.
Experience setting up environments for heavy video streaming/CMS platforms is a major plus.

I need a clean, reliable bridge between my mobile application and Tally so that product, party and invoice data stay perfectly in sync. The integration has to work both ways: my app must be able to push freshly-created records into Tally, and it must be able to pull any updates or new entries back out again for real-time use.

The focus is strictly on those three datasets—products, parties and invoices—nothing else for now. I am open to whichever technical route you find most stable, whether it involves TallyPrime’s XML interface, TDL customisations, ODBC, a lightweight REST layer or a hybrid of these. What matters to me is that calls from the app return the expected JSON quickly and that writes land in Tally without manual intervention.

Acceptance criteria
• End-to-end demo showing bi-directional sync of one product, one party and one invoice.
• Clear setup notes so I can reproduce the connection on another machine.
• Source code or scripts documented well enough for my internal team to maintain.

If you have proven experience integrating Tally with mobile stacks, I’d like to see an example build or brief walkthrough of how you handled authentication and error handling.

Skills: PHP, XML, Mobile App Development, Android, MySQL, JSON, API Integration, REST API

We are seeking a skilled Laravel developer to enhance our web application. The ideal candidate will have experience in building scalable and efficient web solutions using Laravel. Responsibilities include developing new features, optimizing performance, and ensuring code quality. Familiarity with MySQL and PHP is essential. If you have a passion for delivering high-quality web applications, we would love to hear from you.

I’m setting up a series of REST services built on Java 17 with Spring Boot and need an experienced backend developer to take ownership of both new features and ongoing maintenance. The core of the work is writing clean, test-covered code that exposes reliable, versioned endpoints, backed by a MySQL data store accessed through JDBC and, where appropriate, JPA/Hibernate. All modules sit in a microservice architecture and are managed through Git, so solid branching and pull-request discipline is essential.

While the focus is the backend, it will help if you can speak the same language as our UI team; they primarily work in React and Angular with plenty of vanilla JavaScript, HTML, CSS, Bootstrap—and the occasional PHP snippet for legacy views—so being able to align contract-first API design with frontend needs is a big plus.

I expect:
• Well-structured Spring Boot projects (Gradle or Maven)
• REST endpoints that follow standard HTTP semantics and return consistent JSON
• Swagger/OpenAPI docs generated automatically and kept in sync
• Unit and integration tests (JUnit, Testcontainers or similar) integrated into CI
• Regular, incremental commits with clear messages and timely pull-request reviews

Deliverables are considered complete when the code merges cleanly into main, the pipeline passes, and the new endpoints are reachable in our staging cluster with documentation available at /swagger-ui.

If you enjoy crafting scalable microservices and can hit agreed timelines without sacrificing code readability, let’s talk.

Skills: PHP, Java, JavaScript, Python, MySQL, Bootstrap, React.js, Backend Development, Frontend Development, Spring Boot

Designed and developed a complete enterprise-grade multi-vendor eCommerce platform with advanced marketplace functionality, customer management, inventory control, CRM integration, AI-powered features, and scalable architecture. The platform supports multiple product types including physical, digital, subscription, and auction-based products while providing secure authentication, role-based access control, and comprehensive analytics dashboards.

Key Features:

Multi-Vendor Marketplace with Vendor Dashboard & KYC Verification
Advanced Product & Inventory Management System
Order Processing, Returns & Refund Management
Multiple Payment Gateway Integrations (Stripe, PayPal, Razorpay, PayU, Cashfree, etc.)
Shipping Integration with Major Logistics Providers
Customer CRM & Loyalty Rewards System
AI-Powered Product Recommendations & Smart Search
Progressive Web App (PWA) Support
REST API Architecture for Mobile Applications
Advanced Analytics & Business Reporting
SEO Optimization & Content Management System
Enterprise-Level Security with 2FA, GDPR Compliance & Activity Monitoring

Technology Stack: Laravel, MySQL, REST API, PWA, AI Integration, Payment Gateway APIs, Shipping APIs, CRM Systems, Advanced Security Architecture.

Project Outcome: Built a scalable, high-performance enterprise eCommerce ecosystem capable of supporting thousands of products, vendors, customers, and transactions while maintaining security, speed, and seamless user experience.

Skills: PHP, Website Design, Software Architecture, eCommerce, MySQL, Laravel, Payment Gateway Integration, REST API

I'm looking for a robust CRM app tailored for others window cleaning businesses. The app should streamline operations and enhance customer interactions.

Essential Functionalities:
- Customer Database Management: Maintain and manage customer profiles.
- Schedule Appointments: Organize and schedule cleaning appointments.
- Invoice Generation: Create and send invoices seamlessly.
- Door Knocking Tracking: Monitor and manage door-to-door sales activities.

Must-Have Integrations:
- Tap to Pay: Enable quick and easy payments.
- QuickBooks: Sync financial data and manage accounts.
- Google Maps & Google Earth: For route planning and job site overviews.
- Stripe: Handle payment processing.
- Google Profile Integration: Access and manage business information.

Ideal Skills & Experience:
- Proven experience in developing CRM applications.
- Strong knowledge of third-party integrations, especially with financial and mapping tools.
- Familiarity with UI/UX design for mobile applications, ensuring ease of use.
- Ability to incorporate AI features, like an AI quoter, for enhanced customer interaction.
- Background in project management to ensure timely delivery within budget.

Looking for a skilled developer who can bring this vision to life!

Skills: PHP, Project Management, Mobile App Development, Software Architecture, CRM, MySQL, Salesforce.com, API Integration, Payment Processing, AI Development

We are looking for an experienced IoT and Full-Stack Developer to design and implement a robust data acquisition and cloud monitoring system. The project involves polling data from multiple Selec MFM383A-C-CE energy meters, routing it through two USR-W630 Wi-Fi/Ethernet/Serial gateways, and securely logging the data into a cloud-hosted database with a web-based dashboard and reporting interface.

Scope of Work
1. Hardware Configuration & Integration
Gateway Setup: Configure 2 units of USR-W630 to ensure stable, continuous network connectivity (ping monitoring).

Meter Linkage: Connect and daisy-chain the Selec MFM383A-C-CE energy meters via Modbus RTU to the USR-W630 gateways.

Data Polling: Fetch high-frequency data from all connected energy meters at a 1-second polling interval.

2. Local Buffering & Cloud Sync (Fail-safe Mechanism)
Local Edge Buffer: Implement a local database/buffer mechanism on the gateway or an intermediate local server to prevent data loss.

Offline Tolerance: If internet connectivity is lost, data must be buffered locally.

Auto-Sync: Once connection is restored, the buffered data must automatically upload and sync with the cloud database without gaps or duplication.

3. Database & Cloud Architecture
Storage Scale: Designed to handle high-frequency (1-second) data logging continuously, scaling up to 3 years of historical data.

Hosting Environment: The system will be hosted on a Linux VPS. You will need to recommend which of the following two environments is required for your stack:

Option 1: 1 vCPU, 4 GB RAM, 50 GB NVMe, 4 TB Bandwidth

Option 2: 2 vCPU, 8 GB RAM, 100 GB NVMe, 8 TB Bandwidth

4. Web Dashboard & User Management
Cloud Web Portal: Build a responsive web application with an Admin panel and standard User roles.

Access Control:

Admin: Full rights to provision users, edit profiles, and reset user passwords.

Users: Restricted to view-only data and dashboard access.

Local Reporting: A webpage accessible on the local network to view real-time reports.

5. Alerts & Notifications
Set up automated email notifications triggered by specific data thresholds or system anomalies (exact logic detailed in an attached Excel sheet).

Project Terms & Deliverables
Open Source & Transparency: All source code must be entirely open and unencrypted.

Handover: Full deployment documentation, repository access, and all system/root passwords must be shared upon project completion.

Hardware documentation: Manuals and specification sheets for the Selec meters and USR-W630 will be provided.

Preferred Skills
Strong experience with industrial IoT protocols (Modbus RTU/TCP, MQTT, RS485).

Hands-on experience configuring serial-to-ethernet gateways (specifically USR IOT devices).

Proficiency in database management optimized for time-series data (e.g., PostgreSQL, InfluxDB, MySQL) handling high write-loads.

Full-stack web development (Node.js, Python/Django, React, or similar) and VPS server deployment (Ubuntu/Linux).

To Apply
Please review the attached manuals and specs. In your proposal, specify:
Your experience with similar Modbus data acquisition projects.
Which VPS hosting option (Option 1 or Option 2) you recommend for this architecture and why.
Your estimated timeline for completion.

Skills: C Programming, Java, Linux, Cloud Computing, Software Architecture, Web Development, Full Stack Development, Database Management

I have a ridesharing website built in Laravel and vue.js, and an app built in Flutter

They need hundreds of fixes, but they are all very small. A few them are large

Budget: CAD$1,500

Must be completed in a month

Skills: PHP, MySQL, HTML, Laravel, Web Development, Backend Development, Frontend Development, Vue.js, Flutter, App Development

We are experiencing strong business growth and are looking for an experienced Technical Lead to take ownership of our technology platform and help modernize our infrastructure.

This is a long-term opportunity for someone who enjoys solving real business problems, improving systems, and building scalable web applications.

Current Environment
Custom PHP platform
100,000+ vehicle listings
Multiple inventory and auction API integrations
Cloudflare
MySQL database
High SEO requirements
Ongoing development and feature requests
Project Goals

We are planning a gradual modernization of our platform and need someone who can lead the technical direction.

Key objectives include:

Review and improve existing architecture
Create a modernization roadmap
Move toward Laravel + React/Next.js
Improve website performance and Core Web Vitals
Implement AWS S3 + CloudFront image infrastructure
Improve caching and scalability
Improve data synchronization and inventory management
Implement technical SEO requirements correctly
Reduce technical debt
Establish development standards and processes
Responsibilities
Take technical ownership of the platform
Review existing codebase and infrastructure
Design system architecture
Lead development efforts
Perform code reviews
Work with external SEO consultants
Coordinate AWS and hosting requirements
Improve website performance and reliability
Recommend and supervise additional developers when needed
Create technical documentation and roadmap
Required Skills
8+ years of software development experience
Strong PHP experience
Strong Laravel experience
React and/or Next.js experience
MySQL database design and optimization
REST API development and integrations
AWS (S3, CloudFront, EC2, RDS)
Git and code review workflows
Performance optimization
Caching strategies
Experience working with large databases and inventory systems
Highly Preferred
Automotive marketplace experience
Classifieds platform experience
E-commerce platform experience
Technical SEO knowledge
Cloudflare experience
Redis
Queue systems
Elasticsearch/OpenSearch
First Engagement

We prefer to start with a paid technical audit.

Deliverables:

Codebase review
Infrastructure review
AWS review
Performance review
Technical SEO review
6-month technical roadmap
Recommendations for future development structure

Successful candidates may transition into a long-term Technical Lead role.

To Apply

Please answer the following:

Describe a large inventory or marketplace platform you have worked on.
Have you led a migration from a legacy system to a modern architecture?
What technology stack would you recommend for our situation and why?
How would you handle vehicle listings that are sold in the source system but still appear on the website?
Describe your AWS experience.
Have you managed other developers? If yes, how many?
Please provide examples of projects similar to marketplaces, automotive platforms, classifieds, or large e-commerce websites.

## Long-Term Opportunity & Team Fit

This is not a one-time enhancement project or short-term contract. We are looking for a developer who is interested in becoming a long-term technical partner and support resource for our growing platform.

Community Nature Station (CNS) is a startup nonprofit cooperative building a unique community platform focused on Nature, Culture, Adventure, Wellness, Tourism, and Outdoor Leadership. We are a small but passionate team working to create a world-class platform that serves thousands of community members and partner organizations.

Technical skills are important, but we place equal value on the following qualities:

* Excellent communication skills
* Responsiveness and timely delivery
* Transparency and accountability
* Ability to work independently and proactively
* Loyalty and commitment to long-term collaboration
* Attention to detail and quality
* Willingness to learn and grow with the platform
* Passion for building innovative products that create real community impact

We are looking for someone who takes ownership, provides honest recommendations, communicates clearly when challenges arise, and enjoys being part of a mission-driven team rather than simply completing isolated tasks.

If you're looking for a long-term opportunity to help shape and evolve a unique platform from the ground up, we'd love to hear from you.

Here is more details about the first round enchantment to deliver the MVP release.

# WordPress Event Management System Enhancement (MEC + Elementor)

**Duration:** 2–3 Weeks

## Project Overview
Community Nature Station (CNS) is seeking an experienced WordPress developer with strong "Event Management Platform" experience to enhance our existing event management system.

This is an enhancement project, not a rebuild. The platform has been operating successfully for over two years and requires UI/UX improvements, booking flow optimization, mobile responsiveness, integrations, and optional AI-powered features.

## Key Responsibilities

### Event Display & Booking Experience
* Improve event page UI/UX and visual consistency
* Optimize RSVP and booking sections
* Enhance booking flow and user experience
* Fix display issues for logged-in and logged-out users
* Improve mobile responsiveness

### Event Creation Experience
* Improve frontend event submission forms
* Simplify organizer workflows
* Improve image upload and form usability
* Add guidance and better field organization
* Optimize mobile event creation experience

### Platform Integrations
* Integrate CNS with Meetup and Facebook Events
* Import external events into CNS
* Export CNS events to external platforms

### System Optimization
* Review plugin settings and configuration
* Improve search and filtering
* Enhance archive and empty-state experiences
* Ensure compatibility between plugins, Elementor, and custom styling

### AI Features (Optional)
* Event description generation
* Event image generation
* Integration with CNS AI Engine APIs

## Required Experience
* Proven experience building or enhancing **Event Management Websites**
* Strong WordPress development experience
* Experience with **Modern Events Calendar (MEC)** (**preferred**)
* Experience with **WP Event Manager** or similar event management plugins
* Elementor and Custom CSS
* Responsive Design and UX/UI improvements
* API Integrations and Automation

## Preferred Experience
* Meetup API integration
* Facebook Events integration
* AI/OpenAI/Gemini integrations
* Membership and community platforms (BuddyBoss, Paid Memberships Pro, etc.)
* Event ticketing, RSVP, and booking systems

## Deliverables
* Enhanced event display experience
* Improved booking and RSVP workflow
* Optimized event creation interface
* Mobile-responsive design
* Meetup/Facebook integrations
* Documentation and recommendations

## To Apply
Please provide:

1. Examples of Event Management websites you have built or customized.
2. Examples using **MEC**, **WP Event Manager**, or similar event plugins.
3. Experience with event booking, RSVP, ticketing, and payment workflows.
4. Experience with API integrations and automation.
5. Estimated timeline and approach for completing this project.

We are looking for a developer who has real-world experience with event management platforms and can help transform an already successful system into a polished, scalable, and user-friendly experience.

We are looking for an experienced Ubuntu/Linux System Administrator to help manage, secure, and optimize our server infrastructure.

Responsibilities:

* Install, configure, and maintain Ubuntu/Linux servers.
* Troubleshoot server, network, and application issues.
* Configure and manage NGINX/Apache web servers.
* Manage MySQL databases and perform backups.
* Monitor server performance, security, and uptime.
* Implement security best practices and system updates.

Required Skills:

* Ubuntu Linux Administration
* NGINX and/or Apache
* MySQL
* Network Administration
* AWS or other cloud platforms
* Strong troubleshooting and communication skills

Please include details of your relevant experience, similar projects completed, and availability.

We are seeking an experienced SQL and MySQL developer to enhance our database systems. The ideal candidate will have a strong understanding of database design and optimization, and be able to implement efficient solutions. Responsibilities include developing and maintaining databases, ensuring data integrity, and optimizing performance. Experience with PHP and JavaScript is a plus.

We have a custom-built appointment tracking system hosted on Railway that our team uses daily. It has several critical bugs that need to be resolved immediately. This is an urgent engagement — we need someone who can move fast, communicate clearly, and ship real fixes.

The system:

-Railway hosted, TypeScript monorepo
-Express + tRPC backend
-MySQL database via Drizzle ORM
-Two separate React 19 frontend apps (admin portal + advisor portal) sharing one backend
-Vite, Tailwind, Zod, React Query

What's broken:

-Status updates not saving or syncing between views
-Data inconsistencies between the two frontend apps
-Reporting counts are off

Hard requirements:

-tRPC — non-negotiable, the entire API layer runs on it
-Drizzle ORM + MySQL — must be able to trace issues at the DB level
-React 19 + React Query — data fetching, caching, and state sync
-TypeScript — strictly typed codebase throughout
-Railway — deployments, env variables, logs
-Claude Code — we use it as our primary dev tool, you need to be actively using it in your workflow

How this works:

-We start with a paid audit. You review the codebase, document root causes, we align — then fixes get shipped. If you're a good fit there's ongoing work available.
-To apply, answer these three questions or your application won't be reviewed:

1. Describe a broken system you were brought in to fix that someone else built. What was wrong, how did you find it, and what did you change? Keep it simple — explain it like the person reading this isn't a developer.

2. If you jumped into our codebase and got stuck on something, walk me through exactly what you'd do next. Be specific.

3. What does your first 48 hours on this project look like?

We are looking for some super star developers specialized in both Custom PHP and Laravel development. The successful candidate will be able to build features quickly in a monolithic architecture, while keeping in mind the roadmap to allow extensibility.

We are a very fast moving startup and speed is king here, we keep things as simple as possible so you will see patterns that move us in this direction, for example we use sever-side rendered blades with light js libraries instead of full blown frontend frameworks like react, we choose monolithic architecture vs microservices, we are more interested in shipping features and moving the project to our goals faster and require the candidate to fit this culture.

Responsibilities
• Build and maintain patient-facing web applications in PHP and Laravel, including landing pages, quiz flows, checkout experiences, and patient dashboards
• Maintain attribution system across multiple services for tracking and conversions
• Rapidly spin up A/B test variants across the conversion funnel to support ongoing experimentation
• Integrate directly with third-party APIs including Stripe, telehealth platforms, and communication tools
• Design and manage database schemas, migrations, and queries in MySQL or PostgreSQL
• Develop admin panels and internal tooling to support operations, fulfillment, and customer service teams
• Collaborate with marketing and product teams to translate growth ideas into working features quickly

Qualifications
• 5+ years of professional experience writing PHP, with solid Core PHP fundamentals
• Strong hands-on Laravel experience or similar framework (Symfony experience is okay)
• Proficiency with MySQL or PostgreSQL, including schema design and query optimization
• Experience building and consuming REST APIs
• Self-directed with strong communication skills. You flag blockers early, ask good questions, and ship without hand-holding

Additional Assets
• Direct Stripe API integration or subscription billing experience
• Experience with A/B testing or experimentation platforms
• Previous experience in a startup or fast-paced scaling environment
• Working with server rendered blade systems instead of full react front-end

Job Type: Contract-to-Hire (2-week paid trial with conversion to full-time)

• How many years have you been coding? Tell me your story, and how you progressed from the beginning to today.
• If you needed to build a quiz funnel with branching logic, how would you approach this?
• Can you work 8am-4:30pm PT (GMT-7) daily? This is our office hours and is a requirement
• Show me (1) PHP application that you built solo (without other devs), that you are proud of.
• Tell me about your coding setup, what do you use for your operating system, what kind of code editor (vscode, neovim, etc), what kind of tools do you use for PHP development?

Full-Stack Developer (Next.js / Prisma / MySQL) — Build a Parts Inventory Feature

We're looking for a skilled full-stack developer to build a new Parts Inventory feature into our existing platform — a SaaS web application for the automotive/garage industry. There's
strong potential for ongoing work beyond this first project if it's a good fit.

About the task

The initial scope is a parts inventory module. Broadly, this means:

- Tracking parts/stock items (name, SKU/part number, quantity on hand, cost & sale price, supplier)
- Adding, editing, and removing inventory items through a clean UI
- Adjusting stock levels (manual adjustments, and ideally linking parts to existing jobs/work orders so stock decrements automatically)
- Low-stock visibility and basic search/filtering

We'll provide a detailed spec and access to the codebase once we've selected a candidate. This first feature is also a way for us to evaluate working together before committing to more.

Our stack

- Frontend: Next.js 14 (App Router) + TypeScript
- Backend: Next.js API routes with Prisma ORM
- Database: MySQL 8
- Infra: Docker

You should be comfortable working within an existing codebase, matching established patterns and conventions rather than reinventing them, and integrating cleanly with what's already
there.

What we're looking for

- Solid experience with Next.js, TypeScript, Prisma (or similar ORMs), and MySQL
- Comfort with Docker-based local development
- A focus on clean, maintainable code and thoughtful integration with existing systems
- Good communication and the ability to collaborate with our team to scope, build, and resolve issues efficiently

On AI tools

We have no problem with candidates using AI assistants (Copilot, Claude, Cursor, etc.) to help write code — we use them ourselves. What matters is that you understand, review, and stand
behind the code you deliver, and that it meets our quality and architectural standards.

To apply

Briefly tell us about a similar feature you've built in a Next.js/Prisma stack, your typical approach to working inside an existing codebase, and your availability. Strong candidates can
expect a steady pipeline of additional work.

• Include a link to your GitHub profile and/or website
• Describe your recent experience with similar projects

I'm looking for an experienced full-stack developer to build a complete e-commerce web app from an Adobe XD design I already have.

The design is mobile-first, so you'll need to adapt it to desktop and tablet layouts as well — not just copy it.

---

What I need built:

• Two main pages to start: a Home page and a logged-in User Dashboard — both pixel-perfect to the XD design
• Full authentication: sign-up, login, logout, and protected routes (bcrypt passwords + JWT or NextAuth)
• A working database (PostgreSQL, MySQL, or MongoDB — your call based on what fits best with Next.js)
• E-commerce features: product listings, cart, checkout — everything shown in the design
• Razorpay integrated for payments
• Shiprocket integrated for shipping
• Clean, reusable components and styles (I'm planning a mobile app build right after this, so structure matters)

---

Tech stack:
• Frontend: Next.js (latest)
• Backend: Node.js (API routes or separate server)
• Database: PostgreSQL / MySQL / MongoDB
• Payments: Razorpay
• Shipping: Shiprocket
• Deployment: Vercel (or similar)

---

Deliverables:
✅ Full source code in a public GitHub repo
✅ README with setup instructions (should take under 5 minutes to get running)
✅ Deployed and live on Vercel or equivalent
✅ Lighthouse desktop score of 90+ for performance and accessibility
✅ Builds clean with: yarn install && yarn build

---

Nice to know:
• I'm available for quick feedback during the build
• A mobile version is planned right after, so well-structured, reusable code will lead to more work
• All secrets/API keys must go in environment variables — no hardcoding

If you've built Next.js e-commerce apps with payment and shipping integrations before, I'd love to see examples. Please share your relevant work and estimated timeline when you apply.

• Describe your recent experience with Website Design and API integration
• Include a link to your GitHub profile and/or website
• Describe your recent experience with similar projects

# Implement Probabilistic Attribution Between Marketing Website and Electron Desktop App

We have a marketing website where users can click to download our Mac desktop app. The app is distributed as a standard Mac DMG and built with Electron. We use PostHog for product analytics, and we also run Google Ads. Users may eventually sign in inside the desktop app through ChatGPT/auth, but many users will first be anonymous.

We want to implement a simple first version of attribution that helps us understand which website visitors / ad campaigns / download clicks later become desktop app users.

## Goal

Build a lightweight probabilistic matching system that connects:

1. A user visiting the marketing website
2. The same user clicking “Download” for the Mac DMG
3. The desktop app being opened for the first time
4. The user later signing in, when applicable

The goal is not perfect identity matching. The goal is good-enough attribution for our current low-volume flow, roughly around 100 download clicks per week.

## What needs to be figured out

The developer should determine the best simple implementation for:

- Capturing enough information on the marketing website when someone clicks the Mac download button
- Capturing enough information from the Electron app on first open
- Matching those two events probabilistically on the backend
- Passing useful attribution information into PostHog events
- Associating the attribution with the authenticated user once the user signs in
- Testing that the full flow works end-to-end

The likely matching signals are things like timestamp proximity, hashed IP, platform, timezone, language/locale, and other non-invasive browser/app context. The implementation should avoid overcomplicated or privacy-invasive fingerprinting.

## What we should do

Implement a simple backend-backed attribution flow:

- When someone clicks “Download for Mac” on the website, create a download-attribution record.
- Capture campaign data such as UTMs, Google Ads click ID if present, landing page, referrer, and PostHog anonymous/browser ID where available.
- When the Electron app first opens, create or retrieve a persistent app install ID.
- Send a first-open event from the app to the backend.
- Backend attempts to match that first app open to a recent download click.
- Store the match with a confidence level such as high/medium/low/unmatched.
- Send attribution metadata as properties on relevant PostHog events.
- Once the user signs in, connect the app install and attribution record to the authenticated user ID.

## What we should not do in this version

We do not want to overbuild this.

Do not:

- Generate a unique DMG per user
- Modify the signed Mac app bundle
- Inject tokens into the installer
- Implement custom deep links yet
- Build a full deterministic attribution system
- Use probabilistic matching to permanently merge PostHog user identities
- Send raw IP addresses to PostHog
- Add invasive browser fingerprinting

Probabilistic attribution should be treated as estimated attribution, not as guaranteed user identity.

## Expected deliverables

The task is complete when:

- The website download flow records download intent and campaign metadata.
- The Electron app records first-open/install metadata.
- The backend can probabilistically match app first opens to recent website download clicks.
- PostHog receives app events with attribution properties when a match exists.
- The system links the app install to the authenticated user after sign-in.
- There is a way to inspect/debug attribution matches.
- The implementation is tested locally or in staging with realistic flows:
- normal download → immediate app open
- delayed app open
- no matching download
- multiple download clicks from the same network
- user signs in after opening the app

## Important constraint

This is a first version. We prefer a simple and maintainable solution that gives us useful attribution data over a complex solution that tries to be perfectly accurate.

Project Vision

The objective is to create a centralized platform where student records are maintained from school level through higher education, employment, and career growth. The system should help eliminate fake certificates, duplicate profiles, and fraudulent employment records by maintaining a verified digital career history.

Required Modules
1. Student Management System
Student Registration
Admissions Management
Attendance Tracking
Fee Management
Exam & Result Management
Certificates & Documents
Parent Portal
Faculty Portal
Student Portal
2. School / College Management
Institution Registration
Staff Management
Academic Management
Attendance Reports
Fee Collection
Timetable Management
Analytics Dashboard
3. Academic Lifecycle Repository
School Records (Class-wise history)
Intermediate / Diploma Records
Degree / Engineering Records
Academic Certificates
Digital Document Vault
4. Career Profile System
Resume Builder
Skills Management
Projects & Certifications
Internship Records
Career Timeline
5. Job Portal
Candidate Registration
Job Search & Applications
Employer Dashboard
Job Posting Management
Interview Scheduling
Offer Letter Management
AI-Based Candidate Matching
6. Background Verification (BGV)
Education Verification
Employment Verification
Identity Verification
Document Verification
Verification Reports
Fraud Detection
7. HRMS & Payroll
Employee Database
Attendance & Leave Management
Shift Management
Payroll Processing
Payslips
PF, ESI, PT, TDS Management
Performance Management
8. Unique Student ID System

Every student should have a permanent unique ID that follows them from education to employment.

The system should maintain:

Academic History
Employment History
Verification History
Career Progression
9. User Roles
Super Admin
State Admin
District Admin
Institution Admin
School Admin
College Admin
University Admin
HR/Admin
BGV Executive
Faculty
Student
Parent
Technical Requirements

Preferred Technology Stack:

Frontend: React.js / Next.js
Backend: Node.js / .NET / Java
Database: PostgreSQL / MongoDB
Cloud: AWS / Azure
Mobile App Support (Future Phase)
API-Based Architecture
Role-Based Access Control (RBAC)
Secure Authentication & Authorization
Scalable Multi-Tenant Architecture
Deliverables
UI/UX Design
System Architecture
Database Design
Web Application Development
Admin Dashboard
API Documentation
Source Code
Deployment Support

Skills: PHP, Website Design, Project Management, MySQL, HTML, Node.js, Software Development, React.js, Web Development, Database Management

We are looking for an experienced sports data / odds feed engineer or consultant who has worked with sports betting data systems, odds feeds, fixture mapping, market lifecycle, results processing, and settlement workflows.

This is not a content, affiliate, or marketing role. We are looking for someone with real backend/data experience in sports odds or iGaming data infrastructure.

Initial scope:
- Review our target architecture for a sports odds feed and settlement workflow
- Advise on fixture/event mapping, market mapping, odds updates, result handling, and settlement logic
- Explain practical options for using third-party odds feeds vs building internal feed-processing infrastructure
- Help define an MVP technical specification for a reliable B2B sports data service
- Identify risks around duplicate updates, out-of-order messages, suspended markets, cancelled events, re-settlement, and rollback handling

Ideal experience:
- Built or integrated sports odds feeds, sportsbook data APIs, or iGaming backend systems
- Experience with live and prematch odds data
- Understanding of fixtures, leagues, teams, markets, selections, odds movement, market status, results, settlement, and correction flows
- Backend experience with Node.js, TypeScript, Java, Go, Python, or similar
- Experience with WebSocket/API integrations, message queues, Redis, PostgreSQL/MySQL, RabbitMQ/Kafka, or similar
- Familiarity with providers such as LSports, Sportradar/Betradar, Genius Sports/BetGenius, FeedConstruct, BetConstruct, or similar is a plus
- Experience with smaller/regional sports data providers is also highly valuable

First milestone:
We want to start with a paid consultation and technical discovery. Please describe, without violating any NDA, one sports odds/data/settlement system you have worked on and what your role was.

Please answer these questions in your proposal:
1. Have you personally worked on odds feed, sports data API, or settlement logic? What exactly did you build?
2. Which sports data providers or sportsbook platforms have you integrated with?
3. How would you handle duplicate odds updates, delayed updates, and out-of-order messages?
4. How should a system handle settlement corrections or cancelled matches?
5. What would you recommend for an MVP architecture for a small B2B sports data feed service?

We are seeking a full stack developer to enhance our mobile app. The ideal candidate will be comfortable with vibe coding, have experience with Google Cloud, and be skilled in app bug fixing. Responsibilities include improving app performance, resolving bugs, and ensuring seamless deployment on Google Cloud. The role requires a proactive approach to problem-solving and collaboration with our team to deliver high-quality results.

• What apps have you vibe coded with?
• Explain your AI vibe code strategy? For development and cost efficiency.
• Describe your recent experience with similar projects
• What frameworks have you worked with?
• Describe your approach to testing and improving QA