Job Details

Database Engineer at a company developing technological solutions for the payment industry, e-commerce, and fintech sectors. Focus on international markets with high loads and large data volumes. Remote, full-time.

The company develops technological solutions for the payment industry, e-commerce, and fintech sectors. Products are focused on international markets and operate with high loads and large data volumes. 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

Solid experience with PostgreSQL in a high-load environment (3+ years) Excellent SQL knowledge (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 the result Nice to have: - Experience in payments / fintech - Experience with real-time analytics - Experience with Clickhouse, Cassandra

Competitive salary (discussed individually) Work in a strong team Opportunity for professional growth and work on complex tasks