Database Engineer

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. Qualifications 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 its 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‑, and 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. 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. #J-18808-Ljbffr