Job Title: Database Administrator (DBA SingleStore / MemSQL)
Location: Montreal, QC (Hybrid)
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.
Strong 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.
...system for mobile servicesa platform that lets tech companies embed global connectivity into their products effortlessly. Just as Stripe lets any business add a payment button in seconds, Gigs empowers platforms to weave in connectivitybridging the traditional world...
...The Data Entry Typist is responsible for accurately entering, updating, and maintaining information in digital databases and systems. This role requires strong attention to detail, fast and accurate typing skills, and the ability to manage confidential information with...
...industries to develop innovative IT solutions. We are looking for a Data Entry Clerk to support our operations by ensuring accurate and... ...Suite (Excel, Word, Outlook) and data entry software. ~ Strong typing speed and accuracy (minimum 45 WPM preferred). ~ Excellent...
...If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Magento Developer to join our team in bangalore, Karntaka (IN-KA), India (IN). Magento Sr Developer Who we are: NTT DATA America...
...Preferredc Qualifications:~ Minimum of 4 years of service desk / helpdesk experience or equivalent combination of education and technical... ...for specific roles. The starting pay range for this remote role is $34,387.00-$47,760.00 . This range reflects the minimum...