Senior Database Expert

Our client is a leading cybersecurity company specializing in video tracking, anomaly detection, and large-scale data analytics. They process terabytes of real-time video metadata and require an expert in distributed databases to optimize data ingestion, retrieval, and analytics for our cybersecurity solutions.

We are looking for a Distributed Database Expert with deep knowledge of sharding, indexing, distributed joins, segment elimination, and query optimization for large-scale SQL databases. You will be responsible for designing and maintaining high-performance, low-latency data architectures that support real-time video analytics and anomaly detection at scale.

• Database architecture and design: Develop and optimize schemas for distributed SQL databases handling billions of video events.
• Sharding and partitioning strategies: Select and implement efficient shard keys and sort keys to maximize performance and scalability.
• Distributed query optimization: Improve query performance for complex joins, segment elimination, and analytical workloads.
• Performance tuning: Optimize large-scale queries, including COUNT(DISTINCT) operations, across distributed environments.
• Indexing and data access patterns: Implement advanced indexing strategies to support high-volume queries efficiently.
• Real-time and historical data management: Ensure the system handles both real-time streaming and historical data analytics seamlessly.
• Collaboration: Work closely with data engineers, backend developers, and security teams to integrate database solutions with the broader cybersecurity platform.

Will be a plus:

• Experience with real-time analytics and streaming data architectures.
• Understanding of cybersecurity challenges in video tracking.
• Familiarity with message queues (Kafka, Pulsar) for distributed event processing.
• Hands-on experience with query optimization tools and profiling.

• 5+ years of experience in distributed SQL databases (SingleStore, PostgreSQL Citus, Google Spanner, CockroachDB, or similar)
• Strong expertise in shard key selection, sort key strategies, and partitioning
• Deep understanding of distributed joins and optimizing cross-shard queries
• Experience with query execution plans, indexing, and performance tuning
• Familiarity with segment elimination techniques in columnar databases (SingleStore preferred)
• Knowledge of large-scale video metadata processing is a plus
• Proficiency in working with terabyte-scale datasets and ensuring low-latency analytics
• Experience with cloud-based data solutions (AWS, GCP, or Azure) is a plus
• Strong problem-solving skills and ability to explain complex database concepts clearly
• English level: Upper-Intermediate

• 20 working days of paid vacation per year;
• Official holidays of Ukraine – days off;
• Modern equipment for work;
• Corporate events;
• External and internal training: conferences, professional events, courses, TechTalks;
• English speaking club.

• HR interview;
• Test task;
• Interview with client