Join us at the NYC and Philadelphia PostgreSQL User Groups

Architectural and Database Audit

OpenSCG can deliver a performance and security audit of your PostgreSQL database to ensure your system is fully optimized. Our PostgreSQL Architectural and Database Audit assesses all aspects of your database environment including the client applications utilizing the database and will enable OpenSCG to identify any bottlenecks or medium term considerations for the ongoing performance optimization of your database and application. Our audits use a combination of monitoring tools and practical experience to understand all aspects of your database environment.

The final deliverable of the engagement will be a report that provides comprehensive diagnostics and will make practical recommendations for any performance or configuration optimization. Many organizations decide to have an independent assessment of this nature carried out on a regular basis, whether for compliance purposes or just for additional peace of mind.

An Architectural and Database Audit includes

  • Backup and Recovery Audit
    • The audit will validate your backup and recovery procedures to ensure that your PostgreSQL database can be recovered in cases of hardware or software failure.
  • PostgreSQL Best Practices Audit
    • We ensure that your database follows best practices for manageability and configuration.
  • PostgreSQL Performance Audit
    • We will review all of the PostgreSQL parameters and disk configuration to ensure that your database is optimized to make maximum use of all available hardware resources. This includes a check of the disk I/O sub-system latency (disk bottlenecks) and a review of Network, RAM and CPU utilization.
  • PostgreSQL Security Audit
    • We will review the current PostgreSQL security configuration to ensure that only the users allowed to see your sensitive data will be able to see it.

Talk to us about your Architectural and Database Audit requirements.

Please email us at info@openscg.com or call us +1-908-864-0906.