MySQL DBA Projects

opportunity

PHP 5.5 MySql upgrade and server transferr

I have 3 websites currently on an outdated server written in PHP 5.5 and My Sql. I have a new server that they need transfering to and then perform code update to the newest form of PHP and malware removal replacement. thesites are www.oilopps.com, singitjobs.com, ibanktalent.com

Backup website and migrate to Joomla 5

We need someone who will migrate our website from Joomla 4.4.x to 5.x: https://unternehmerzentrum.li/ We're looking for someone who has previous experience with Joomla and feels confident doing this task. Joomla instructions: https://docs.joomla.org/Joomla_4.4.x_to_5.x_Planning_and_Upgrade_Step_by_Step Hosting information needed for upgrade: - PHP 8.1 - MySQL 8.0.13 - MariaDB 10.4.x (testing has shown that J3, J4, and J5, are compatible with MariaDB 10.4.x) - PostgreSQL 12.0 (if you are using PostgreSQL 16 you will need to make a manual change before proceeding.) Acceptance criteria: - Back up of the current website (Joomla 4) has been created and is available to revert to if needed - Hosting environment is prepared correctly - The current website has been migrated to Joomla 5 and runs smoothly with no broken components Let me know if you need any more details.

“Build a Creator Support Website with Tipping & Live Streaming

I need a skilled web developer to create a platform where creators can: Have personal profiles Accept tips/donations from fans Offer subscriptions or membership tiers Host live streaming sessions (safe, educational, or creative content) The platform should be user-friendly, responsive, and secure. Experience with PHP, MySQL, HTML/CSS, and live video integration is preferred. Please provide examples of previous web development projects.

Server Compromise (cPanel Hosting Account Malware Cleanup)

cPanel Hosting Account Malware Cleanup + WordPress Rebuild (Confirmed Server Compromise) We are looking for a senior WordPress & Linux hosting security expert to perform a complete forensic cleanup and rebuild of a compromised cPanel hosting account. This is NOT a simple WordPress malware cleanup. The entire hosting account has been compromised. A detailed forensic report has already been completed. The compromise includes: • Multiple PHP backdoors • File-write RCE webshell • Malicious .htaccess hijack • Traffic redirect malware • Shadow WordPress installations (/fresh and /pixoll directories) • Modified wp-config.php • 72,000+ injected spam users in database • Suspicious FTP account with full home directory access • Locked malicious files (0444 permissions) • Ongoing file modifications as recent as March 2026 Hosting environment: cPanel (Namecheap shared hosting) Multiple MySQL databases Shared IP environment Scope of Work Required The expert must: Perform full account-level cleanup (not just WordPress) Remove all malware and backdoors Remove shadow WordPress installations Delete suspicious FTP accounts Rotate all credentials (cPanel, FTP, MySQL, WP) Replace WordPress core with clean installation Clean infected database (remove 72k spam users safely) Verify no remaining persistence mechanisms Audit .htaccess and server configs Ensure site is safe to submit for Google reconsideration If required, we are open to: Full cPanel account reset and rebuild Migration to a fresh hosting environment Important You must have: Proven experience with advanced WordPress malware removal Experience handling RCE webshell infections Experience with cPanel server-level audits Ability to work via SSH if needed Ability to provide a detailed post-cleanup report This is NOT a beginner job. Do not apply if you only use plugins to “scan and delete”. Deliverables Clean hosting account Clean WordPress installation Clean database No shadow installations Security hardening implemented Final written security report Confirmation of no reinfection vectors When Applying Please include: Description of similar infections you have cleaned Your proposed approach (brief step outline) Estimated timeline Whether you recommend full account rebuild

I need a experienced developer for a technical round for 20 min

Hi, I need a experienced developer in PHP/MySQL magento, prestashop, wordpress etc, to attend a online technical round with me, it will be via phone, some questions will be asked and you will help me in answering them. For those twenty minutes you will be part of my team and I will introduce you similarly. Regards, Raj

PHP & MySQL Website Optimization and Bug Fixing Project

This project involves analyzing, troubleshooting, and improving an existing dynamic website built with PHP and MySQL. The primary objective is to identify and fix coding errors, optimize database queries, and enhance overall website functionality and performance. Tasks include debugging PHP scripts, resolving connection and query issues, improving user interface responsiveness, and ensuring secure and efficient interaction with the MySQL database. The project also focuses on implementing best practices in web development, such as proper error handling, input validation, and optimized backend logic, resulting in a stable, reliable, and user-friendly website.

