Job Details

SQL Developer with ClickHouse/YDB experience for PaynetEasy (Fintech). Salary: from 250-300,000 RUB net. Full-time, remote/hybrid (Moscow). Design, develop, and optimize analytical and transactional solutions.

We are looking for an experienced SQL developer who will design, develop, and optimize analytical and transactional solutions based on ClickHouse and YDB. You will be part of a team responsible for data at scales where speed and reliability are not a wish, but a requirement. Tasks: - Design data schemas and write high-load SQL queries for analytical and OLTP tasks. - Develop and maintain ETL/ELT pipelines, ensuring data quality and consistency. - Optimize query performance: profiling, execution plan analysis, choosing partitioning and sharding strategies in ClickHouse. - Participate in the design of data storage architecture, selecting the appropriate engine (MergeTree, ReplacingMergeTree, etc.) for a specific task. - Interact with the backend team to integrate the data layer with application services. - Document solutions, schemas, and approaches for the team.

Proficient SQL skills - complex analytical queries, window functions, CTE, subqueries. Experience with ClickHouse for at least 3 years: understanding of columnar storage architecture, table engines, materialized views, replication and sharding configuration. Understanding of data schema design principles for OLAP systems. Experience with large data volumes (tens and hundreds of billions of rows). Query profiling and optimization skills. Familiarity with Linux at a confident user level. Nice to have: - Experience with YDB - understanding of data model, working with YQL, knowledge of distributed transactional schema design approaches. - Experience with other DBMS: MySQL, MariaDB. - Familiarity with data migration tools (debezium). - Understanding of distributed systems principles and CAP theorem.

Full-time employment. Remote, office/hybrid (Moscow). Flexible working hours possible. Employment according to the Labor Code of the Russian Federation in an accredited IT company.