PostgreSQL Support & Services

REMOTE DBA SERVICES

 

PostgreSQL Infrastructure

• PostgreSQL Setup & Installation

• PostgreSQL Automation

• Database Architecture

• Capacity Planning

 

PostgreSQL Migration

• From MS SQL Server to PostgreSQL

• From Oracle to PostgreSQL

• From MySQL / MariaDB to PostgreSQL

 

PostgreSQL High Availability

• High Availability (with Patroni)

• PostgreSQL Replication (Streaming)

• PostgreSQL Load Balancing (LB)

• PostgreSQL Pooling (with PgBouncer)

 

PostgreSQL Optimization & Security

• PostgreSQL Health Check

• Performance Tuning

• Advanced Level Security

​

PostgreSQL Troubleshooting & Data Recovery

• Database Restore from Backup

• Analyzing, Find and Fixing Errors

• Professional Data Recovery

 

 

PostgreSQL Update & Upgrade

• Upgrade to the New PostgreSQL Version

• Add New Features to PostgreSQL

• Update Features and Packages for PostgreSQL

​

Requirement Analysis

• Create Recommendations and concepts that refer individually to your requirements

• Concept for your PostgreSQL setup

• Concept for migration to PostgreSQL

• Consulting Database modeling

• Consulting regarding infrastructure and architecture

• High Availability concept

• Performance Analysis

• Backup and Restore concept

• Security concept

 

 

PostgreSQL Consulting

• Consulting Security & Optimization

• Consulting High Availability

• Consulting Backup and Restore

• Consulting Migration & Replication

• Consulting Upgrade & Update

• Consulting Development (PL/pgSQL)

• Consulting Support

 

PostgreSQL Development

• Modification of Existing Tables in Database (DDL)

• Optimization Existing Procedures and Functions in Database

• Improvement of Procedures & Functions

​

PostgreSQL Database Design

• Planning and Create New Database Design for Project

• Create New Database Objects (tables, views, functions, procedures, triggers)

• Create New Indexes for Tables and Views

 

PostgreSQL Support

• Standard Package:

  • 5/9 Remote DBA Support (5/9 means: Monday - Friday, 9am - 6pm)

  • 7/24 Remote DBA Support (7/24 means: Anytime)

• Enterprise Package:

  • 5/9 Remote DBA Support (5/9 means: Monday - Friday, 9am - 6pm)

  • 7/24 Remote DBA Support (7/24 means: Anytime)

​