Make the code work

We are seeking a skilled developer with expertise in both front-end and back-end technologies to seamlessly integrate and optimize our web and app functionalities. The ideal candidate should be proficient in PHP (Laravel) or Node.js for backend development, and React, Vue.js, or clean Blade templates for mobile-responsive frontend design. A strong understanding of MySQL is essential. Your role will involve taking provided code and SQL updates, ensuring proper implementation while maintaining a well-organized file and folder structure. Availability for at least five hours daily is required to facilitate smooth collaboration during the development process.

JQuery toggle to display specific records in a database table

I have a register of members displayed as a simple jQuery table on a website which pulls from a MySQL table. I would like a series of toggles displayed above the table which, when pressed will update the table to display certain records. The database records are all specified by an unique id number. As a result, I would like it so when an user toggles 'x', the table will automatically update just to display, for example, records that have the id number of 5 and 22. After the work is complete, I need to be able to change the id numbers that each toggle displays.

Full Stack Laravel + React Developer (AI Tools Experience)

Project Summary: We have an existing sustainability tracking platform (materials, emissions, transport data etc). We need a developer to continue development, extend features, and maintain the platform. Required Skills: PHP Laravel (mandatory) React (mandatory) MySQL (mandatory) AWS deployment experience Git workflow Experience using AI-assisted development tools (Replit AI + OpenAI Codex/GPT) Nice to Have: Experience with carbon emissions or supply-chain data Dashboard development REST API experience Expectation: Work on backend APIs, React UI, MySQL data models, and AWS deployment. Must be able to work independently and use AI tools for faster development. Please share: :heavy_check_mark: Portfolio or GitHub :heavy_check_mark: Relevant Laravel/React work :heavy_check_mark: Availability + hourly rate

opportunity

Custom Website Development for software house

Custom software & web development website design and development required, a fully custom design, high-performance, SEO Optimized website built from scratch using modern technologies (No WordPress or templates). Please provide examples of similar custom build websites you have built as references. Required Pages: (NOT FULL Description - Will discuss) • About Us • Services (Multiple service pages) • Solutions (Multiple solution pages) • Technologies (Multiple solution pages) • Portfolio / Projects (Multiple Project profiles) • Careers • Blog • Live Chat • Social Media Integrations • FAQ • Contact Us & more Preferred Tech Stack: • Frontend: React, Next.js, Angular, HTML5, CSS3, Tailwind, Material UI (mobile-first, responsive, SEO Optimized) • Backend: Node.js, PHP, Python, .NET, or Ruby with secure REST APIs ( Or similar, modern) • Databases: MySQL, MongoDB, DynamoDB, Redis, Redshift, OpenSearch • AI/ML (Preferred): TensorFlow, PyTorch, LangChain, OpenAI integrations I will share some reference websites

opportunity

Small MYSQL React system

i need a basic programme i can host in AWS which has MYSQL backend and a React front end. it will be basic spreadsheet of unique identifier, the coursename/names, and the candidate name. a box to confirm attendance and then a box to publish a PDF certificate with the Unique identifier, name, company logo and naming, course names and a static piece of writing. the Docuemnt will be downloadable in batch or alone as needed. Not required here but maybe an option as part of this is for the candidate to register to the course themselves and so would populate the register, and then an office user i.e Trainer able to go in and update they have attended and screen shot any paperwork so it stores with the user info for that course or courses. or we add to the register and the candidate gets a link to confirm and gets attendance email with location and times and dates for which courses.

opportunity

AI-Powered Price Scraper & Monitoring System (Multi-Website)

