Sql Server London Projects
Looking for freelance Sql Server London 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 ago24 proposalsRemoteopportunity
Research and organise a meeting in London
I am looking for someone who is thorough and detailed when it comes to researching info that is available online and at the same time confident to make phone calls to organise a meeting. This task is to find a place to rent for taking professional pictures for tourists. It would have to be near one of the London's landmarks and preferably on a private estate. more details in correspondence. This task does not involve sales, however persuasive telephone manner is a must.
3 hours ago6 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.
17 hours ago5 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 proposalsRemoteLand For Sale Greater London Area
Land for Sale is wanted. Site must be between 3 acres and 60 acres. Site must be within M25 Site must be between Junction 6 and Junction 10 of M25 We will pay £10 per lead which meets the above criteria.
3 days ago10 proposalsRemoteCurtains shortened on-site, Farringdon London
Skilled sewing machinist required for one set of thermal-acoustic curtains (with lining) to be slightly shortened, to better fit recess. Alteration preferably performed on-site in Farringdon, London location.
4 days ago0 proposalsOn-site in London, GBopportunity
YPO London Wine Experience 2024
This is a 2-day wine education & tasting event. I'm looking for a photographer to join us at 67 Pall Mall on - May 30, 10am to 5pm - May 31, 3pm to 5pm To take pictures during the event (speakers, participants, wines, etc.). We will be looking for a creative eye (unique & interesting perspectives). This is a YPO event and due to the members participating and wines being tasted, confidentiality is key (i.e. no posting / usage of pics outside of YPO). As commissioner of the photographs, I will own copyright exclusively.
5 days ago9 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 ago8 proposalsRemoteLondon Based Events Assistant for Hybrid role
We are looking for someone who loves the world of media and entertainment particularly dance and music- who wants international travel 4 to 5 times a year, is well spoken, fun, creative, technology aware, a real go getter, people person, great with numbers and words, and organised. A real bonus is someone who drives, with own car. Get in touch if you sound like the above!
6 days ago4 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 proposalsRemoteopportunity
Sewing machinist based in South London, Caterham Surrey
Machinery lockstitch and 4 thread overlocker
5 days ago3 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 proposalsRemoteJunior Freelance Videographer
Unique opportunity to learn for Junior Freelance Videographers in London! Meetupvideo Ltd. is seeking freelance Junior Videographers who are keen to learn the technical aspects of: - videography and video editing, - live streaming. It's an advantage to live in or around London as urgent calls may arise to resolve technical issues or to substitute for an unavailable videographer on-site within one hour after training. Offer: Entry-level hourly rate with significant learning opportunities. Training in videography and live streaming technologies.
3 hours ago0 proposalsRemoteADMIN ASSISTANT REQUIRED IN LONDON
Job Description: As the Admin Assistant, you will be responsible for coordinating and managing some aspects of the leasing process for our properties. This includes advertising available units, conducting property tours, screening potential tenants, and managing move-in and move-out processes. Key Responsibilities: Conduct property tours for potential tenants and provide information on the property and its amenities Communicate with tenants to address any questions or concerns they may have during the leasing process Screen potential tenants by conducting background and credit checks Ensure all necessary documents are completed accurately and in a timely manner Coordinate move-in and move-out processes, including conducting unit inspections and managing security deposits Maintain accurate and up-to-date records of all leasing activities Advertise available units through various channels, such as online listings and local publications Stay up-to-date on local rental market trends and adjust rental rates accordingly Assist with other administrative tasks as needed Requirements: Previous experience in leasing or property management is highly desirable Strong organizational and time-management skills Excellent communication and interpersonal skills Proficiency in Microsoft Office and property management software Ability to work independently and as part of a team Knowledge of local rental market Attention to detail and ability to multitask in a fast-paced environment. P.S. Only Freelancers within the UK should apply
23 days ago8 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
21 days ago28 proposalsRemoteTaxi, mini cab, chauffeur and bus company list in London and UK
We are looking for a list of the following required in the UK and London 1. Taxi and minicab service providers 2. Chauffer and bus companies We need the following information on CSV 1. Name of company 2. Address and location 3. Owner details 4. Email address and contact numbers We are looking for a total of 3,000. All information should be verified and clean
6 days ago20 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 proposalsRemote