Database Administrator

Summary

Join a team at a card transaction processing company that provides services to banks and other companies in Ukraine and abroad. The project offers payment solutions including money transfers, POS services, and ATM monitoring. As a PostgreSQL Database Administrator, you will be responsible for the organization and support of processes for installation, configuration, operation, and monitoring of the PostgreSQL DBMS. You will also configure replication, backups, and recovery, analyze performance issues, and implement security policies. The role requires 3+ years of experience with PostgreSQL in OLTP systems and familiarity with various related technologies. Fluency in Ukrainian and English (B1/B2) is required.

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

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)

Preferred Qualifications

Experience with financial domains