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).
