Database Engineer
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 to hr@themindstudios.com