
$1,000+
Min Project Size
25-49
Avg Hourly Rate
2-9
Employees
2020
Year Founded
Bufisa was established with the goal of delivering cutting-edge IT solutions to our clients, particularly in PostgreSQL Database Management and SQL Development. To support our credibility, my team has successfully managed PostgreSQL Database Management and SQL Development projects for clients from Europe, America, and Asia. You can view our profile and client testimonials at https://www.upwork.com/agencies/bufisa. We focus extensively on optimizing PostgreSQL performance through various methods, including Linux and PostgreSQL configuration tuning, database structure optimization (such as indexing, materialized views, and partitioning), and advanced querying techniques that enhance query execution plans for better performance. Our expertise extends to database design, encompassing database normalization, setting table and column constraints, establishing primary and foreign keys, creating triggers and views, and developing indexing strategies. We also have considerable experience in generating reports from SQL databases and can refine queries for optimal performance. Additionally, we participated in a data analytics project utilizing Looker and AWS Redshift (based on PostgreSQL 8.0) for about four months, where we restructured tables and crafted queries, as well as migrated a SQL Server database to PostgreSQL. SQL Development is an integral part of our services. Since January 2014, we have been providing PostgreSQL DBA services for USIC (one of the largest American companies), including assisting with query tuning. Currently, we manage approximately six PostgreSQL database servers, which encompass a production database (around 5 TB, 32 cores, and 145 GB RAM), a Slony replica, a streaming replica, a GIS database, a monitoring database, and a developer database. Our responsibilities include performance tuning, migrating production databases, conducting PostgreSQL data center migrations (complete migration of all PostgreSQL database servers), routine maintenance, troubleshooting, and performing daily DBA tasks.
$1,000+
Min Project Size
25-49
Avg Hourly Rate
2-9
Employees
2020
Year Founded
Min Project Size
Avg Hourly Rate
Cost Rating
"Bufisa Global Datatech delivers quality projects within budget and timeline expectations based on verified client feedback."
Based on verified reviews and internal benchmark data
0 Reviews
this rangeNo distribution data available.
Be the first to share your experience working with Bufisa Global Datatech.