SQL Database Optimization & Upgrade to 2019

Job ID: 38740217

Budget: $250 – $750 USD

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