Databases Projects
Looking for freelance Databases jobs and project work? PeoplePerHour has you covered.
featuredopportunity
Looking up terms in historical newspaper databases
The project is as follows: I have a complete list of quotes (around 150-120 quotes) that I would like to look up in old newspapers. I have two historical newspaper sources: https://www.britishnewspaperarchive.co.uk/ (for the UK) https://gallica.bnf.fr/html/und/presse-et-revues/presse-artistique?mode=desktop (for France) And i would like to start with the UK. The outcome I am looking for is a count of appearances of each of those phrases in each unique issue of each newspaper present in those historical databases. Is this something you are able to do? If so, could you please let me know what you would need from me (i.e. subscriptions), as well as how much it would cost to complete the task within a month of receiving the list of quotes? Thanks a lot for your help!
Upgrade MySql 5.7 to 8.0
I need to upgrade MySql 5.7 to 8.0 on AWS, including making changes to the database to get it to run on 8.0. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MySQL.html Could I have a price for this please? Thanks
an hour ago9 proposalsRemoteLastPass Administrator
We are seeking a skilled and experienced LastPass Administrator to join our team. The LastPass Administrator will be responsible for managing and maintaining our organization's LastPass password management system. The ideal candidate will have a strong understanding of cybersecurity best practices, experience with LastPass and the ability to effectively communicate and collaborate with team members. Responsibilities: • Set-up and configure LastPass accounts for users and the organization • Manage and administer the LastPass password management system for the organization • Collaborate with the team to integrate LastPass with other systems and tools • Provide training and support to employees on how to use LastPass effectively • Create and enforce password policies to ensure the security of sensitive information • Troubleshoot and resolve technical issues related to LastPass Qualifications: • Bachelor's degree in Computer Science, Information Technology, or related field • Proven experience as a LastPass Administrator • Strong knowledge of cybersecurity principles and best practices • Excellent communication and interpersonal skills • Ability to work independently and as part of a team • Relevant certification (e.g., LastPass Certified Administrator) is a plus Work Schedule: • Must be able to work during Central Standard Time Zone business hours. The team works between 9:00 am – 5:00 pm CST • Project completion: 2-3 weeks Fixed Rate: $200-$250, to be paid upon completion of the following: • LastPass users and organization accounts setup • Creation of LastPass administrator’s video guide • Creation of LastPass user’s video guide • Creation of FAQs
5 hours ago2 proposalsRemoteopportunity
Create backup scripts to backup MariaDB database
I have a 250GB MariaDB database (v 10.6) running on RHEL 9 - currently this is backed up using VMWare backups but they are not crash consistent. I have started using MariaBackup and it works fine but I need to automate the usage via bash scripting and crons. I have posted this under Databases as I need some advice on the best way to do this - currently I take a full once a week, then an incremental each night for 6 nights and then another full and so on. I do not run the prepare process during the backup/post backup stage. Currently full backup takes around 12 mins, incremental takes around 4 mins - prepare on the full backup takes around 90 minutes. Ideally I would like to be able to run backups every 4 hours - however, backups are easy and I need the best way to be able to recover/restore should this be needed and that is where advice part comes in. I have to have a full backup - so if I take a full on Monday at midnight and then 40 incrementals and I need to restore I assume this means I have to prepare and then restore 40 incrementals and 1 full backup which will be time consuming and complex etc So the ask is two fold - recommend the "best" backup/recovery regime for usage of MariaBackup based on 4 hours RPO and, ideally, 4 hour RTO. Secondly then write the bash scripts/crons to automate this so the backups happen without intervention including folder creation using date based naming conventions (e.g. dbname_date_time_inc or dbname_date_time_full etc), removal of old folders after a period of time and anything else needed to achieve what you set out above in recommendations (especially around making restores easier/quicker/preparation process). Note: this is NOT just writing some bash scripts so you need to know databases and ideally Mariabackup/Mariadb/Percona and/or MySQL. There is no system access available - you will need to create this locally and test etc then send to me to run in live
9 hours ago8 proposalsRemoteWeb Data Scraping
I need someone to fix a simple script to scrape data from zoopla.co.uk and into Excel format. I have attached an example of data someone has already extracted. There is also a photo of the simple .exe that was built in Python and I have the files still. This should be a case of fixing the links to Zoopla as these have changed since this was made. Please also let me know any questions. Thank you.
21 hours ago26 proposalsRemoteDesktop Support Engineer
Experience Required – 5-7 Years of Experience Primary Skill Required (SKU required) – End users service / Deskside support engineer. Secondary Skill Required (Skill required) - Basic understanding of Computing & Network Estimated Efforts - 2 days per week for 6 months. Project Location – Belgium (Malmedy)
3 days ago4 proposalsRemoteopportunity
Seeking a local web developer in UK - Yorkshire or North West
I'm seeking a trustworthy local developer in UK who is based in South Yorkshire or North West of England. To help finish my OnlyFans alternative platform using adent.io software. Experience using and woorking on adent software is an advantage. If you are based overseas it won't work. I need face to face and local meets from time to time to get this project over the line. Pricing to be agreed, but must be competitive.
4 days ago13 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.
7 days ago69 proposalsRemoteExpires in 23opportunity
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
7 days ago27 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.
7 days ago28 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.
7 days ago16 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.
7 days ago41 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.
7 days ago17 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’
9 days ago35 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.
10 days ago48 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.
14 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.
16 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.
17 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.
18 days ago36 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.
18 days ago10 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.
19 days ago43 proposalsRemote