Staff DB Administrator - BigQuery, Cassandra, Cloud

Responsibilities:

• Design/rearchitect our infrastructure platform components to be highly available, scalable, reliable, and secure, with a strong focus on database-backed services.

• Own and manage database infrastructure including BigQuery, Redis, AlloyDB, and Cassandra, ensuring high performance, availability, and cost-efficiency.

• BigQuery Management: Design, implement, and optimize datasets, tables, and queries for large-scale analytics.

• Monitor and troubleshoot database performance and query optimization, including cost management and efficient data storage techniques.

• Manage and monitor data ingestion pipelines using tools like Dataflow or Kafka.

• Ensure data security, access control, and compliance for all managed database platforms, including IAM policies and encryption.

• Manage schema changes and data migrations using automation tools such as Liquibase or similar.

• Ensure observability is an integral part of the infrastructure platforms, providing adequate visibility into health, utilization, and cost—especially across database workloads.

• Implement IaC using tools like Terraform/Terragrunt.

• Build tools that predict saturations/failures and take preventive actions through automation.

• Collaborate extensively with cross-functional teams to understand data access patterns and infrastructure requirements; educate them through documentation/trainings and improve the adoption of the platforms/tools.

Qualifications:

• 8+ years of experience in building large-scale distributed systems in an always-available production environment.

• 5+ years of experience building Infrastructure Platforms and CI/CD pipelines in a major public cloud provider – GCP preferred; hands-on expertise in commonly used Cloud infrastructure/platforms services.

• Deep expertise in BigQuery and strong hands-on experience with database technologies such as Redis, AlloyDB, Cassandra, or Cloud Spanner.

• Experience managing large-scale data pipelines and stream processing systems using tools like Dataflow, Kafka, or Pub/Sub.

• Strong programming skills in Python, Shell/Bash, or similar scripting languages.

• Fast learner with the ability to troubleshoot complex scenarios while processing large volumes of data (Terabytes and Petabytes).

• Hands-on experience with observability platforms/tools like Grafana/Prometheus.

• Experience coaching and mentoring junior engineers; strong verbal and written communication skills.

• GCP certification is a plus.

• Bachelor’s degree in Computer Science or equivalent.