Sql Server Toronto Projects
Looking for freelance Sql Server Toronto 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.
6 days ago24 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.
17 hours ago24 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.
6 days ago8 proposalsRemoteTutor for Calculus
Hi I need a tutor for calculus. I live in Toronto, pls msg me and quote me your price.
a month ago20 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.
13 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.
9 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
5 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
19 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!
18 days ago18 proposalsRemoteSelenium-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
19 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),
13 days ago24 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
18 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.
10 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
21 days ago28 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.
5 days ago54 proposalsRemoteopportunity
Low run-cost Remote desktop Solution for coding & general use
Reposting this requirement as couldn't finalise on proposals received. I need a very low running cost remote desktop solution on a cloud application/data server, to allow few interns and contractors to work on a startup project idea. This is required to secure the company assets (data/info), prevent users to download or copy data to their own devices; remote admin features to install, uninstall apps, monitor user activities, control access levels, along with other standard security features. Minimum requirement in terms of storage/server capacity etc, but need something that can later be scaled for a fully functional office. Less than 5 users. Please suggest options with pros/cons plus indication of running cost in your proposal. Happy to discuss over a call if needed. Any other question, please ask. Only serious candidates who can meet the requirements need to apply. Thanks
2 hours ago1 proposalRemoteBrowser & server side conversion tracking - ongoing projects
Hi, Our team is looking for a resource to join our Slack channel to pick up tracking requests from our current and new clients. We get about 3 to 6 per month, so this would be ongoing work. High communication internal to our team, a short report detailing the work done/tested is required. The ability to speak client-facing is a plus. Quote: Leeds in your response. Thanks, Alex,
21 days ago18 proposalsRemoteTransferring WordPress website files from one server to another
Hi, I'm looking for a programmer to transfer WordPress website files from one server to another and connect it to the domain. This is a regular site, not a sales site, so it's just a matter of transferring the files and connecting them to the domain and creating a new name and password to enter the WordPress management software I am a graphic designer with many clients looking for someone professional and reliable.
a month ago41 proposalsRemoteWordPress developer needed to resolve some issues
I am having trouble with the media library on my WordPress website. Sometimes I receive an error when trying to delete an image from the library. Also, in certain categories - new featured thumbnails are showing as "unattached," even though they are showing up in the post fine. I believe something went wrong when I was cleaning up the SQL database months ago. I didn't notice the issue until quite a bit after the fact, making a backup restoration nearly impossible.
17 days ago66 proposalsRemoteHigh CPU Issue - WooCommerce Website
I have a WooCommerce website which maxes out the CPU usage when browsing on the front end of the website. The website has minimal traffic, a good spec server (6 GB RAM, 4 vCPUs, 320 GB SSD). I have removed all plugins, cleaned the database & even migrated the website to a new instance. I need someone to diagnose and fix the issue.
6 days ago41 proposalsRemote