Position: Database Engineer
Company: Mind Studios
Experience required: 3y
English level: intermediate

About the project

Customer location: United Kingdom
Domain: Health & Fitness Coaching Software
Platforms: iOS, Android, WEB

Our product is the online coaching platform used worldwide by coaches across various disciplines. Experience the all-in-one solution that allows you to distribute a wide range of online training services. Seamlessly automate program delivery, online sales and client management. Whether it’s a one-off program download, individual 1-2-1 coaching or larger group-based training, our project efficiently powers coaches with 1 to 15 000+ clients.

Why we hire? 
We have a lot of clients and media now, but current database runs slow on the peak of users’ requests. We need a person who can make an audit of the current database and optimize it as best as possible.  

Your responsibilities:
— Review and refactor current requests to the database much faster;
— Review PostgreSQL statements and guide developers with best practices how to interact with the database, for a high-scale production environment;
— Improves the performance of the system by either making better use of resources, distributing load, or reducing the latency.

Preferred qualifications:
— Deep SQL knowledge and understanding of PostgreSQL or other relational databases; 
— Experience in decoupling and optimizing database queries;
— 3 years experience in managing SQL in a high traffic;
— Experienced with Linux distributives (Debian, Ubuntu);
— Experience running SQL in a microservices architecture (Kubernetes);
— Experienced with migration from on-prem SQL solutions to cloud native services;
— Strong problem solving and debugging skills;
— Experience with scripting languages (eg. Bash, Python).

Would be plus:
— Experience working in cloud services any of (AWS, GCP, Azure, Digital Ocean);
— Strong experience in SQL sharding and partitioning;
— Have knowledge in data warehousing and enterprise IT concepts;
— Experience with ElasticSearch.

If you match this position and like challenges — send your CV