You will get Solve performance issues & setup HA PostgreSQL with a trusted DBA.
Project details
What sets me and my PostgreSQL consulting services apart is a deep, hands-on expertise developed through years of managing complex database systems in high-traffic environments. I offer end-to-end solutions tailored to your specific needs—whether it's performance optimization, monitoring setup, or high availability architecture. Each engagement begins with a thorough assessment to identify bottlenecks and improvement areas, followed by clear, actionable recommendations. I prioritize automation and best practices to ensure consistency, reliability, and minimal operational overhead.
My approach is not just technical—it’s also strategic. I aim to empower your team by transferring knowledge, providing documentation, and implementing scalable solutions that reduce long-term risks. Whether you’re a startup scaling fast or a large enterprise with mission-critical systems, I adapt to your context and deliver measurable results. With a focus on transparency, collaboration, and long-term support, my goal is to build systems that perform reliably—day in and day out.
My approach is not just technical—it’s also strategic. I aim to empower your team by transferring knowledge, providing documentation, and implementing scalable solutions that reduce long-term risks. Whether you’re a startup scaling fast or a large enterprise with mission-critical systems, I adapt to your context and deliver measurable results. With a focus on transparency, collaboration, and long-term support, my goal is to build systems that perform reliably—day in and day out.
Database Type
PostgreSQLWhat's included
| Service Tiers |
Starter
$100
|
Standard
$500
|
Advanced
$1,000
|
|---|---|---|---|
| Delivery Time | 1 day | 3 days | 7 days |
Number of Revisions | 0 | 0 | 0 |
Source Code | - | - | - |
2 reviews
(2)
(0)
(0)
(0)
(0)
This project doesn't have any reviews.
AV
Andy V.
Dec 11, 2024
setting up Haproxy, pgBouncer and pgwatch2
Was a pleasure working together and many thanks for the quick and professional service.
UA
Usman A.
Dec 31, 2020
Forensically Investigate an Image and write a Report
Emre knows his stuff really well and he's been helpful throughout the project with effective communication, Would recommend him
About Emre
PostgreSQL Database Administrator
100%
Job Success
Ankara, Turkey - 11:40 am local time
Database Administrator
Updating the PostgreSQL Server database with Version 12.6.7 to Version 15.2 was carried out.
PostgreSQL Cluster managed with Repmgr has been migrated to Patroni Cluster.
Central Consul Cluster was installed and the management of Patroni Clusters was provided through this Cluster.
PgWatch2 & Grafana has been installed to monitor PostgreSQL Cluster. Database performance reports are taken daily by automating PgBadger.
Version updates of Haproxy, Keepalived and PGBouncer tools have been made.
Performing Database Index and Table bloat maintenance
Performing SQL Tuning, Table Partitioning studies
Management of PostgreSQL System Parameters
Establishing the Database Backup mechanism, providing back-up tests, establishing a database from 8 hours behind
Yüksek Seçim Kurulu Başkanlığı Seçmen Kütüğü Genel Müdürlüğü
Database Administrator
EDB Postgres & PostgreSQL Docker Mimarisi
EDB Postgres v.12.6.7 Working on Intranet and Internet networks, studies were carried out on the management of Live and Test Databases, log & audit management, creation of database monitoring infrastructures, and backup and restore management.
EDB Postgres EFM Mimarisi
In order to bring high availability and failover capabilities to the real environment EDB-Postgres database, EnterpriseDB Fail-over Manager tool was installed and a cluster structure was gained in the test environment. It consists of Cluster 1 Primary 2 Standby Database. Stanby databases are configured as Synchronous-Asynchronous.
Switchover-failover tests of EDB Postgres EFM architecture, replication management were done by me.
In order to monitor the established database, Pgwatch2-Grafana has been installed and the database has been made continuously monitorable.
Restoration tests were carried out by me by establishing the Backup architecture of the test database. PgBackrest tool is used for the backup system.
The installation of the EnterpriseDB High Availability Architecture installed in the test environment to the live environment and the database version updates were made by me.
Steps for completing your project
After purchasing the project, send requirements so Emre can start the project.
Delivery time starts when Emre receives requirements from you.
Emre works on your project following the steps below.
Revisions may occur after the delivery date.
Client purchases the project and submits the requirements
The client selects the service package and shares environment details, access credentials, and expectations.
Initial assessment and scope confirmation
I review the provided information, clarify the scope, and confirm deliverables and timelines.