SQL Database Optimization & Upgrade to 2019

Cerrado Publicado hace 2 meses Pagado a la entrega
Cerrado Pagado a la entrega

My SQL Server 2016 database is suffering from storage overuse, which is causing slow performance and potential crashes. I need to have the bloat removed, and the database converted to SQL Server 2019.

Please apply the following optimization techniques during the process:

- Indexing

- Normalization

- Partitioning

I need all data preserved during the conversion, apart from the bloat. This includes:

- Customer data

- Transaction history

- Reports/Logs

The ideal freelancer for this project should have extensive experience with SQL Server, database optimization techniques, and data migration. They should be able to ensure the integrity and security of all data during the process. Please provide examples of similar projects you've completed in your proposal.

This database contains personal client data,

Database is 95gb, should be likely 30gb

Administración de bases de datos Programación de bases de datos Servidor de Microsoft SQL MySQL SQL

Nº del proyecto: #38740217

Sobre el proyecto

34 propuestas Proyecto remoto Activo hace un mes

34 freelancers están ofertando un promedio de $587 por este trabajo

schuja

Greetings from Germany, My name is Shuja. I have read your project and I can do this. I am working as database developer since 2013 and have designed databases for some startups as well. I have good experience with MS Más

$750 USD en 7 días
(54 comentarios)
7.3
AwaisChaudhry

Hello, I understand you're looking to optimize your SQL Server 2016 database and upgrade it to SQL Server 2019 while ensuring all data is preserved and secured. I have extensive experience in SQL Server and database o Más

$750 USD en 11 días
(32 comentarios)
7.2
yasirk1979

Hi, Could you share the database schema or any additional details on the bloat you’re experiencing? Understanding this will help me plan for the optimal combination of indexing, normalization, and partitioning to stre Más

$700 USD en 7 días
(14 comentarios)
6.4
abdelghafar

Hi there! With over 12 years of experience in software engineering on large and complex projects, I'm sure I can help you finish your project with ease. I have an extensive experience in the following areas: - Sof Más

$750 USD en 7 días
(10 comentarios)
6.3
talhamq

With over a decade of experience in the IT industry, specializing in database management and optimization, I am convinced that I am the right professional to transform your SQL Server 2016 database into a well-oiled ma Más

$300 USD en 1 día
(112 comentarios)
5.7
royalcalif

Hi Mr. Employer I have lot of experience with Microsoft SQL. I can achieve your requirements with your 100% satisfaction. I would like to discuss little bit more about the project. Pm me for more information and sample Más

$250 USD en 6 días
(42 comentarios)
5.6
maverick44000

Hello Sir, With extensive experience in SQL management, I can migrate you to SQL 2019. Please share how many tables do you have in the database. I will share the most safe option to carry out the transition. Thank yo Más

$600 USD en 3 días
(6 comentarios)
4.9
jayantkumar314

Hi there, I have the necessary skill set to design the database properly. I'll also do proper normalization and partitioning if required. Over the past 8 years, I have designed around 100 website databases. Please init Más

$750 USD en 10 días
(37 comentarios)
5.0
kreativesol

Hi there! ✅ I can assist with optimizing your SQL Server 2016 database and migrating it to SQL Server 2019 while ensuring the removal of bloat. With over a decade of experience in database management and optimization, Más

$500 USD en 7 días
(3 comentarios)
4.6
rashidamjad

Dear Mitch, We understand the importance of optimizing and upgrading your SQL database to enhance performance and prevent potential crashes. Our team of SQL experts has extensive experience in database optimization, d Más

$650 USD en 15 días
(4 comentarios)
4.2
DeveloperStation

In my experience working with SQL Server, I have successfully executed similar projects focused on optimizing database performance and ensuring data integrity throughout the process. For instance, I handled a database Más

$500 USD en 7 días
(1 comentario)
3.1
landrejicfl123

Hello, how are you? ⚡Your requirement: Storage overuse is slowing down your SQL Server 2016. You need optimization (indexing, normalization, partitioning) and a smooth upgrade to SQL Server 2019 while preserving cruc Más

$500 USD en 7 días
(0 comentarios)
0.0