Database Administrator

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