Technical Breakdown

Starting Context: Matrix Applications was poised to evolve from Oracle Engineered Systems to a more sustainable PostgreSQL on VMware setup.

Objectives of the Migration:

• Transition to a PostgreSQL database to avoid imminent hardware investments.

• Simplify the database environment for enhanced manageability and cost savings.

• Facilitate a future-proof platform for potential cloud migration.

Cintra's Methodological Approach:

• Selection of PostgreSQL Edition:

  • Opted for the PostgreSQL community edition to ensure compatibility with future cloud environments.

  • Secured enterprise support from EDB for robust failover and monitoring capabilities.

• High-Availability Architecture Design:

  • Implemented active-passive clustering using EDB Failover Manager for enterprise-grade service levels.

  • Integrated EDB Postgres Enterprise Manager for comprehensive system monitoring.

• Application Migration Support:

  • Configured databases to align with security, performance, and availability best practices.

  • Developed and automated new ETL processes for efficient data management across technologies.

  • Provided training for Matrix Applications’ teams on PostgreSQL administration and management.

Benefits & Advantages:

• Cost Savings:

  • Eliminated the need for new hardware purchases and reduced Oracle licensing expenditures.

  • Decreased data center and maintenance costs by optimizing existing VMware investments.

• Performance Enhancements:

  • Notable acceleration in ETL processes and backups, increasing operational efficiency.

• Operational and Future Readiness:

  • Maintained consistent service level agreements post-migration.

  • Established a scalable and flexible architecture ready for cloud transition.