Remote
3 days ago
full-time
- Design and evolve relational schemas, including tables, indexes, constraints, and relationships.
- Develop and optimise SQL queries, stored procedures, functions, and other database-driven logic.
- Analyse execution plans and identify improvements to performance and efficiency.
- Work hands-on with OLAP cube–based data models, including designing and modifying dimensions, hierarchies, and measures.
- Develop, optimise, and troubleshoot OLAP-related queries.
- Support feature teams with developing and maintaining the database.
- Diagnose and resolve issues involving locking, contention, inefficient joins, and indexing gaps.
- Recommend and implement indexing, partitioning, or structural improvements.
- Participate in load testing and capacity discussions related to the data layer.
- Participate in design and peer reviews.
- Mentor team members on SQL best practices, schema design, and performance techniques.
- Work within a small agile team to deliver high-quality features and continuously improve engineering practices.
- Document data structures, conventions, and patterns for broader engineering use.
- 4–5 years of experience in database engineering, SQL development, or backend engineering with strong data responsibilities.
- Deep expertise in Microsoft SQL Server, including complex joins, execution plan analysis, query optimisation, and indexing strategy.
- Strong understanding of relational data modelling and schema design principles.
- Experience working with OLAP cube-based data models, including dimensions, hierarchies, measures, and analytical queries.
- Experience designing, modifying, or supporting multidimensional data models used for reporting, trend analysis, or business intelligence solutions.
- Experience building ETL/ELT components.
- Experience improving database performance through structural and query-level optimisations.
- Familiarity with Agile delivery practices.
- Role based in the Philippines.
- Fully remote from anywhere within the Philippines.
- Must have at least 6 hours of daily overlap with the Australian Eastern Time Zone (AEST/AEDT).
- Flexible working hours outside the overlap period.
Similar jobs
Head of Analytics
iGaming Startup · Remote
1 month ago
View →
Field Service Tech II - Canada
IGT · Remote
2 days ago
View →
Field Service Technician - Casino Gaming
IGT · Remote
$49k - $68k
8 days ago
View →
Talent Systems Analyst
GR8 Tech · Remote
19 days ago
View →
Retention Manager
International iGaming Company · Remote
1 month ago
View →
Senior Payment Technical Manager
GR8 Tech · Remote
1 month ago
View →