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:
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
- 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
- AI with pgvector, pgai etc, the will to learn and expand
- 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
- MS SQL, mysql skills are welcome
- perl, python
