Skip to content
HomeServicesPackagesProjectsAbout
Services

PostgreSQL and Databases

Slow reports, locked tables and queries that get more expensive as you grow. Getting the data model right and speeding up complex queries is some of the work I enjoy most. I work with advanced experience on PostgreSQL.

What I Do

  • Relational data model and schema design
  • Query and index optimization with EXPLAIN ANALYZE
  • Partitioning and archiving for large tables
  • Data migration to PostgreSQL from other databases
  • Backup, replication and monitoring setup

Fixed-Scope Package

All packages

PostgreSQL Health Check

A review that finds the cause of slow queries, missing indexes and risky settings.

  • Analysis of the slowest queries with EXPLAIN ANALYZE
  • Assessment of indexes, schema and data model
  • Check of the backup, replication and monitoring setup
  • Review of connection and memory settings

Deliverable: A list of fixes ranked by impact, with example query and index changes

From €1,800 (excl. VAT)

3 business days

Request a quote

How I Work

  1. 1

    Discovery Call

    We clarify the need, the current state and the goal together.

  2. 2

    Analysis and Plan

    I put the scope, the risks and the roadmap in writing.

  3. 3

    Development

    I work in short iterations, so you can see every step.

  4. 4

    Go Live

    I release with tests, monitoring and a rollback plan.

  5. 5

    Support and Handover

    I hand the documentation and the knowledge over to your team.

Frequently Asked Questions

Do you work remotely?

Mostly, yes, and I work with clients in other countries and time zones. I am based in Mersin, Turkey (UTC+3); when the work requires it, we can also plan on-site meetings or working days.

How do you charge?

It depends on the type of work: a fixed project price for work with a clear scope (an architecture review, for example), a day rate for work whose scope will become clear over time (€600 per day (excl. VAT)), and a fixed monthly fee for ongoing work (such as a fractional software architect, a fractional CTO or maintenance). For a fractional architect or fractional CTO the fee is from €2,400 per month for 1 day a week (excl. VAT); for maintenance it is from €1,200 per month with 2 days included (excl. VAT); unused days do not roll over. Starting prices for the fixed-scope packages are listed on the packages page, in EUR and excluding VAT; I send the exact price in a written quote after our first call.

What are your payment terms?

Half of the fee is paid upfront when the work starts, and the other half on delivery.

Do you issue invoices?

Yes. Every piece of work is invoiced in EUR by my company in Turkey, SDR Bilişim Hizmetleri Dijital Yazılım E-Ticaret Danışmanlığı İthalat İhracat Limited Şirketi.

Do you sign a contract?

If you want one, yes: scope, delivery, fees and confidentiality are set out in a written contract. For work where you do not want a contract, the written quote and your approval apply.

Who owns the source code and the rights?

You do. Once payment is complete, the source code, the documentation and all rights to the software pass to you.

Will you sign a data processing agreement?

Yes. For work that requires me to access personal data, I sign a data processing agreement.

Will you sign a non-disclosure agreement (NDA)?

Yes. If you like, I can sign it before our first call, before we discuss any details of your project.

When can you start?

I can start a project with a clear scope within 1 week. We agree the exact date together on our first call.

Who works on my project?

I do, Umut Yerebakmaz, directly. I do not hand the work over to someone less experienced; you deal with the same person from the first call to delivery. For continuity I document every decision and technical detail and pass the knowledge on to your team, so the software does not depend on me.

Will you work with our existing software team?

Yes. As a fractional software architect I can work as part of your team: guiding architecture decisions, reviewing code, building the hard parts together and passing the knowledge on to the team. My aim is to strengthen your team, not to make it dependent on me.

What happens after the work is done?

I hand the software over to your team with its documentation, and run a knowledge transfer session that explains how the code and infrastructure work. If you like, we can continue with monthly support afterwards; I respond to support requests within 1 business day.