Phoenix - Your AI AssistantSql Projects
Looking for freelance Sql jobs and project work? PeoplePerHour has you covered.
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.
opportunity
Data Analyst
Position Overview: We are seeking a Data Analyst to transform raw data into actionable insights. In this role, you will analyze complex datasets, create reports, and develop visualizations to support business decisions and optimize processes. Key Responsibilities: Collect, clean, and organize data from multiple sources. Analyze datasets to identify trends and insights. Create reports and dashboards using BI tools (Tableau, Power BI, etc.). Design visualizations to communicate findings clearly. Collaborate with teams to provide data-driven recommendations. Ensure data integrity through audits and validation checks. Required Skills and Experience: Education: Bachelor’s degree in Data Science, Statistics, or related field. Experience: 1–3 years in data analysis or a related field. Technical Skills: Proficiency in SQL and data analysis tools (Excel, Python, R, etc.). BI Tools: Experience with data visualization tools (Tableau, Power BI). Analytical Skills: Strong ability to interpret data and provide actionable insights. Communication: Ability to present complex data simply and effectively. Nice to Have: Experience with machine learning or predictive analytics. Familiarity with data warehousing and ETL processes.
Software Tester / QA Engineer
Job Description We are looking for a detail-oriented Software Tester (QA Engineer) to ensure the quality and reliability of our software products. You will work closely with developers and product managers to identify bugs, improve performance, and deliver high-quality applications to users. Responsibilities Analyze requirements and create test plans, test cases, and test scenarios Perform manual and/or automated testing of web and mobile applications Identify, document, and track bugs using defect tracking tools Execute functional, regression, integration, and system testing Collaborate with development teams to resolve issues Ensure software meets quality standards before release Participate in reviews and provide feedback on product usability Requirements Bachelor’s degree in Computer Science, IT, or a related field (or equivalent experience) Experience in software testing or quality assurance Knowledge of SDLC and STLC Familiarity with testing tools (e.g., Selenium, JIRA, TestRail, Postman) Basic understanding of SQL and APIs (preferred) Strong analytical and problem-solving skills Good communication and documentation skills
Senior Data Engineer
We are seeking a Senior Data Engineer to design, implement, and optimize data pipelines utilizing Scala, Spark, and Java. The ideal candidate will develop and maintain real-time data processing systems essential for business operations. Collaboration with data scientists and analysts is crucial to understand data requirements and deliver high-quality solutions. Responsibilities include ensuring data quality through robust testing, monitoring workflows, and troubleshooting pipelines. Candidates should possess a degree in Computer Science or Engineering, with proven experience in data engineering, real-time processing, and SQL proficiency. Familiarity with cloud platforms and data governance is preferred. We offer a competitive salary, benefits, and opportunities for professional growth in a collaborative environment. Key Responsibilities: - Design, implement, and optimize data pipelines using Scala, Spark, and Java. - Develop and maintain real-time data processing systems to support business-critical operations. - Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver high-quality solutions. - Ensure data quality and reliability through robust testing and validation procedures. - Monitor and troubleshoot data pipelines and workflows to ensure high availability and performance. - Stay current with emerging technologies and industry best practices to continuously improve our data infrastructure. Qualifications: -Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field. - Proven experience with Scala, Spark, and Java in a data engineering or similar role. - Strong understanding of real-time data processing and streaming technologies. - Experience with big data platforms and tools such as Hadoop, Kafka, and Flink is a plus. - Proficiency in SQL and experience with relational databases. - Excellent problem-solving skills and attention to detail. - Strong communication and collaboration skills to work effectively with cross-functional teams. Preferred Skills: - Experience with cloud platforms (AWS, Azure, Google Cloud) and their data services. - Knowledge of data warehousing solutions and ETL processes. - Familiarity with data governance and security best practices.
Senior UK .NET Developer – Long-Term System Support + Dev
We are looking for an experienced UK-based senior .NET developer to take long-term ownership of a business-critical CRM & Finance platform. This is not a one-off task. We want a long-term partner who can first familiarise themselves with the system and stabilise it, then provide full ongoing support and further system development. We are actively replacing an existing slow and ineffective support arrangement and are keen to work with someone professional, proactive and reliable. Phase 1 – Initial Audit, Familiarisation & Bug Fixing The first phase will be a paid engagement to: • Set up a full offline / local development environment • Review the codebase, database and overall architecture • Identify and fix priority bugs and long-standing issues • Improve system stability and performance • Produce a short stabilisation and improvement plan This phase allows you to fully understand the platform and demonstrate ownership before moving into long-term support. Phase 2 – Full Ongoing Support & Further Development (Long-Term) After stabilisation, this becomes an ongoing hourly role providing both live system support and further development, including: • Full production support when bugs or system issues arise • Rapid diagnosis and fixing of live problems • Ongoing performance monitoring and optimisation • Enhancements and new feature development • Refactoring and gradual modernisation • Safe testing and controlled deployment into the live environment We expect regular monthly work and a long-term working relationship. Technology Stack • VB.NET and C#.NET (mixed legacy and newer code) • SQL Server Express (stored procedures, LINQ, optimisation) • jQuery, NuGet packages, PDF export module • Hosted on AWS (Windows Server 2019) • Source control in Bitbucket Two tightly integrated applications (CRM + Finance) sharing a central database. Who We’re Looking For This role is only suitable for a senior UK-based developer who: • Has strong experience with C#.NET / VB.NET and SQL Server • Has proven experience supporting live, business-critical systems • Is confident diagnosing and fixing production issues quickly • Is comfortable owning and evolving a complex legacy platform • Communicates clearly and works reliably long-term Experience with AWS / Windows hosting is a strong advantage. Budget & Engagement • Engagement via PeoplePerHour • Hourly rate: £60 – £75 per hour (depending on experience) • Phase 1 expected to be a short initial contract (audit + stabilisation) • Phase 2 is an ongoing hourly support & development role with regular monthly work How to Apply Please include: • Confirmation that you are UK-based • Relevant experience with legacy .NET systems and live production support • Your hourly rate • Availability per week / month • Brief outline of how you would approach the initial audit and stabilisation phase
Hiring machine learning engineer
Location: Remote Job Type: Contract About the Project: We are looking for a skilled Machine Learning Consultant to join our team on a contract basis. This role is ideal for an expert who can provide strategic guidance and hands-on support for various machine learning projects. Responsibilities: - Consult on the end-to-end ML pipeline, from data preprocessing to model deployment. - Provide clear documentation and presentations on findings and recommendations. - Collaborate with stakeholders to translate business needs into technical requirements. Required Qualifications: - Bachelor's degree in Computer Science, Engineering, Statistics, or a related field. - Minimum of 5 years of experience in a machine learning engineering or consulting role. - Demonstrated expertise with Python, SQL, and major ML frameworks. - Experience with cloud platforms (e.g., AWS SageMaker, Google AI Platform, Azure ML) is a plus. - Excellent verbal and written communication skills.
opportunity
Engineer to audit Existing CRM Codebase (TypeScript/Node/NeonDB)
Job Description I’m looking for an experienced senior full-stack engineer to review an existing CRM system and provide a clear, structured technical assessment of the current codebase. This is not a build-from-scratch role. The goal is to audit the existing system, review architecture and implementation choices, and highlight risks, concerns, and improvement opportunities across backend, frontend, and data layers. Tech Stack Backend: Node.js, Express, TypeScript Frontend: TypeScript, Tailwind CSS Database: NeonDB (PostgreSQL) System Type: Custom CRM platform Auth: Mix of public and authenticated endpoints Scope of Review You will be asked to review the existing codebase and provide written feedback on: 1. Code Structure & Architecture Project structure and separation of concerns API design and route organization Service, controller, and data access patterns Type safety and TypeScript best practices 2. Backend & API Review Public vs authenticated endpoint design Validation, error handling, and middleware usage Security posture of public endpoints Rate limiting, abuse protection, and access controls 3. Frontend Review Component structure and state management Tailwind usage and maintainability Frontend/backend contract consistency 4. Database & Data Layer Schema design and relationships Query patterns and performance considerations Data access safety (SQL injection, unsafe queries) 5. Security & Reliability Authentication/authorization design IDOR, data exposure, and abuse risks Secrets management and configuration hygiene Logging, monitoring, and error visibility Deliverables A written technical review (bullet-pointed and structured) Clear identification of high-risk, medium-risk, and low-risk concerns Practical, actionable recommendations (no theoretical fluff) Notes on what is good and should remain unchanged No code changes are required unless specifically discussed. Ideal Freelancer 5+ years professional full-stack experience Strong TypeScript + Node.js background Experience reviewing or auditing existing codebases Comfortable with PostgreSQL / NeonDB Strong understanding of API security and CRM-style systems Clear written communication (this is a review role)
Past "Sql" Projects
PL/SQL AND ORACLE APEX DEVELOPER
We are seeking a proficient PL/SQL and Oracle APEX developer to join our project team. The ideal candidate will possess extensive experience in crafting robust database solutions and developing dynamic web applications using Oracle Application Express. Responsibilities include designing and implementing efficient SQL queries, optimizing database performance, and creating user-friendly interfaces. The successful freelancer will demonstrate strong problem-solving abilities and a keen attention to detail. If you have a passion for database management and application development, we invite you to submit your proposal for this exciting opportunity.
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
Data Scientist – Measurement & Causal Inference
We are seeking a Freelance Data Scientist (3+ years experience) with strong expertise in statistical inference and causal analysis to support enterprise measurement frameworks. Time Commitment: ⏱ 2–2.5 hours/day | Monday–Friday (No weekends) Key Requirements: Strong knowledge of hypothesis testing, OLS, GLM, and causal inference Hands-on experience with A/B testing & experimental design Proficiency in Python & SQL (statsmodels, scikit-learn, DoWhy) Experience with Databricks or enterprise cloud environments Ability to work independently and collaborate via GitHub (CI/CD) Type: Freelance
Senior Software Developer – Web, Mobile & Blockchain
We are seeking highly skilled Software Developers from India, Pakistan, the Philippines, the EU, or Latin America who have strong expertise across web, mobile, and blockchain technologies. This is a remote, full-time position requiring collaboration with our US-based team and working in CST/EST timezones. As part of our team, you will develop and maintain applications using JavaScript/TypeScript, React, Next.js, React Native, and other modern frameworks, while also building and integrating Web3/blockchain features. You should be experienced in full-stack development, smart contract integration, and databases (SQL or NoSQL). The ideal candidate communicates well in English, can work effectively during US timezones, and is motivated to join a collaborative, growth-focused environment that serves US clients. Budget range: Receive offers Who are you, and what do you do? Hi, I’m the Manager of our Software Development Team, and I’m passionate about building a strong, collaborative engineering culture. I work closely with developers from different countries, helping them grow, succeed, and build amazing products for US clients. I’m looking for talented developers who are reliable, motivated, and able to communicate well in English. If you enjoy working with modern web, mobile, and blockchain tech, you’ll fit right in.
ASP.NET Webforms to ASP.NET MVC conversion with SQL Server
I posted this project before but closed it. I am reposting it. Looking to start approx 6th Nov. If you already put in a bid I will look at existing proposals or welcome to put in another proposal. Initial job is quite small, a few weeks, overall project is larger and will need more work. I’m a C# .NET developer currently working on an ASP.NET MVC project. I am looking for C# .NET developers to help complete it. The project involves a webforms VB site that I’ve migrated to .NET (Core) MVC with C#. I have already build a large amount of the site - I need help to test what is already done and make any updates. Then the rest of the project to complete. I have a VM setup with Visual Studio and SSMS which can be used for development and checking code into GitHub. I would like to send an NDA. Some of the tech used is ASP.NET MVC C# SQL Server Stored Procedures JQuery EF Core database first MSTest VS2012 (for running old WebForms app) Interested in hourly rates/ongoing/agencies - just send me details of your offer/rates. Also any links to your website or other info appreciated.
Polymarket Wallet Forensics
Job Description I am looking for an experienced Blockchain Data Analyst to help identify and track clusters of wallets on Polymarket (Polygon Network). The goal is to identify multiple wallets that likely belong to the same individual based on funding patterns and behavioral fingerprints. Key Responsibilities Funding Source Traceback: Analyze the initial funding source of specific Polymarket wallets. Determine if the source is a private self-custodial wallet or a Centralized Exchange (CEX) hot wallet. Temporal & Amount Analysis: For wallets funded by exchanges, perform temporal analysis to match withdrawal times and amounts to identify "sibling" wallets (wallets funded in the same batch). Cluster Mapping: Identify "Hub-and-Spoke" patterns where one primary wallet distributes funds (USDC/MATIC) to multiple proxy betting accounts. Exit Point Verification: Track where funds are sent after betting. Identify if multiple wallets "sweep" their winnings to the same exchange deposit address or unique memo ID. Reporting: Provide a spreadsheet or visualization mapping the connections between the target wallet (0xb786...) and any identified related addresses. Required Skills Blockchain Explorers: Expert-level use of PolyScan and Etherscan. Forensic Tools: Experience with Breadcrumbs.app, Arkham Intelligence, Bubblemaps, or Dune Analytics. Methodology: Deep understanding of "Peeling Chains," withdrawal clusters, and exchange deposit memo tracking. Network Knowledge: Strong understanding of the Polygon network and Polymarket’s CTF (Conditional Token Framework) contracts. Preferred Qualifications Experience in "Sybil detection" or crypto-forensics for DeFi platforms. Ability to write custom Python/SQL scripts (Dune) to automate the search for similar funding patterns across the Polygon network. Deliverables A list of all wallets identified as "highly likely" to belong to the same owner. A brief summary of the evidence for each link (e.g., "Funded within 60 seconds of each other," or "Shares the same Binance deposit memo"). (Optional) A visual map of the wallet cluster.
opportunity
Software Engineer - .NET
Seeking a Software Engineer (.NET) experienced in designing, developing, testing, and maintaining web applications and services using C#, ASP.NET MVC, .NET Framework/.NET Core, and SQL Server. Responsibilities include building efficient database solutions, creating and consuming Web APIs, developing front-end components with JavaScript, jQuery, AJAX, HTML, and Bootstrap, and maintaining code quality through unit testing/TDD and peer reviews. Ideal candidates should have strong skills in LINQ, Git, and Entity Framework, with bonus experience in Azure DevOps/CI-CD, React, Kendo UI, AutoMapper, SSIS, and common C# design patterns (e.g., Singleton, Factory Method, Abstract Factory). The role involves collaborating with cross-functional teams, troubleshooting performance issues, and writing clear technical documentation.
ASP.NET Webforms to ASP.NET MVC conversion with SQL Server
I’m a C# .NET developer currently working on an ASP.NET MVC project. I am looking for C# .NET developers to help complete it. The project involves a webforms VB site that I’ve migrated to .NET (Core) MVC with C#. I have already build a large amount of the site - I need help to test what is already done and make any updates. Then the rest of the project to complete. I have a VM setup with Visual Studio and SSMS which can be used for development and checking code into GitHub. I would like to send an NDA. Some of the tech used is ASP.NET MVC C# SQL Server Stored Procedures JQuery EF Core database first MSTest VS2012 (for running old WebForms app) Interested in hourly rates/ongoing/agencies - just send me details of your offer/rates. Also any links to your website or other info appreciated. Please no AI generated proposals
Senior Software Engineer
About Us: Koinos is a leading software development company dedicated to creating innovative solutions in the blockchain and digital currency space. We pride ourselves on building scalable, secure, and cutting-edge applications that empower users worldwide. Position Oversiew: We are seeking a talented and motivated Software Engineer with expertise in React and Node.js to join our dynamic team. The ideal candidate will be responsible for developing, enhancing, and maintaining our web applications, ensuring optimal performance and user experience. Responsibilities: Design, develop, and maintain web applications using React.js for front-end development. Build and optimize backend services and APIs with Node.js and related technologies. Collaborate with cross-functional teams to define, design, and ship new features. Write clean, scalable, and efficient code following best practices. Troubleshoot and resolve bugs and performance issues. Stay updated with the latest industry trends and continuously improve technical skills. Participate in code reviews and contribute to a collaborative team environment. Qualifications: Bachelor’s degree in Computer Science, Software Engineering, or a related field. Proven experience in full-stack development with React and Node.js. Strong understanding of JavaScript, HTML, CSS, and related technologies. Experience with RESTful APIs, GraphQL, and database systems (SQL/NoSQL). Familiarity with version control systems like Git. Knowledge of blockchain or cryptocurrency technologies is a plus. Excellent problem-solving skills and attention to detail. Good communication and teamwork abilities. What We Offer: Competitive salary and benefits package. Opportunity to work on innovative blockchain projects. Flexible working hours and remote work options. Collaborative and inclusive work environment. Professional growth and development opportunities. Set-up: Remote Hiring Process: Resume Screening Take-Home Assessment Technical Interview Final Interview Job Offer How to Apply: Interested candidates are encouraged to send their fully updated resume or portfolio to hire@koinos.us.
opportunity
Microsoft Access Developer (Azure SQL Back-End)
We require a Microsoft Access developer to create a robust customer and call management system for our company. The system will: Import weekly CRM and Waiver CSVs Deduplicate bookings and merge records Calculate 12-month spend and visits Generate automated call lists for several sales campaigns (party reactivation, birthdays, upsells, etc.) Provide two user levels (Manager / Staff) with dedicated dashboards, data correction tools, and KPI reporting. The database back-end will be hosted on Azure SQL Database with Azure AD authentication (IT team will provide). You’ll build the Access front-end (forms, queries, VBA automation) and ensure clean integration. Experience in Access-to-SQL linking, VBA ETL routines, and user interface design is required.
Microsoft Access Developer
We are currently looking for a freelancer to support us with a few modifications in our existing invoicing system (Winflector). Requirements: Minimum 1 year of experience Proficiency in: - Microsoft Access 2010 Development - Microsoft SQL Server - Working knowledge of Accounting Software
Transact SQL help
I have an OK knowledge of Transact SQL but struggle with more complex queries. I'm looking for someone who can help me create the queries that I need on an on-going basis. Typically my requests will be for help with specific queries and each one will almost certainly be no more than an hour at a time. So very short, sharp 'projects'. So I'm looking for a longer term 'helper' who I can call upon when needed. I *might* be interested in a one-to-one on-line session to get a better understanding of TSQL queries.
opportunityurgent
FileMaker Pro to Microsoft SQL Server (MS SQL) Migration
The business refurbishes IT equipment in three key areas: PCs/Laptops, AV, and Networking. The current FileMaker Pro system handles order intake (goods-in), tracks unit-level details (brand, model, serial, spec, upgrades), manages engineering workflow (notes, statuses, ready-to-ship), and records shipping info. It also stores commercial data (purchase & shipping prices ex-VAT), supports basic reporting (daily/weekly outputs), and provides user-facing screens to process stock quickly. This project migrates to a cloud-hosted MS SQL database with a custom internal web app: React (Tailwind + chart library) front-end and a thin API (Node/.NET) that serves data and KPIs. The UI must match or improve current layouts and support core KPI dashboards. This scope includes Sections 1–3 only. Section 4 (automation, real-time P&L, AI) is not to be implemented now; a separate Technical Backdrop describes groundwork. Sections 1–3 must be built with future expansion in mind. Section 1 – Core Migration to MS SQL Objective: Recreate FileMaker logic and data in a normalized, indexed MS SQL schema, ready for API consumption. Deliverables Cloud-hosted MS SQL setup with least-privilege access control. Logical data model & ERD (from FileMaker exports/screenshots). Normalized schema with PK/FK, key indexes, and core views. Full data migration (cleansing, transformation notes, reconciliation). Reference tables (suppliers, engineers, statuses, codes, brands, categories, channels). Documentation: schema guide, migration steps, backup/restore process. Acceptance Criteria Row counts validated; FK relationships enforced. Sample lookups return in ~1s or less. Backup and restore tested and documented. Section 2 – Custom UI + API Goal: Deliver an internal web app as usable as (or better than) FileMaker, with a thin API layer. Frontend (React + Tailwind) – Minimum Screens Goods-In: intake, supplier link, statuses, notes, timestamps. Production Worksheet: engineer queue, actions/notes, ready-to-ship toggle. Dispatch/Shipping: ready list, carrier/label refs, shipped timestamps. Search/Record View: search by SKU/serial/unit; editable detail view with validation. API (Node/.NET) REST endpoints for units, goods-in, shipments, production queues, engineers, KPIs. Server-side validation; created_by/updated_by and timestamps. Internal/trusted users now; design to accept OIDC/Azure AD later. Acceptance Criteria All workflows achievable with same or fewer clicks vs FileMaker. Field validation + audit fields recorded. Responsive for desktop use; access limited to internal/trusted users. Section 3 – KPI Dashboards & Reports KPIs Required Time from goods-in to finished/ready-to-ship/shipped (per unit & per batch). Engineer throughput (units/day or week); flag returns if available. Shipping volumes (daily/weekly), sliced by brand/supplier/category. Basic batch profitability: purchase + logged costs vs revenue (where data exists). Deliverables React KPI views (charts/tables via Recharts/Chart.js) backed by API/SQL views. Exports: daily/weekly in CSV/PDF (server-side export endpoint); Google Sheets optional later. Brief docs: KPI definitions and SQL per card. Acceptance Criteria KPI outputs match test calculations on supplied data. Scheduled or manual exports work as expected. Inputs We Provide FileMaker exports (CSV/Excel), layout screenshots. Sample KPIs and example calculations. SQL credentials and app/API environment (or guidance). Named contacts for testing/decisions. Out of Scope Automation, live P&L, smart pricing, forecasting (see Technical Backdrop). Amazon SP-API, Linnworks, Repricer, etc., beyond preparatory schema/API surfaces. Public/external UI; mobile optimization. Non-Functional Requirements Security: Least-privilege access; secrets not in repos (use env/KeyVault). Backups: Daily backups; at least one restore tested successfully. Performance: Fast queries (<~2s) on typical volumes. Docs: ERD, schema dictionary, KPI SQL, backup/migration runbooks, API spec. Minimal Performance Standards Indexes: Primary keys + selected non-clustered indexes (e.g., Serial_Number, Status). Lookups: Lists and common queries should feel instant (<0.5s). Dashboards: Pre-aggregated tiles load in <1s on current volumes. Fixes: Any slow query at handover must include an implemented fix. Housekeeping: Daily backups in place; restore test documented. Timeline & Questions We see this as a 2–3 week exercise. Please raise questions early, and provide feedback on timings and costs. A slightly extended version of this brief exists if needed. Thank you.