> Markdown version of [/jobs/ext/1918449-ops-bigquery-dba](https://www.wearedevelopers.com/jobs/ext/1918449-ops-bigquery-dba). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Ops - BigQuery DBA

- **Company:** Capgemini
- **Location:** Chicago, IL, United States
- **Experience:** Experienced
- **Salary:** $86,549.0 - $135,221.0
- **Contract:** Temporary contract
- **Skills:** Query Performance, Backup Devices, Bash Shell, BigQuery, Cloud Computing, Continuous Integration, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Security, Data Warehousing, Disaster Recovery, Data Flow Control, Github, Identity and Access Management, Python (Programming Language), Query Optimization, Data Logging, Freeform SQL, Google Cloud, Data Ingestion, Multi-Cloud, Plex, Gitlab-ci, Infrastructure Automation Frameworks, Information Technology, Star Schema, Google Bigquery, Search Engines, Database Replication, Terraform, Jenkins
- **Published:** August 4, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=c1a0846ae4c043fb

## About the Role

* Strong mastery of Google BigQuery architecture and storage mechanics.
 * Advanced SQL optimization and query tuning skills.
 * Proficiency in GCP CLI (gcloud) and BigQuery command-line tool (bq).
 * Experience with Infrastructure as Code (IaC) tools like Terraform.
 * Solid understanding of data warehousing concepts (Star/Snowflake schema). [1, 2, 3, 4, 5], * Bachelor's degree in Computer Science, Information Technology, or a related field.
 * 3+ years of hands-on experience specifically administering GCP BigQuery.
 * 5+ years of total experience in Database Administration or Data Engineering.
 * Experience with CI/CD tools (GitHub Actions, GitLab CI, or Jenkins). [1, 2, 3, 4, 5]

Preferred Certifications:

 * Google Cloud Certified Professional Data Engineer.
 * Google Cloud Certified Professional Cloud Architec

## Description

Security & Governance
bigquery
performance optimization
cloud platform
data engineering
DevOps & CI/CD
sql database
database administration, Architecture & Administration:

 * Manage BigQuery datasets, tables, views, and authorized views.
 * Implement and maintain data retention and partitioning policies.
 * Monitor slots allocation and manage reservation configurations.
 * Set up and maintain BigQuery Omni for multi-cloud deployments if required. [1, 2, 3, 4, 5]

Performance & Cost Optimization:

 * Optimize query performance using clustering and partitioning.
 * Analyze execution plans to eliminate full table scans.
 * Monitor and minimize GCP slot utilization and query costs.
 * Implement materialized views and search indexes to accelerate queries. [1, 2, 3, 4, 5]

Security & Governance:

 * Enforce Identity and Access Management (IAM) roles and permissions.
 * Implement row-level and column-level security policies.
 * Audit data access patterns using Cloud Logging and Data Plex.
 * Ensure compliance with data privacy regulations (e.g., GDPR, HIPAA). [1, 2, 3, 4, 5]

Data Integration & Operations:

 * Collaborate with Data Engineers to optimize ingestion pipelines (Dataflow, Datastream).
 * Manage data replication, backup, and disaster recovery strategies.
 * Troubleshoot complex SQL queries and data loading failures.
 * Automate administrative tasks using Python, Bash, or Terraform. [1, 2, 3, 4, 5]


## Related Videos

- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [The Road to MLOps: How Verivox Transitioned to AWS](https://www.wearedevelopers.com/videos/1050-the-road-to-mlops-how-verivox-transitioned-to-aws)
- [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next)
- [Our GitOps approach for deploying an Identity Provider and an API Gateway in a SaaS company](https://www.wearedevelopers.com/videos/776-our-gitops-approach-for-deploying-an-identity-provider-and-an-api-gateway-in-a-saas-company)
- [The Cloud is Calling: Answer with In-Demand Skills](https://www.wearedevelopers.com/videos/945-the-cloud-is-calling-answer-with-in-demand-skills)
- [Bringing AI Model Testing and Prompt Management to Your Codebase with GitHub Models](https://www.wearedevelopers.com/videos/1536-bringing-ai-model-testing-and-prompt-management-to-your-codebase-with-github-models)

## Related Articles

- [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)