Find Jobs
Hire Freelancers

Microsoft SQL Clean-up and Optimization

$30-250 CAD

Completed
Posted about 4 years ago

$30-250 CAD

Paid on delivery
Hello, I have an ASP website using MSSQL, running on a Windows server. It's fairly old, designed more than 10 years ago. The database, currently in use by the website, is at 17 GB in size and that's not normal. There may be hacked files and entries in the database and web files of the website. Security holes would need to be closed as well so this issue does not occur in the future. You will need to clean/optimise the database (potentially bring it down in size) and the website (there may be hacked files) so that it could be migrated easily in the future and it would be error free. At this point just trying to back-up, or restoring the database takes hours do to. When working on the site, you will need to make sure you can restore to the current working version if needs be.
Project ID: 23973778

About the project

27 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, As an expert in ms sql server, i am very much interested to do the database optimization. Protecting security holes is not included in this bid as this is much analytical & technical task which need to analyze the current code firstly, then the cost could be estimated. Let's discuss more in detail. Thanks
$40 CAD in 2 days
4.9 (283 reviews)
7.8
7.8
27 freelancers are bidding on average $171 CAD for this job
User Avatar
Hi, We are a .Net company with 10+ years of experience and can start this job immediately. We are dealing in Android, C#, VB, Quickbooks, MVC, ASP .Net, Razor, ASPX, Web Services, API, LINQ, MS SQL, MySQL, HTML, CSS, Ajax, JQuery, Kendo etc. We manage code very well with comments and always pass it to owner. We are available most of time and don't mind to work in emergency or on Saturday & Sunday. We are pleased to discuss your requirements and can start it today. Thank you for your time.
$150 CAD in 7 days
5.0 (53 reviews)
6.1
6.1
User Avatar
Hi, I am interested to optimize database and fix other files if they are hacked. I would like to have more information, we can chat By they way, I am experienced asp coder with more than 15 years experience. Regards, Nurba
$250 CAD in 7 days
4.9 (74 reviews)
5.8
5.8
User Avatar
Proposal - You need to shrink database and then defragment all your database indexes. This will drastically reduce the db size and defragmenation get back your performance of your db. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$180 CAD in 1 day
5.0 (28 reviews)
4.9
4.9
User Avatar
Analyzing database and optimizing is the one thing. But need to look in detail for the "hacked files" as I need to know what you really want to say. It might be case, you have problem with your existing ASP website as well, so some fixes (or big fixes) might be needed there as well, so looking to complexity, we might need to continue it on next project.
$250 CAD in 30 days
5.0 (49 reviews)
5.0
5.0
User Avatar
Hi, I'm expert in .net,c# and sql serer and I can clean up your database and make it to it's original size. Let me know when we can further discuss so I could start . Thanks
$250 CAD in 7 days
5.0 (10 reviews)
4.8
4.8
User Avatar
Hello! I am very happy to see your project detail. I think it is just my project. :) I read your requirement carefully and understood fully. I am sure I can do your project. I have much experience with 8+years. It's important to me to build long-term relationships with clients. Please get in touch with me to discuss more. Look forward to working with you. Thank you for taking time to look at my proposal. Warmest regards
$140 CAD in 3 days
5.0 (7 reviews)
4.5
4.5
User Avatar
Greetings, I'm professional database and BI expert with 12+ years experience. Currently I'm working as Senior DW, BI & DB developer in one of the leader financial corporation. As you can see in my profile page, I have a deep experience of database related projects. I'm top expert. -- Best regards, Davit Dartsimelia Senior BI & SQL Developer
$277 CAD in 2 days
5.0 (4 reviews)
4.4
4.4
User Avatar
Hi, I can help you clean up the db files in quick time. As I have done this before as well. I am systems administrator with over 12 years of experience managing server infrastructures and data-center operations across multiple platforms (mostly Microsoft, partially Linux) mostly in virtualized environment (both Hyper-V and VMWARE). Experienced in Web and Email hosting deployment and customer support. Effectively plan, install, configure and optimize the IT infrastructure to consistently achieve high availability and performance. Certified in MCSE 2012, VCP6-DCV and CCNA. Can we discuss further, so that we can finalise the cost and timeline? I will be glad to help you.
$40 CAD in 1 day
4.9 (34 reviews)
4.7
4.7
User Avatar
Hello Sir, Iam a core SQL Server DBA with 10+ yrs of exp. I am expert in cleanup,scrub, purge unused or old data .Good exp in all DEV and DBA roles .Give me chance I will do it 100% make it optimized. I will help you to remove the hacked filer entries from your website and database . I will make sure the size of the database is greatly optimized such that backup and restore will run faster . I will also give you the exact root cause of the problems and a permanent resolution . Please contact me sir to get started and pay only if you like my support.
$100 CAD in 1 day
5.0 (13 reviews)
4.1
4.1
User Avatar
Hello. I can help with MSSQL Database. Regarding to hacked files - i can only check it with good Antimalware software. About me: Senior SQL Developer with 10+ years experience, worked during this time with several automation systems, Business Intelligence tools. Five years working within scrum team in USA product company. Also during my professional activity i gathered expertise and experience in several areas of IT from configuration development environment to delivery of developed product. Areas of specialization: ● MS SQL Server DB Engine ● T-SQL ● MS Reporting Services ● DWH ● MS Integration Services ● ETL Processes ● MS Analysis Services
$333 CAD in 3 days
5.0 (14 reviews)
3.5
3.5
User Avatar
I am SQL DBA with 8+ years of experience in database optimization and space management. Please review my profile. Looking for more invite to discuss more on this requirement. Regards Omkar
$100 CAD in 2 days
5.0 (1 review)
3.0
3.0
User Avatar
I have 12+ years of experience in software development C#,VB.NET,ASP.NET and data integration, also specialized in database tuning and application performance, I worked bfore on 1TB+ databases, and on a certical application I worked before a couple of months on a similar project on upwork for a US company and the application was written before 15 years. I can find the cause of unusual database size, and retun the database size to the supposed normal sized based on the actual data I can remove any affected files I can fix any security issues or bugs in the current version Also i can upgrad your application to anew version Thanks, All the best.
$250 CAD in 10 days
5.0 (1 review)
1.0
1.0
User Avatar
I am a full stack programmer, I can handle your project as easy as pie, I need more details, please contact me to discuss in details.
$200 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A review must be carried out from the server to the database, it is very important to perform cleaning tasks such as srink to the database to reduce its size, to make a backup to the database if a backup cannot be performed, it must be make a backup of the .mdf and .log files. The log file of the database should be reviewed and the respective maintenance performed. Review website, run vulnerability analysis to website and server Execute a program task in the SQl for monthly maintenanc
$200 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I have read your post very carefully and I have understood job description. I am sure I can handle your project perfectly in the quick timeline. Let me know if you have some time to discuss the details further. Looking forward to hearing from you.
$90 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 10 years of experience in Ms SQL Server and 8 Years as SQL DBA. I can join immediately. My mobile no is 9249892762(India). Relevant Skills and Experience Managed several databases in Ms SQL independently and done performance tuning very well.
$155 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have expertise in Microsoft SQL server and its optimization. I have handled many complicated queries and DB optimization to increase overall speed of the web application. Hoping for the positive reply. Thanks and Regards, Manjiri
$180 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have been working with SQL Server for more than 8 years. I currently administer a database cluster of 2TB+. I read your requirements and notice that these are common issues. SQL Server opimization is part of my daily job. The issue seems to be with the database logs, indexing, the database recovery model and parallel processing on the server. If ever you have been hacked, the server should be scanned for 3rd party applications running without permissions.
$140 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am working professional with 6 years of IT experience, i have bachelors degree in Electronics and Telecommunication engineering.I Working as a DBA in SQL, MySQL, Postgres I am Handling team of 12 in MNC, I work and review on SQL programming, Excel, Word, Scripts on daily basis. I am very good at analytics, design, capacity planning etc. Thanks
$140 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Full stack developer with 6+ years of experience working in .Net platform.
$155 CAD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Montreal, Canada
5.0
17
Payment method verified
Member since Jan 4, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.