The same as designing a database on any other platform.
On the hardware side make sure that you have enough RAM and CPU power. Make sure that you have enough disk space, and that the storage is fast enough. Make sure you have a way to back everything up.
Within the database, use the correct data types, and the correct recovery model and database engine for the project. A properly designed relational model is key to maintaining good performance as the database grows.