Overview
On Site
Depends on Experience
Contract - Independent
Contract - 12 Month(s)
Skills
Python
SQL
Google Cloud Platform
Bigquery
DBA
Job Details
Job Summary:
We are seeking a skilled Python BigQuery DBA to manage, optimize, and maintain our BigQuery data warehouse environment. The ideal candidate will have strong experience in database administration, performance tuning, and automation using Python, with a deep understanding of Google Cloud Platform (Google Cloud Platform), particularly BigQuery.
Key Responsibilities:
- Administer and maintain BigQuery datasets, tables, and views.
- Design and implement efficient data models and schemas for analytics and reporting.
- Optimize BigQuery SQL queries and manage costs associated with data processing.
- Develop and maintain Python scripts for data processing, automation, and database management.
- Monitor performance, troubleshoot issues, and implement best practices for data security and access control.
- Collaborate with data engineers, analysts, and business stakeholders to support data needs.
- Create and maintain documentation related to data architecture, processes, and workflows.
- Implement backup, recovery, and data archival strategies.
Required Skills & Qualifications:
- 3 6 years of experience as a Database Administrator, with at least 2+ years of experience in BigQuery.
- Proficiency in writing complex SQL queries and query optimization in BigQuery.
- Strong hands-on experience in Python for scripting, automation, and data processing.
- Deep understanding of database design, indexing, and data partitioning strategies.
- Experience with Google Cloud Platform services including IAM, Cloud Storage, Dataflow, and Pub/Sub is a plus.
- Knowledge of ETL/ELT tools and frameworks (e.g., Apache Airflow, dbt) is a plus.
- Familiarity with CI/CD pipelines and version control tools like Git.
- Strong analytical and problem-solving skills.
- Excellent communication and documentation skills.
Preferred Qualifications:
- Google Cloud Platform Professional Data Engineer or similar certification.
- Experience working in Agile/Scrum environments.
- Exposure to data governance, compliance, and data quality frameworks.
Education:
- Bachelor s or Master s degree in Computer Science, Information Technology, or a related field.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.