Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rb1Dw-00Ce2n-QI for pgsql-jobs@arkaria.postgresql.org; Fri, 16 Feb 2024 16:38:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rb1Dv-002tE0-Cx for pgsql-jobs@arkaria.postgresql.org; Fri, 16 Feb 2024 16:38:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ra9eT-004ad7-O0 for pgsql-jobs@lists.postgresql.org; Wed, 14 Feb 2024 07:25:53 +0000 Received: from mail-vk1-xa36.google.com ([2607:f8b0:4864:20::a36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ra9eR-0077Iu-Fz for pgsql-jobs@lists.postgresql.org; Wed, 14 Feb 2024 07:25:53 +0000 Received: by mail-vk1-xa36.google.com with SMTP id 71dfb90a1353d-4c02478c8efso1228728e0c.0 for ; Tue, 13 Feb 2024 23:25:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1707895550; x=1708500350; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=2XblYCUWK/k55c7NWYQvu6xISlYs2iekKlrhciA+pjA=; b=XuMXSjgXZPBw7awu4wqZsdEiPow0/4nVs41+Kk2+7WZta+5FSOyyBkLAXEu4Sh66Cw h7uE0PxahsWdY5p+Y0IcLIfSNHhrRoGXMAKeLL4mXVViUCN9ltyXJ+dLoEz5mOfgISSa EkYyt6GZ0omPjMX7G7+7yg8UF9RriGipzQkVYbJLKplttUNT0ZgW8TZMv8m7NCB41yMg sa4wf3Pqymq5lkiJBtbfbGoq+WIVE/kL2f5Fdo1eEgysla1dhELhs8Gr/LKSKwriB7gZ v9X/jS5WMMB0VbBdJsuDP0Y8X9p77s/QVsaNm+VLQAv1Qx+ccSyfuPJXgUS1YhgGqxVo 7hiQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1707895550; x=1708500350; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=2XblYCUWK/k55c7NWYQvu6xISlYs2iekKlrhciA+pjA=; b=gi40WuGOd8i6KqdRZrKJ3KdSN6zIVUk5X4bWdLxKQwXYXD6RKqo72jwPhrA/kr6Jsd WMOKAJUCH9uukiqptg3pk6vTtwQlhMmqIZ6p46+Ls7qqRAcabMYooKz0qI0Pj4ZQmKMq /zEdAGQL7xGDkxUwjyGqsm2j1wF8pEGh+EwWyXI9NWbijUKBjyHK5rnsTuiRf+wTUixG M+hQ1SIktesdgKAXc+TVkQDMmbLGW2dyVsVzaSnPIrNSnnX/u2FrNEyb6g0RnqfmGtkf 09jJHy+u1woEWt4S6ei5/gQ5bRzYc2UGfnJN3B1PQ4w3vpZQtpkDN2oyU+fuFXAun3YB oSIg== X-Gm-Message-State: AOJu0Yxq5l7EOFbXY1Ulh2sgak/Ym5vW96E5gANP1SainLCYi+Lh25P1 Idd+/iiID1xqtWgn25HQ3Beeh5cdMUuF+4+jIDat4fQgVJSBCXYz41OCy0GWlu/Nhs8LVDVSFBf rG1Ag5rWNOomaokW2xwHD/8u3y4owRdUc8iM= X-Google-Smtp-Source: AGHT+IEAm87Tro5ICqm5ArbyrWzSIw3Ga9K3ILO8mDMQo5T0g9uvuYc3DATPmJU5VeXgk0rEUjGKIWOwleU9c3MFEqE= X-Received: by 2002:a1f:e403:0:b0:4c0:2ae7:7859 with SMTP id b3-20020a1fe403000000b004c02ae77859mr1637193vkh.14.1707895549544; Tue, 13 Feb 2024 23:25:49 -0800 (PST) MIME-Version: 1.0 From: Achilleas Mantzios Date: Wed, 14 Feb 2024 09:25:38 +0200 Message-ID: Subject: PostgreSQL Data Engineer, Glyfada, Athens, Greece To: pgsql-jobs@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000008b51880611526b09" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008b51880611526b09 Content-Type: text/plain; charset="UTF-8" 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 --0000000000008b51880611526b09 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

PostgreSQL Data Engineer


Job description<= /p>

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

Our team consists of experienced programmers, admini= strators 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, maintenanc= e, monitoring of the company's DB systems.


Responsibilit= ies:

  • Design efficient architectures around= PostgreSQL

  • Troubleshoot slow queries

  • Monitor for performance,=C2=A0 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 i= n order to help deliver efficient software and systems

  • Add value to the company by he= lping with OLAP

  • Take part of a very large PostgreSQL upgrade across 100s of installa= tions

Required skills:

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

  • Knowledge = of PL/pgSQL, functions, procedures=C2=A0

  • Experience with PostgreSQL on Linux or BSD

  • Solid know= ledge of fundamental PostgreSQL concepts

  • Great SQL skills

  • Great Unix/Linux/BSD skills, OS knowl= edge, Bash, awk, sed etc

  • High level of understanding of the whole stack of a soft= ware system


Nice to have:

  • pgbadger, pg_stat_statements

  • pgbouncer, pgpool2

  • pgbackrest=C2=A0 or other backup soft= ware

  • Logic= al Replication, Physical Replication + PITR

  • Major PostgreSQL upgrade experience

  • java experience= is big plus

  • mysql, MS SQL skills are more than welcome

  • perl, python


W= e offer:

  • Competitive compensation, above= market average

  • Stable working environment

--0000000000008b51880611526b09--