Experience of implementation of the projects based on PostgreSQL

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

Design of DB model:

• Design tools: EMS SQL Manager for PostgreSQL, 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.