Database Developer

Overview

Full-time | Philippines-based | 6-hour AEST Overlap Required

We are seeking a highly skilled Database Developer with deep expertise in SQL development, schema design, application-centric data engineering, and analytical data solutions. In this role, you will work directly with Product and Engineering teams to design and optimise the database structures and data logic that power our applications. 
 
Candidates should be comfortable working with both relational database structures and OLAP-based analytical models. 

Key Responsibilities

· 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.

Important Requirement 
This role requires previous experience working with OLAP cube-based data models. Candidates should be familiar with concepts such as dimensions, hierarchies, measures, and analytical queries. Applicants with strong SQL Server experience but no exposure to OLAP technologies are unlikely to be a suitable fit for this position. 

Required Skills and Experience

• 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. 

Work Arrangement

· 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.

#LI-REMOTE