Job Title: Database Administrator (DBA – SingleStore / MemSQL)

Location: Montreal, QC (Hybrid)

NOTE: In case we are not able to find SingleStore (MemSQL), We are also fine with good DBAs with DB (Sybase/DB2/MongoDB) and Python skills.

Job Summary:We are seeking an experienced Database Administrator (DBA) with strong expertise in SingleStore (formerly MemSQL) to manage, optimize, and support high-performance in-memory database environments. The ideal candidate should have hands-on experience with SingleStore versions 7.x, 8.x, and 9.x, database performance tuning, monitoring, replication, and automation using Python.Key Responsibilities:

- Install, configure, administer, and maintain SingleStore (MemSQL) database environments.
- Manage and support SingleStore versions 7.x, 8.x, and 9.x, with a clear understanding of the architectural and feature differences between releases.
- Monitor database health, performance, and availability using Grafana and Prometheus.
- Perform database performance tuning, query optimization, and troubleshooting.
- Optimize database objects including tables, indexes, views, and stored procedures.
- Configure and maintain database replication and ensure high availability.
- Work with development and infrastructure teams to resolve database-related issues.
- Develop automation scripts using Python for database administration and monitoring tasks.
- Support backup, recovery, disaster recovery, and database security initiatives.
- Maintain documentation for database configurations, procedures, and operational processes.




- Provide production support and participate in on-call rotations as required.

Required Skills:

- Strong hands-on experience with SingleStore (formerly MemSQL) database administration.
- Good understanding of SingleStore versions 7.x, 8.x, and 9.x, including key feature enhancements and differences.
- Experience with Grafana and Prometheus for database monitoring and alerting.
- Proficiency in Python scripting for automation and database management.
- Working knowledge of Sybase ASE and database replication concepts.
- Solid understanding of Relational Database Management System (RDBMS) fundamentals.
- Experience in:
- Database schema design
- Tables, Views, Indexes
- Query optimization
- Performance tuning
- Database maintenance
- Knowledge of backup and recovery strategies.
- Experience with Linux/Unix environments is preferred.
- Strong analytical and troubleshooting skills.

Preferred Qualifications:

- Experience supporting mission-critical production database environments.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) configurations.
- Familiarity with cloud environments (AWS/Azure/GCP) is an added advantage.
- Experience with CI/CD and infrastructure automation is a plus.

Nice to Have:

- Experience with additional relational databases such as Oracle, MySQL, PostgreSQL, or SQL Server.
- Exposure to DevOps practices and monitoring automation.
- Excellent communication and documentation skills.

Work Location: Hybrid remote in Montréal, QC

📌 Database Administrator (Db2 OR MongoDB OR Sybase) and Python (Canada)
🏢 Apptad
📍 Canada