The company develops technological solutions for the payment industry, e-commerce, and fintech sectors. The 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 the outcome
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
- Opportunity for professional growth and work with complex tasks
