#vacancy

Hiring DBA.

DBA:
- timescale DB / time series db
- financial data
- IOT database
- replication and sharding
- live streaming data
- analyse and provide solutions for optimizing database
- statistics and monitoring
- extensive experience with postgres replication / migration / sharding / optimization / maintenance
- experience with timescale, knowing its limitations and shortcomings for large amount of data effective aggregations.
- additionally / alternatively to timescale - if guy is a clickhouse guru. That would be REALLY great


Someone who managed a lot of amounts of data.

English / Russian

#vacancy

DBA:


Main goals:
DB administrations, replication, failover, sharding our signle instance
and helping architecture design
Challenges examples:
A:
we have 30M swaps / day
example task: given every new swap (chain | token | trader | amount | tx hash) -
determine how much user has bought in total (incl this tx) for given token.
Same swap can be sent multiple time - need deduplication
B:
we have 60M holder updates / day
for each holder update (chain | token | trader | amount | block_number),
need to to know top10 holder for given tokens.
Block numbers consecutive order not guaranteed
same update may be sent multiple times