Sql Server Toronto Projects
Looking for freelance Sql Server Toronto jobs and project work? PeoplePerHour has you covered.
PHP SQL - Linux Debian SSH - DevOp Server Code Maintainer
We are building a financial application whereas you can put money hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring ------ I'm looking for a skilled DevOps professional who can help in maintaining my server code. As the DevOps server code maintainer for this project, you will be responsible for: - Server Configuration and Setup: Ensuring the smooth operation of our Linux Debian SSH server. - Code Deployment and Version Control: Managing our PHP and SQL code deployments, including version control. - Monitoring and Troubleshooting: Monitoring the server's performance, and troubleshooting any issues that may arise. The ideal candidate should have experience with PHP, SQL, Linux Debian SSH, and possess sufficient DevOps expertise to effectively maintain and optimize our server.
5 days ago14 proposalsRemoteopportunity
User portal
We sell a device which uploads data via cell network. We want to develop a user portal that provides access to the data. Preferably the database would be SQL Server on an AWS platform in USA. We have users that require data security. Phase 1 is replicating an existing platform. This is a new project, we do not wish to reuse existing code. Phase 2 is a series of functionality improvements. Phase 3 is providing insight/AI across the data. The data will be viewed via a web portal. We may consider an app at a later date.
5 days ago57 proposalsRemoteopportunity
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.
17 days ago24 proposalsRemoteI am looking for urgent fixer for web api not working.
i have c++ server and qt client desktop app. when i setup c++ server and local and client desktop app in local in my end, it is working for web api from client to server. when i setup c++ server in vps and client desktop app in vps, it is working for web api from client to server. And in my local , using postman, web api is working. But in clientT of my local, web api is not working to vps server. For this testing, i checked log for server, but server doesn't get request from local using qnetworkaccess manager. We are using windows server from bare metal dedicated. thanks.
4 days ago7 proposalsRemoteServer-Side Tracking Setup via Stape.io
We are looking for a skilled developer to assist in setting up server-side tracking using Stape.io for our digital marketing agency. The ideal candidate will have experience in server-side tracking, Google Tag Manager, and data layer implementation. Project Requirements: Set up server-side tracking on our website using Stape.io Configure Google Tag Manager for server-side tagging Ensure accurate data collection and event tracking Collaborate with our team to integrate the tracking setup with our existing systems Troubleshoot and resolve any issues related to the tracking setup Skills Needed: Proficiency in Stape.io and server-side tracking Strong knowledge of Google Tag Manager and data layer implementation Experience with JavaScript, HTML, and web development Ability to work independently and communicate effectively Detail-oriented with a focus on accuracy and data integrity About Us: Lomax PPC is a digital marketing agency specialising in Google Account management. We pride ourselves on providing seamless, high-quality services that allow our partner agencies to focus on their core business and client relationships. Project Timeline: We aim to have the server-side tracking setup completed and verified within two weeks from the start date. Please provide an estimated timeline and any relevant project experience in your proposal. If you have the expertise and are interested in working with us, please submit your proposal along with your portfolio and any relevant references. If this solution works well for our initial client, we will be looking to roll our the solution across our wider client base. We look forward to collaborating with you!
10 days ago16 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.
10 days ago16 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.
12 days ago35 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.
17 days ago10 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
10 days ago34 proposalsRemoteQAD MFG PRO Programmer
I seek a highly skilled QAD MFG PRO programmer with extensive experience developing business applications and maintaining the .NET version environment. The ideal candidate will possess a deep understanding of QAD's architecture and capabilities. This intermittent work involves creating solutions to streamline operations and improve workflow efficiencies. Past projects include developing an inventory management module to optimize production planning and building an order tracking system to enhance customer service. The programmer should be well-versed in QAD's development tools like MFG/PRO IDE, SQL Server. Responsibilities writing code, testing, debugging, and documenting. The ability to troubleshoot complex issues independently and find innovative solutions is important. Experience working with multinational clients and handling varied timelines and priorities is preferred. This is a flexible role where the selected programmer will work remotely on an as-needed basis. The goal is to leverage your expertise to help changing business needs through customized QAD solutions. If you have a proven track record of delivering high-quality work on schedule, please indicate your hourly rate and availability. I look forward to reviewing your qualifications and experience.
2 days ago7 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.
24 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.
21 days ago16 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
17 days ago35 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!
a month ago19 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
10 days ago24 proposalsRemoteData Cleaning , Data Analyst & Data management.
We require assistance in managing a large dataset for an e-commerce firm. The key tasks include data wrangling, cleaning, transforming and structuring the raw files into a centralized database. The data consists of order records, product listings, customer profiles and shipping details from multiple sources in different formats. The hired professional will need to assess the data quality, derive insights to identify missing values, outliers and inconsistencies. They will then need to standardize, convert and consolidate the information into a relational database for easy querying and analysis by our data science team. Proficiency in SQL, experience in database modeling and expertise in data cleaning tools is essential.
2 days ago15 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
a month ago13 proposalsRemotePython Developer
We are looking for a skilled Python Developer to complete a specific project task. The ideal candidate will have experience in developing and maintaining Python applications and can deliver high-quality work within a set timeframe. Key Advantage: Already know CrewAI or AutoGen or ChatGPT OpenAI API. Responsibilities: Complete a specific task using Python. Write clean, efficient, and well-documented code. Ensure the solution is robust and scalable. Provide troubleshooting and debugging as needed. Requirements: Proven experience as a Python Developer. Strong knowledge of Python frameworks (e.g., Django, Flask). Familiarity with databases (SQL, PostgreSQL, MongoDB). Understanding of RESTful APIs and web services. Proficient in version control systems (e.g., Git). Excellent problem-solving skills and attention to detail.
2 days ago31 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),
25 days ago26 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.
21 days ago8 proposalsRemote