Senior Software Engineer – Database Optimization

This is a fully remote position, open to applicants in Bulgaria.

📋 Description

• Design, create, and manage the Database Gateway.

• Develop high-performance services using Go and Rust.

• Work on features such as database caching, rate limiting, and other capabilities of the gateway.

• Construct the recommendation engine for the Database Agent.

• Develop systems for index suggestions, query analysis, and improvements to queries.

• Address cache invalidation and ensure data consistency, where accuracy is paramount.

• Establish methods for safely validating database recommendations prior to their implementation.

• Troubleshoot complex production issues across the gateway, agent, and underlying database systems.

• Analyze database performance, query behavior, and workload patterns.

• Collaborate with product and engineering teams to tackle problems without established solutions.

• Contribute to the direction of products, technical decisions, and the engineering roadmap.

• Help define the future of automated database administration.

⛳️ Requirements

• Strong foundation in software engineering principles, including clean abstractions and maintainable code.

• Professional experience in building production services using Go.

• Extensive knowledge of PostgreSQL or MySQL.

• Understanding of the workings of database clients, drivers, and wire protocols.

• Strong skills in debugging, optimization, and performance tuning.

• Experience with query profiling, index design, and database tuning beyond ORM usage.

• Proven track record of taking complex technical projects from design to production.

• Proficient in written and spoken English.

• A proactive and adaptable attitude in a fast-paced environment.

• Comfort with ambiguity and contributing to the technical direction.

• Experience with Rust, particularly in high-performance network services or proxies.

• Background in building or extending database proxies, gateways, or poolers.

• Experience in designing cache invalidation strategies at scale.

• Familiarity with index recommendations, query-plan analysis, or query optimization tools.

• Experience in validating technical changes through workload replay, shadow traffic, or benchmarking.

• Production experience with Prometheus, Grafana, or OpenTelemetry.

• Experience working with Kubernetes and cloud infrastructure.

• Please note that CAST AI does not offer visa sponsorship or work permits for this role.

🏝️ Benefits

• Remote-first work environment.

• Equity options available.

• Be part of a global team of cloud and infrastructure specialists.

• Enjoy fast feedback and short delivery cycles, with many feature projects completed within one to four weeks.

• Allocate 10% of working time for personal projects or professional development.

• Annual learning budget for conferences and courses.

• Participate in an annual hackathon.

• Enjoy a team-building budget and company events.

• Benefit from an equipment budget.

• Additional days off provided.