CRM system - VoIP:
It will be necessary to extract information on orders daily:
- which products
- when they were ordered
- in what quantity
- at what price
- UTM tags
- Manager who accepted the order
Warehouse system - My Warehouse: extract information on:
- product stock
- delivery dates
- quantities of orders in stock at suppliers with arrival dates.
Regarding the database:
1. Setting up a virtual network
2. Setting up computing resources
Create virtual machines (VM) with the necessary configuration of CPU, RAM, and storage (disk space).
3. Setting up data storage
- Ensure data replication across different availability zones for increased reliability.
4. Setting up the database
Select the best option and deploy databases:- SQL Server on VM for relational data.
- MySQL, PostgreSQL, or other databases as per project requirements.
- Create database backups and set up automatic recovery.
5. Setting up security
Install SSL certificates for secure access to applications.
- Configure firewall policies to restrict access to servers and databases.
6. Monitoring and management
Set up data collection on resource performance (CPU, memory, traffic).
- Create alerts based on defined metrics (e.g., high CPU usage or low disk space).
- Set up log collection and data analysis.
7. Security requirements
- Ensure data encryption at rest.
- Set up protection against DDoS attacks (Azure DDoS Protection).
- Regularly update software and operating systems.
8. Testing and deployment
- Conduct testing of computing resources, databases, and network settings.
- Verify backups and data recovery.
- Set up a test environment for safe deployment of new application versions before going to production.
9. Documentation
- Create instructions for administrators and developers on setting up and maintaining the environment.
- Provide documentation describing the structure of resources and networks.
All of the above points may be changed/edited by the executor after analyzing the required project outcome (to be discussed in person).
Kyiv