Phoenix - Your AI AssistantSql Projects
Looking for freelance Sql jobs and project work? PeoplePerHour has you covered.
Need an MS SQL database account and its credentials
We don’t need any additional services. We only need an MS SQL database account and its credentials so we can set it up and manage our own database. We are facing issues during the account creation process, as our account keeps getting suspended. Therefore, we simply need you to create a dedicated database specifically for our project and share the database credentials with us. That’s all we need. We will handle the database setup and management on our own. Thank you.
Senior Data Analyst
We are looking for an experienced Senior Data Analyst to analyze complex datasets, identify business trends, and provide actionable insights to support strategic decision-making. The ideal candidate will have strong analytical skills, excellent attention to detail, and experience transforming raw data into meaningful reports. Key Responsibilities Collect, clean, organize, and analyze large datasets. Develop dashboards and reports using Power BI, Tableau, or similar tools. Use SQL and Excel to extract, manipulate, and interpret data. Identify business trends, patterns, and opportunities for improvement. Prepare clear reports and present findings to management. Collaborate with different teams to understand business needs. Ensure data accuracy, consistency, and confidentiality. Recommend data-driven strategies to improve business performance. Required Skills and Qualifications Proven experience in data analysis or business intelligence. Strong knowledge of SQL and Microsoft Excel. Experience with Power BI, Tableau, or other visualization tools. Excellent problem-solving and critical-thinking abilities. Strong communication and reporting skills. Ability to work independently and meet project deadlines. A degree or relevant professional certification is an advantage, but equivalent practical experience may also be considered.
opportunity
WEBSITE SKETCH SHOP WITH CRM FUNCTIONALITY
Need a website+MObile app developed that allows users to buy ink sketches as nfts buy can be bought with card too. Its a simple display with only one sketch padded centrally on the homescreen, all sketches will have same size, and one sketch will be showing everyweek. And automatically updates or publishes the archive in a folder where users can see the past weeks sketches in a grid format. Users cannot screenshot nor download the sketches, only view and buy. The menu will be simple only, About us, Home/This week, Library, Commissions/Inqury. The back end will have where the admin can upload the sketches, view orders, and access database. SQL, Android, io, python/c++
urgent
Microsoft Azure Data Factory Work (ADF)
Seeking an experienced Azure Data Factory specialist to assist with multiple ADF tasks, primarily implementing an incremental load solution. The project entails designing and developing pipelines to perform incremental bulk writes from source tables to six target SQL tables, applying complex SQL logic and transformation rules per table. Deliverables include robust, efficient pipelines, error handling, logging, and documentation of design and operational steps. Familiarity with performance tuning and version control is required. YOU MUST BE UK BASED WITH THE RIGHT TO WORK IN THE UK AND WILLING TO COME TO WORK IN THE CITY OF LONDON PLEASE.
Mid-Level Fullstack Developer
Seeking a proficient Mid-Level Software Developer for a part-time, remote role across Hong Kong, Singapore, Philippines, or Vietnam. Ideal candidate has 3+ years’ professional experience across frontend and backend, a demonstrated ability to deliver clean, maintainable code, and comfort working independently. Responsibilities include developing and maintaining web and mobile applications, implementing features, integrating APIs, debugging and optimizing systems, and producing clear documentation. Required skills: React/Next.js, Node.js/Express/NestJS, PHP/Laravel, Python/Django/FastAPI, React Native or Flutter, SQL/NoSQL. B2+ English, strong problem-solving, adaptability, responsiveness, and ownership are essential. Familiarity with cloud platforms, Docker/CI-CD, AI/LLM integrations, and mobile deployment is advantageous. Long-term collaboration preferred; flexible schedule.
Past "Sql" Projects
Senior .NET + Angular Developer
We are looking for an experienced Senior .NET + Angular Developer to join our engineering team. You will design, develop, and maintain scalable web applications using C#, .NET 8, ASP.NET Core, Angular, and SQL Server. Responsibilities Build and maintain web applications using ASP.NET Core and Angular Develop RESTful APIs and backend services Create responsive UIs with Angular, TypeScript, HTML, and CSS Work with SQL Server and Entity Framework Core Implement authentication, authorization, and security best practices Write unit and integration tests Collaborate with product managers, designers, and other developers Participate in code reviews and Agile/Scrum ceremonies Required Skills 5+ years of software development experience Strong C# / .NET / ASP.NET Core experience Strong Angular / TypeScript experience REST APIs and microservices SQL Server and Entity Framework Core Git and CI/CD Experience with cloud platforms such as AWS or Azure Preferred Docker/Kubernetes Azure/AWS React experience Microservices architecture Automated testing
opportunity
AI Travel Planning & Recommendation Platform
Project Overview: We are building an AI-powered travel platform that helps users plan complete trips based on their destination, budget, travel dates, interests, and preferences. Key Features: AI-generated travel itineraries Destination recommendations Hotel and accommodation recommendations Flight and transportation suggestions Restaurant and activity recommendations Daily trip schedules Budget estimation and expense tracking Weather and local information Personalized recommendations based on user preferences AI chatbot for travel questions User accounts and saved trips Google Maps/location integration Mobile-friendly web interface Technology Stack: Backend: C#, .NET 8 / ASP.NET Core Web API Frontend: Angular / React Database: SQL Server / PostgreSQL AI: OpenAI API or similar LLM service Cloud: AWS / Azure Authentication: JWT / OAuth 2.0 DevOps: Docker, CI/CD APIs: Maps, weather, hotel/flight and travel APIs Developer Responsibilities: Design and develop REST APIs using ASP.NET Core Build AI-powered travel recommendation services Design database architecture and optimize SQL queries Integrate external travel and mapping APIs Develop responsive Angular/React interfaces Implement authentication and authorization Build itinerary generation and personalization logic Write unit and integration tests Deploy and maintain the application in AWS/Azure Troubleshoot production issues and improve system performance Project Goal: Create a smart travel assistant that can take a user's preferences and automatically create a practical, personalized travel plan from “Where should I go?” to “What should I do each day?”
PHP My SQL Bug Fix
I have 3 websites/job boards. A Server migration has left me with some bug fixes. One concerns a malfunction in the candidate databse section, another concerns adding hyperlinks to articles. coding language PHP My Sql.
VULNERABILITY ASSESMENT & PENETRATION TESTING
Talent We Are Looking For We require an experienced VAPT/Penetration Testing Consultant to assess an AWS-hosted Hospital Management Information System within four to five working days. Scope and deliverables: • Test one HMIS web application, one API, one SQL database and one Windows Server. • Conduct black-box, grey-box and white-box testing. • Review AWS security configuration, encryption, hashing, access controls and code/data integrity. • Perform manual testing supported by appropriate automated tools. • Deliver an executive summary, detailed technical report, evidence, risk ratings, remediation recommendations and one retest. Required skills: • Strong web application and API penetration-testing experience. • SQL database and Windows Server security expertise. • Practical AWS cloud-security assessment experience. • Knowledge of OWASP, PTES, NIST and CVSS. • Ability to produce clear, professional customer-facing reports. • OSCP, CREST, CEH or equivalent practical credentials are desirable. Professional expectations: The consultant must demonstrate high integrity, confidentiality and responsible handling of healthcare information. They must communicate clearly in English, provide regular progress updates and escalate critical findings immediately. How we work: We work within a signed scope and Rules of Engagement, maintain strict testing boundaries and prohibit destructive testing. The consultant will collaborate with our project lead, submit evidence for quality review and meet the agreed four-to-five-day delivery timeline.
Create a Excel 'availability viewer' linked to a live database
I need an excel document creating that pulls information from a SQL database into the attached format The file will need to show the following A total of that product we have in fleet How many of those are quoted/booked/on hire Who the client is Date view of how many are booked out each day
Freelancer Needed to Market Data Arrow
Job Description We have built a new web-based product called Data Arrow: https://data-arrow.kea-data.com/ Data Arrow helps data teams, consultants, students, and analytics engineers move from raw SQL and technical data structures into clean, business-friendly data models. The product supports areas such as: ER and Kimball data modeling SQL reverse engineering dbt model generation dbt lineage understanding semantic modeling graph model / CypherQL generation GitHub sync for generated artifacts I would like to hire a freelancer to help make this product more visible across the internet and reach the right audience. What I Need I am looking for someone who can help with simple but effective online marketing activities such as: Identify relevant online communities, groups, and platforms Promote Data Arrow professionally without spamming Create short launch posts for LinkedIn, Reddit, Indie Hackers, Medium, X/Twitter, Product Hunt, Hacker News, etc. Suggest where the product can be listed or launched Improve the website/product messaging if needed Help position Data Arrow for data engineers, dbt users, data architects, consultants, and students Target Audience The product is mainly for: Data engineers Analytics engineers dbt developers Data architects BI consultants Students learning data modeling Teams modernizing SQL, dbt, and semantic models Expected Deliverables For this initial task, I expect: A simple marketing plan with recommended channels 5–10 short promotional posts A list of relevant communities/websites where Data Arrow can be shared Basic competitor or positioning suggestions Initial outreach/posting support where possible Budget My initial budget is around €50. This is a small starting task. If the work is good, I may continue with further marketing, SEO, Product Hunt launch support, LinkedIn content, or community growth activities.
Wine E-Commerce Platform | Senior .NET Software Engineer
Senior .NET Software Engineer to enhance a full‑stack wine e‑commerce platform enabling product browsing, search, cart management, checkout, and order tracking. Develop robust ASP.NET Core REST APIs for catalog, inventory, customer, cart, and order operations. Implement C# business logic for pricing, availability, inventory validation, and transactional order processing. Build efficient EF Core data access with SQL Server, optimize queries, and ensure consistency. Create automated unit and integration tests, enforce authentication and authorization, implement logging, validation, and exception handling, and support AWS deployment and production troubleshooting.
Senior full-stack developer for long-term products
We’re looking for a strong senior full-stack developer to build and ship real-world products across e-commerce, FinTech, EdTech, SaaS, and AI, taking ownership from development through production. This is intended as long-term collaboration (not a one-off task), and production experience matters more to us than just listing technologies. - Build scalable applications across e-commerce, FinTech, EdTech, SaaS, and AI use cases - Develop scalable Python/FastAPI backend services, including REST APIs and third-party integrations (including AI/API integrations) - Build modern React/Next.js applications using TypeScript (with Node.js as needed) - Implement AWS-based production infrastructure, including Docker and CI/CD - Work with PostgreSQL plus SQL/NoSQL data stores as required - Own delivery end-to-end: understand requirements, make architectural decisions, solve complex technical problems, and take work to production - Please do not send a generic proposal. - Include your years of professional experience with Python, FastAPI, React/Next.js, Node.js, and AWS. - Include 2–3 relevant projects you personally worked on (preferably e-commerce, FinTech, EdTech, SaaS, or AI). - For your strongest project, explain what you built, your role, the stack/architecture, and one difficult problem you solved. - Share your GitHub, portfolio, or live work. - Share your current availability and weekly capacity. - Generic or copy-pasted proposals may not be considered.
Develop our internal tool for job tracking
We are looking for an experienced developer to build and improve an internal job tracking and management tool for our team. The system will be used to organize job opportunities, track applications, manage application statuses, and help our team efficiently monitor the entire job application process. Key Responsibilities Develop a responsive and user-friendly internal web application. Create tables for managing and tracking job opportunities and applications. Implement pagination, search, sorting, and advanced filtering. Add job categories and customizable application statuses. Save filters and user preferences using browser cache/local storage. Support CSV and PDF export of job/application data. Allow users to upload screenshots or other proof related to submitted applications. Build dashboards or summaries showing application progress and status. Develop and integrate backend APIs as required. Design and maintain the database structure. Troubleshoot bugs and improve existing functionality. Ensure the application is secure, reliable, and easy to maintain. Preferred Skills Strong experience with modern frontend frameworks such as React or Angular. Backend development experience with Node.js, Java/Spring Boot, or similar technologies. Experience with SQL databases such as PostgreSQL or MySQL. REST API development and integration. Experience building internal dashboards, admin panels, or workflow management systems. Git/GitHub experience. Strong communication and problem-solving skills. Project Goal The goal is to create a centralized internal system that allows our team to efficiently manage job opportunities, track each application from initial discovery through completion, maintain supporting information, and easily review the overall progress of our job application activities. We are looking for someone who can understand the existing workflow, recommend improvements, and develop a clean and reliable solution that can be expanded with additional features in the future.
opportunity
MySQL database needs to handle non-English characters
Experienced MySQL/WordPress developer needed to fix character encoding issues in a 391MB production database. Greek characters currently display as "???" due to charset/collation issue following DDoS attack some years ago. Tasks: analyze database config, convert tables and fields to proper UTF-8/utf8mb4 without data loss, correct connection settings, verify restored Greek text, and provide a safe migration plan for a staging environment. Expertise with backups, SQL conversions and WordPress charset nuances essential. (I'll shortly be setting up a WordPress staging site and it seems a suitable time to fix the database problem.) Nigel Howarth
Data Analyst
We are seeking a detail-oriented Data Analyst to collect, analyze, and interpret data that supports business operations and strategic decision-making. The ideal candidate has strong analytical skills, proficiency in data analysis tools, and the ability to communicate findings to stakeholders. Key Responsibilities: Collect, clean, and validate data from multiple sources. Analyze datasets to identify trends, patterns, and business opportunities. Create dashboards, reports, and visualizations using tools such as Power BI, Tableau, or Excel. Develop and maintain databases and data management systems. Write SQL queries to extract and manipulate data. Collaborate with business teams to understand reporting requirements. Present insights and recommendations to management. Monitor key performance indicators (KPIs) and generate regular reports. Ensure data accuracy, integrity, and security. Support data-driven decision-making across departments. Required Qualifications: Bachelor's degree in Data Science, Statistics, Mathematics, Computer Science, Business Analytics, or a related field. Experience with SQL and Microsoft Excel. Knowledge of Power BI, Tableau, or other data visualization tools. Familiarity with Python or R for data analysis is an advantage. Strong analytical, problem-solving, and critical-thinking skills. Excellent communication and presentation skills. Attention to detail and ability to work with large datasets. Preferred Skills: Experience with data warehousing concepts. Knowledge of statistical analysis and predictive modeling. Understanding of ETL processes. Familiarity with cloud platforms such as AWS, Azure, or Google Cloud. Ability to manage multiple projects and meet deadlines. Key Competencies: Analytical thinking Data visualization Problem-solving Time management Communication Teamwork Attention to detail Typical Tools Used: Microsoft Excel SQL Power BI Tableau Python R Microsoft SQL Server Google BigQuery Snowflake
Build an Intelligent AI Agent for Automated Inventory Management
We are looking for an experienced AI developer or automation expert to design and deploy a custom AI agent tailored for real-time inventory management. The goal is to automate tracking, optimize stock levels, and reduce manual workload across our supply chain. Key Responsibilities: Develop an AI agent that monitors inventory levels in real-time across channels/warehouses. Implement predictive capabilities to forecast demand, prevent stockouts, and flag overstock risks. Create automated alerts and triggers for automated purchase order drafting when stock falls below reorder thresholds. Integrate the AI agent with our existing system (e.g., Shopify, QuickBooks, Custom ERP, or database). Required Skills: Proven experience building custom AI agents (using frameworks like LangChain, AutoGen, or similar). Proficiency in Python, API integrations, and database management (SQL/NoSQL). Background in supply chain, inventory management systems, or e-commerce integrations.
MS SQL EXPERT NEEDED (USA BASED ONLY)
As an expert, you must be residing in the USA, be able to provide a W9 tax form as a consultant, and sign an NDA. The project involves analyzing a complex MS SQL database with over 1500 tables in order to dump and convert the raw data tables into MySQL. The backup is nearly 15GB of data. The schema is based on Enspire ERP and requires the ability to identify which tables are joined in order to output relevant archive data. You will work together to provide samples of what data fields are identified and narrow down only those which are required. Many system fields are likely and not needed, so it will be a process of working together to adequately arrive at a curated MySQL database. Migration of resulting data will be part of the process onto a Linux cloud server with MySQL installed. Project will be awarded based on best overall estimated total hours to complete.
React / Next.js Front End Developer — Remote
We're building the new web version of our product and are looking for an experienced front-end developer to lead and support the rollout. You'll work primarily in React and Next.js, building the interfaces our customers use every day. The frontend integrates with a SQL Server database via a C# API — you won't be modifying the API or database directly, but you'll need to understand relational data and work comfortably against existing APIs. WHAT YOU'LL DO - Build and maintain UI features in React / Next.js - Consume and integrate with an existing C# REST API - Translate designs and requirements into performant, accessible, responsive interfaces - Write clean, maintainable, well-tested code and participate in code review - Collaborate with the wider team (and any backend/API developers) to flag issues, edge cases, or data needs WHAT WE'RE LOOKING FOR - 3-5+ years of professional front-end development experience - Strong hands-on experience with React and Next.js (App Router / SSR / routing/data fetching patterns) - Solid JavaScript fundamentals; TypeScript experience strongly preferred - Strong HTML5 and modern CSS skills - Comfortable working with relational databases conceptually (you won't write SQL day-to-day, but should understand schemas, joins, and how data is structured) - Experience consuming REST APIs built by another team (ideally including .NET/C# APIs, but not essential) - Good communication skills — able to work async/remote and flag blockers early NICE TO HAVE - Experience with a component library/design system - Automated testing experience (Jest, React Testing Library, Playwright/Cypress) - Familiarity with CI/CD and Git-based workflows - Experience in construction, CRM, or B2B SaaS products LOGISTICS - Fully remote HOW TO APPLY When you apply, lead with relevant experience; tell me how you've shipped React or Next.js apps that tracked complex regional data and how you kept performance sharp. Links to repos or live products speak louder than a polished proposal.
opportunityurgent
AI-powered dispatch and customer service assistant
PROJECT: AI Assistant for TaxiCall Platform Overview TaxiCall is a cloud-based taxi booking and dispatch platform written primarily in ASP.NET WebForms (VB.NET) with a Microsoft SQL Server backend. The objective is to develop an AI Assistant that can access TaxiCall operational data and assist drivers, operators, and customers through natural language interactions. Initial Requirements The AI Assistant should be able to: Query booking information from the SQL database. Answer questions about customers, bookings, drivers, vehicles, and jobs. Create and amend bookings through controlled workflows. Search historical bookings and call records. Provide business reports and summaries. Assist operators with dispatch decisions. Provide customer support through web chat and mobile apps. Potentially support voice interactions in a later phase. Current Technology Stack Frontend: ASP.NET WebForms VB.NET JavaScript jQuery Bootstrap jQuery Mobile Backend: Microsoft SQL Server Stored procedures and direct SQL queries Existing web services (ASMX) Mapping / Tracking: Google Maps APIs Google Directions APIs OpenLayers mapping components Vehicle GPS tracking data Existing Functionality The system currently manages: Customer accounts Driver accounts Vehicle details Immediate bookings Advance bookings Dispatching Route calculations GPS vehicle tracking Driver availability Call recording references Fare calculations Customer mobile app Driver mobile app Database Access Required The AI agent will require read access initially to: Customers Drivers Vehicles Bookings GPS locations Call history Later phases may require write access for: Creating bookings Editing bookings Driver allocation Customer notifications Preferred Architecture Phase 1: OpenAI API Python backend SQL Server connectivity REST API layer Phase 2: Integration into TaxiCall web applications Customer-facing chatbot Driver-facing assistant Voice support Existing Code Available Relevant code exists for: Booking creation Customer booking screens Driver allocation Route mapping Vehicle tracking SQL database access Examples can be provided once the project starts. Deliverables Required Proof-of-concept AI assistant connected to SQL Server. Secure database query layer. Natural language booking search. Booking summary and reporting functions. Documentation and source code. Deployment guidance. API credentials, database credentials and server access will be provided after selection of the developer.