
Databases Projects
Looking for freelance Databases jobs and project work? PeoplePerHour has you covered.
opportunity
Amendment of existing PDF template
Im looking for an expert on acrobat or Java to achieve the following on an existing template; 1. Enable functionality for a drop down option to change colour according to colour key. 2. Enable scroll function to work on a free text box after the document is locked for editing to share with recipient. 3. Advise on how to lock the document for sharing without paid version of acrobat.
2 days ago14 proposalsRemoteShopify Product Manager Required
We have 1000 products on Shopify and these need managing. The products are already on the store but they need SEO optimising, new descriptions, size guides adding, linking to related products and generally making better. This will be an ongoing project and there is the scope for a lot more work. Sensible offers from credible freelancers with excellent feedback only to apply.
6 days ago80 proposalsRemoteScraping email addresses
On excel sheet there are 1158 companies (not people in this database) as on sheet 3 'Key companies’ - if you can manipulate Excel you can also get the people’s name for each of these companies How much would it to be to get emails from this list of 1158 where obviously it will be much letter if we have john.smith@xxxx rather info@xxxx
6 days ago55 proposalsRemoteISPconfig conf files copy from plesk and set it up
There is a current admin who cannot getthe reverse proxy to work with ispconfig and apache 2 and nginx Hel p is needed urgently to help him? Immediate start tasks to do: 1. make ispconfig work 2. add domains with ssl-letsencrypt cert 3. make varnish and redis work with one specific domain Here we point the dns to the server so it can start delivering web pages again 3. move emails to to the ispconfig 4. move all over to the original live server if you have done it previously and are fast you can do it I installed ispconfig and got it to work in less than1.5 hours but then when adding ssl all messed up I installed mariadb, apache,nginx, dovercot, postfix and all what is needed
10 days ago12 proposalsRemoteMove websites to Ocean Digital from Vercel/Hostinger
I have two websites currently hosted on Vercel, and I’m looking to migrate them to DigitalOcean (I already have an account and one website set up there). I'm looking for someone who is familiar with DigitalOcean, particularly with managing Droplets and related services.
14 days ago33 proposalsRemoteSQL Database administrator
Role: Database Administrator Experience: 5 to 7 Years Location: Saket (Delhi) About The Company: At WeCredit, we partner with heading NBFCs to help Customers find the best online financial solutions, including quick and hassle-free loans. Our skilled team provides assistance every step of the way, from Completing your loan documents to ensuring fast disbursal of funds. About the Role: We are seeking a skilled and detail-oriented Database Administrator (DBA) to manage and maintain our company’s databases. The ideal candidate will have extensive experience in database management, performance tuning, and ensuring data integrity and security. As a DBA, you will be responsible for overseeing database systems, ensuring their reliability and performance, and supporting business applications Responsibilities: • Install, configure, and maintain database management systems (DBMS) such as MySQL, SQL Server • Design and implement backup and recovery strategies to safeguard data against loss or corruption. • Manage database security, including user access controls and data encryption, to protect sensitive information. • Diagnose and resolve database issues, including performance problems, corruption, and connectivity issues. • Work closely with developers, system administrators, and other IT staff to support application development and ensure seamless integration. • Apply software updates, patches, and upgrades to database systems as needed. Qualifications: • 5 to 7 Years of experience as a Database Administrator or similar role, with expertise in managing databases and performance tuning. • Proficiency in SQL and experience with DBMS such as MySQL or SQL Server. • Strong analytical and troubleshooting skills with the ability to resolve complex database issues. • Query Optimization. • Internal DB Level.
14 days ago21 proposalsRemoteopportunity
Create a project management database within Google sheets
I'd like to make a Project management database within Google sheets. This should have similar interactivity to the Airtable. The sheet should be able to input new project information in, with the ability to define a deadline, and assign tasks to employees. If that could also create a google task or give an email reminder deadline. With everything inputted, it would also need to have a timeline so that we can see the teamwork flow on a calendar style sheet
15 days ago36 proposalsRemoteUnix / Linux Server Back Up and Recovery Solutions Consultant
Looking for a consultant to set up and provide a step-by-step data backup and recovery process (with screenshots) for a Unix server and selected folders using open-source tools such as BorgBackup/Rsync, etc. The setup must include two backup types: (1) Mirror backup and (2) Tiered backups (4x daily, daily, weekly, monthly), with backups stored across three separate cloud vendors: Ionos, Azure, and Hetzner. The consultant should help us ensure the solution works end-to-end when we follow the step-by-step document provided, troubleshoot any issues, and perform a successful recovery test.
16 days ago15 proposalsRemoteI need a woocommerce product csv extracting from a mysql file
I have a mysql dump of an old websites database, I need all the products extracting in woocommerce csv format, ready to publish on the new website, the only products I need are out-of-stock, think there is around 4000 odd products In the CSV i need a find and replace in the images section from this tnsdiamonds.com to this 18.170.228.235
16 days ago49 proposalsRemoteData migration from Slack to Google Chat
Hi, I'm looking for someone to help with the migration of data from Slack to Google Chat this month. For 25 user active users
18 days ago38 proposalsRemoteopportunity
LearnDash questions downloaded to excel sheet.
We need all our 30, 000 questions downloaded onto an excel sheet so we can proofread them all and upload them onto a new LMS. This includes english and maths questions. Only bid if you definitely know a solution on how to do this and have experience with LearnDash before.
19 days ago18 proposalsRemoteopportunity
Database Design for our CRM
We require an experienced database designer to help optimize the backend architecture of our customer relationship management system. The current database which powers our Node.js based CRM platform is in need of restructuring to support scalability goals. The ideal candidate will have extensive experience designing relational databases using MySQL along with deep knowledge of database normalization techniques. As our systems see continuing growth, a redesigned schema is needed to accommodate more data and users efficiently. Some key objectives of this project include improving query performance, reducing data redundancies, enabling facets for advanced searching and reporting. The new model should follow best practices for security, integrity and maintainability. Applicants should detail their experience with comparable projects, outlining approaches taken to solve related challenges. Portfolios highlighting SQL design skills are encouraged. We welcome proposals from freelancers comfortable navigating both backend infrastructure as well as front-end CRM features.
22 days ago38 proposalsRemoteNeed help with Supabase - react native mobile app
I need an expert in Supabase to help with auth, triggers, iap and user tiers for my react native mobile app. Please include your years of exp with supabase and or react native in the first line of proposal - all proposals without this will be deleted.
24 days ago19 proposalsRemoteWant to get job done of email scraping.
We have approximately 12 thousand plus company name. We want extraction of authentic emails and company URLs. those who are ready to extract all complete set of emails should contact only. Emails must be authentic.
a month ago34 proposalsRemoteShopping list programme using Excel and VBA
I want to create a shopping list programme for personal use built on Excel with VBA to improve the UI Each week i want to create a shopping list from my database of products that will give me a list of products to buy from two shops, Aldi and Tesco. It should be prefilled with weekly or regular items and then pull from the database as i type the product and ask me quantities. when i print the front page should be Aldi items and the second page Tesco items i need to be able to add items to the "database" tab myself
a month ago20 proposalsRemoteURGENT: Create a Detailed Materials Tracking Log
We urgently require a well-structured Materials Log to help us track materials across various home renovation projects (bathrooms, kitchens, wardrobes, windows, doors, etc.). The log must be in Google Sheets and easy for our team to update in real time. It should help us track: • Job Reference Number (e.g., CR01500) • Customer Name • Installation Date • Project Type (Bathroom / Kitchen / Wardrobe / Windows / Other) • Material Type (e.g., Glass, Frames, Handles, Hinges, Panels, Worktops, Cabinets) • Supplier Name • Quantity Required • Quantity Ordered • Quantity Received • Delivery Date • Status (Pending / Delivered / Backorder) • Notes / Issues • Cost Price • Total Value of Materials for Job We want the layout to be clean, intuitive, and colour-coded if possible (e.g., red for delays, green for completed, yellow for pending). This sheet will be used daily, so speed, structure, and clarity are key. Skills Needed: • Google Sheets / Excel expert • Workflow/Operations understanding • Eye for detail and formatting • Quick turnaround (within 1-2 hours) What to include in your proposal: • Examples of similar tracking sheets/logs you’ve created • Estimated delivery time • Any suggestions you have to make this even more efficient
a month ago14 proposalsRemoteopportunity
Develop a Pricing table for Sales Team with Margin calculators
Freelance Excel Specialist Needed – Multi-Currency Pricing Table with SKU Images & Search Functionality We are looking for an Excel expert to develop a comprehensive pricing tool for our sales team, covering approximately 200 SKUs across three currencies (GBP, USD, EUR). This tool must streamline price calculations, display product images, and allow for quick searches by product name. Project Scope: ✅ Three Currency Sheets – Separate pricing sheets for GBP, USD, and EUR, with automatic currency conversion. ✅ Dynamic SKU Pricing – Automated calculations based on materials, customizations, and quantity. ✅ Image Integration – Ability to display product images next to SKUs. ✅ Search Functionality – Quick search/filtering by product name for easy navigation. ✅ Cost & Margin Calculation – Include built-in profitability metrics (cost, margin, and contribution calculations). ✅ User-Friendly Interface – Dropdown selections, conditional formatting, and structured layout for ease of use. Ideal Candidate: ✔ Proficient in Excel (advanced formulas, data validation, pivot tables). ✔ Experience with large datasets (handling 200+ SKUs efficiently). ✔ Knowledge of image embedding in Excel (linking or displaying product visuals). ✔ VBA/macros experience is a plus for automation and enhanced functionality.
a month ago34 proposalsRemoteProduct Professionals - Database
Looking to gather up 10,000 lines of data. + UK Based (Mandarin Speaking a bonus) - Manchester (Mandarin Speaking a bonus) - North West UK - North UK - England - UK Wide + Job Titles - Product Manager - Lead Product Manager - Chief Product Officer - VP of Product - DevOps Engineer (Must Speak Mandarin) - Senior DevOps Engineer (Must Speak Mandarin) - QA Tester (Must Speak Mandarin) - LinkedIn URL - Email Address if Available (not important) Will only pay $0.01 per line as it is just LinkedIn scraping.
a month ago23 proposalsRemote
Past Projects
Purchase of a High-Quality Realtor Database
I am looking for a professional who can provide or create a comprehensive and up-to-date database of realtors. The database should include key details such as full names, contact information (phone numbers, emails), company affiliations, locations, and areas of specialization (e.g., residential, commercial, luxury properties). It should be well-organized, preferably in a spreadsheet format (Excel or CSV), and contain at least 15,000 verified entries. Accuracy and relevance of the data are crucial, as this will be used for targeted marketing campaigns. Please specify the source of the data, ensure compliance with data privacy regulations (e.g., GDPR if applicable), and provide a sample of the database for review before final delivery.
Transfer from pdf to excel (data from annual reports)
Plesase kindly find attached some annual reports of a company. Please kindly transfer to P&L & the balancs sheet info from 10 years into an excel (1 Excel sheet for P&L and one for balance sheet) Each attached document entails the annual infos for 2 years. The 2023 report has the info for 2023 and 2023, the 2021 report has the info for 2021 and 2020, etc. For all 10 Years from 2023-2014 The annual statements are in german. Just so you know “balance sheet” = “Bilanz” and “P&L” = “Gewinn- und Verlustrechnung“ Please transfer alle rows (inkl the subrows) from the P&L as well as the balance sheet into excel. I please want the years in column and the line items in the rows. In total 5 annual reports. One as an example attached Can you kindly make a porposal? Unitil when can you deliver? today still? Very best, Felix