DATABASE EXPERT - BIG DATA
We are currently running our OPENX ad server data-base using MySQL to manage ads, data, reporting, analytic, etc.
The volume of traffic that we currently have requires that we switch to a Big Data solution and are looking to replace MySQL with CLICKHOUSE based on recommendations. However we are open to discuss other options such as integration with Apache CASSANDRA or Apache IGNITE
We are looking for the following person (s)
Someone who can work remotely and has flexible hours. This person will have to:
1) Review current data base (MySQL) and overall settings, queries, script, etc.
2) Propose a plan for setting up Clickhouse on a dedicated server to do the same or better
3) Identifying migration options and data transfer protocol with no or min. interruption and no loss of data
4) Oversee the migration of historical and current data from MySQL to Clickhouse
5) Provide on-going maintenance, update and optimization of Data base and make recommendation to improve system