Find Jobs
Hire Freelancers

MSSQL, Visual Basic and MYSQL Expert to fix slow script

$45-50 AUD / hour

Anuluar
Postuar over 4 years ago

$45-50 AUD / hour

We have a script that processes 250,000 transactions every 15 minutes, it's been running correctly for over 2 years, but now it has stopped working. The script is written in visual basic and uses windows scheduler to run. You will be required to work remotely on a Windows server and investigate why the script now takes many hours to run instead of a few minutes, data size is the same as always. The script basically takes data from MSSQL, does some checks then uploads it to MYSQL. Only experts need apply for this role, must be able to work immediately, there will be a larger project after this has been fixed. Webserver admin and windows server admin is beneficial but not 100% required.
ID e Projektit: 21338467

Rreth projektit

49 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
49 freelancers are bidding on average $47 AUD/orë for this job
Avatari i Përdoruesit
Hi, I have 9.5 years of experience and i am AWS Certified Solution Architect. I am highly interested in this project based on my skills as i have experience with MSSQL as well as MYSQL too. Lets discuss in more detail so that i can help you with optimum solution. Thank You, Gshyam
$50 AUD në 40 ditë
5,0 (324 përshtypje)
9,3
9,3
Avatari i Përdoruesit
Hi There, I am very good MSSQL and VB. I have done many different projects on Microsoft environment using VB, C++, and C#. I hope some indexing is missing in your database which makes the script malfunctioning as the data grows I can check and fix it on your server remotely. We can discuss more in detail Thanks
$45 AUD në 20 ditë
4,9 (1245 përshtypje)
9,5
9,5
Avatari i Përdoruesit
Hi, I can definitely look into your system and can debug the script for late execution. I am an expert visual basic developer and have complete command on MSSQL and MySQL. I am ready to initiate right away and surely we will work together in the future as well. Let's connect to get started. Best Regards, MK
$50 AUD në 40 ditë
4,7 (205 përshtypje)
9,5
9,5
Avatari i Përdoruesit
Hello Yes, I can help you to fix your script and I will update it according to your requirements. I can assure you about the best quality of the work as I have vast experience in complete WEB DEVELOPMENT. I can be an ideal candidate for this project as I have developed 500+ websites. I am a full stack developer. I do have over 8+ year of experience in responsive & complete development. I am well versed in the technologies such as CSS3, HTML5, JavaScript, Angular JS, PHP, Laravel, Code Igniter,Python, MongoDB, Ruby on rails,React JS, NodeJS, WordPress, woo-commerce, Magento, Android & iOS development, Shopify, Joomla, payment gateways, third party API, plugin development, integration, and customizations. Please initiate a chat for further discussion. I am waiting here for your positive response. Thanks & Regards Vivek
$45 AUD në 40 ditë
4,8 (620 përshtypje)
9,1
9,1
Avatari i Përdoruesit
Hi There, we can check that, we have a good experience to do this kind of jobs with databases having millions of records and syncing and migration to different databases. For your job, first of all I need to confirm few things: -> Only the execution time has been increased or it is getting failed while execution? -> Is it taking the same amount of execution time when we run the scheduled task manually? -> Do you have that VB script setup with IDE on that, so that we can debug it? -> Those MSSQL and MySQL databases are still on same server or shifted to other ? Cheers Abi
$45 AUD në 40 ditë
4,9 (239 përshtypje)
9,2
9,2
Avatari i Përdoruesit
IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 10+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networking, real-estate and other websites with the proliferation of mobile devices. We stand ready and eager to assist you with any web based solutions, graphic requirements, and mobile application solutions, internet marketing or corporate branding solutions you may require. The exceptional customer service that we provide never deviates regardless of the size and scope of the project at hand. ABOUT OUR TEAM Our team is made up of skilled programmers, designers, customer support executives and business development analysts with many years of expertise in the industry. Our aim is to build and strengthen long-term relationships with our customers, based on our commitment to provide the highest quality services and solutions. SKILl SET Magento,Joomla,Drupal,Wordpress,DJANGO,PYTHON HTML CSS JavaScript and Ajax PHP, ASP, .net, MySQL and SQL Database SEO Mobile development Thanks Mirth
$45 AUD në 40 ditë
4,9 (345 përshtypje)
8,9
8,9
Avatari i Përdoruesit
HI, I will solve the script running time issue. I do have expertise with visual basic, Mysql. I have 8+ years of experience in web designing and development using PHP and frameworks. I have expertise with CSS, HTML, JS, and frameworks. Kindly revert me. So I can start right away. Thanks!!
$45 AUD në 40 ditë
5,0 (87 përshtypje)
8,3
8,3
Avatari i Përdoruesit
Hello, As an experienced visual basic developer and having sound knowledge in MSSQL as well as MySQL, i am very much interested to investigate the slow issue and fix it. I am available now to start working. Looking forward to have a positive response from you. Note: Don't know why you added PHP as a required skill, i guess it would be 'Visual Basic'? Thanks
$46 AUD në 40 ditë
5,0 (354 përshtypje)
8,0
8,0
Avatari i Përdoruesit
Dear Sir/Madam, I think You are using PHP API connection with Visual Basic. You said It was processed 250.000 transactions in 15 minutes. So, I think the Mysql database is handle billions transactions. So, Mysql will be very big database now. So, We need optimized via partition table, move old data to archive database.... Best regards, Bang T.
$45 AUD në 40 ditë
5,0 (174 përshtypje)
8,0
8,0
Avatari i Përdoruesit
Hi there, I read your initial requirements and I have some questions regarding your MSSQL project. please send me a message so that we could discuss it further.
$45 AUD në 40 ditë
5,0 (102 përshtypje)
7,7
7,7
Avatari i Përdoruesit
Dear Australian employer. How are you? I am a senior backend developer for 5+ years, mssql/mysql master So I can deliver on what your looking for. I would like to work with you under a good long-term relationship. I can start immediately. Hope to see you soon. Kindly regards..
$48 AUD në 40 ditë
5,0 (69 përshtypje)
7,7
7,7
Avatari i Përdoruesit
Hello I can immediately look into windows server via remote and can start investigating right away. I have ample experience in Visual Basic (Classic ASP), MSSQL And MySql. I will first understand whole workflow and then will find point where it is being slow and find a solution to fix it I have some special non-technical skills like analytical skills, strong grasping power which will help me to find issue fast and fix it. Brief About Me: I am a "Full-Time" Individual freelancer having 10.5+ years of expertise over MS Technologies(C#). Apart from having relevant technical skills, I have good analytic skills and strong grasping power. I have 4~ years of experience of working as a full time freelancer and in that span I have worked over various Windows & Web Project ranging over various domains in different sub technologies. Please have a look over my profile to gain trust on me and my work
$50 AUD në 10 ditë
4,8 (93 përshtypje)
7,7
7,7
Avatari i Përdoruesit
Dear Employer, Thanks for job posting. I have read the description carefully and give you 100% assistance as MSSQL, Visual Basic and MYSQL Expert. I am an Expertise in following: 1. Front-End Development : HTML5, CSS3, Bootstrap, React Js, Less, Saas etc. 2. Backend Development: PHP, CodeIgniter, Laravel, MySQL, NODE Js, Express Js, Mongo Db, MSSQL, MYSQL. 3. CMS: Wordpress, Magento, 4. Project Management Software and Tools: BASECAMP, ASANA, JIRA, Gitlab etc 5. Version Control: Git, GitHub, Bitbucket. I work extremely fast and with high quality. Will provide you 100% satisfactory results within allotted time. Waiting for your message to discuss with you. Thanks Ashraf
$45 AUD në 40 ditë
5,0 (52 përshtypje)
7,5
7,5
Avatari i Përdoruesit
==== YOUR SEARCH ENDS HERE ==== Hello Sir/Madam, I love Visual Basic as it was my first computer language at the time of 2003. 1. I will look into your code processes and dig-out the root cause of the issue. 2. I will rectify the operations to the normal functionalities. 3. I will give you a detailed report of the cause and rectification. 4. I will manage to be durable and long-lasting. let me know so that we can discuss further. Regards, Mehboob Afridi
$50 AUD në 5 ditë
5,0 (211 përshtypje)
7,4
7,4
Avatari i Përdoruesit
Hello, client. This is SQL expert! You can find SQL project(though it is small project) from my profile. I am sure I can fulfill your requirement at a high level. Please feel free to contact me. I can start right now. Hope to hear from you soon. Best regards. Damian.
$50 AUD në 40 ditë
5,0 (18 përshtypje)
6,8
6,8
Avatari i Përdoruesit
Hi. So the script is still running without any issue, but it takes many hours to run instead of mins? Seems strange that there will be mssql or mysql server connection from your vb script. I want to check your current code structure and find the reason why it not works. Furthermore I already work as a windows server administrator for large company which introduced pos system all places in Japan. Recently I had to replace all the business and tax count logic because of tax rate increase to 10% in japan. I am sure I can complete the job definitely. Let's discuss details via chat.
$48 AUD në 40 ditë
4,9 (111 përshtypje)
6,9
6,9
Avatari i Përdoruesit
I can fix the script and start immediately. Programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Some reference projects: a) Responsive website on .NET - https://www.freelancer.com/projects/C-Sharp-Programming-ASP-NET/ASP-Net-Responsive-Web-Application/ --> Review -> “Thanks Hardik! Great work.” b) VB 2013 Desktop Application with AWS integration -https://www.freelancer.com/projects/Amazon-Web-Services-Windows/Visual-Basic-Express-Desktop-Application/ --> Review--> "Great Job! Would hire again!" c) Data pull application from Facebook using VB.NET -https://www.freelancer.com/projects/PHP-Social-Networking/Timeline-Posts-Extraction-with-Likes/ --> Feedback by Client --> "I was extremely satisfied by hardikshah83's work. Excellent communication skills. Very professional. I asked for a couple of changes in the course of the project and he delivered them gracefully." Let's discuss and make this project a success.
$45 AUD në 40 ditë
4,9 (68 përshtypje)
6,5
6,5
Avatari i Përdoruesit
Hello, I have gone through the project details and have required skill set as specified in the requirements to work on SQL script optimization and speeding up SQL result. We can discuss further in private message. Thanks.
$45 AUD në 40 ditë
4,7 (62 përshtypje)
6,5
6,5
Avatari i Përdoruesit
Hi There, I can get started right now!!! I have few questions to start with. 1) Is the DB server is on same machine where script is running or on different server? 2) You mention is runs via Windows scheduler so is it a exe file which runs? I would be needing server access to review the DB and see if its performing slow. I believe in good communication and usually, reply within minutes of ping from you. I'll wait for your ping on chat to discuss more on the project. Regards, Shobhit Pundir
$45 AUD në 40 ditë
5,0 (28 përshtypje)
5,8
5,8
Avatari i Përdoruesit
Hi there, I am having 18 years of experience in developing and designing. please message me for further discussion. My hourly rate:30$ per hour for this project.
$45 AUD në 40 ditë
4,7 (38 përshtypje)
6,1
6,1

Rreth klientit

Flamuri i AUSTRALIA
St Leonards, Australia
5,0
5
Mënyra e pagesës u verifikua
Anëtar që nga shk 14, 2013

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.