Database Expert

компания "advantage solutions" we are looking for an experienced database administrator (dba) able to be his or her own boss, to ensure uninterrupted operations and high cluster performance. the role: in addition to administering and maintaining database performance 24/7, you will be involved in the development of advanced infrastructure solutions to accelerate the development of the companychr(39)s products and services. who is the person: an expert who is keen on researching, analyzing, optimizing current infrastructure performance, and sharing knowledge with our devops team. tasks: maintaining existing clickhouse and postgresql clusters; building scalable fault-tolerant database clusters; сonfigurating clickhouse and postgresql instance; making replication setup, sharding, keeper configuration, backup support and maintenance; monitoring configuration; designing data warehouse architecture; clickhouse performance optimization, troubleshooting. requirements: current knowledge and experience with clickhouse and postgresql: principles of engines, indexes, replication, sharding; 3 or more years of experience in administering it systems; linux experience (administrator level) not less than 1 year; thorough understanding of database design, implementation, troubleshooting and maintenance; proficiency in bash, sql, ansible; desire to work with clickhouse and share expertise with the team; basic python scripting skills. we offer: being a part of a modern international technology team, zero bureaucracy, legacy and technical debt; great opportunities for professional growth and personal fulfillment: top team, cool atmosphere, participation in professional international conferences; remote work from anywhere in the world, flexible schedule, help with relocation; a real wage, pay in hard currency, compensation for vmi, corporate sports and non-core training, help with relocation; awesome corporate events.