Jobs
1-
Β· 42 views Β· 0 applications Β· 6d
Database Administrator
Full Remote Β· Ukraine Β· 3 years of experience Β· Pre-IntermediateAbout 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...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).
About us:
Softjourn is a full-cycle consulting and software development company, with expert product teams experienced in Fintech, Media & Entertainment, with a special emphasis on Ticketing. Headquartered in Silicon Valley, California, with R&D offices in Ukraine, Poland, and Brazil, Softjourn is a global software development company with over 20 years of experience.
Softjourn has been honored as a veteran-friendly business by the Veteran Hub in Ukraine. We are committed to creating a supportive environment for veterans and implementing processes that address their needs. We highly value the unique skills and perspectives that military veterans bring to our company and are dedicated to assisting their transition to the workforce.
Softjourn Inc. is an Equal Opportunity Employer. We celebrate diversity in all forms and are committed to maintaining a discrimination-free workplace that treats applicants and employees with dignity and respect. Our employment process is conducted without regard to race, color, religion, nationality or ethnic background, sex, pregnancy, sexual orientation, gender identity or expression, age, disability, protected veteran status, genetic information, or other attributes protected by state, federal, and local law.
More