What are the responsibilities and job description for the Big Query DBA-Only W2 Candidates position at Mega Cloud Lab?
Location : Irving, TX (onsite role)
Role: Big Query DBA -Only W2 Candidates
We are seeking candidates experienced in ETL processes, Google BigQuery, and Teradata migrations.
Qualifications
Job Description:
Role: Big Query DBA -Only W2 Candidates
We are seeking candidates experienced in ETL processes, Google BigQuery, and Teradata migrations.
Qualifications
Job Description:
- 8 years as a Data Warehouse Engineer or DBA.
- 3 years of hands‑on BigQuery administration in production.
- Strong SQL performance tuning and query optimization skills.
- Hands‑on experience with GCP services: BigQuery, Composer/Airflow, Dataflow, Cloud Storage, Pub/Sub, Monitoring/Logging.
- Experience with EDW platform migrations and enterprise‑scale data engineering.
- Strong knowledge of IAM, security controls, networking basics, and DR strategies.
- Experience with scripting (Python/Bash) and automation.
- Monitor BigQuery performance, query runtimes, slot utilization, and daily cost metrics; identify regressions and implement performance optimizations.
- Analyze and tune slow or expensive SQL queries, recommend and apply partitioning, clustering, and materialized views to improve efficiency.
- Operate and troubleshoot data pipelines (Composer/Airflow, Dataflow, Pub/Sub); investigate job failures, restart/triage runs, and coordinate fixes with ETL teams.
- Plan, execute, and validate ETL/EDW migrations (e.g., Teradata to BigQuery): create migration runbooks, perform test migrations, reconcile source and target data, and produce migration status reports.
- Maintain and enforce data platform configurations: schemas, access controls (IAM), networking considerations, DR/backup strategies, and security controls; handle daily access requests and audits.
- Develop and maintain automation and operational scripts (Python/Bash) for deployments, monitoring, alerting, and routine maintenance tasks.
- Respond to incidents and participate in on-call rotation; perform root cause analysis and implement corrective actions and preventive measures.
- Collaborate with data engineers, analysts, and stakeholders to prioritize requests, define deliverables, and provide status updates and capacity planning.
- Produce regular operational deliverables: weekly performance and cost reports, incident postmortems, migration progress reports, and updated runbooks/documentation.
Salary : $50 - $60