Database Engineer
Apply NowCompany: PIXOMONDO
Location: Toronto, ON M4E 3Y1
Description:
We're looking for a seasoned Database Engineer to join our Innovation Lab team in building and optimizing a custom web platform that leverages PostgreSQL and SQLite. In this role, you will be responsible for ensuring performance, reliability, and scalability of our data layer, as well as contributing to custom database design and engineering solutions tailored to our unique platform needs.
Key Responsibilities:
Analyze, design, and optimize database schemas for performance and scalability
Implement indexing strategies, query optimization, and storage planning
Work closely with backend and platform engineers to support data-intensive features
Develop tools, scripts, and automations for monitoring and maintaining database health
Design and maintain efficient data migration and replication processes
Ensure database security, backup, and recovery practices are in place
Troubleshoot and resolve complex database issues in production and development environments
Requirements
5+ years of hands-on experience in database engineering, with a focus on SQLite & PostgreSQL
Strong experience with query tuning, indexing, performance profiling, and storage optimization
Familiarity with SQLite in web or embedded environments
Experience supporting data-driven web platforms or custom application stacks
Proficiency in writing stored procedures, views, triggers, and custom SQL logic
Knowledge of database versioning and migration tools (e.g., Alembic, Flyway, Liquibase)
Solid understanding of transactional systems, ACID principles, and data integrity
Comfortable working in a hybrid team environment with regular in-person collaboration in Toronto~
Nice to Have Experience with multi-tenant database architecture or custom data access layers
Familiarity with Event Sourcing and their impact on performance.
Familiarity with saving custom data types and custom asset persisting strategies.
Exposure to data caching strategies, replication, and high availability setup.
Prior work on database tooling or infrastructure in a DevOps setting
Why Join Us? Work at the cutting edge of AI and web technology.
Build real-world, user-facing AI experiences-not just chatbots.
Collaborate with a world-class team of AI, product, and platform engineers.
Enjoy a flexible, creative, and fast-paced environment with lots of ownership.
Benefits
Pixomondo is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, veteran status, age, sexual orientation, gender identity, or other protected characteristics.
Benefits may vary by location due to regional regulations and company policies.
PXO does not accept resumes from recruiters. Unsolicited resumes are accepted directly from candidates only. PXO will not pay any fees associated with unsolicited resumes.
Key Responsibilities:
Analyze, design, and optimize database schemas for performance and scalability
Implement indexing strategies, query optimization, and storage planning
Work closely with backend and platform engineers to support data-intensive features
Develop tools, scripts, and automations for monitoring and maintaining database health
Design and maintain efficient data migration and replication processes
Ensure database security, backup, and recovery practices are in place
Troubleshoot and resolve complex database issues in production and development environments
Requirements
5+ years of hands-on experience in database engineering, with a focus on SQLite & PostgreSQL
Strong experience with query tuning, indexing, performance profiling, and storage optimization
Familiarity with SQLite in web or embedded environments
Experience supporting data-driven web platforms or custom application stacks
Proficiency in writing stored procedures, views, triggers, and custom SQL logic
Knowledge of database versioning and migration tools (e.g., Alembic, Flyway, Liquibase)
Solid understanding of transactional systems, ACID principles, and data integrity
Comfortable working in a hybrid team environment with regular in-person collaboration in Toronto~
Nice to Have Experience with multi-tenant database architecture or custom data access layers
Familiarity with Event Sourcing and their impact on performance.
Familiarity with saving custom data types and custom asset persisting strategies.
Exposure to data caching strategies, replication, and high availability setup.
Prior work on database tooling or infrastructure in a DevOps setting
Why Join Us? Work at the cutting edge of AI and web technology.
Build real-world, user-facing AI experiences-not just chatbots.
Collaborate with a world-class team of AI, product, and platform engineers.
Enjoy a flexible, creative, and fast-paced environment with lots of ownership.
Benefits
Pixomondo is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, national origin, disability, veteran status, age, sexual orientation, gender identity, or other protected characteristics.
Benefits may vary by location due to regional regulations and company policies.
PXO does not accept resumes from recruiters. Unsolicited resumes are accepted directly from candidates only. PXO will not pay any fees associated with unsolicited resumes.