Database Engineer

PIXOMONDO; Toronto; Hybrid; CAD 90,000 - 110,000; Full time

Job summary

An innovative firm is seeking a seasoned Database Engineer to join their cutting-edge Innovation Lab team. This role involves building and optimizing a custom web platform using PostgreSQL and SQLite, ensuring performance, reliability, and scalability of the data layer. You will analyze and design database schemas, implement indexing strategies, and collaborate closely with backend engineers to support data-intensive features. This position offers a dynamic and creative environment where you can make a significant impact on real-world AI experiences. If you are passionate about database engineering and eager to work at the forefront of technology, this opportunity is for you.

Benefits

Flexible working hours

Creative work environment

Ownership of projects

Collaboration with AI experts

Qualifications

• 5+ years of experience in database engineering focusing on SQLite & PostgreSQL.
• Proficient in writing stored procedures, views, triggers, and custom SQL logic.

Responsibilities

• Analyze, design, and optimize database schemas for performance and scalability.
• Develop tools and scripts for monitoring and maintaining database health.

Skills

PostgreSQL

SQLite

query tuning

indexing

performance profiling

data integrity

stored procedures

custom SQL logic

Education

Bachelor's degree in Computer Science or related field

Tools

Alembic

Flyway

Liquibase

Job description

2 weeks ago Be among the first 25 applicants

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
  
  
  

About Pixomondo And Our Innovation Lab Team

PXO, a Sony Pictures Entertainment company, creates industry-leading Visualization, Virtual Production, and Visual Effects for premium Film and Episodic content. Through its 23-year history, the Oscar, BAFTA, & Emmy-winning creative and technology company has been a trusted partner for storytellers and showrunners worldwide

PXO's Innovation Lab is where the future of content creation is being built. Backed by Sony and powered by a world-class team of disruptors, this high-tech hub explores emerging technologies like AI, machine learning, real-time engines, robotics, and new media workflows.

We're not just redefining how VFX and animation are made, we're shaping the next wave of storytelling across all mediums. Our team thrives on experimentation, rapid prototyping, and pushing the boundaries of what's possible, using cutting-edge hardware and software to challenge industry norms and invent bold new ways to create."

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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at PIXOMONDO by 2x

Get notified about new Database Engineer jobs in Toronto, Ontario, Canada.

Junior Application and Database Developer

Richmond Hill, Ontario, Canada 2 weeks ago

Mississauga, Ontario, Canada CA$90,000.00-CA$110,000.00 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.