Sql Server Indonesia Projects
Looking for freelance Sql Server Indonesia jobs and project work? PeoplePerHour has you covered.
opportunity
Creating a SQL database on Google
We are a marketing agency that has built our own custom software. in the course of the upgrade, we are looking to update the location of the database from zapier tables to Google SQL database. We have 12 tables of information that we would like to be newly formatted on Google SQL. You don't need to help with the transfer of data, this would just be about making sure that the SQL database is properly set up. We need a setup of the Google SQL to be able to properly store the 12 tables worth of information, with each field having formatting rules that they would follow. What's more, we will be having AI read from this, so if the data is not properly formatted we would need a rule to revert the data to something that won't confuse the AI.
7 days ago25 proposalsRemoteopportunity
Moodle Local Server Installation
We are seeking a skilled Moodle web developer, preferably located in the United Kingdom or Cameroon, to assist us in installing a local copy of our Moodle website on standalone laptops or PCs. Our current main website is located at opeflearning.com, and we require assistance in creating identical local versions of this website, encompassing the setup of a server/database and the duplication of website files. The local copy should be fully functional and operate independently without an internet connection on the laptop where it is installed. If you have any questions or require clarifications, please feel free to send us a message. Project budget is open for negotiations. Thank you for your interest in this project.
4 hours ago13 proposalsRemoteopportunity
IoT Data Sharing & Module Management
I need a system for an IoT-based project in which a WiFi module will share data to an SQL server. This needs to function within a SAAS environment with subscription per device. Main features include: - Admin and User Modules - Managed subscriptions per device - Real-time data alerts In the Admin Module, the following functionalities should be available: - User Management: Admin can manage and monitor users - Device Permissions: Admin can determine how much data a user can view - Monitor Device Data: Admin can view data from all devices - Payment Module: Ability to process transactions For the User Module, users should be able to: - View specific device data as permitted by the administrator - Receive alerts via data changes - Make payments for their subscriptions The ideal freelancer would have experience with IoT systems, SQL databases, and User Management design. They should also be well-versed with SAAS environments and have handled projects which required real-time data alerts in the past. A strong background in payment gateway integration will also be a major plus.
a day ago6 proposalsRemoteopportunity
MySQL Query Optimization for Charity Website
We are seeking an experienced MySQL developer to analyse and optimise slow SQL queries for our website hosted on a shared server environment. Our monitoring has identified a significant number of slow queries that are adversely affecting server performance and website loading speeds. Background: During routine server monitoring, we discovered that our website is generating slow MySQL queries that are consuming extensive CPU and memory resources, leading to a degradation in performance. Scope of Work: Analysis of Slow Queries: Review the log file located at (****) containing 1,181 slow queries. Identify key factors contributing to the slow performance. Optimise the top 10 slowest queries, which have execution times ranging from 29.1 to 44.1 seconds. Implement query restructuring and indexing strategies to reduce execution time. Testing and Validation: Test the optimised queries to ensure they meet performance improvements. Validate that changes do not negatively impact the functionality of the website. Reporting: Provide a comprehensive report detailing changes made, before and after execution times, and any recommendations for further improvements. Deliverables: A detailed report of analysis and optimisations performed. Implementation of query optimisations in the live environment. Final validation report showing performance improvements. Timeframe: The project needs to be completed within three days of commencement. Selection Criteria: Proven experience in MySQL and database performance tuning. Ability to work efficiently under tight deadlines. Previous experience with high-traffic websites on shared servers is preferable.
2 days ago33 proposalsRemoteI need help pulling data from AWS server for App
I need help pulling data from AWS server to my iOS app. App runs a chat and pulls wallpapers and videos from the server for subscribed users, but it has recently not been doing so. Need help on this ASAP.
7 days ago9 proposalsRemoteWooCommerce/WordPress Programming Assistance
Hello, We have recently set up WooCommerce shipping/label making/QR creation on our WordPress website. There is an extention which needs changing on the server in order for the QR codes to pull through as photos. Our web developer has advised he can't change the extension because he has the site on a shared server, and this will change everybody elses extentions too. The only thing he an advise is to put the site on its own server which is costly, or find somebody else to help. Could anybody please offer a less expensive and more straight forward fix? Thank you
4 hours ago21 proposalsRemoteServer configurations and Google vitals
PLEASE READ THIS BEFORE CONTACT - MY SITE IS AN ADULT SITE- CUPIDESCORTS.CO.UK - ONLY GET IN TOUCH IF YOU HAVE NO ISSUE WORKING ON ADULT SITES. I IDEALLY WANT TO WORK WITH AN ENGLISH DEVELOPER, I HAVE HAD LANGUAGE BARRIER ISSUES IN THE PAST. AT LEAST YOU NEED TO BE ABLE TO SPEAK PERFECT ENGLISH. I WILL ONLY REPLY TO PEOPLE WITH HISTORY ON PPH AND DEVELOPERS WHO HAVE SUITABLE EXPERIENCE. This task was going to be completed by my current web developer, but he has stated it would make more sense to hire someone with much more server config experience. I have recently changed my server from a shared one to a dedicated one with Hostinger. Previous experience with Hostinger would be a bonus, but not necessary if you have the relevant experience. Please see below the task and info sent to the previous developer This one is kind of a 3 parter. As you can imagine, I have changed the server to increase speed and generally improve reliability. When I moved servers recently it seemed a lot faster for admin, but when the transfer was complete, the back-end system was perhaps even slower than the shared one. I raised this with the new server guys hoping they could see why and resolve it. They didn't. I need you to see what is causing conflicts and make the admin system run faster. I need the site to perform better as a whole. One thing that has never been great is the speed an escort profile opens. Navigating to a location is pretty fast, but opening profiles isn't that fast. I believe there are a number of scripts associated. A little more info on this, I have always used WProcket to cache all content for 6 hours, and then after 6 hours all profiles and ads rotate, so if people revisit the site at a later date, it looks different. WProcket is now off as the server people advised to use Lite cache and CDN services instead. They state they have set Lite cache to cache and change every 6 hours, but I am not sure that it is working correctly. And the final part of the site's speed is the vitals judged by Google (See screens attached). I have been working on passing all the website vitals for close to a year now. From January to recently all URLs for desktop were good, and mobile had 30+ that needed improvement until the 20th of Feb. Then for a period of 3-4 weeks all URLs were good, with no more issues. Then on the 13th of March, the urls needed improvement and now they have gone to poor again. After the server change recently, I have checked and the mobile ones have gone from poor to need improvement but the desktop remains poor. When they started failing again no development was or had been done on the site which could have caused this, nothing had changed apart from plugin updates. That's what one of my devs said must have caused it. I need these all good again and ideally stay that way. So to sum up the project. - Improve speed of the site for admin, logged-in users and general visitors whilst not changing the functionality of the site -CACHE FOR 6 HOURS NEEDS TO STAY - Make all Google vitals good and to stay that way My current developer suggested the below to fix the issues above. - Remove any unused plugins - Pick 1 form plugin and recreate other forms in it, I noticed you have Contact Form 7 and Caldera both installed - Configure CSS, JS and HTML minify, deferred and combination settings in LiteSpeed cache - Configure Page and Object Caching settings - Optimise media files for faster delivery - Consider upgrading PHP to a newer version - Review scripts in ESLST-PTPL-custom plugin as a lot of the queries from this plugin are slow in execution - Explore caching the WP Admin Dashboard with LiteSpeed cache I imagine I will get several offers for this project. I will most likely take the most reasonable offer with the quickest complete time. I have a staging site for all these configs to be worked on. I have one more small task to complete after this too but I will mention that if this can be completed.
14 days ago18 proposalsRemoteJoint / Guided AZURE Server Deployment
I need to set up a simple enterprise AZURE server to host a server-side Google Tag Manager (GTM), and need someone who is an absolute "boss level" Azure admin to help me with this. Experts with Microsoft Azure enterprise development required. You must be very conversant with Azure, have set up server instances with scaling, security, health checks etc. for large enterprises with complicated security requirements, and ideally know how to write up detailed requirements specifications and plan server architecture. IMPORTANT NOTE: You will not be given any access. All work will be done by me, with you on a Teams call with sharing screens, where you will guide me. First part of the project will be to write up the detailed spec and setup plan. Second part will be the actual setup. Work will be done side-by-side, with you assisting me with setup and testing environments. This will be a one-off project, but will most likely lead to an on-going programme over a number of months, with the right person. You will not be given direct access to the Azure environment, but will view my screen and tell me how to set up. This is very important. The average time for the first part is expected to be around 20 hours, and the expected on-going monthly project time requirement will average 2 hours per month.
10 days ago15 proposalsRemoteWordPress Plugin Developer
We are seeking a skilled WordPress Plugin Developer to continue the development of a basic WordPress plugin. The ideal candidate should have experience with PHP, jQuery, HTML, CSS, JavaScript, and SQL. As a WordPress Plugin Developer, you will be responsible for enhancing the functionality of the existing plugin, implementing new features, and ensuring compatibility with the latest WordPress updates. This is a great opportunity to showcase your expertise in WordPress development and contribute to the growth of our plugin. Skills required: - PHP - jQuery - HTML - CSS - JavaScript - SQL
7 days ago31 proposalsRemoteServer proxy setting
I am running a react app on my Ubuntu server which already using a proxy server to call another api, all works fine when run it with npm start and use :3000 port with my domain name but I want it to run without port with domain and run using pm2 in background anyone can help in this? Regards, Kamran
20 days ago12 proposalsRemoteApache Problem on my Webmin Server
Hello, I have a dedicated server with UBUNTU + WEBMIN We are experiencing Error 500 codes on our Linux server and need an expert to diagnose and resolve the issue promptly. The server hosts our website, and these errors are impacting our online presence. Responsibilities: Investigate the root cause of Error 500 codes on our Linux server. Implement necessary fixes to resolve the issue and prevent recurrence. Optimize server configurations for better performance and stability. Requirements: Proficiency in Linux server administration. Experience troubleshooting and skilled in handling apache requests. Familiarity with web server configurations (e.g., Apache, Nginx). Ability to work efficiently and communicate effectively to provide timely updates on progress. Preferred Skills: Knowledge in Ubuntu, Apache or BIND DNS Server Experience with monitoring tools to identify performance bottlenecks. Additional Information: This is a remote freelance opportunity. Please provide details of your relevant experience and approach to troubleshooting server issues in your proposal. If you have the expertise to tackle this challenge and ensure our server operates smoothly, we'd love to hear from you. Kindly submit your proposal outlining your qualifications and proposed solution. Thank you!
19 days ago18 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
2 hours ago5 proposalsRemoteFT Studio Edition Rockwell
We have the following error in our Factory Talk SE application Failed to load data server 'RNA://$Global/project name' on machine 'xxx' (result = 0x800004004) can any one help please
4 hours ago1 proposalRemoteSelenium-based data scrape of targeted LI profiles
The creation of a SQL database by scraping data from ~345,000 records from LinkedIn. - Selenium scripts to capture multiple fields from LI profiles (including Summary, Role Descriptions, Dates in Roles) - The storing of the data in an SQL database - Detailed technical documentation about each script
21 days ago28 proposalsRemoteopportunity
Python / Machine Learning / Selenium Scrap
We need help with python. Would you want to work for us? If so, when can you start working ? If you are interested, so there would be 2 contract fix rate $50/country flow, $10/script for easier works (like scrap-data transferring between GS&SQL),
14 days ago25 proposalsRemoteHelp with tracking, cookie consent, server side tracking
I have a few clients who are all suffering from declining numbers due to the above issues. There isn't a one size fits all so looking for a consultant who can come up with a solution for each depending on their needs. Needs someone experienced in conversion tracking google ads, GTM etc
19 days ago13 proposalsRemotePHP Code Debugging for VoIp billing
When importing customers via CSV file in ASTPP version 6.0, both postpaid and prepaid customers balance always uploads 0. The task is to find the corresponding php file/path on the server and correct it, so that the balance uploads correctly when uploading the customers on the ASTPP both for prepaid and postpaid customers. Positive balance must upload as positive balance. Negative balance must upload correspondingly. 0 uploads 0. You need to make a detailed document how to do that on any ASTPP server, so that someone without technical knowledge takes the document, follows it and gets the same working on the other ASTPP server. Example of the document: docs.switzernet.com/3/public/230622-astpp-v6-installation/ Someone from our side will try to upload customers on the provided server to make sure it works, if yes, then we will take your document, which you provided and will correct the balance upload on other ASTPP server following the doc, if that is successful and works correct, then the project is considered as done and will be paid. In case it does not work, when tested from our side, document is not clear or incomplete, the project is not done and will not be paid. Additional instructions and already installed ASTPP server access will be provided.
11 days ago8 proposalsRemoteProgram one page website. Audio + recording onto server.
Simple web page, for fun on the littlebox.org website. Programming required: on one page is a little box, when you click the box and it shows a play button, you can listen to the audio recording. once you've listened you then leave an audio recording for the next person who visits the page. the person can only leave a 30 second recording. they can listen to it, before they over ride the previous recording. The recordings will all get stored on the server as mp3's. Thank you. Max
22 days ago29 proposalsRemoteFull stack dev
I need a good front and back end Dev to integrate 3rd party APIs like address look up and implement a server email system so we collect user data from a website form on our admin email account.
6 days ago55 proposalsRemoteCall Re-coding app in ios and android
Develop a cross-platform call recording application for iOS and Android. The app should record all incoming and outgoing call details such as call duration, timestamps, and phone numbers. It should capture this call log data at regular one-hour intervals and securely transmit the anonymized aggregates to a backend server. The server would then compile and store the usage statistics. Key features include initiating audio recording with phone calls, running recording in the background even when the app is closed, and uploading encrypted data payloads on a schedule. Developers proficient in mobile SDKs like Swift, Java and backend services like Node.js are encouraged to bid on bringing this call data capture and reporting concept to life with an eye towards privacy and security best practices.
a day ago15 proposalsRemote