Experience of implementation of the projects based on PostgreSQL

Versions of PostgreSQL DBMS: 7.x, 8.x.

Design of DB model and business-processes:

  • Design tools: Sybase PowerDesigner, Platinum Erwin, Rational Rose.
  • Design experience: sophisticated DB model using for social networking using various DB-side business logic object and different integration platforms (e.g. PostgreSQL->MySQL integration on DB business-logic layer).

DB-side design of business logic:

  • Programming languages: PLPGSQL, PLPERL.
  • Usage of stored procedures, triggers, views and other features for implementation of db-layer business logic object. Vast experience in SQL-queries optimization.
  • Technologies:
    • FULL-TEXT search support;
    • Various data storing possibilities as Geometric, Network and other data types;
    • Functional and Partial indexes - is used to reach the best performance;
    • Native SSL support;
    • Replication (3-rd party libraries).
  • Administering:
    • Installation of PostgreSQL and other components to Linux and Windows platforms;
    • Initial data filling, using export/import, data pump utilities;
    • DB monitoring. Settings and recommendations for improving of its performance;
    • DB cloning;
    • DB backup and restoring;
    • Server hardware settings;
    • Data privacy and security-related issues.
  • Additional info:
    • Experience in DB remote installation and maintenance;
    • Experience in managing of large data bulks;
    • Experience in adjusting and applying systems to various business areas.