Description :

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 SingleStores (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.