Bufisa Global Datatech

Bufisa was founded with the vision to provide advanced IT Solutions to our clients, especially in scope of PostgreSQL Database Management/SQL Developing. To convince you, my team has been trusted by some clients from European, American and Asian Countries to handle PostgreSQL Database Management/SQL Developing projects. You can check out our profile and clients' acknowledgment at https://www.upwork.com/agencies/bufisa.

PostgreSQL performance is one of the biggest topic that we work on, through Linux configuration tuning, PostgreSQL configuration tuning, database structure tuning (index, materialized views, partitioning, etc), advanced query technique, query execution plan and can fine tune query for performance, etc. 

We have experience in designing database, know database normalization, table and column constraints, primary keys and foreign keys, trigger functions, views, materialized views, indexing strategy, etc. We also have much experience with producing reports on SQL databases, know advanced query technique, query execution plan and can fine tune query for performance. We have also ever involved in data analytics project using Looker and AWS Redshift (based on PostgreSQL 8.0) around 4 months, redesigned table structure, and created queries, including imigrated SQL Server database to PostgreSQL. SQL Developing is also a part of our business core.

We have been handling works as PostgreSQL DBA on USIC (One of the biggest American Companies) since January 2014, here we have been also helping with query tuning. We have been managing about 6 PostgreSQL DB servers, including production DB (sized around 5 TB, 32 core, 145 GB RAM), slony replica, streaming replica, GIS DB, monitoring DB, and developer DB. Here we have done with performance tuning, production DB migration, and also PostgreSQL datacenter migration (complete migration of all PostgreSQL DB servers), routine maintenance, troubleshooting, and daily DBA task.