Database Projects
Looking for freelance Database jobs and project work? PeoplePerHour has you covered.
Discover call and onboarding assistant
We are seeking a highly skilled and experienced Call and Onboarding Assistant to join our team. As a member of our team, you will be responsible for making discovery calls via video link with new clients for a web design agency. The ideal candidate will have excellent communication skills, a professional demeanour, and a strong understanding of the web design industry. They must be from the UK and speak perfect English. Responsibilities: - Make discovery calls via video link with new clients for a web design agency. - Present our services and solutions to the clients. - Answer any questions the clients may have. - Close the deals by scheduling follow-up meetings. - Maintain a database of client information. - Collaborate with the sales team to improve sales strategies. If you are a highly motivated and experienced individual who is eager to join a fast-paced and dynamic team, we encourage you to apply for this position. Please submit your resume and a cover letter highlighting your relevant experience and qualifications.
13 days ago13 proposalsRemoteWebsite/CMS (with specific targeted website)
Website / Any E-commerce platform / Any framework Copy specific targeted website Like a property agent that list property photos and property details, we are an employment agency that list the candidate profiles. 1) Message us for the specific target website(s) that we want to achieve, 2) Any framework/platform that achieves our goal will do, as long as it is cloud, stable and speedy. Step 1) Job-finder filling up forms Step 2) Admin change and approve (hide all contact) Step 3) List of all Biodata/cv able search (database over) Step 4 ) Export pdf / word and share button Step 5) Issue sales invoice Step 6) PayPal, Stripe payment gateways. Please propose to us the estimated time and framework/platform. Many Thanks for your attention.
18 days ago50 proposalsRemoteopportunity
Power BI (6) - Balance Sheet Metrics
This engagement requires developing advanced Power BI reports and dashboards to analyze key balance sheet metrics. The client, a mid-sized financial institution, needs customized visuals created to provide insight into trends in their assets, liabilities, and equity accounts over time. The visualizations should enable leaders to make informed decisions by highlighting areas of strength and weakness. The freelancer will be given access to the company's financial database containing historical balance sheet data. Advanced DAX formulas and measures need to be written to calculate critical metrics like current ratios, debt-to-equity ratios, and days of inventory outstanding. Interactive reports and dashboards then must be designed visually compelling and easy to interpret. Conditional formatting and other data bars will aid in comparing performance to internal targets and industry benchmarks. Dynamic tiles and card visuals are preferred to deliver at-a-glance updates of key performance indicators. Line, bar and area charts should be employed to show patterns in accounts over recent years. A fully labeled organizational chart is required to breakdown asset and liability compositions. Roadmaps and planned initiatives need to be integrated to forecast expected impacts to financial health. The end product will be a sophisticated, role-based dashboard delivering transparent insights to aid strategic decision making. Strong Power BI and financial analysis skills are needed to complete this impactful pro bono project.
a day ago20 proposalsRemoteExperienced Mobile App Developer Needed for a Fitness App
I require an experienced mobile app developer to build a robust fitness tracking app for both Android and iOS platforms. The goal of this app is to create a one-stop solution for users to track their workouts, meals, weight, and activity patterns over time. Key features required include a modern and intuitive UI, ability to add customizable workout routines, barcode scanner for quick meal logging, integration with popular health trackers via APIs, meal planning tools, progress tracking reports, social features to follow friends, and a widget on home screen for glanceable metrics. Security and privacy of user data is of utmost importance. The developer should be highly proficient in either Kotlin/Java for Android and Swift for iOS. Experience building fitness, health or other data-focused apps is preferred. You will be responsible for the entire development lifecycle from designing UI mockups and database schema to developing all the features, testing, and publishing the app on Google Play Store and App Store. Regular communication on progress, addressing any issues quickly and delivering an app that meets quality standards are expected. This is a remote contract project with an initial timeline of 3 months but may extend depending on the requirements.
18 days ago77 proposalsRemoteOnline bookshop
Online Book Shop Summary Overview: Our online book shop aims to provide book enthusiasts with a convenient platform to explore, purchase, and engage with their favorite literary works. Utilizing a combination of Servlets, JSP (JavaServer Pages), HTML, CSS, and MySQL, we have developed a user-friendly interface that offers seamless navigation and an enjoyable shopping experience. Key Features: User Registration and Authentication: Users can create accounts and securely log in to access personalized features such as order history, wishlist, and account settings. Browse and Search Functionality: Customers can easily search for books by title, author, genre, or keyword. They can also browse through categories and view detailed book descriptions and cover images. Shopping Cart: Our platform includes a robust shopping cart system where users can add, remove, and update items before proceeding to checkout. Order Management: Users can track the status of their orders in real-time, from placement to delivery. They receive timely notifications and updates regarding order processing and shipment. Admin Dashboard: Administrators have access to a comprehensive dashboard for managing inventory, processing orders, monitoring sales analytics, and moderating user activity. Technologies Used: Servlets: Handle requests and provide dynamic content generation. JSP (JavaServer Pages): Enable the creation of dynamic web pages with Java. HTML/CSS: Structure and style the user interface for an engaging and visually appealing experience. MySQL: Manage the database to store and retrieve book information, user data, and order details. Conclusion: Our online book shop is more than just a marketplace; it's a community for book lovers to connect, discover new reads, and indulge in their passion for literature. By leveraging powerful technologies and intuitive design principles, we strive to deliver an unparalleled shopping journey that leaves a lasting impression on every visitor.
6 days ago18 proposalsRemoteMusic listening
I am looking to hire a freelance designer to develop a simple but elegant web application focused on music listening and discovery. The goal is to create an online portal where users can browse songs by genre, era, and artist. They should be able to stream full tracks directly within the site or save songs to personal playlists for later enjoyment. The core functionality needed includes an intuitive interface for navigating a catalogue of songs drawn from various streaming services' open databases. Users must be able to search for songs by partial titles, artists, or other attributes. Playback controls are essential to allow starting, pausing, rewinding or fast-forwarding through tracks. Beyond just playing individual songs, the ability to create public or private playlists would add value by letting users customize musical collections. A clean, visually appealing design is important to enhance the user experience. The color scheme, layout, typography and other aesthetic elements should seamlessly support interactivity with the music. Responsiveness across devices is also a priority, as the site needs to perform and appear nicely on both desktops and mobile phones. Account registration, personalized profile pages, social sharing options and purchase/subscription features could potentially be added in future if the initial rollout is successful. The goal is to create a tasteful yet technologically sophisticated platform for music lovers to discover new favorites, revisit old ones and connect over shared tunes. Strong skills with
20 days ago9 proposalsRemoteopportunity
Multilingual IVR SMS AI Support Bot
Hi! we need AI-based IVR and SMS Chat bot to answer to calls and SMS while calling a number like 333 or sending SMS to SC like 333 with questions. We are receiving a call traffic landing in the customer care department (around 110K calls daily). As per the call traffic analysis, the majority of customers are seeking Information or requesting activation and deactivation of products. To reduce this traffic we are going to implement an AI solution that could efficiently interact with customers over the texts and voices (something like virtual agents) to deflect a remarkable portion of calls from live agents. Thus, we look forward to receiving a proposal along with the PPT in this regard if you are interested and have the solution available. The AI should understand the IVR/SMS, process and reply customers in regards to available offers, activating/deactivating data bundles, packages, changing SIM tariff plans and etc. The platform should convert Speech to text and vice versa. Log the call details in Database/logs and be able to integrate with different platforms for targeting and service provision. Pls analyze above information and let me know if you can propose a working solution. Also let us know which soft/cloud/AI technologies will you use for this solution so that we understand the feasibility of your proposal. Besides of product and tech design description please let us know the price for the proposal. P.s the solution should be hosted on our servers and we should be able to manage/configure new services activation/deactivation and have detailed reports. Awaiting to hear from you soon. Best regards
22 days ago17 proposalsRemotePython ETL Expert Needed for Data Transformation Project
Hello We're looking for a skilled Python ETL expert to assist us with a data transformation project. Our goal is to extract, transform, and load data from various sources into a structured format for analysis. We need someone with experience in automating ETL pipelines, handling data quality issues, and ensuring seamless integration. Key Responsibilities: Retrieve data from all sorts of places – databases, APIs, and flat files. Work on raw data, making it clean, consistent, and accurate. Handle missing values, normalize data, and some feature engineering. Load the transformed data where it belongs, ensuring it gets along with our storage solution. Test and validate, ensuring our data stays true to its transformed self. Proven experience in Python development with a focus on ETL processes Strong understanding of data extraction, transformation, and loading best practices. Previous success in automating ETL pipelines for efficient data processing. Excellent problem-solving skills and attention to detail. Python Expertise: Proven experience in Python development with a focus on ETL processes. A deep understanding of data extraction, transformation, and loading best practices. A track record of successfully automating ETL pipelines for efficient data processing. Excellent problem-solving skills and meticulous attention to detail. Delivarbles: structured and organized CSV files, each containing accurately transformed, structured data. An automated and efficient ETL pipeline that can be easily maintained. Regular updates on project progress, ensuring we're always on the same page. If you're a Python ETL expert looking for an engaging project, we'd love to hear from you! Please send a propsal detailing your relevant experience, a brief overview of your approach to ETL projects, and any examples of past work.
18 days ago16 proposalsRemoteopportunity
Keyword Research Web Tool
I am building a Web application that helps businesses and website developers conduct keyword research to find all the keyword phrases typed into search engines, search volumes of the phrases, and categorize them in terms of high, medium or low competition. The basic features are: 1) Enter a phrase or query in a search field. 2) Select your country from a dropdown list of countries 3) Select your language from a dropdown list of countries 4) Select the search engine from four options, Google, Bing, YouTube and Amazon 5) Upon clicking the Enter button, the app connects to the search engine database and extracts the results. 5) The results are presented in 3 ways and will be exportable via CSV, Google Sheets or PDF: i) Visual Wheels ii) Lists iii) Alphabetical tables 6) The user can create projects and store several searches within the projects. Frontend Development Technologies: ReactJS or Vue.js D3.js or Highcharts Bootstrap or Tailwind CSS Backend Development Technologies: Node.js with Express.js Python: For more complex data processing or interaction with search engines' APIs. Database Technologies: MongoDB API Integration Custom API Development: For extracting search volumes and competition categories. Authentication and Authorization Technologies: OAuth and JWT (JSON Web Tokens): For managing user logins and securing sessions. Payment Gateway Integration Stripe or PayPal: To manage the subscription payments. Cloud Services and Deployment AWS or Google Cloud Platform: For hosting. Export Functionality Libraries or APIs for generating CSV, Google Sheets, and PDF formats will be necessary.
a month ago30 proposalsRemoteopportunity
Tidy the server from X-ransom attack
Hello, Our Wordpress website was attacked by x-ransom. We have a backup of the WP and the database dump. We have detected some corrupted files there but it seems that there are still some left that were not detected. It has to be tidy after the attack. It’s an internet shop with uploads files of around 100GB. It’s stored on a private hosting in LV. What is done do far: 1. Update WordPress Version 2. Use z’d updateSecure WP-Admin Login Credentials 3. Set Up Safelist and Blocklist for the Admin Page 4. Use Trusted WordPress Themes 5. Install SSL Certificate 6. Remove Unused WordPress Plugins and Themes 1. Enable Two-Factor Authentication for WP-Admin 2. Back Up WordPress 3. Limit Login Attempts 4. Change the WordPress Login Page URL 5. Log Idle Users Out Automatically 6. Monitor User Activity 7. Check for Malware - found several none-Wordpress specious files and plugins. Deleted them. 1. Disable PHP Error Reporting 3. Turn File Editing Off 4. Restrict Access Using the .htaccess File 5. Change the Default WordPress Database Prefix - not done 6. Disable XML-RPC 7. Hide the WordPress Version 8. Block Hotlinking - not done 9. Manage File Permissions not done After making the list, we received another x-ransome attack. I suspect he has a server level access not only wp level. If you apply, you need to be a server security and a Wordpress specialist. Please, quote for the job.
2 months ago18 proposalsRemoteopportunity
Automated Semantic Text Analysis Pipeline
Comprehensive Use Case Specification: Automated Semantic Text Analysis Pipeline Objective Develop an automated semantic text analysis pipeline that processes and analyses textual data extracted from documents. This pipeline enriches text with metadata for deeper insights and enables semantic search capabilities through a user-friendly interface. This stage of the project is for a MVP system should leverage AWS services such as Textract for text extraction, a text categorising stage with a simple to use GUI, all-mpnet-base-v2 for embedding, and Postgres with a vector extension. This job posting is for the MPV stage only, but we must be mindful of the stage two development and facilitate rapid and straightforward scalability in any stage one MPV processes. System Overview The solution encompasses AWS services for storage and processing, a custom interface for metadata enrichment, all-mpnet-base-v2 for generating text embeddings, Postgres and a vector extension for efficient storage and retrieval of vectors, and a custom-built web interface for user interaction. RAG will be implemented with a broad a context as possible to the model across a large document set. Phase 1: MVP Stage 1. Document Storage and Processing Trigger - Tool: Amazon S3. - Process: Upload documents (PDFs initially) to designated S3 buckets, documents will be remained in accordance with a set naming convention and key metadata relating to the document entered into the database for future reference. This triggers the subsequent text extraction process. For test purposes the uploads will be made manually, and at later stages a web scraper will be added that automatically places PDF documents into relevant S3 buckets. 2. Text Extraction - Tool: AWS Textract. - Process: Text is extracted from uploaded PDF documents and temporarily stored in A3 buckets to facilitate further processing. 3. Text Enrichment Developer to advise on best method of adding labels / categories to the text, via an easy to use interface. Labels to be added at a granular level to allow the return of text snippets, providing context to the LLM in formulating it's responses from a broad range of documents without exceeding the token limit. 4. Text Vectorization - Embedding tool: all-mpnet-base-v2 - LLM: Amazon SageMaker (using LLaMA 2). - Process: The text is processed with LLaMA 2 to generate vector embeddings, capturing semantic information for advanced analysis and search functionalities. 5. Vector Storage - Tool: Postgres with a vector extension - Process: Text vectors are stored in the database, allowing for efficient management and retrieval of vectorized data for semantic searches. 6. Front-end Web Application and Search Functionality - Front-end Technology: React.js. - Key Features: - Semantic search input and results display. - email input field for collecting contact information for marketing purposes, forwarding to the client's email address. - Homepage containing descriptive marketing text. - 3 pages total: home page, interaction page, contact page, plus a pop up with GDPR info. Graphics provided as template guidance. - Back-end Technology: Python with FastAPI. Phase 2: Full Automation and Scaling 1. Automated Document Ingestion - Process: A web scraping tool is implemented to automatically identify and upload new documents to the S3 bucket, facilitating a continuous flow of data into the pipeline without manual intervention. 2. Scalable Architecture - Deployment: The application components are containerized using Docker and managed with Kubernetes (Amazon EKS), ensuring the system can scale efficiently to accommodate increased data volumes and user queries. 3. Enhanced Processing Capabilities - Improvements: Integrate additional NLP and ML models for broader and more nuanced text analysis. Consider fine-tuning custom models for specific domain applications. 4. User registration and user management system integration. Please note the attached contract agreement that will be deemed agreed to upon acceptance of the project. Your price given on PPH will be deemed to be your full and final price, and you will be deemed to have fully understood the scope, brief, and specification. To provide context, the project business plan has been uploaded. This is for context only and does not form part of the brief.
21 days ago11 proposalsRemoteopportunity
Local Council Chatbot utilising Llama2 and dataset of PDF docs.
Full stack developer with relevant experience in AWS services and LLM deployment. Description Develop an MVP that provides a chat interface allowing users to query a dataset of local council documents, which will variously include minutes and policy documents. A dataset that contains all information relating to the purpose, policies, news, information, and decision making by that council. The dataset would contain approximately 100 PDF documents, and the chatbot would return meaningful and coherent answers to user prompts, while providing reference links to documents that information in the response is taken from. The client acknowledges the current limitations of LLMs in returning responses from queries across multiple documents, especially given current token limits and processing cost restrictions. A developer is sought that can leverage techniques to embed metadata in the text, allowing techniques such as RAG to extract snippets of data from multiple documents relating to the query and collate them into a response to the user, while adhering to token limits. Objective Develop an automated semantic text analysis pipeline that processes and analyses textual data extracted from documents using Llama2. This pipeline enriches text with metadata for deeper insights and enables semantic search capabilities through a user-friendly interface. This stage of the project is for a MVP system, leveraging AWS services such as Textract for text extraction, a text categorising stage with a simple to use GUI, all-mpnet-base-v2 for embedding, and Postgres with a vector extension. This job posting is for the MPV stage only, but we must be mindful of the stage two development and facilitate rapid and straightforward scalability in any stage one MPV processes. System Overview The solution encompasses AWS services for storage and processing, a custom interface for metadata enrichment, all-mpnet-base-v2 for generating text embeddings, Postgres and a vector extension for efficient storage and retrieval of vectors, and a custom-built web interface for user interaction. RAG will be implemented with a broad a context as possible to the model across a large document set. Phase 1: MVP Stage 1. Document Storage and Processing Trigger Tool: Amazon S3. Process: Upload documents (PDFs initially) to designated S3 buckets, documents will be renamed in accordance with a set naming convention and details of the document entered into the database. This triggers the subsequent text extraction process. For test purposes the uploads will be made manually, and at later stages a web scraper will be added that automatically places PDF documents into relevant S3 buckets. 2. Text Extraction - Tool: AWS Textract. - Process: Text is extracted from uploaded PDF documents and temporarily stored in A3 buckets to facilitate further processing. 3. Text Enrichment Developer to advise on best method of adding labels / categories to the text, via an easy to use interface. Labels to be added at a granular level to allow the return of text snippets from within the chunks of data, but with relevant metadata. The purpose of this is to provide context to the LLM in formulating responses from a broad range of documents without exceeding the token limit. 4. Text Vectorization • Embedding tool: all-mpnet-base-v2 • LLM: Amazon SageMaker (using LLaMA 2). Process: The text is processed with LLaMA 2 to generate vector embeddings, capturing semantic information for advanced analysis and search functionalities. 5. Vector Storage Tool: Postgres with a vector extension Process: Text vectors are stored in the database, allowing for efficient management and retrieval of vectorized data for semantic searches. 6. Front-end Web Application and Search Functionality Front-end Technology: • React.js. Key Features: • Semantic search input and results display. • email input field for collecting contact information for marketing purposes, forwarding to the client's email address. • Homepage containing descriptive marketing text. 3 pages total: home page, interaction page, contact page, plus a pop up with GDPR info. Graphics provided as template guidance. Back-end Technology: • Python with FastAPI. 7. Fine Tuning Allow for fine tuning based on a series of questions and responses to be provided by the client, until such point that coherent responses to queries are achieved. Phase 2: Full Automation and Scaling Beyond the scope of this job. Notes: The developer is to provide guidance and feedback on the capabilities of the technologies and is free to provide their own guidance and suggestions. However, the functionality of the system in providing coherent responses based on text snippets drawn from a large dataset is both the challenge and the absolute requirement. Please only bid with your full and final price. Placeholders will not be accepted. Completion with approximately two weeks. Please respond by explaining how you would handle the text enrichment?
21 days ago17 proposalsRemoteopportunity
Existing website redesign
Hello! I'm looking for someone to redesign one of our websites. Design, graphics design and function changes are all needed. I'm looking more for a long time relationship with the developer / agency because there are other tasks and websites are in the pipeline, so a month or week based quote would be nice. Used frameworks, languages and software: Backend: PHP 7.4.33, Laravel 8, MariaDB Frontend: HTML, CSS, Javascript-JQuery Server: Debian 11 Website: https://vip.maxlomp.com/ What I would like to change on the website: The whole website should be usable both from desktop computer and mobile phone. Home page: - some of the text needs to be changed for sure, but I can do that on my own - the design should be changed, especially the mobile version, right now there is no incentive for a visitor to proceed with registration or anything Menu page / movie scene list: - because we will have much more movie scenes here (around 200) we will need paging, show 10 movies on each page - the design should be much better, right now it is uninteresting and too simple - we should be able to show title, short description, length, main image, 2-4 images for each individual movie - I also need a ?block? to the top of the website where we can put marketing messages, image slider etc. like we are doing on graias.com now - if they click on the movie title or the images or a button they should be linked to the movie sub page - there should be a “Watch this” button which will bring you to the membership purchase page next to each movie (if he is already a member just go to the movie subpage where they can actually watch it) - good example: https://graias.com/preview Movie details subpage: - we need such a page for every movie we will have on VIP MaxLomp - a good example of what we are looking for: - https://graias.com/video/healing-pain---part-2/337 - we need to show: title, description and length of movie, trailer video, gallery of images - if he doesn’t have an active membership there should be a button here that sends him to the membership purchase page - if he has an active membership he can watch the movie here (streaming inside the website), for this the video streaming server is already finished only embedding the streaming link is necessary Membership purchase page: - here a logged in user can select 3 types of memberships (one month, three month, one year) and request payment details for such a membership (right now we do Paypal, Bank transfer and Crypto payments) - so there are 3 types of membership and 3 different way to pay for them - there should be ample room to add marketing text to the page also where we tell them about what we offer, the different memberships etc. - kind of good example: https://graias.com/subscribe What we already have for sure and no need to code it again: - streaming server for movie playback - the way to handle payments (we can discuss this later) We also have the source code of the website and the database. Because this is a website that already works the migrations for the website should take this into consideration (do not delete anything but alter for new needs).
a month ago45 proposalsRemoteSeeking a Highly Skilled Virtual Assistant to Support Our Team
CBH Group Ltd is seeking a skilled Virtual Assistant to support our team in administrative and organizational tasks. As a Virtual Assistant, you will play a pivotal role in ensuring smooth operations and efficient communication within our organization. you will be in charge of Conducting research and preparing reports or presentations, Managing and maintaining the organizations databases. The ideal candidate must have experience as a Virtual Assistant or in a similar role, and also Proficient in using productivity tools such as Microsoft Office and Google Suite. time is flexible also. To be considered for this exciting opportunity as a Virtual Assistant, please submit your proposal, We welcome individuals who are detail-oriented, highly motivated, and dedicated to delivering exceptional support.
2 months ago36 proposalsRemote