Find Jobs
Hire Freelancers

Microsoft SQL Clean-up and Optimization

$30-250 CAD

Dokončeno
Zveřejněno přibližně před 4 roky

$30-250 CAD

Zaplaceno při doručení
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.
IČ projektu: 23973778

O projektu

27 nabídky
Vzdálený projekt
Aktivní před 4 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
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 v 2 dnech
4,9 (283 recenze)
7,8
7,8
27 freelanceři nabízejí v průměru $171 CAD za tuto práci
Avatar uživatele
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 v 7 dnech
5,0 (53 recenze)
6,1
6,1
Avatar uživatele
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 v 7 dnech
4,9 (74 recenze)
5,8
5,8
Avatar uživatele
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 v 1 dni
5,0 (28 recenze)
4,9
4,9
Avatar uživatele
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 v 30 dnech
5,0 (49 recenze)
5,0
5,0
Avatar uživatele
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 v 7 dnech
5,0 (10 recenze)
4,8
4,8
Avatar uživatele
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 v 3 dnech
5,0 (7 recenze)
4,5
4,5
Avatar uživatele
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 v 2 dnech
5,0 (4 recenze)
4,4
4,4
Avatar uživatele
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 v 1 dni
4,9 (34 recenze)
4,7
4,7
Avatar uživatele
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 v 1 dni
5,0 (13 recenze)
4,1
4,1
Avatar uživatele
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 v 3 dnech
5,0 (14 recenze)
3,5
3,5
Avatar uživatele
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 v 2 dnech
5,0 (1 recenze)
3,0
3,0
Avatar uživatele
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 v 10 dnech
5,0 (1 recenze)
1,0
1,0
Avatar uživatele
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 v 2 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
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 v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Full stack developer with 6+ years of experience working in .Net platform.
$155 CAD v 3 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z CANADA
Montreal, Canada
5,0
17
Ověřená platební metoda
Členem od led 4, 2013

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.