We are looking for an experienced developer to build a scalable AI-powered price scraping and monitoring system. The system should automatically extract product pricing data from multiple e-commerce websites and store it in a structured database for monitoring and analysis. The system must support multi-tenant architecture, role-based permissions, subscription tiers, and Stripe payment integration. The goal is to allow different companies to monitor product prices across multiple websites, with usage limits based on subscription plans. Project Scope 1. Target Websites • Scrape product prices from 7–10 e-commerce websites • Support dynamic content (JavaScript-rendered pages) • Proxy rotation & anti-bot handling • Scheduled scraping • Historical price tracking • Price change alerts (email or webhook) • Handle pagination and product variations 2. Multi-Tenant Architecture • Super Admin role • Manage all companies • Manage subscription plans • View system-wide usage • Suspend / activate companies 2. Data Extraction • Extract product name • Current price • Original price (if available) • SKU / Product ID • Availability status • Timestamp 3.1 Company Admin role • Manage company users • Set scraping targets (websites & products) • View company usage stats 3.2 Company Users • View price tracking dashboard • Access only assigned websites/products 3.3 Subscription & Usage Limits System must support different plan levels: Each plan should control: • Maximum number of websites • Maximum number of products • Scraping frequency (e.g., 1h / 3h / 6h / 24h) • Maximum concurrent scraping jobs • Historical data retention length Stripe Integration • Stripe subscription integration • Monthly / Yearly billing (7 days free trial) • Webhook handling for subscription status updates • Automatic feature unlock based on plan • Auto suspend account if payment fails • Admin ability to manually upgrade/downgrade plan 4. AI-Assisted Selector Detection • Use AI or intelligent selector logic to detect price elements • System should adapt if minor DOM changes occur • Minimize manual reconfiguration 5. Infrastructure • Proxy rotation support • Anti-bot handling • Headless browser support (e.g., Puppeteer / Playwright) • Scalable deployment (Docker preferred) 6. Database & Storage • Store data in MySQL • Historical price tracking • Ability to compare price changes 7. Monitoring & Automation • Scheduled scraping (e.g., every 1–6 hours) • Email or webhook alerts when price changes • Logging and error reporting 8. Dashboard • Admin and users dashboard • Search by product • View historical price chart Technical Requirements Preferred stack: • Laravel • Playwright / Puppeteer / Scrapy • REST API architecture • Docker deployment Deliverables • Fully working scraping system • Deployment guide • Source code • Documentation • 2 weeks post-delivery support Bonus Experience with anti-bot bypass, rotating residential proxies, and large-scale scraping is highly preferred. If interested, please include your portfolio and examples of similar scraping projects.

Application Support – Healthcare & Research Systems

We are looking for a Freelance Application Support Engineer (4–5 years experience) to support a medical research institute, providing technical analysis, server support, and application troubleshooting across research and healthcare systems. Time Commitment ⏱ 2–2.5 hours per day | Monday–Friday (No weekends) Key Responsibilities Support 20+ vendor-hosted and in-house clinical/research applications Troubleshoot Azure cloud & on-prem servers (Windows/Linux) Develop and support SQL/MySQL reports Handle user tickets via email, Teams, and phone Coordinate with vendors for upgrades and issue resolution Manage user access, SSL renewals, and security protocols Support applications like REDCap, OnCore, Streamlyne, DocuSign Collaborate with IT, researchers, and clinical stakeholders Must-Have Skills 4–5 years of application/technical support experience Strong SQL & MySQL skills Windows & Linux server administration Report writing and data analysis experience Familiarity with REDCap Healthcare or health-adjacent domain experience Strong communication and customer-facing skills Nice to Have Databricks, Azure/AWS/Snowflake Analytics tools: SAS, SPSS, R, Python Experience with OnCore, Streamlyne, Oracle Health (Cerner) Engagement Type

opportunity

Starling Bank Payment Integration in Payroll App

