Database Engineer
Description For Database Engineer
Pixomondo (PXO), a Sony Pictures Entertainment company, is seeking a Database Engineer to join their Innovation Lab team in Toronto. This role focuses on building and optimizing a custom web platform using PostgreSQL and SQLite. The position requires 5+ years of database engineering experience and offers an opportunity to work at the intersection of AI, web technology, and entertainment.
The Innovation Lab is PXO's cutting-edge technology hub, exploring emerging technologies like AI, machine learning, real-time engines, robotics, and new media workflows. As a Database Engineer, you'll be responsible for ensuring the performance, reliability, and scalability of the data layer while contributing to custom database design and engineering solutions.
The role combines technical expertise in database engineering with the excitement of working in a creative, fast-paced environment. You'll be part of a world-class team that's shaping the future of content creation across all mediums. The position offers the chance to work on real-world, user-facing AI experiences while enjoying significant ownership and flexibility in your work.
Key technical requirements include extensive experience with SQLite & PostgreSQL, query optimization, database security, and data migration. The role requires regular in-person collaboration in Toronto through a hybrid work arrangement. This is an excellent opportunity for a database professional who wants to contribute to innovative projects in the entertainment industry while working with cutting-edge technology.
Responsibilities For Database Engineer
- 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 For Database Engineer
- 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
Benefits For Database Engineer
- Work at the cutting edge of AI and web technology
- Build real-world, user-facing AI experiences
- Collaborate with a world-class team of AI, product, and platform engineers
- Enjoy a flexible, creative, and fast-paced environment with lots of ownership
Jobs Related To Pixomondo Database Engineer
