Database Infrastructure

We provide expertise for the full lifecycle of your databases, leveraging over more than 25 years experience in database infrastructures.

We provide the following expert services :

  • Software Development Support Service: we are very experienced supporting development teams with the technical requirement specifications, database design and performance assessment. We provide advice on development tools and processes to improve the efficiency of development teams.
  • Performance Tuning Service: we deliver performance audit services and carry on short-term, “warfront” business-critical production performance troubleshooting missions on-site or remotely.
  • Migration & Consolidation Service: we migrate your databases within to new servers either on-premise or to the cloud. We execute cross-platform migrations (for example, from Windows to Linux). We consolidate multiple databases on a single server and help you size your servers for optimal utilization.
  • Upgrade Service: we upgrade your database versions and propose an upgrade strategy that suits your availability requirements.
  • Audit Services: we provide a range of audit services (see below for more information).
  • Consulting Services: we provide services that help operational management make informed decisions in the scope of infrastructure evolution, data protection and risk management. See our Management & Strategic Consulting Services page for more details.

Supported RDBMS

postgresql

In a nutshell :

  • All versions
  • Upgrade and migration
  • Cloud IaaS deployment :  Amazon EC2, Microsoft Azure, Google Cloud, Oracle OCP.
  • Cloud DBaaS : Amazon RDS, Azure database for Postgresql.
  • Postgresql on Kubernetes : Zalando’s postgres-operator, Crunchy Data operator, etc
  • High-Availability : patroni, repmgr.

In a nutshell:oracle

  • All supported versions.
  • on-premise or on the cloud : DBaaS (Amazon RDS, Oracle Cloud).
  • Real Application Clusters (RAC)
  • Dataguard
  • Solaris, Linux, and MS Windows.

 

In a nutshell :mysql

  • Mysql : all supported versions
  • MariaDB All supported versions
  • On premise, or on IaaS (Amazon AWS, MS Azure, Google Cloud) and DBaaS (Amazon RDS, Microsoft Azure database for mysql and mariadb.

 

 

In a nutshell :

  • SQL Server 2016 and up
  • On premise or on the cloud : DBaaS/IaaS (Amazon RDS, Microsoft Azure managed instances, elastic pools, etc)

Kubernetes database operators

 

Discover the power of Kubernetes database operators and streamline your database management with ease. Embrace the efficiency of Oracle, SQL Server, Postgresql, mysql, and mariadb operators to enhance your data operations and maximize performance. Elevate your database experience today.

 

Unlock the full potential of your Kubernetes database operators with our expert configuration and integration services. From selecting the right operator for your specific needs to troubleshooting configuration issues, our team will guide your development and operations teams every step of the way. Let us help you harness the power of these operators to enhance your application performance and streamline your production processes.

Audit Services

 

We provide standardized audit services for all the RDBMS we support. The specific tools and techniques used may vary from system to system, but the methodology remains the same and is the fruit of years of experience delivering such services. Below you’ll find our Audit Service catalogue.

We help you improve the performance of your database system through a rigourous and scientific methodology. We start with the capture of baseline metrics in your system to characterize the load and identify bottlenecks. We give you recommendations in order to improve the overall performance of the system through configuration or hardware change (instance tuning).

 

At a second stage, we analyze the SQL statements and the application architecture in order to improve the application performance (SQL tuning and middleware). We work in a controlled test environment and deliver measured and verified recommendations for every test case.

We make a complete evaluation of the database system configuration, storage and administration processes in order to answer the following questions :

 

  • Is the database system coping well with the current workload ?
  • Will the database system be able to sustain the workload for the following X years ?
  • Can the database system grow smoothly ?
  • Are there any limitations of the current technology that I must be aware of ?
  • Is my database system future-proof ?
  • Are our Capacity Planning processes solid ?
  • Is my database system reliable ?
  • Is the database architecture appropriate for the current/future workload ?

This is a punctual evaluation of the system that requires a good understanding of the business processes it supports and is targeted at IT management in need of a risk assessment of the current infrastructure assets.

We perform a through analysis of the database system in order to identify security vulnerabilities and provide recommendations  to overcome them.

 

We investigate data privacy issues when required, in order to identify encryption requirements and regulatory compliance (GDPR). We help you not only discover and classify your data but put in place anonymization measures and fine-grained access controls.

 

 

We perform a scalability analysis based on benchmarks and capacity models in order to evaluate how well a database system can scale under a certain level of concurrency.  This study is useful when evaluating new hardware investment for a database system and it’s important to have an idea of how the system will scale under a certain load.

We not only consider scale-up scenarios but also scale-out architectural choices.

 

We help you migration your databases to the cloud service of your choice.
We evaluate with you  the different options to migrate, the tools to assess the right capacity to sustain your workloads, the means to ensure high availability, the disaster recovery scenarios, the security guarantees and the monitoring.