Job Details

Database Engineer vacancy at a company developing technological solutions for the payment industry, e-commerce, and fintech sectors. Work in a strong team, opportunities for professional growth.

The company develops technological solutions for the payment industry, e-commerce, and fintech sectors. Products are targeted at international markets and handle high loads and large volumes of data. Responsibilities: - Design and development of architecture and data models for OLTP/OLAP systems - Development of high-load SQL pipelines (ETL/ELT within the database) - Optimization of complex queries (large joins, aggregations, window functions) - Working with partitioned tables and large data volumes (tens of millions of records per day) - Development and support of stored procedures and business logic in the database - Building and optimizing real-time metrics and monitoring

Requirements: - Solid experience with PostgreSQL in a high-load environment (3+ years) - Excellent knowledge of SQL (complex joins, aggregations, window functions) - Experience in query optimization (EXPLAIN, execution plan analysis) - Experience with partitioning and large tables - Understanding of OLAP/analytical system design principles - Experience in developing procedures and data pipelines within the database - Experience with replication (GTID, failover) - Ability to independently design solutions and take responsibility for results Will be a plus: - Experience in payments / fintech - Experience with real-time analytics - Experience with Clickhouse, Cassandra

Conditions: - Competitive salary (discussed individually) - Work in a strong team - Opportunities for professional growth and working on complex tasks