Advanced SQL Database Optimization
Budget: $250 – $750 USD
I'm looking for a skilled database administrator who has extensive experience in SQL, particularly with Postgres. The primary goal of this project is to improve the performance of our current database, which is experiencing a variety of issues.
If the project is completed successfully a follow up project may come.
Key Tasks:
- Normalizing the database and building a new Entity-Relationship Diagram (ERD) that ensures data integrity and efficiency.
- Implementing denormalization and triggers where necessary to optimize performance.
- Writing advanced SQL queries to create and query a robust, performant database that can handle large amounts of data.
Ideal Skills:
- Proficiency in Postgres and advanced SQL.
- Experience with database normalization and denormalization.
- Solid understanding of database performance optimization techniques.
- Ability to write complex queries efficiently.
If the project is completed successfully a follow up project may come.
Key Tasks:
- Normalizing the database and building a new Entity-Relationship Diagram (ERD) that ensures data integrity and efficiency.
- Implementing denormalization and triggers where necessary to optimize performance.
- Writing advanced SQL queries to create and query a robust, performant database that can handle large amounts of data.
Ideal Skills:
- Proficiency in Postgres and advanced SQL.
- Experience with database normalization and denormalization.
- Solid understanding of database performance optimization techniques.
- Ability to write complex queries efficiently.