Gathering of information and construction of the logical, physical model and implementation of small and big relational databases, up to 1200 entities, with SQL script to build it in a postgresql environment, creation of indexes, primary keys, foreign keys, relationships, index optimization based on the most frequent queries, data dictionary and entity relationship diagram.
Additionally we can build stored procedures, functions, triggers, aggregate functions, huge table partitioning, data migration and transfer, data analysis, and optimization of complex queries.