PostgreSQL Data Engineer, Glyfada, Athens, Greece

PostgreSQL Data Engineer

Job description

This is a position within Dynacom Tankers Mgmt - IT Dept. Our core business
is ship owning, ship management, shipyards and other business fields as
well.

Our team consists of experienced programmers, administrators and engineers
who constantly deliver state of the art products and services to the
company's departments, subsidiaries and vessels.

The Candidate will be responsible for the design, testing, maintenance,
monitoring of the company's DB systems.

Responsibilities:

-

Design efficient architectures around PostgreSQL
-

Troubleshoot slow queries
-

Monitor for performance, database health, correct table and index
bloating, etc
-

Understand our current architecture and maintain it
-

Work closely with the sysadms in order to deliver the best design
-

Work closely with the dev team in order to help deliver efficient
software and systems
-

Add value to the company by helping with OLAP
-

Take part of a very large PostgreSQL upgrade across 100s of installations

Required skills:

-

At least 3 years of working with PostgreSQL, versions from 10 upwards
-

Knowledge of PL/pgSQL, functions, procedures
-

Experience with PostgreSQL on Linux or BSD
-

Solid knowledge of fundamental PostgreSQL concepts
-

Great SQL skills
-

Great Unix/Linux/BSD skills, OS knowledge, Bash, awk, sed etc
-

High level of understanding of the whole stack of a software system

Nice to have:

-

pgbadger, pg_stat_statements
-

pgbouncer, pgpool2
-

pgbackrest or other backup software
-

Logical Replication, Physical Replication + PITR
-

Major PostgreSQL upgrade experience
-

java experience is big plus
-

mysql, MS SQL skills are more than welcome
-

perl, python

We offer:

-

Competitive compensation, above market average
-

Stable working environment