Category: performance

Subscribe

Filters

Ускоряем VACUUM в PostgreSQL

Пару дней назад к нам поступил вопрос – можно ли ускорить процесс VACUUMа на больших таблицах в момент когда процесс уже запущен. В кратце, нет, VACUUM ускорить…

Vacuuming update-heavy tables

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…

Why avoid long transactions?

The majority of PostgreSQL community clearly understands why long and idle transactions are “bad”. But when you talk about it to the newcomers it’s always a good…

Let’s speed things up.

Parallelism settings and how to accelerate your database performance. Few days ago, when performing a routine audit for our client, we noticed that parallel queries in the…

PostgreSQL Performance Meltdown?

Overview On the 30th of December 2017, Kernel page-table isolation (PTI) patch had been merged with the mainline. Its main goal was to mitigate the Meltdown…

Deep dive into postgres stats: pg_stat_user_indexes

Everything you always wanted to know about Postgres stats One of the major strengths of PostgreSQL are indexes – they are flexible and cover almost all use…

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:

Make changes in database’s schema under load
Perform slow query analysis and optimisation
Correctly create/adjust indexes for query optimisation
Set up and configure Postgres on new servers
Setup Postgres database replication
Perform failover/switchover
Set up backup process and perform recovery
Perform minor and major upgrades
Architectural consulting
Database health check

What do we expect from you?

You are a seasoned DBA with 2 or more years of experience in administering high availability PostgreSQL projects (including replication configuration, performance tuning, monitoring configuration etc.)
Have experience in optimising complex SQL queries
Enjoy working independently on vague client briefs
You are a confident Linux user and know how to administer it (Ubuntu/Debian/RedHat),
Have a general understanding of database theory
Have basic knowledge of shell scripting (writing a couple of screens-lengthy script that will be understandable to other admins and yourself a few month down the line)
You can write a complex (and very complex) SQL query
You are a keen learner and eager to discover new solutions to old problems

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?

Familiarity with Patroni
Familiarity with some DevOps tools such as Ansible/Docker/Kubernetes
C programming skills and experience in analysing with perf/strace/gdb
Administration experience with cloud platforms
Basic knowledge of Russian language would be a plus

Why choose Data Egret as your place of work?

You will become part of one of the leading PostgreSQL DBA teams working in a company that has been named a significant sponsor to PostgreSQL by the Postgres community.
Will be able to brush up your database administration skills on a multitude of databases in different environments and gain experience that would take you years to get working in-house.

What do we offer?

A competitive pay based on your experience and annual performance-based bonus scheme
Full-remote working, offering you the opportunity to actually have a life 🙂
Flexible working hours
An opportunity to work alongside colleagues DBA, who live and breathe Postgres and contribute to its development
Support of your participation in community conferences
Collaborative and open environment where you are supported by your colleagues and can learn and thrive

Think you qualify?

Have questions about this opportunity?
Contact us! [email protected]

Health Check

Most emergencies leading to service unavailability and loss of your data can be mitigated and detected at an early stage with minimal effort. Data Egret Health Check will ensure a smooth running of your service, give you a headstart for your launch or migration and will allow better budgetary planning.

We will provide you a tailored offering based on your system specifications, however, below rates will give you an idea of pricing for our Health Check solution.

Package	Price*
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)

24/7 Support

24/7 PostgreSQL Support offers you a combination of ongoing consultancy from our experts as well as round the clock support from dedicated team. To ensure smooth running of your systems and give you peace of mind we will be providing following services:

Dedicated Data Egret team

that will be your contact in case of any questions or concerns. Team that will be aware of your system’s specifications and will work on any arising issues within 15 minutes to an hour from enquiry.

Real time counsel

on everything PostgreSQL provided by our team of experts to your company developers and operations engineers.

Ongoing monitoring of your databases

that includes query performance, issues management and recommendation on performance improvements.

Regular upgrades

of PostgreSQL and related software.

Backup and recovery

that includes regular backup of your database and recovery solution with regular test recovery.

Basic	Premium	VIP
Incl. up to 5h/month DBA time	Incl. up to 15h/month DBA time	Incl. up to 30h/month DBA time
Slack, Mattermost, Telegram	Slack, Mattermost, Telegram	Slack, Mattermost, Telegram
Response time — 1 Hour	Response time — 1 Hour	Response time — 30 minutes
Up to 2 PostgreSQL instances	Up to 5 PostgreSQL instances	Up to 10 PostgreSQL instances