Phoenix - Your AI AssistantDatabases Projects
Looking for freelance Databases jobs and project work? PeoplePerHour has you covered.
opportunity
Booking / ordering management system for a Wordpress website
I run an event hire company that hires out a range of event hire stock. I carry out three four event hire installations a week and am using Google calendar to log my bookings, Zoho for my invoicing and a spreadsheet for my stock levels - so it's a bit all over the place. I have a Wordpress website at https://cornwalleventscompany.co.uk/ and I would like to integrate a booking / stocktaking system. I would like the following process; A client visits my website and places an order, selecting items for hire (if items are already hired out, then they are marked as unavailable) From this list, a quote is generated and emailed to the client and myself If the quote is accepted, then either an invoice is raised (it would be great if this was integrated with Zoho or another system) or a list of items and amounts produced that I can cut ‘n’ paste into Zoho to raise an invoice. A jobsheet is generated detailing what items are needed along with the client’s address and contact details. I am looking for offers for this project.
Power BI Development
We require someone to set up and establish our PowerBI reporting environment with live data connection feeds from various sources. Reports & dashboards will be need to added and subsequently enhanced on an ongoing basis. The complexity of the work to begin with should hopefully be quite low; we are looking for someone who can add value to our PowerBi experience rather than simply follow our requests verbatim. This will very much an ongoing project across the coming weeks and months as we refine & development our reporting.
DATABASE SPECIALIST
I am seeking a skilled Database Specialist to join our team. This role is a unique blend of a Database Administrator (DBA) and a Developer, providing an exciting opportunity to work on both existing databases and new queries. As a DBA, you will play a crucial role in SQL development, data modelling, and database design, with a focus on optimising and maintaining complex database systems. This role will involve working closely with cross-functional teams to support the development and deployment. RESPONSIBILITIES : 1. Manage and maintain SQL Server and MYSQL databases from development through production environments. 2. Configure and monitor database servers to ensure peak performance, availability, and security. 3. Implement data modelling techniques to support integration and performance goals. 4. Troubleshoot and resolve database issues promptly and effectively. 5. Automate routine tasks and document changes to streamline processes. 6. Assist with query optimization and schema design to enhance system performance. 7. Provide 24/7 support for mission-critical systems. 8. Perform scheduled maintenance and support release deployments outside regular hours. REQUIREMENTS : 1. A university degree, preferably in computer science, engineering, or other numerate disciplines. 2. Certifications in the leading database management systems, i.e., Oracle, Microsoft SQL Server, IBM DB2, Sybase and MySQL. 3. Certifications in Project Management is an added advantage 4. 2 + years of experience with Oracle, Microsoft SQL and MySQL database administration. 5. Experience with Business Intelligence product administration. 6. Conceptual knowledge of all and in-depth knowledge of some of the following: Technical Architectures, Configuration Management, Software Development Life Cycle, Operating systems, Database systems
opportunity
Server Replacement
Replace existing server and configure accordingly with existing settings. Freelancer needs to come into our office in Manchester to do the work.
Client Fee and Salary Calculation Tool or Spreadsheet
Request for Proposal for Development of a Client Fee and Salary Calculation Tool or Spreadsheet for Home Caregiving Services for HOME CAREGIVING BUSINESS Introduction In the evolving landscape of home caregiving services, businesses are tasked with ensuring efficient client management and accurate fee calculations. To that end, we are seeking proposals from qualified consultants to develop a spreadsheet or application that facilitates the calculation of client fees and caregiver salaries based on several criteria. Objective The primary objective of this Request for Proposal (RFP) is to acquire a specialized tool–likely in the form of a spreadsheet–that provides accurate and efficient fee calculations for our caregiving services and, at the same time, calculates a caregiver’s salary. This tool or spreadsheet should be designed to cater to our unique business requirements, accommodating various factors such as the type of care requested, the duration of service, additional services like nighttime care, and transportation costs incurred for caregiver travel. We are NOT looking for a complex tool, but a basic tool or spreadsheet that can provide basic client pricing and caregiver pay based on inputs we will provide. Scope of Work 1. Client Needs Assessment: The tool must allow for nuanced input reflecting client needs. This includes assessing the type of care, which may range from basic companionship to specialized medical assistance. 2. Type of Care Requested: A variety of caregiving services will need to be accommodated within the application. The consultant shall categorize services for straightforward selection during the fee calculation process. 3. Duration of Care: The tool must incorporate functionality for inputting the duration of care, which could vary from a few hours to extended periods such as daily, weekly, or monthly services. It may also distinguish between “live-in care” and “stay-out care.” 4. Extra Services: Inclusion of options for additional services required by clients, such as nighttime care, specialized or my complex care, should be clearly delineated, allowing for automatic calculations of any added costs. 5. Transport Cost Calculation: Accurate transport cost calculations based on the caregiver's distance to the client’s location are essential. This may involve integrating mapping and distance calculation functionalities to ascertain transport expenses. Transport may be optional, and the tool or spreadsheet should also offer an alternative, such as a basic weekly or monthly extra transport fee input as opposed to distance/rate calculations. 6. Caregiver Salary Computation: The tool should allow for the calculation of caregiver salaries based on input pay rates, ensuring compliance with applicable labor laws and fair compensation practices. Deliverables Upon project completion, the selected consultant will provide: - A fully operational spreadsheet or application capable of performing the specified calculations. - Documentation detailing the tool's functionalities and a brief user guide, and one hour of training for two users. Proposal Submission Guidelines Proposals must include: - A statement of work detailing the consultant’s approach to the project. - An estimated timeline for project completion. - The tool or spreadsheet should show pricing and caregiver pay in both US Dollars USD) and Costa Rican colones (CRC), with an ability to change the exchange rate. - A budget outlining costs associated with development, implementation, and support. - Portfolio samples or case studies showcasing relevant experience in developing similar tools. Selection Criteria Proposals will be evaluated based on: - Demonstrated experience and expertise in creating user-friendly calculation tools. - Understanding of the home caregiving sector and its specific financial considerations. - Cost-effectiveness and value for money. - There will be at least two review cycles and changes/feedback provided before the project is officially finished. - Proposed timeline and milestone clarity. We are eager to partner with a knowledgeable consultant who can deliver a robust tool tailored to our business needs. This innovative solution will not only streamline our fee calculations but also enhance our client service experience. We look forward to receiving your proposals and working together to improve our caregiving service efficiency. For any inquiries regarding this RFP, please respond with the information indicated above.
opportunity
Cloud server maintenance for PHP live data processing
Cloud server maintenance for PHP live data processing
opportunity
API Integration & Make.com (Data Feed → Geckoboard Dashboard)
We’re looking for a skilled API Integration Developer who can complete this project today. The task is to connect a live data feed via Make.com (Integromat) and send specific fields to Geckoboard for KPI display. The data is already available via a working API (with a valid API key). Your role is to authenticate, fetch, structure, and post the data to Geckoboard’s Dataset API — ensuring the dashboard updates automatically at regular intervals. Scope of Work: API Connection: Connect to an existing REST API using the provided key. Test and confirm successful JSON response. Identify and extract key fields (e.g. timestamp, price, change, percentage, etc.). Make.com Scenario: Build a Make.com scenario that fetches data automatically (every few minutes). Map fields correctly for Geckoboard compatibility. Include any necessary conversions or rounding (e.g. numbers, percentages, timestamps). Add basic error handling and data validation. Geckoboard Integration: Use Geckoboard’s Dataset API to create or replace a dataset. Ensure the data updates live within the dashboard. Confirm field structure and display are correct. Requirements: Strong experience with Make.com (Integromat). Proven track record of working with JSON APIs and HTTP requests. Understanding of Geckoboard Dataset API (PUT/POST). Fast, clear communication and ability to work independently. Must be available to complete the setup today. Deliverables: A fully working Make.com scenario connected to Geckoboard. Documentation or quick video walkthrough showing how it works. Minor support for any adjustments after setup. Budget: Open to offers — will award quickly for immediate start. To Apply: Please include: Examples of previous Make.com or API automation projects. Confirmation you can complete this today. Your estimated total cost.
opportunity
Data Entry: Compile Actor Info from online Casting Directory
Assemble and format actor information from Spotlight Online Casting Directory into a CSV file within 2–3 days We’re putting together a database of around 250–350 actors drawn from 6–7 European countries and are looking for someone to input details from this information in a CSV format. Each group of actors has already been shortlisted within our Spotlight casting account (about 40–50 per country), and your role will be to collect and record their details in the CSV according to the specified fields. Name (separate fields for forename and surname) Playing age Sex Locations (separate fields if multiple) Nationalities (separate fields if multiple) Languages spoken (native) (separate fields if multiple) Languages spoken (non-native) (separate fields if multiple) Accents (as native) (separate fields if multiple) Home studio (yes/no or details) Agent / other contact Spotlight link Requirements: Accuracy and consistency across all entries Completion within 2–3 days of starting Familiarity with the Spotlight Casting Directory (or previous experience using it) would be a real advantage The following Spotlight page is an example of how the 300 entries look and the information to be extracted from each: https://app.spotlight.com/ Example entry: Name: Bogdana KALANTAY Playing age: 25–35 Sex: F Locations: Kyiv Ukraine; Berlin Germany; London UK Nationalities: German Languages (native): English; German; Russian; Ukrainian Languages (non-native): Polish Accents (as native): American-Standard; East European; English-Standard Accents (high standard): American-California; French Home studio: Access to studio Agent / contact: ML INTERNATIONAL TALENT,
Excel/power bi completion
I am seeking a skilled freelancer to develop an efficient Excel worksheet or Power BI dashboard tailored for managing new energy clients. This tool should allow seamless input of client information via a form, automatically updating and generating insightful reports. As an energy broker dealing with varied payment structures—including advance commissions, contract-based payments, and monthly fees—it's crucial to have a streamlined system that can project monthly earnings based on active and prospective contracts. The current method is cumbersome and time-consuming, so I need a solution that enhances efficiency and clarity in managing client data and financial projections.
opportunity
Custom XML integration between Magento and Gizmo (3rd party)
I have developed a website for a client that now requires some additional XML integration for BUNDLES (in magento) from PACKS (in Gizmo) The clients product management software Gizmo is a bespoke closed system that doesn't have remote access. Therefore when testing we would need to arrange for the client to come online and 'push' products from gizmo to ensure it works.
Past Projects
opportunity
Data Scrapping with Details
We are seeking a skilled **Data Scraper / Research Specialist** to help us enhance our database. You will be provided with a base dataset of 2,000 entries, and your role will be to expand this to additional approximately 6,000 records by carefully researching, gathering, and verifying additional information. You will be required to collect the following data fields: * Contact person’s name * Contact person’s email address * Phone number * Company name * About the company – approx. 500 words * Company email address * Company contact number * Full UK postal address * Website * Service areas (county names) * Type of provider (only: Worktop Supplier, Builder, Electrician, Plumber, Gas Engineer, Handyman) **Geographic coverage:** * **London postcodes** * **London surrounding postcodes (Greater London region), including 2-letter areas such as:** AL, CM, DA, EN, GU, HP, IG, KT, RH, RM, SG, SL, SM, TN, TW, WD * **Worktop Suppliers:** nationwide across the UK Please note: **We will physically verify 100+ entries at random. Therefore, the data must be accurate, genuine, and thoroughly validated.** High attention to detail, accuracy, and consistency is essential for this project.
Contact Details List
I want a list of contact details, email only, of 250 companies in London, medium engineering, financial services and law firms.
opportunity
Email AI Tool and LLM Integration Project
This work involves taking two existing AI tools and turning them into live products on our website. The first is the AI Email Prediction Engine, which needs to be uploaded to the site, given a full user interface, and connected to a database so lookups, credits and billing can be managed. The second is the LP Mandate LLM (essentially a LLM that contains a database of information that clients will query). Both tools already exist in working form, and the remaining job is to integrate them properly, deploy them and maintain their underlying databases. PART 1 – AI Email Prediction Engine 1. What the Product Is This is a prediction engine that identifies the most likely email address for any investor based on their name, company and domain, with an optional verification-style signal similar to Hunter.io. The final product will be a full SaaS tool on the AIP website where users can register, use a small free trial, buy credits or subscriptions, run single or bulk lookups, and download results. It will behave like a commercial email-finding platform designed specifically around AIP’s investor data patterns. 2. What We Need to Build To turn the model into a usable product, the following must be developed: A full web interface integrated into the AIP site. User authentication including signup, login, password reset and email verification. A credit system where each lookup consumes credits, with a free starter allowance. Stripe billing for subscriptions and credit packs. Single lookup and bulk lookup features. Bulk upload processing for CSV and Excel files, running through a queue system. Postgres storage for completed jobs and history. A downloadable results function. A user dashboard and history page. An admin console for adjusting user credits and reviewing activity logs. Secure FastAPI backend handling predictions, credit logic, job scheduling and invoices. Deployment of the C++ inference engine and backend on AWS. 3. What Has Already Been Done The core AI model and inference system are fully complete. The engine is written in C++ and exposes two prediction functions. This is wrapped in Python so that it can be served through FastAPI as REST endpoints. A working demo already exists showing a basic front end sending prediction requests to a remote server. All data engineering work has been completed: cleaning, preprocessing, feature engineering and pattern mining. These components are modular and documented. There are one-click scripts that turn raw data into final training sets. The training notebooks exist and the model is already trained, with weights stored in the repo and ready for immediate inference. 4. Developer Coordination Required You will need to liaise with the original engineer who built the C++ inference engine and Python wrapper, as well as the engineer who built the data pipelines and training system. Each holds domain-specific knowledge that will make integration and deployment significantly smoother. PART 2 – LP Mandate LLM 1. What the Product Is This is a mandate-intelligence platform built around Claude, supported by a vector database containing AIP’s mandate documents. Users will query LP and GP mandates across private equity, venture capital, hedge funds and real estate through a branded chat interface on the AIP website. Subscription tiers will dictate which asset classes users can access. The model will use AIP’s embedded documents to produce grounded, investment-safe answers. 2. What We Need to Build To productise this: A dedicated chat-style interface on the AIP website. Login and subscription gating. 1-, 3- and 6-month plans with tiered access to different asset classes. A secure backend proxy for all Claude calls. Rate limiting, usage logs and audit trails. Chat history, pinning and export features. The vector retrieval system that feeds mandate-specific context into the model. The final deployment within a new Intelligence section of the AIP website. System prompts, tone rules, disclaimers and compliance guidance implemented consistently on every call. 3. What Has Already Been Done The conceptual structure is complete. Claude has been selected as the underlying model. The retrieval architecture has already been defined and will rely on embeddings stored in a vector database. Tone, compliance and formatting requirements are already drafted. The overall system behaviour is fully mapped out: users will query mandate preferences across strategies, and the LLM will respond using AIP’s embedded documents and structured prompts. 4. Developer Coordination Required You will need to work closely with the person who prepared the LLM architecture and prompt framework, as well as the person managing the mandate data and vector embedding process. Each owns core pieces that must be integrated properly for the final product to function.
AWS Storage Cost Reduction & Cleanup Specialist (One-Time Job)
Description: We are looking for an experienced AWS Cloud Engineer to review and optimise our existing AWS account. Our current usage is very light (mainly Word & Excel document storage, under 1TB), yet our monthly AWS bills are unexpectedly high. We need an expert to analyse our setup, identify unnecessary costs, configure the correct storage tier, and clean up unwanted files or unused services. Scope of Work: ✔ Review our current AWS services (S3, EBS, backups, snapshots, etc.) ✔ Identify what is causing the high monthly charges ✔ Recommend and apply the most cost-efficient AWS storage solutions (e.g., S3 Standard/IA/Glacier) ✔ Delete unnecessary data, old snapshots, unused resources ✔ Configure lifecycle policies for automatic archival ✔ Provide a short report on what was done + monthly saving estimate ✔ One-time job (not ongoing) Requirements: – Strong AWS Cloud experience (S3, EBS, IAM, Billing Dashboard, Trusted Advisor) – Proven track record reducing AWS bills – Ability to work safely via IAM temporary access, screen share or limited-role access – Must maintain confidentiality of our data – Available for immediate start Deliverables: Full audit of the account Optimisation of storage Clean-up of unwanted/unnecessary services
Download specific image files using a spreadsheet
I am seeking a skilled freelancer to assist with downloading specific image files from Dropbox, utilizing a provided spreadsheet. The spreadsheet contains approximately 470 product entries, each with corresponding model numbers and Dropbox links. Your task will be to accurately retrieve the images linked to these model numbers and download them into a designated folder. Attention to detail is crucial to ensure that all files are correctly matched and efficiently organized. This project requires proficiency in data management and file handling, ensuring a seamless integration into my eCommerce website. The dropbox with images is: https://www.dropbox.com/scl/fo/0e787a8b95itq8t0uehz0/AE9xNxebHVebCZX1aocGXsE?rlkey=glj00r4og1xbaxhlvrl90nj1x&st=wuaujg1r&dl=0 (we do not have admin access to this Dropbox)
EXCEL IF FORMULA
I need a simple IF formula Here it is A = 5 B = 200 C = Calculation of the 5*200 which is 1000 D will be the IF formula and if C is greater then 5000 then if is 10 but if it is less then 5000 it is 100
Convert 20 DBF Files to .CSV
I have 20 DBF Files to be converted to CSV.
I am looking for a date base in excel or LibreOffice
I am looking for a date base in excel or LibreOffice I am looking to create an excel, Libre Office work sheet. I own a logistics company, and i need to input my drivers delivers each day, i would then like to create an invoice by filtering each drivers name and a second sheet. So... I would have a master sheet i input the info, then an invoice sheet that would pull the info from each driver on the second sheet( the invoice) Regards, Phillip
Mongo DB issue/audit - Running on a Python / Flutter App
Hello - i have an app and the Mongo DB has deleted a stored section that users complete and stays on their account. I wanted someone to take a look at this to see if it can be restored, and then to see how we prevent this from happening again in the future. If the server needs upgrading or any changes need to be made to the database infrastructure. I also want a default checklist installed for every new account.
opportunity
TP-Link Omada Help
Hi, I have a number of sites loaded into a TP-Link Omada setup. This was on an old computer, which got reset. I have a backup of the files stored on that PC, however I do not have a 'formal' backup from the Omada utility itself, just the config files that the utility stored. I have tried downloading the utility and placing the old config files in the relevant folder, but it wont open when I do this or just suggests there is an issue with the Mongo DB. I have tried this with an old version of the Omada utility, too. Someone has successfully completed this project before, but tried to extort me for more money once completed, hence looking for someone else to do the work!