Jobs / Cap***
Ops - BigQuery DBA
Cap*** · Chicago, IL, United States
Visa sponsorship details are locked. Unlock company name and apply link with .
Chicago, IL, United States42-65 USD/hourlyOnsite
Remuneration
42-65 USD/hourly
Location
Chicago, IL, United States
Visa sponsorship
Sponsors visa
Job summary
Chicago, IL, United States (On-site) Contract (1 year 5 months) Published 5 hours ago Security & Governance bigquery performance optimization cloud platform data engineering DevOps & CI/CD sql database database administration Key Responsibilities: Architecture & Administration: - Manage BigQuery datasets, tables, views, and authorized views.
Benefits
Include medical, dental, vision and retirementApplications will be accepted on an ongoing basis.Tundra Technical Solutions is among North America’s leading providers of StaffinOur success and our clients’ success are built on a foundation of service excell
Qualifications
- Technical Expertise:
- Strong mastery of Google BigQuery architecture and storage mechanics.
- Advanced SQL optimization and query tuning
Responsibilities
- 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.
Certifications
GitHub ActionsGoogle Cloud Certified
Degrees
AssociateDegree
Work schedule
Shift
Industry
AutomotiveEducation
Company size
Smb
Contract length
1 years
Security clearance
Confidential