Databases Projects
Looking for freelance Databases jobs and project work? PeoplePerHour has you covered.
opportunity
Migrate my Access application to Azure
Help me migrate my Access application to Azure and show me how to update the app once it is on the Azure platform. Reply only if you have successfully done this before.
2 days ago11 proposalsRemoteopportunitypre-fundedurgent
CSV Bulk upload for Shopify Store
We require assistance uploading a large volume of product listings to our Shopify ecommerce store in an efficient manner. The candidate must have expertise utilizing the Shopify admin interface and be well-versed in the platform's product and variant structure. A CSV file containing all relevant product information for hundreds of SKUs needs to be formatted and parsed to populate our online catalog in accordance with Shopify's standards. Experience formatting CSV files specifically for Shopify bulk uploads is preferred. The goals of this project are to automatically ingest our product dataset, associate variants and metafields like sizes and colors to their parent listings, set the proper prices, inventory levels, images and other relevant fields. This bulk upload should leverage Shopify's API functionality to programmatically replicate our existing product assortment in the most seamless way. Strong attention to detail and accuracy will be crucial when migrating such significant product information. Expertise with Shopify's product and variant schema as well as familiarity with their CSV import template will be invaluable for a project of this scope and size. Documentation of the process and any caveats/limitations encountered is expected. We request bids from Shopify professionals well-versed in performing large-scale data imports who can help maximize our catalog content and replication.
2 days ago60 proposalsRemoteExpires in 27opportunity
Aws maitnenace and postgres upgrade
Hello, I am looking for a certified AWS developer or someone very experienced in managing AWS instances and platform maintenance which includes upgrading our databases from Postgres 11 to 16 For those with experience in Java development, there are additional development opportunities for ma This could be an exciting prospect for your career growth. Must have skills Aws certified or proven expériences in managing Aws instance Java stud 1 expert Available during UK working hours bonus skill. experience in implementing stripe Payment gateway
2 days ago21 proposalsRemoteDatabase Creation
We seek the advice from a database specialist to advise on what system to use and create the database for our business. We need a system that: 1. We upload email address and identify what file uploads (from a predetermined list) is required ie insurances, risk assessments etc 2. Email is then sent to each of the lists asking for their information 3. Person receiving email uploads requested files to a form and submits 4. We check the documents and approve each one of them, if some are missing or files have not been uploaded, we can tick for email reminders to be sent out. 5. Summary sheet to be able to run off as a pdf chart for client 6. Ideally files would be stored into individual contractor folders onto google drive for easy retrieving 7. Ability to connect for a document to be sent through the database, through Docusign for signing Have been looking at team desk.net but not set on any particular system. Although all of our file storage and email is currently with google, should be beneficial to be compatible.
2 days ago21 proposalsRemoteKPI Document Creation
We are looking for someone to turn a spreadsheet complete with backdated and current business data into a KPI document. Please provide us with quotes for this and examples of what it will look like and include.
2 days ago12 proposalsRemoteMass Data Upload
We are looking for someone to backdate 18 months’ worth of business data e.g. service, charges, outgoings etc. into a spreadsheet. Please provide us with a quote and how long this is likely to take you. With this approximate information, we’ll be in touch with more details about what the job will involve.
2 days ago55 proposalsRemotePart-Time Google Sheet Specialist Needed!
Are you a Google Sheets expert looking for a part-time opportunity to showcase your skills? We are seeking a talented individual to join our team as a Google Sheet Specialist. If you have a knack for managing data, creating complex formulas, and automating tasks in Google Sheets, we want to hear from you! Flexible hours and competitive compensation. Apply now! Key Responsibilities: *Create and maintain Google Sheets templates for various business functions, including sales tracking, budgeting, and project management. *Manage large datasets in Google Sheets to extract meaningful insights and trends. *Develop and implement complex formulas, scripts, and macros to automate repetitive tasks and streamline workflows. *Collaborate with cross-functional teams to gather data requirements and ensure accurate representation of information in Google Sheets. *Generate customized reports and dashboards to visualize data and facilitate data-driven decision-making. *Stay updated on new features and functionalities in Google Sheets to optimize usage and enhance productivity. Requirements: *Proficiency in Google Sheets with advanced knowledge of formulas, functions, and pivot tables. *Strong analytical skills with the ability to manage and interpret data effectively. *Experience in automating tasks using Google Apps Script or other scripting languages. *Excellent attention to detail and organizational skills, with the ability to prioritize and manage multiple tasks simultaneously. *Effective communication skills with the ability to collaborate across teams and present findings in a clear and concise manner. *Flexibility to work 10 to 15 hours per week with availability for ad hoc tasks as needed. *Compensation is TBD Preferred Qualifications: *Experience working with Google Workspace (formerly G Suite) applications, including Google Docs, Slides, and Drive. *Knowledge of data visualization tools such as Google Data Studio or Tableau. *Previous experience in a similar role or working with data analysis tools/software.
2 days ago33 proposalsRemoteopportunity
Query Optimization Across Database Systems
I'm seeking guidance on understanding SQL Execution Plan reports generated by Dbeaver or similar tools. While I used these reports extensively over a decade ago, I've lost practice. Now, I need to optimize the time for a specific SQL set, and revisiting these reports with an expert will help refresh my understanding and enable me to make improvement suggestions. I do not expect the freelancer to change existing scripts or access the DB but be able to make suggestions looking at the execution plans and the SQLs that will be delivered by me. Here the aim is to help me to remember how to do this so that I can do these evaluations and find bottlenecks myself.
3 days ago14 proposalsRemoteOnline populated database
I need a database that can be populated by people entering data online - each person will probably only ever enter one set of data. Some data items will be shortbnarrative, some multi choice yes/no, some images. The database may run to 20,000 ‘lines’
4 days ago34 proposalsRemoteExcel graphs and charts to be made
I need three graphs to be done from an Excel spreadsheet including a scatter categorical chat (71 items) and two pie charts.
5 days ago44 proposalsRemoteExcel Work
I need some database and excel work done.
5 days ago93 proposalsRemoteKanban Stock Card Generator
A Kanban stock card generator is a tool used in the Kanban methodology to manage inventory and production. It consists of cards that represent tasks or items in a workflow, and it helps to visualize the progress of tasks and identify bottlenecks. The freelancer will be responsible for building a Kanban stock card generator in Excel, which will enable users to create and print cards. The freelancer will need to have experience with Excel and mail merge, as well as a good understanding of the Kanban methodology. The project will involve the following steps: 1. Review the source file and layout for the Kanban stock cards. 2. Build a functional Kanban stock card generator in Excel. 3. Ensure that the generator is user-friendly and easy to use. 4. Implement features such as card printing and customization. 5. Test the generator thoroughly to ensure that it works correctly. 6. Provide documentation and support to users. The freelancer will be paid based on the project's scope and complexity. We are open to discussing a fixed price or a hourly rate. If you are interested in this project, please submit your proposal, including your experience, skills, and estimated timeline for completion. We look forward to working with you on this project.
9 days ago20 proposalsRemoteopportunity
Microsoft Access Database to Microsoft PowerApps
As the title explains, i would like to have my clients MS Access database moved over to an up-to-date solution. I've read a lot about Powerapp / PowerBi. Initially, I'd like to have a detailed conversation with you to go through what's required and hear your suggestions. Currently, the backend of the database is hosted on Microsoft Azure. Any questions, please just ask. Thanks.
11 days ago19 proposalsRemoteEnhanced Accountancy Website Features
Project goal: Integrate advanced features into an existing accountancy website for improved functionality and user engagement. Scope of work: - Integrate a database for various fee packages and pricing options. - Develop an online signing-up process for easy user registration. - Set up an online Direct Debit (DD) process for both fixed and variable payments. - Integrate scheduling tools such as Calendly. - Develop a secure client login/area by integrating Accountancy Manager. - Implement other basic tweaks and changes as needed for website enhancement. Budget: Kindly quote a fixed fee. Additional information: - Open to creative IT skills and ideas for website development. - New ideas for website enhancement are welcome.
12 days ago29 proposalsRemoteopportunity
Development of an Online Database Using Open Source Data APIs
We are seeking proposals for the development of an online database capable of holding and managing a substantial amount of data, with advanced search functionality. The database will be populated and continuously updated using several open-source data APIs. Our existing database contains approximately one million business records, which we seek to enhance and expand through this project. Project Requirements: 1. Database Development: • Design and develop a scalable online database to hold a large volume of data. • Ensure the database supports advanced search capabilities to quickly and efficiently query against the stored data. 2. Data Integration: • Access and extract data from multiple open-source data APIs. • Integrate and normalize data from these sources into a unified format within the database. • Ensure data is regularly updated and synchronized with the latest information available from the APIs. 3. Data Management: • Populate the existing base of approximately one million business records with additional relevant data from the APIs. • Ensure data quality and consistency, removing duplicates and correcting inaccuracies. 4. Technical Specifications: • The database should be accessible online with a user-friendly interface. • Support for exporting data into standard formats such as CSV for offline analysis. • High availability and performance to handle large-scale data queries and updates.
13 days ago35 proposalsRemoteopportunity
Create an extension to extra images from a app using API
We are looking for a skilled freelancer to develop an extension that seamlessly integrates with a delivery app's API. The extension should enable users to extract data about their orders, including images, effortlessly. The primary objective is to automate the process of downloading and organising these images into an Excel sheet. The freelancer should have a solid understanding of the work required. They should be able to work independently and meet deadlines. Experience with similar projects and a portfolio of successful work is highly desired. If you have the expertise I encourage you to bid on it.
13 days ago11 proposalsRemoteYoutube URL scrapping
I need someone to scrap youtube URLs from song titles in a .csv file. It will be an extensive list of around 7,500 - 10,000 titles. I want the URLs added to the URL column in the csv and the file returned.
15 days ago42 proposalsRemoteWebsite Deployment Though Fillzilla
front end Is Next.js, Backend in Node.js and Database in MongoDB i have build for of next.js which is already upload but i can not seen output on IP address
18 days ago19 proposalsRemoteopportunity
Database Administrator / Back-end Developer Required
Hi, I am looking for a Database Administrator / Back-end Developer to complete the given below requirements: Scenario: 1. The store is based on Magento 2.4.6-p3 with all necessary server requirements such as Nginx 1.22, MariaDb 10.6, Varnish cache 7.3, php 8.1, Composer 2.2, Elasticsearch 8.5, MySQL 10.6, RabbitMQ 3.11, Redis 7, etc. 2. The website is hosted on CCX53 on Hetzner Cloud: 32 CPU, 128 GB RAM (dedicated resources) Here are the details of the products present in the database: 1. The store has 320 million products in 411 GB database. There are no product attributes, or variables. Just simple products. 2. There are no product images 3. Each product is a company information page i.e. the products are digital and it provides information on companies globally. I will share the sample product page link once you submit your proposal. Magento Modules Installed and configured: 1. Amasty Elasticsearch: https://amasty.com/elasticsearch-for-magento-2.html 2. Amasty Google Speed Optimiser Pro: https://amasty.com/google-page-speed-optimizer-for-magento-2.html 3. Amasty Varnish Full Page Cache Warmer: https://amasty.com/full-page-cache-warmer-for-magento-2.html Requirements: 1. Import the product database of 411 GB database. I will provide the database in SQL format. 2. Optimise the Elasticsearch and page load 3. We expect 100 concurrent users anytime throughout the day 4. Elasticsearch should index all the products 5. Optimize website performance. Current score on Google page speed insight is 47 on mobile and 83 on Desktop. 6. Product search result should be less than 3 seconds 7. Suggest if the job requires server change
19 days ago23 proposalsRemoteopportunity
Develop a simple carbon caculator
Good morning , We are looking for a developer to develop a carbon caculator. The work is a fast turnaround and should be completed by 20th May. We have spreadsheets with back end data and formulas. It should be easily updated with new data available on the free data on Government website. This is just for scope one and two of caculator which is quite simple. The below link shows an example of what we need developing. We want to provide free access like Greenly. The final page can reveal the result. https://greenly.earth/en-gb?utm_term=carbon%20calculator&utm_campaign=1:+SN+%7C+2:+Acquisition+%7C+3:+Search+Generic+Carbon+UK+google+%7C+4:+UK&utm_source=adwords&utm_medium=ppc&hsa_acc=8929442750&hsa_cam=15453379597&hsa_grp=135745822249&hsa_ad=580573821047&hsa_src=g&hsa_tgt=aud-1962306165324:kwd-298447716438&hsa_kw=carbon%20calculator&hsa_mt=b&hsa_net=adwords&hsa_ver=3&gad_source=1&gclid=CjwKCAjwrvyxBhAbEiwAEg_KgnSACrRF3uny2vlBuN356Qmh-dECqos_KMuiSpCceY3wXEu1QQsJ-hoCoSoQAvD_BwE Here is a second example although we want it to look like Greenly. https://www.carbonfootprint.com/calculator.aspx The carbon caculator should be easily updated with new data published each year. This is the new data on the excel https://www.gov.uk/government/publications/greenhouse-gas-reporting-conversion-factors-2023 We can provide formulas. We need passwords and access when project is complete. Thanks, Luke
22 days ago45 proposalsRemote