Phoenix - Your AI AssistantDatabases Projects
Looking for freelance Databases jobs and project work? PeoplePerHour has you covered.
featuredopportunitypre-funded
UAT tester scripted end-to-end testing : tight deadline
I'm a solo developer looking for a careful, methodical tester to run scripted, end-to-end UAT on a web-based, multi-tenant project-management and delivery platform, ahead of client demos. It's a sophisticated application, with live customer data already in production — I'm close to my first formal customer onboarding. It spans a dozen-odd tightly connected modules (project planning and baselining, delivery, governance and approvals, variations, cost capture, finance and billing, rate cards, RAID, KPIs and quality standards, portfolio reporting). Because they're connected, actions ripple — progressing a deliverable feeds its quality and KPI sign-off, signing off a milestone triggers billing, and it all rolls up into the reports — so a small inaccuracy in one place surfaces in the numbers elsewhere. That's why I need thorough, accurate end-to-end testing. HOW IT WORKS I provide the scripts: each section opens with a plain-English explanation of what it achieves, followed by precise steps. You follow them (or use sensible judgement from what's on screen), capturing screenshots and logging anything that's wrong or doesn't work. If you have your own screen-capture and UAT reporting tools, great — use them; if not, I provide a simple spreadsheet template (one row per issue: steps to reproduce, expected, actual, screenshot, severity). UX improvement ideas are welcome but optional. Everything runs in the browser on a staging environment — logins provided, nothing to install. All testing is on Microsoft Edge, on a standard Windows PC (no mobile or other-browser testing at this stage). THE WORK — ONE COMPLETE END-TO-END SCENARIO You'll take a single project through its full lifecycle: - Create a project with the setup wizard and correct settings - Build the plan in a grid — milestones, deliverables and tasks - Configure financials, build the team from a rate card, and baseline the plan (with supplier and customer sign-off) - Run it as if live — progress deliverables, work the approval workflows, assign and rate KPIs and quality standards - Sign off milestones against the baseline (supplier delivery sign-off + customer certification) to trigger billing - Submit and approve timesheets, expenses and sundries - Raise variations — time extensions, scope increases/reductions, financial changes, combinations — each through supplier and customer sign-off - Do some RAID management, and confirm the reporting and finance views stay accurate throughout This first scenario is the full "governed" project type — the most involved, with sign-offs at every stage — so it means switching between several user roles (supplier-side PM, customer-side PM, a contributor, and so on); the script tells you exactly when to switch. As a guide to scope, expect around 12–16 hours of focused work. WHO FITS You don't need to be a project-management expert — the scripts carry the detail — but experience with project delivery (milestones, deliverables, tasks, change control, variations) is a real plus. What matters most is that you're observant, methodical and accurate, and can clearly describe how to reproduce a problem. Comfort with web apps, data grids and file uploads helps, as does exposure to tools like Microsoft Planner, Microsoft Project, Monday.com or Wrike. TIMELINE — THIS FIRST ROUND IS A TIGHT TURNAROUND I'll send everything you need (scripts, spreadsheets, supporting material) by 11pm UK time on Monday 8 June, and I need completed results back by 06:00 UK time on Saturday 13 June. Please only apply if you're confident you can commit dedicated, focused time across this window. CONFIDENTIALITY The platform and its commercial/customer data are sensitive, so I'll ask you to sign a short NDA before we start and to treat everything you see as strictly confidential. ONGOING POTENTIAL This is the first of several scenarios. If the quality's there, more assignments follow — the other project types, then ongoing UAT and regression testing on each release as the product grows. Do well here and there's a real pipeline behind it. IN YOUR PROPOSAL, PLEASE INCLUDE - A short note on your relevant testing experience and how you approach UAT - Confirmation you can hit the Saturday 13 June deadline, and your availability this week - Any testing standards, certifications or accreditations, and professional associations - The screen-capture / reporting tools you'd use, if any
Database Build for Canada Relocation Pathways
Seeking a meticulous researcher to compile comprehensive relocation and visa pathways for Canada. You will identify, verify, and document all federal and provincial immigration streams, eligibility criteria, processing times, fees, required documents, and applicable restrictions. Tasks include thorough online research, accurate data entry into provided spreadsheet templates, and assembly of credible citations and source links. Strong attention to detail, proficiency with spreadsheets, and experience in immigration research or government-source navigation are essential.
Smartsheet → Google Sheets Migration (incl. forms & history)
We are looking for an experienced freelancer to migrate a set of Smartsheets into Google Sheets, including associated web forms, sheets and historical data. We need someone who understands both platforms and can ensure the structure, functionality, and data integrity are maintained throughout.
opportunity
Stock Control Program
We need someone to design a user friendly basic stock control program in something like Microsoft Access. The data base will need a single user landing/interface page for recording changes in the stock level, the information required is Category Sub Category (Free Issue or owned) Item Name Quantity In Stock Unit - to show either single units or grams Price per unit Increase stock level (input number) Reason for increase - restocked / stock count / stock correction Decrease stock level (input number) Reason for decrease - Consumed / stock count / stock correction Supplier Stock Location Other information box. We will need to be able to generate reports showing stock levels and stock value that is searchable by category, sub category, item, supplier . We will also need to be able to show - minus levels
opportunity
UK B2B Data Scraping Expert 2
We need a UK B2B data scraping expert to extract business contact details from public online directories. Target sectors: Construction and building contractors, car dealerships, solar and renewable energy companies, estate and letting agents, recruitment agencies, aesthetics and cosmetic clinics, mortgage brokers and financial advisors, double glazing and home improvement companies, plumbing, electrical and HVAC contractors, security companies, waste management and skip hire, dental practices and private healthcare, hotels and hospitality businesses, solicitors and law firms, personal injury and no win no fee solicitors, gyms and fitness studios, driving schools and training companies. Target criteria: UK limited companies only, nationwide, an estimated 10 or more employees or staff would be ideal but not essential. Data points required for each business: Business name which must be a Limited company Decision maker name where available Job title where available Mobile phone number beginning 07 Email address Website URL Facebook URL Industry The URL link where the information was obtained from online which must show the companies mobile phone number 1. Please state in your proposal how many records you can deliver and at what cost. 2. Please provide a small sample so we can see if the project has been understood. 3. Due to a high level of time wasters, please do not bid on this project if you cannot do it exactly as described in the project description as you will not be hired. Thanks
opportunity
PX FML 0526
Develop a robust data feed integration to automatically export listings from the WordPress site https://paxtons.co.uk/ to https://www.farmmachinerylocator.co.uk/listings/for-sale/jg-paxton-and-sons-ltd-pity-me/farm-machinery/?LocationID=350006903008. Implement XML, JSON or CSV output including mandatory fields: unique ID, manufacturer, model, category/subcategory, description, year, price, images as absolute URLs, condition, plus relevant specs (HP, mileage, hours, axle config, emissions). Support URL pickup or FTP upload and ensure flexible field mapping, error handling and scheduling for automated updates.
opportunity
UK B2B Data Scraping
We need a UK B2B data scraping expert to extract business contact details from public online directories. Target sectors: Construction and building contractors, car dealerships, solar and renewable energy companies, estate and letting agents, recruitment agencies, aesthetics and cosmetic clinics, mortgage brokers and financial advisors, double glazing and home improvement companies, plumbing, electrical and HVAC contractors, security companies, waste management and skip hire, dental practices and private healthcare, hotels and hospitality businesses, solicitors and law firms, personal injury and no win no fee solicitors, gyms and fitness studios, driving schools and training companies. Target criteria: UK limited companies only, nationwide, with an estimated 10 or more employees or staff. Data points required for each business: Business name which must be a Limited company, decision maker name and job title where available, mobile phone number, email address, website URL, Facebook URL, sector, link to where information was obtained. Important requirements: All phone numbers must be checked against the TPS and CTPS registers before delivery. Any numbers registered on TPS or CTPS must be removed from the final list. Data must be delivered as a clean CSV file with no duplicates, ready to import into Pipedrive CRM. Phone numbers must be mobile numbers which begin 07 in the UK. Volume: Please state in your proposal how many records you can deliver and at what cost. Please confirm in your proposal: That you are familiar with UK GDPR requirements for B2B outbound calling data, and that all data will be sourced from publicly available sources only. Thanks
opportunity
Fleet Management
Design and build a cloud-based fleet management platform that centralizes vehicle, driver, maintenance, telemetry, and alerting data into a single operational system.
Consulta stock y movimientos paginas
Hola, busco algo muy sencillo con AI para ver tres paginas donde poseo claves de usuario. Ver en estas el stock de cada producto para ver cuales son los que mas tienen y revisar a la semana para ver los movimientos que han tenido de stock así saber cual es el que mas se rota
Past Projects
opportunity
Create template for schedules in excel with gantt presentation
I use smartsheet all the time but it only does daily and not hourly gantt bars. I want to basically have a template i can make a start date, add the format for the hours (ie 24 hour or just between certain hours) ideally dependencies not sure if that can work in excel and labels on the gantt bars - open to ideas and suggestions
REVERSING QUERIES ON MY DATABASE
I need an experiebced Database manager to reverse queries on my datbase for my website as requested by hosting account, I will need my database cleaned to function better and a excutable zip file of my website to be creared for me. Thanks. Mazi Ogbonna
Airtable Base and Form - Verification Only - No updates required
I have around 10 Airtable bases, which are currently set up but largely empty, and around 10 forms that feed into those Airtable bases. The purpose of this job is to check that the bases have been created correctly and that the forms are properly updating the relevant tables. I will provide: An Excel spreadsheet showing what each Airtable base/table is supposed to contain The Airtable base links The form links The job is to create two simple review tables and complete the checks below. Table 1: Airtable Base Review Create a table with the following columns: Base Name Airtable Base URL Review Notes Status For each Airtable base, please open the relevant Airtable link and compare it against the Excel spreadsheet I provide. Please check only that the Airtable has been set up correctly, including: Correct table names Correct column headings Correct field types Correct dropdown options Correct linked fields Any other requested fields or structure shown in the Excel spreadsheet This is a review only. You DO NOT need to rebuild the Airtable or make changes. In the review notes, write anything that is missing, incorrect, or unclear. If everything is correct, simply write: CHECKED - all present Table 2: Airtable Form Testing Create a second table with the following columns: Form Name Form URL Linked Airtable Base/Table Dummy Entry Submitted Result in Airtable Issues / Notes Status For each form, please: Open the form link. Submit a dummy test entry. Check whether the entry appears correctly in the relevant Airtable base/table. Confirm whether all submitted fields are captured correctly. Note anything that does not work properly. Delete the dummy entry afterwards so the Airtable is left clean. If the form works properly and updates the correct Airtable table, write: CHECKED AND WORKING If the form does not work properly, please write exactly what is wrong, for example: The form does not submit The entry does not appear in Airtable The entry appears in the wrong table Some fields are missing Dropdown selections are not being captured Linked fields are not working Data is going into the wrong columns Required fields are incorrect Any other issue found Final Output Required Please provide the completed two tables: Airtable Base Review Table Airtable Form Testing Table The aim is simply to confirm whether all bases and forms are correctly set up and working, and to identify any missing items or errors clearly
Lead Research: German-Speaking Content Creators (DACH)
Overview For a Marketing Project for growth and monetization for content creators in the adult entertainment space. We run targeted outreach campaigns on behalf of our clients and need a highly qualified, structured lead list of German-speaking OnlyFans creators from the DACH region (Germany, Austria, Switzerland) to contact via Instagram DM. Required Columns in Google Sheet 1. Creator Name 2. Instagram Handle (@username) 3. Instagram URL (clickable hyperlink) 4. Instagram Follower Count 5. OnlyFans URL (clickable hyperlink) 6. Link-in-Bio URL (Linktree, Wonderlink, Beacons etc. — if used) 7. OnlyFans Subscriber Count / Like Count (if publicly visible) 8. Email Address (if available in bio or Linktree) Where to Search — All Sources Where to Search — All Sources
Urgent Project: Full Database Extraction of via scrape
Overview We need a developer to build and run a scraping script that extracts all current records from the UK Government's Individual Insolvency Register (IIR). Register URL: https://www.insolvencydirect.bis.gov.uk/eiir/search This is a public government database published under the Open Government Licence v3.0, which permits reuse including for commercial purposes. We have had this data scraped successfully before, so we know it is achievable. What the Register Contains The register lists individuals currently subject to an Individual Voluntary Arrangement (IVA), Debt Relief Order (DRO), or Bankruptcy in England and Wales. Each record contains personal details and case information on a dedicated case detail page. Data Fields Required We need the following fields extracted for every record on the register and delivered in a single CSV/Excel file: FieldSource LocationNotesTitleCase detail page — "Individual details"e.g. Mr, Mrs, MsFirst NameCase detail page "Forename(s)"Last NameCase detail page — "Surname"Address Line 1Case detail page — "Last known address"Parsed/split from full addressAddress Line 2Case detail page — "Last known address"Parsed/split from full addressCityCase detail page — "Last known address"Parsed/split from full addressPostcodeCase detail page — "Last known address"Parsed/split from full addressDate of BirthCase detail page — "Date of birth"Format: DD/MM/YYYYTypeCase detail page — "Type" under Insolvency case detailse.g. Individual Voluntary Arrangement, Debt Relief Order, BankruptcyArrangement DateCase detail page — "Arrangement date" (or equivalent date field)Format: DD/MM/YYYY FirmCase detail page — Insolvency practitioner "Firm"The IP firm managing the case How the Register Works (Technical Context) No API exists - the data must be scraped from the web interface. The search page accepts a name query and returns paginated results. Search results URLs follow the pattern: /eiir/search-results/{base64_encoded_search_term}/{page_number} Each result links to a case detail page at /eiir/case-details/... containing all fields above in structured HTML. The site is server-rendered HTML (no JavaScript framework rendering), making parsing straightforward. The search term in the URL is standard base64-encoded text. Suggested Approach The typical method (which has worked before) is: Systematic search iteration - cycle through common surnames, alphabetical letter combinations, or other strategies to ensure full coverage of all records on the register. Collect all case detail URLs from paginated search results. Deduplicate case URLs (the same record may appear under multiple search terms). Visit each case detail page and parse the HTML to extract all required fields. Address parsing — split the "Last known address" field into Address Line 1, Address Line 2, City, and Postcode. Compile into a single CSV or Excel file with one row per record. Polite rate limiting (delays between requests) should be used to avoid overloading the server or triggering blocks. Deliverables The complete dataset as a CSV and/or Excel file, with all fields above, one row per record. The scraping script (Python preferred but open to other languages), so we can re-run this periodically. Brief documentation on how to re-run the script (dependencies, any configuration needed). Important Notes We need all records currently on the register, not just a sample. Please confirm your approach to achieving full coverage. The data is publicly available under the Open Government Licence v3.0. We have done this before and know it is achievable — please only apply if you are confident you can deliver. This is urgent - we need this turned around quickly. Please state your estimated delivery time when quoting.
Data Scrapping - Linkeding
Hello. again we are looking for an expert who source emails from Linkeding / other sources. Simple - we provide you a sample g-doc with required details (Name / Position / Company / email address / Country) - you fill in that file with contacts. Quality of work and efficiency will be taken in to consideration. For the start of project we may hire 3/4 experts for test work One or two will be offered a long term collaboration as we always need help on this field. For test period: 100 quality contacts - 10 euro. If you are interested, drop us a message happy to start. otherwise we may not reply to you. Good luck !
opportunity
Excel Database with dashboard
Create a polished, user-friendly Excel workbook to manage a property portfolio, including an intuitive dashboard summarizing key metrics and performance. Features: property list with ownership type, lease length, and use (long-term, serviced accommodation, renovate-to-sell); mortgage details (fixed-term expiry, total duration, interest rate); utilities and insurers with provider names and expiry dates; management companies and other critical contacts; key dates and alerts. Build dynamic charts, filters, conditional formatting, and simple formulas to track cashflow, ROI, occupancy, and upcoming expiries. Emphasize clarity, ease of use, and actionable insights. Some Visuals on the dashboard such as property locations on a global map and also performance metrics would be great if possible on the excel dashboard or linked powerBI
Data scrape from LinkedIN
I need Data from LinkedIN, what I need is a list of IT recruitment professionals based in the UK details from their profiles, I need: First/Last Name Company Job Position Email Address Contact Number
Extract links from google drive
I have a Google Drive folder with circa 1200 files saved within. Each file is names as a postcode. I want to extract the file names and the link to the file into google sheets. One column will be the file name. The other a hyperlink to the actual file. See screenshot below of start of sheet that i did manually. You'll obviously need to automate this given quantity of files. Post code can't have .pdf Link to the file must save in same way as shown in screenshot
opportunity
I need new features to the leads admin area of my website
Current goal: In the leads admin area, I want to create two separate lead lists from the main leads list shown in “Print Records.” Each lead should have an option in the dropdown area to assign it to one of these lists: Before Auction List After Auction List I want each list to be exportable as a PDF file and downloadable. I also want each list to be exportable as an Excel file and downloadable. The Excel download should include these fields: Owner’s Name Property Address Owner’s Address APN Auction Date County State Phone Email Property Taxes Owed or Minimum Bid Winning Bid Please review the website admin area first and let me know: Can you do this? How many hours do you estimate? What is your hourly rate or fixed price? Have you done admin/export features like this before? Can you work with PHP, HTML, forms, databases, PDF export, and Excel/CSV export? Must understand english well
I need a professional to Excel/database generation
Hi, I’m looking for an experienced data extraction / web scraping specialist to help build a large-scale Excel database from World of Books. Project requirements: • Extract product data from the website • Build a structured Excel database with the following fields: barcode, name, category, pricePristine, priceGood, priceFair, pricePoor, image_url • Pricing must be generated using the website trade-in/buying prices (NOT selling prices) Pricing logic: Pristine = website trade-in price Good = 50% less than Pristine Fair = 75% less than Pristine Poor = 95% less than Pristine • Download product images and rename them using: barcode.jpg • Image references must match correctly inside the database This is a large-scale project and may exceed 100K entries, so I’m looking for someone experienced with: web scraping data structuring Excel/database generation image automation batch processing Please send: • Relevant experience • Tools/languages you plan to use • Estimated delivery speed for large datasets • Example of similar scraping/database work completed Ready to start immediately.
Need a excel file created, certain fields from an website
So i need a excel database created, and filled out there are 5 main fields, and cross checked with prices, from a website and images downloaded. To then be uploaded as a bulk import. this is a large database creation, could be in the region of 100K entries.