We provide the user with administrative and consultative services and also maintenance relating to working with Postgre SQL database.
Some typical activities are:
- monitoring disk space
- monitoring database load and the server on top of which the databases are (processor load, disk traffic, etc.)
- monitoring and inspecting database production logs
- verifying adequate space in backup system, and backup success
- help with resolving problems like system halt and/or database operation problems
- participating in upgrade preparations
- optimization suggestions at database level
- warnings of possible problems in database operation
- replication status check
- monthly system condition report
- available hardware support analysis and issuing recommendations for procuring new hardware support
- network traffic analysis according to database management system, issuing recommendations for physical and logical organisation of network and communication infrastructure
- analysis of security aspects of information system and nominating security problem solutions
- bulk data or entire database migration