Database Administrator

extra holidays - extra parental leave
Work set-up: 
Full Remote
Contract: 
Experience: 
Mid-level (2-5 years)
Work from: 

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.

Softjourn logo
Softjourn SME https://softjourn.com/
201 - 500 Employees
See all jobs

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

 

Required profile

Experience

Level of experience: Mid-level (2-5 years)
Spoken language(s):
UkrainianEnglish
Check out the description to know which languages are mandatory.

Other Skills

  • Willingness To Learn
  • Time Management
  • Problem Solving

Database Administrator Related jobs