Good — here is the revised **Starling integration fixed-price spec**, tightened and now explicitly referencing: * Your defined internal interfaces / APIs * GitHub workflow * Your stack and architecture constraints You can repost this exactly. --- # Fixed Price Project – Starling Bank Business API Integration (PHP) ## ⚠️ Fixed Price Only This is a clearly scoped integration project. Provide: * Total fixed price * Delivery timeline (weeks) * Milestone breakdown No hourly proposals. --- # Project Overview We operate a UK CIS payroll platform (PayCIS) built in: * PHP 8+ * MySQL (relational, indexed) * Object-Oriented architecture * MVC-style request framework * Strict naming conventions * TLS-only environment * Subdomain-based routing * Role-based permissions The system already: * Calculates subcontractor net payments (CIS + VAT handled) * Stores validated bank details * Generates structured bulk payment lists * Manages payment lifecycle: * For Approval * To Be Paid * Paid * Maintains full audit logging * Uses defined internal service classes for payments We now require **direct integration with Starling Bank Business API**. --- # Important Architecture Note We already have: * A cleanly defined internal payment interface * Clear service-layer APIs for retrieving payable batches * Structured payment models * Consistent database schema The integration must plug into our existing payment service layer — **not bypass it or rewrite core logic.** This is an API integration project, not a system redesign. --- # Scope of Work ## 1️⃣ Starling API Client Build a reusable, clean OOP Starling client: * OAuth authentication * Secure token storage * Automatic refresh handling * Sandbox + live configuration * No hardcoded credentials * Environment-driven config Deliverable: * `starling_api.class.php` (or equivalent clean service class) * Fully documented --- ## 2️⃣ Bulk Payment Submission Using our existing internal API: * Fetch payments marked “To Be Paid” * Submit via Starling Faster Payments API * Use idempotency keys * One batch or controlled sequential processing Each payment includes: * Recipient name * Account number * Sort code * Amount (2 decimal precision) * Unique internal reference Deliverable: * Method to send payment batch * Clean separation between: * Data retrieval * API payload generation * Submission logic --- ## 3️⃣ Payment Status Handling System must: Store per-payment: * Starling transaction ID * Status (pending / completed / failed) * Failure reason * Timestamp Update internal status accordingly. Database changes allowed if necessary, but must follow our schema conventions. --- ## 4️⃣ Webhook Handling (If Supported) * Implement secure webhook endpoint * Signature verification * Map webhook status → internal payment state * Log raw webhook payload Deliverable: * Controller endpoint * Webhook log table * Replay-safe handling --- ## 5️⃣ Minimal Admin UI Additions Add to existing admin interface: * “Send to Starling” action * Starling reference display * Live payment status display * Error feedback No UI redesign required. --- ## 6️⃣ Logging Requirements Create structured logs for: * API requests * API responses * Webhooks * Failures * Initiating user Logs must include: * Payload * Response * Timestamp * Account ID * User ID Must follow existing audit log conventions. --- # Development Standards You must adhere to: * OOP principles * DRY * No deprecated PHP * No inline SQL * Clean separation of concerns * Strict naming conventions * Existing schema standards All code must: * Be production ready * Include basic inline documentation * Pass linting * Follow consistent formatting --- # GitHub Requirement All development must be: * Submitted via GitHub * Branch-based workflow * Pull request for review * No direct server edits * No ZIP file delivery Commit history must be clean and logical. --- # Security Requirements * TLS only * Encrypted token storage * Idempotency protection * No double-pay risk * Strict input validation * No credentials in frontend * Webhook verification mandatory --- # Out of Scope * Multi-bank support * Open Banking aggregation * Refund flows * International payments * Credit card processing * Accounting integrations Starling Business API only. --- # Deliverables * Working Starling sandbox integration * Production-ready live configuration * Updated schema script (if required) * Clean Starling API service class * Webhook controller * Updated admin UI integration * Deployment instructions * GitHub PR submission Proposal Must Include 1. Fixed total price 2. Timeline (weeks) 3. Confirmation of: Starling API experience OAuth implementation Webhook handling Fintech or banking integrations Examples of similar API integrations UPDATE: Starling developer hub access is in place, and the sandbox set up. Our site is www.paycis.co.uk

PHP Developer – Booking Form & Google Maps Fare Calculator

I have a live local rideshare website built with PHP, JavaScript, and MySQL. This is a Phase 1 solo-driver MVP, not an Uber clone and not a rebuild. The site already exists. I need a developer to clean up, stabilize, and finish core logic inside the current codebase. This project is rule-driven, not feature-heavy. Scope of Work (Phase 1) 1) Ride Request Form Cleanup & Validation Clean existing form UI (no redesign) Required field validation (pickup, dropoff, date, time, name, phone, passengers) Google Places Autocomplete for pickup & dropoff Block submission unless a Places-suggested address is selected Create ride request with status Pending Confirmation page with Request ID 2) Fare Estimate Calculator (Google Maps) Use Google Directions API to calculate distance (miles) Apply pricing rules: Base fee Minimum fare Per-mile tiers Show estimated fare before submission Store distance + quoted fare in database 3) Ride Limits & Overbooking Protection Enforce: Operating hours Minimum lead time Max advance booking Daily ride cap One ride per time slot Approved rides lock the time slot 4) Admin Review & Approval Page Secure admin dashboard View requests (filter by date/status) Approve / Decline / Cancel / Complete rides Full lifecycle managed via admin UI 5) Driver Profile Page (Mobile-Friendly) Driver photo (optional) Name, vehicle info, plate number Rides completed Member since Rating (manual for now) 6) Final Polish Pricing page cleanup Airport service page cleanup + checkbox logic Clear “Request a Ride” CTAs What This Project Is NOT ❌ No framework migration ❌ No Laravel rebuild ❌ No React/Vue frontend ❌ No payments / Stripe ❌ No live GPS tracking ❌ No AI / SaaS features This is a simple, deterministic MVP. Tech Stack PHP JavaScript (vanilla or light jQuery) MySQL Google Maps / Places / Directions API Responsive HTML/CSS Budget & Milestones Total Phase 1 Budget: $280 (fixed) Milestones: Milestone 1A: Form validation + address enforcement — $40 Milestone 1B: Fare calculator + request creation — $40 Milestone 2: Ride limits + admin approval flow — $120 Milestone 3: Driver profile + page polish — $80 How to Apply (Required) Please answer all of the following: Have you worked with Google Maps Places/Directions API before? (Yes/No + brief example) Are you comfortable working inside an existing PHP codebase without rebuilding it? Confirm you understand this is a solo-driver MVP, not an Uber-style system Confirm you agree to the milestones and fixed $280 budget Proposals that do not answer these questions will be ignored. Preferred Developer PHP/MySQL focused Experience with booking or scheduling systems Comfortable following strict rules and acceptance criteria Communicates clearly and delivers incrementally

