Offer summary

Qualifications:

At least 3 years of experience as a PostgreSQL database administrator., Knowledge of PostgreSQL architecture and experience with related services like Oracle_fdw, HAProxy, Patroni., Experience migrating, upgrading, and maintaining PostgreSQL databases., Fluent Ukrainian language skills and intermediate English proficiency..

Key responsibilities:

Install, configure, and monitor PostgreSQL databases and clusters.

Manage data replication, backup, and recovery processes.

Analyze performance issues and implement improvements.

Handle emergency situations and resolve errors in PostgreSQL operation.

Job description

About the project:

The Client is a card transaction processing company that provides services to banks and other state or commercial companies within Ukraine and abroad. The project offers payment solutions: money transfers, POS services, ATM monitoring services, etc.

The system accepts payments by payment cards and e-wallets and provides convenient tools for the development of e-commerce. Whatever business is: online, offline, or on mobile phone, launch an online store, a mobile application, issue an invoice, or arrange for subscription services - the platform will help with any task. In addition, the team works on separate services for Merchant control, simplified flows to process the payments, etc.

Requirements:

3+ years of experience as a PostgreSQL industrial database administrator, working with OLTP systems;
Understanding of PostgreSQL DBMS (Database Management System) architecture principles with experience configuring and working with additional services like Oracle_fdw, HAProxy, Keepalived, ETCD, Patroni (or similar);
Experience migrating from Oracle or other DBMS to PostgreSQL, upgrading PostgreSQL versions, and installing PostgreSQL updates;
Experience and knowledge of SQL, PL/pgSQL, backup systems (Data Protector, Tivoli), and monitoring systems (Icinga, Zabbix, Prometheus);
Experience with PostgreSQL RDS databases;
Desire to learn new systems to find solutions for task implementation, and independently solve problems within a specified timeframe;
Fluent Ukrainian is required (internal communication is in Ukrainian);
English level – B1/B2.

Will be a plus:

Experience with financial domains;

Responsibilities:

Organization and support of processes for installation, configuration, operation, and monitoring of PostgreSQL DBMS (PostgreSQL cluster with Patroni);
Configuration of physical and logical replication for PostgreSQL databases, as well as data backup and recovery;
Performance issue analysis for PostgreSQL DBMS, identifying and providing recommendations to improve the efficiency of both the database and applications;
Analysis and implementation of security policy requirements, updates, and database backup;
Resolution of emergency situations and errors in PostgreSQL DBMS operation (during and outside of working hours).