Sql Server Uk Projects
Looking for freelance Sql Server Uk 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.
5 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.
11 hours ago21 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 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.
12 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 proposalsRemoteopportunity
Scorpion Unnovate uk
I had a circuit designed and coded but contractor lost interest, Im currently looking for someone to complete the project from him I need Circuit fabrication, PCB design Prototype development.
9 days ago11 proposalsRemoteSenior Paid Advertising Strategist | UK
Role type: Contract, part time (remote) Experience level: Senior Reports to: Head of Strategy Location: Remote The Brains Group is a fast-growing group of global marketing brands with a focus on future thinking, AI and innovation. We’ve helped hundreds of clients across a wide range of verticals to maximize ROI, improve client acquisition & retention and grow faster, with our unique marketing platform and solutions. The future is bright for us, with lots of new products, services and brands on the horizon. The Group of companies includes: - The Brains Marketing - our flagship brand, a well-established marketing agency offering training, consultancy and support services on an adhoc or ongoing basis. - Rocket Healthcare Marketing - our bespoke healthcare brand, offering affordable, scalable healthcare marketing tools and solutions that help clinics, consultants and practices reach, convert & retain more patients. - SaaSible - our distinct SaaS offering, helping B2B software providers scale up their marketing and increase demand. The Role: Our Senior Paid Advertising Strategists are true experts in their field who harness experience and innovation to deliver exceptional results for key B2B and B2C clients across paid search, display and social advertising. You must be a confident communicator with proven experience managing or consulting on large scale paid advertising campaigns. You need to be comfortable feeding into multichannel strategies, managing client expectations, coaching junior team members, reporting on performance and setting / optimising account strategies. You may be asked to operate as a paid lead for a key client, to triage the strategy for an existing client, to consult with a client who is learning to run their own PPC, or to assist The Brains Group with our own paid advertising. We are looking for someone with flexibility who is happy to scale hours up or down, with an agreed base minimum each week. Core responsibilities: - Develop, execute and optimise cutting-edge paid advertising campaigns, from conception to launch - Onboard new paid media clients and nurture those relationships, keeping a close eye on client retention and ensuring that clients receive an exceptional quality of service - Evaluate campaign performance based on clear KPIs, and report confidently on a weekly and monthly basis, either via call, video call or email, to client stakeholders - Actively recommend account improvements, constantly look for ways to further boost account performance and ensure strong client engagement - Flag any concerns with account performance, troubleshoot alongside the Head of Strategy and Client Services Manager, work hard to ensure retention and satisfaction of your clients - Be the account lead for your designated key clients - this means operating as the main client point of contact, ensuring all members of the account team are feeding into the monthly report, being aware of overall account performance and liaising with the Head of Strategy about any concerns you have over account performance, or any opportunities to provide additional services and support for that client. You are the advocate for that client and should work carefully on building up a trusting and supportive relationship with the client representative(s) - Support the Head of Strategy and Managing Director with new sales opportunities, by attending introductory and proposal calls with prospective clients and feeding into proposal decks. Be prepared to present slides on your area, what strategies you recommend, and what potential ROI could look like (you don’t have to attend sales calls alone, or act as point person for new opportunities, you’ll be operating as part of a sales team run by the Managing Director or Head of Strategy) - Work cross-departmentally, to align campaign strategies and goals on multichannel clients - Train/support junior team members where necessary, providing support on tricky account challenges, recommending additional strategies and advising on the correct approach if the junior is unclear Skills and experience: - 5+ years as a paid media strategist, paid advertising manager or paid account manager - Proven experience creating, managing and optimising Google Ads, Performance Max, LinkedIn and Meta campaigns - Comfortable setting up, consulting on or taking over paid client account teams and ensuring that deliverables stay on track - Excellent oral communications skills - Very strong written communication skills and email comms skills - Strong experience producing reports and explaining them to clients - Happy to chat on the phone, comfortable calling clients - Well-organised and efficient, good time management and prioritisation skills. - Team player who likes to work in a dynamic environment and collaborate across teams
6 hours ago7 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 proposalsRemoteUK B2B EMAIL DATA
We are looking for IT Managers within UK companies with the below fields Contact Name Job Title - Network Manager / IT Manager / IT Director Company Name Company Sector - This is essential (Financial / Manufacturing / Warehouse / Travel & Tourism / Retail / Hospitality etc). Email Address (NAMED EMAIL ADDRESS - NO PERSONAL GMAIL / YAHOO ETC) Phone Number (if available not essential) Please provide a count of available data. Thanks, Jake
5 days ago62 proposalsRemoteLooking for a civil lawyer who understands UK Law
I am looking for a civil lawyer who can help me respond to a civil case in court
3 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
19 days ago28 proposalsRemoteUK-Based Company Representative Needed
We sell on the amazon marketplace through our company in the United Kingdom. The Amazon marketplace has made some rule changes and started to impose additional tax liability by deciding that companies that do not have a director or employee in the UK are not resident. We are looking for a director or an employee in our company to pass the verification requested by Amazon. We expect the candidate we are looking for to provide the following documents. Required Documents: 1. Identity Verification (one of the following): • National Identity Card • Passport • Driving Licence 2. Address Verification (one of the following): • Council Tax Bill • Utility Bill 3. Bank Account Information Verification: • Local Bank Account Statement https://find-and-update.company-information.service.gov.uk/company/15335204 https://www.amazon.co.uk/sp?ie=UTF8&seller=A1OQ71R7Z4K8FU
4 days ago6 proposalsRemoteopportunity
UK Loft extension planning drawings up
Hi, I need someone to update planning drawings for a loft extension. The current plans allow for a 40CBM increase and this needs to be increased to 50CBM. Thanks
4 days ago17 proposalsRemoteI need some plans and elevations for a UK heritage application.
I have had architectural drawings produced by someone on PPH but the drawings do not conform to the requirements of the local authority and I have been asked to have them done correctly. I need some elevations and floorplans drawn done again by someone who is familiar with the protocols and can do them to acceptable standards. Samples of the drawings are attached, the rest can be provided. What I need are: - Existing and Proposed front elevation (no changes to the proposed) - Existing and proposed rear elevation (no change) - Existing and proposed first and second floor floorplans (minor changes in internal layout) and I will also need to add on heating pipes between boiler and new radiators under the 2 windows on the first floor. Please indicate your UK architectural experience and how long you'll need to produce them. Many thanks, Ross.
5 days ago22 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 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 proposalsRemoteopportunity
Aquisition to purchase an e-commerce business in UK
I am just about to purchase an e-commerce business that operates on the following platforms - Amazon, TikTok, EBay, Etsy and own website. We are purchasing it for £35k so not a large amount. We would like a solicitor to work on our behalf to ensure that the IP, Stock, domain, branding and listings on the platforms are transferred legally with all of the legal documentation is in place. WE will not be purchasing the limited company just the above. The solictor that we use must be UK based and we would like to do the background checks to ensure that you are who you say you are, and you are a qualified solicitor. We are flexible on teh budgert if we get the right person
5 days ago10 proposalsRemoteopportunity
Building regs UK
I have plans drawn up for upward extension on a dorma bunglow and rear single storey extension. Need building regs done. The loft space I want with a open cut roof and floor joists ready to use has a loft.
15 days ago17 proposalsRemote