About Deep.BI
We provide enterprise support and consulting for open-source analytics and data infrastructure platforms such as Apache Druid, Apache Flink, StarRocks, YugabyteDB and other emerging technologies. Our customers run mission-critical, high-volume systems and rely on us to keep them up and performing. We're a small, expert, remote-first team working across time zones (US, Brazil, Europe, India, Philippines). Our engineers have supported 300+ production clusters, with SLAs from advisory support to 24/7 incident coverage.
Role overview
As an Expert YugabyteDB Database Engineer (DBE), you'll be the core L3/L4 technical expert for the hardest database problems our customers hit in production, with a focus on YugabyteDB clusters. You'll go deep into query optimization, transaction throughput, schema and sharding design, replication and HA/DR configuration, so that large distributed SQL systems keep up with production load.
Your main focus is database internals and advanced troubleshooting. Knowledge of DevOps, infrastructure, security or SRE practices is a real plus and will make you even more effective.
Key responsibilities
- Advanced troubleshooting (L3/L4): diagnose and resolve complex issues in YugabyteDB and other distributed SQL / OLTP clusters, such as transaction contention and conflicts, query regressions, tablet hotspots, replication lag, compaction stalls and connection saturation.
- Performance optimization: tune queries, schemas, sharding and indexing strategies, connection pooling and configs for high read and write load. Use EXPLAIN ANALYZE and execution plans on the YSQL (PostgreSQL-compatible) layer.
- Architecture and design support: work with Solution Architects on data models, primary key and sharding design, indexing strategies and HA/DR approaches, including synchronous replication, xCluster asynchronous replication, read replicas and geo-distributed deployments.
- Incident resolution under a 24/7 SLA: debug under SLA pressure and take part in on-call rotations. Act as the escalation point for production incidents, with fast root cause analysis and fixes.
- CVE patching: apply, validate and test security patches for database systems in customer environments.
- Knowledge sharing: document best practices, contribute to playbooks and mentor junior engineers when needed.
Nice to have
- Supporting deployments with DevOps engineers (Kubernetes, cloud, automation).
- Helping with secure configuration and compliance requirements.
- Working with our developers on upstream OSS bug fixes or features.
- Strong PostgreSQL skills.
- Open-source contributions to YugabyteDB.
- C/C++ skills.
Requirements
- 5+ years of hands-on experience operating and troubleshooting YugabyteDB clusters in large-scale production (not only querying or application use; no PoCs).
- Proven experience with query optimization, indexing, schema and sharding design, and transaction throughput tuning.
- Solid knowledge of distributed systems concepts: consistency, Raft consensus, replication, failover, scaling.
- Hands-on experience with high availability and disaster recovery setups.
- Comfort with Linux, networking basics and SQL (PostgreSQL experience strongly preferred, given YugabyteDB's YSQL compatibility).
- Ability to analyze logs, metrics and configs under pressure during incidents.
- Fluent written and spoken English, and the ability to explain technical decisions clearly to engineers and delivery managers.
- Bonus: experience with PostgreSQL, CockroachDB, TiDB, Google Spanner, Apache Cassandra, Vitess or similar distributed SQL / OLTP databases.
- Bonus: experience with Apache Druid, StarRocks, ClickHouse, Apache Doris or similar OLAP databases.
- Bonus: experience with Kubernetes, cloud infrastructure (AWS, GCP, Azure) or security practices (RBAC, encryption, IAM).
What we offer
- Work with current open-source database technology at enterprise scale.
- Collaborate with top engineers across databases and open-source communities.
- Competitive salary.
- Support for conference travel and OSS contributions.
- Flexible contract structure (direct employment, a global payroll partner, or contractor/B2B), depending on your location and preference.
Location and working style
- Remote-first. We collaborate online across multiple time zones.
- The role needs regular overlap with European and North American business hours.