Database Engineer

Smartfox | Engineering | Remote (Canada)

Build the Data Foundation Everything Else Depends On

Every great product runs on data that is fast, accurate, and always available. As a Database Engineer at Smartfox, you’ll design, optimize, and protect the databases that power our applications and analytics. You’ll solve real scale and performance challenges, and your decisions will shape how our platform grows.

What You’ll Do

- Design: Build efficient, scalable database schemas and data models that fit how our applications actually work.
- Optimize: Tune queries, indexes, and configurations so systems stay fast under heavy load.
- Maintain: Manage database environments across cloud and on-prem, including upgrades, patching, and capacity planning.
- Protect: Own backups, replication, high availability, and disaster recovery, and test them regularly.
- Secure: Enforce access controls, encryption, and auditing to keep sensitive data safe and compliant with Canadian privacy requirements such as PIPEDA.
- Migrate: Lead data migrations and modernization efforts with minimal downtime and zero surprises.
- Automate: Use scripting and infrastructure tools to streamline deployments, monitoring, and routine tasks.
- Monitor: Track performance and health metrics, and resolve issues before they reach users.
- Collaborate:



Work with software engineers, data teams, and product to deliver reliable data solutions.

What You Bring

- [4+] years of experience in database engineering, administration, or a related role
- Strong expertise in SQL and relational databases such as PostgreSQL, MySQL, or SQL Server
- Proven experience with query tuning, indexing strategies, and performance troubleshooting
- Hands-on experience with cloud databases (AWS RDS/Aurora, Azure SQL, or Google Cloud SQL)
- Solid understanding of backup, replication, and high availability architectures
- Experience with scripting (Python, Bash, or PowerShell)
- Familiarity with version control, CI/CD, and schema change management
- Awareness of data residency and privacy considerations for Canadian data (PIPEDA, and provincial laws such as Quebec’s Law 25)
- Strong analytical skills and a careful, detail-oriented approach
- Explicit communication in English (French is an asset)
- Legal authorization to work in Canada

Bonus points : Experience with NoSQL databases (MongoDB, DynamoDB, Redis), data warehousing (Snowflake, Redshift, BigQuery), ETL/ELT pipelines, Infrastructure as Code (Terraform), bilingual English/French ability, or certifications from AWS, Microsoft, or Oracle.

📌 Database Engineer (Canada)
🏢 SMARTFOX
📍 Canada