Company About
We are a multimedia AI platform where users can organize a session with various participants, share content (such as any documents, photos, videos, and others), make live video calls, live streaming, create smart forms with smart conditions, attache AI (computer vision, classification, natural language processing, chatbots), connect health data logic.
About the role
The primary responsibilities of this role will include developing and implementing efficient and scalable SQL solutions for data storage and retrieval, ensuring data integrity, and optimising database performance.
Responsibilities
- Writing complex SQL queries and stored procedures for different OLTP workloads
- Writing complex non-SQL queries (e.g., Document based, graph based)
- Creating data access interfaces (mostly complex views) for BI Tools in OLAP solution
- Participating in databases design for new modules and services of cloud platform
- Conducting code reviews
- Participating in demo activities
Qualifications
- Bachelor’s degree in Computer Science or related field or relevant work experience
- Good SQL knowledge (with any of widely-used RDBMS - MS SQL Server, Oracle Database, PostgreSQL), with proven production experience of 1+ year
- Understanding of relational theory and principles of database design
- Experience in creating reports using SQL
Nice to have
- Experience with administering any of widely-used RDBMS (MS SQL Server, Oracle Database, PostgreSQL): backups, recovery, security, performance tuning
- Knowedge of mongo-DB and/or neojs.
- Experience with "infrastructure as a code" solutions (like Ansible, etc.)
- Experience with cloud environments (Google Cloud Platform, AWS, Azure Cloud)
- Experience with any BI Tools (Power BI, Tableau, etc.)
- Knowledge of Python