Database Consultant, CockroachDB
6 days ago
Fareham
• Own the reliability, scalability, latency, and performance of mission‑critical CockroachDB infrastructure., • Promote operational efficiency by developing automated systems and tools, significantly reducing operational toil., • Act as a technical mentor and subject‑matter expert within the team and consulting partner to customer teams., • Serve as a primary technical consultant, partnering with customer teams for project‑based and long‑term CockroachDB support., • Design, document, and implement the new L1/L2 support channel and operational workflow, including ticket triage, escalation paths, and SLA adherence., • Act as an escalation point for complex, time‑sensitive production support and troubleshooting within distributed database environments., • Ensure data security, integrity, and quality by adhering to internal standards and industry best practices (TLS/certificate management, RBAC, secrets management, audit logging)., • Own Backup, Restore, and Disaster Recovery operations, including scheduled full/incremental backups, point‑in‑time restore, restore drills, RPO/RTO definition, and failover testing., • Manage the full CockroachDB cluster lifecycle, including node add/remove/decommissioning, rolling upgrades, patch validation, capacity planning, and downgrade/rollback planning., • Develop readable, reusable code to streamline provisioning, management, and monitoring of CockroachDB clusters., • Collaborate with development teams to define and implement relevant observability metrics, enhancing application reliability., • Direct incident response, root cause analysis, and post‑mortem processes for critical database outages., • Create and maintain clear documentation, runbooks, and operational guides to reduce business risk and operational costs., • Define the technical strategy and roadmap for CockroachDB adoption and management across customer engagements., • Proactively manage technical debt and identify scaling bottlenecks, ensuring infrastructure remains robust for future growth., • Achieve billable and effective utilization targets of 85% (subject to modification)., • Perform other duties as assigned by your Manager., • 5+ years of experience as a Database Administrator (DBA) or Site Reliability Engineer (SRE)., • Advanced experience with CockroachDB and intermediate‑level experience with a secondary relational database (e.g., PostgreSQL or MySQL)., • Proven experience migrating legacy databases (e.g., PostgreSQL, MySQL) to a distributed SQL system like CockroachDB., • Advanced SQL and optimization knowledge: query tuning, schema/index design, identifying hotspots, managing transaction contention and retry errors, using EXPLAIN ANALYZE/table statistics for diagnostics., • Tool stack proficiency: Terraform, AWS (high skill in networking for multi‑region deployment), Vault, Gitlab, and deep production experience with Kubernetes/Helm/Operator., • Deep scripting and automation skills (Python, Go, Bash)., • Expertise in analyzing CockroachDB‑specific observability metrics, including hands‑on experience with Prometheus/Grafana/Alertmanager, Datadog or CloudWatch, DB Console, and SLO/SLI reporting., • Excellent customer service and consulting focus with proven ability to manage client expectations and priorities., • Exceptional logical and systematic analysis for problem‑solving and root cause analysis., • Proactive individual who identifies process gaps and enhances improvements across systems and structures., • Excellent verbal and written communication skills for delivering technical and strategic information to diverse audiences., • Competitive total rewards package (including paid vacation, sick days, and a day off to volunteer for your favorite charity)., • Flexible remote work: work from home with stable internet; no daily travel required., • Professional development: substantial training allowance, professional development days, and opportunity to become certified., • Updated equipment: laptop with chosen OS and annual budget to personalize home workspace., • Health and wellness budget for gym memberships, massages, fitness, and more., • The successful applicant will need to fulfill requirements necessary to obtain a background check., • Accommodations are available upon request for candidates taking part in any aspect of the selection process. #J-18808-Ljbffr