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
Our instagram