TC
BigQuery Administrator
TechDigital Corporation
🇺🇸 United States
On-site
2 months ago
- BigQuery
- GCP
- AI/ML
- Python
- IAM
- SQL
- Terraform
- Git
- CI/CD
- Apache Airflow
- Composer
- Teradata
- PostgreSQL
- Oracle
- Opsgenie
- Splunk
- New Relic
- ServiceNow
2 months ago
The BigQuery Administrator is responsible for the administration, monitoring, performance optimization, security, governance, and operational support of Google Cloud BigQuery environments.
The role ensures the availability, scalability, reliability, and cost efficiency of enterprise data platforms while supporting analytics, reporting, AI/ML, and business-critical workloads.
Experience Level:8 - 10 Years
Role: L2/L3 Support / Platform Administration
Support Model: 24x7 Production Support (as applicable)
Technical Skills
∙ Google Cloud Platform (GCP)
∙ BigQuery Administration & Performance Tuning
∙ BigQuery Reservations & Capacity Management
∙ Python Programming
∙ GCP IAM & Security
∙ Cloud Monitoring & Logging
∙ Cloud Storage
∙ Data Warehousing Concepts
∙ SQL Performance Optimization
∙ Shell Scripting
∙ Terraform
∙ Git / CI-CD Pipelines
∙ Apache Airflow / Cloud Composer (preferred)
Database Knowledge
∙ BigQuery
∙ Teradata (Preferred)
∙ PostgreSQL/MSSQL/Oracle (Good to Have)
Monitoring & Operations
∙ Cloud Monitoring
∙ OpsGenie
∙ Splunk
∙ New Relic
∙ ServiceNow
Key Responsibilities
Platform Administration
- Administer and maintain Google BigQuery environments across Development, QA, UAT, and Production.
- Configure and manage datasets, tables, partitions, clustering, and storage lifecycle policies.
- Manage BigQuery resource allocation, quotas, reservations, and workload management.
- Support platform upgrades, new feature adoption, and environment provisioning.
- Analyze and tune BigQuery SQL queries for improved performance and reduced execution cost.
- Optimize storage structures, partitioning, clustering, and materialized views.
- Monitor query execution patterns and recommend performance improvements.
- Improve workload efficiency and reduce cloud spend through continuous optimization.
BigQuery Administrator · TechDigital Corporation