Laravel Developer Needed Ongoing Support

We have an existing Laravel + MySQL web application that provides access to a paid relationship assessment. The system is already built and live. It is hosted on Hostinger and access is integrated into our website which is Wordpress. The original developer is no longer available and cannot help with Knowledge Transfer. The original cost for development of the entire application was $400 We are not looking for a rebuild, but for a developer who can: Take over support and change requests Understand an existing codebase without hand-holding Make small, well-scoped enhancements The application: Built in Laravel Uses MySQL Hosted on Hostinger Integrated with Kajabi (purchase triggers account creation) Sends automated emails (reminders + assessment report) using Zoho Front-end website is WordPress (no WordPress dev required) Immediate task The first paid task that I am looking for quotes for is simply: Review the existing Laravel codebase Understand how Kajabi purchases trigger account creation Understand the email logic and assessment flow Confirm how a second product type can be added This initial task should result in: A short written summary of how the system works, how it's built, structured, technology being used, how the parts integrate A clear estimate for implementing the next change Upcoming change request We want to add a second product on our website Same assessment Includes 60 minutes of coaching Different email sequence and texts after purchase Different text in generated assessment report Account flagged as “Assessment + Coaching” Required skills Strong experience with Laravel MySQL Experience working with existing/legacy code Comfortable with webhook-based integrations (Kajabi or similar) Clear written communication in English Ability to explain technical concepts to non-technical clients Nice to have Experience with Kajabi Email automation / transactional email experience WordPress familiarity (not essential) I need your best fixed price quote for the first piece of work (taking over the codebase and writing up a report of how it works) along with giving a quote for the change request itself (which I expect once the code is understood, should be a matter of 3-4 hours of work but that is for you to validate).

opportunity

Skilled WordPress Developer – Immediate Start (Long Term)

We’re a well-established tech company with a close-knit, supportive culture, and we’re looking for a talented and reliable WordPress Developer to jump in immediately for an important upgrade project. In the past, we’ve lost valuable time waiting for developers who couldn’t start right away or didn’t have the right technical depth. So, to be upfront, this opportunity is for someone who’s genuinely ready to hit the ground running and confident in their skills. The Role You’ll take ownership of key upgrades to our WordPress platform, focusing on efficiency, clean code, and clear communication throughout the process. 3 Core Parts to this Task - API Integration: Connect our WordPress platform with a government database API to automatically populate client registration details, helping reduce manual data entry. - Ad Placement: Implement dynamic ad placements within search results that mimic the look and feel of Google Ads-style listings. - Listing Enhancements: Develop a “Bump Listing” feature allowing users to move their posts back to the top of search results. What We’re Looking For - Proven, hands-on experience with WordPress, PHP, and MySQL. - Strong background in API integrations and custom theme/plugin development. - A clear understanding of performance optimization, security, and best coding practices. - A proactive communicator with great attention to detail and a sense of ownership. Key Details Start Date: Immediate - please only apply if you’re ready to begin right away. Engagement: Initial contract with strong potential for long-term collaboration. To confirm you’ve read everything, please include the code NICD2601 in your application. The maximum budget for this is £200 - Do NOT apply if your are over this budget. We value working with people who care about doing things the right way, dependable professionals who take pride in their craft. If that sounds like you, and you’re ready to make an impact from day one, we’d love to hear from you.