SingleStore Database Administrator / Engineer

We are seeking a hands-on SingleStore Database Administrator / Engineer developer with track-record of building large scale distributed systems.

The team encourages open communication, new technologies and thinking out of box.

Core Responsibilities :

• Database Management: Install, configure, and maintain SingleStore database systems.
• Data ingestion: Manage SingleStore Pipelines for streaming and load utility for batch data ingestion.
• Performance Tuning: Optimize queries, indexes, and database design for speed and scalability.
• Monitoring & Troubleshooting: Set up monitoring tools, diagnose performance issues, and resolve database-related problems.
• Backup & Recovery: Implement and test disaster recovery strategies and backup plans.
• Security: Apply database security best practices, manage user roles, and ensure compliance.
• Automation: Develop scripts (often in Python) to automate routine DBA tasks.
• Collaboration: Work with developers, DevOps, and infrastructure teams to ensure smooth integration.

Required Skills :

• SingleStore Expertise: Good understanding of SingleStore’s (or other columnar stores, such as ClickHouse, Snowflake) distributed architecture, pipelines, and query engine.
• Knowledge of columnstore vs rowstore optimizations: and how to balance them in Single
• StoreStrong SQL proficiency: writing complex queries, stored procedures, and optimizing query performance.
• Scripting: Python and Unix (Shell) skills for automation.

Desired Skills

• Experience with other RDBMS platforms: such as PostgreSQL, SQL Server, or DB2.
• High Availability: Knowledge of clustering, replication, and failover strategies.
• Backup & Disaster Recovery: Proven experience in backup/restore processes.
• Security: Familiarity with encryption, access controls.
• Cloud Knowledge: Experience with AWS, Azure, or GCP for cloud-based deployments is a plus.