Streaming replication in practice.
My slides about PostgreSQL Streaming Replication from PgConf 2016 Russia.
Working with databases one can’t help but wonder what happens with data stored on the disk. For example you need to know this to be able to…
В прошлой статье я описал общие настройки AUTOVACUUM, подходящие для обычной работы. Параметры агрессивные, но позволяют работать другим процессам в нормальном режиме. Часто обновляемые таблицы – это…
Пару дней назад к нам поступил вопрос – можно ли ускорить процесс VACUUMа на больших таблицах в момент когда процесс уже запущен. В кратце, нет, VACUUM ускорить…
In my previous post I gave an overview of some general parameters that will work well in a standard setting. They might be aggressive, but will allow…
We are a consulting firm that offers remote PostgreSQL administration services. We are looking for a seasoned PostgreSQL DBA specialist for a remote full-time position.
Who will you be working with?
Some clients have their own DBA teams, with whom you will be working and some don’t – in this case you will be working with client’s developers and technical managers. In either case you will be surrounded by best in class Data Egret PostgreSQL DBA, who have many years of experience servicing our clients.
What skills will you gain?
As well as harnessing your technical skills you will grow as a technical support specialist, who is able to listen to our clients, ask questions, review possible solutions with them, and be a reliable partner, who will add value beyond customer expectations.
What will your job be?
You will be the focal point to our clients when it comes to databases – figuring out why things don’t work the way they should, providing guidance and fixes to ensure that our client’s high availability projects go like clockwork.
Here are a few examples of your day-to-day technical tasks:
What do we expect from you?
This is a client facing role and the ability to communicate your actions and be able to reason with clients is imperative.
What skills would be a plus?
Why choose Data Egret as your place of work?
What do we offer?
Think you qualify?
Workshops usually have hands-on elements, we therefore suggest limiting the number of attendees to a maximum of 15.
Looking to upscale your team with PostgreSQL know-how? Contact us now.
|PostgreSQL configuration analysis||from 500 €|
|Hardware and OS configuration analysis||from 600 €|
|Slow SQL queries analysis||from 500 €|
|Comprehensive performance Health Check*||from 3500 €|
|* For single PostgreSQL installation (1 master + 1 replica)
|Incl. up to 5h/month consultation time||Incl. up to 10h/month consultation time||Incl. up to 20h/month consultation time|
|1 dedicated named contact
|2 dedicated named contacts
|3 dedicated named contacts
|Response time — 30 minutes||Response time — 15 minutes||Response time — 15 minutes|
|Starting 2.100€ month||Starting 5.000€ month||Starting 10.000€ month|