What are the responsibilities and job description for the BigQuery Database Administrator (DBA) position at Wavicle Data Solutions?
A BIT ABOUT WAVICLE
Wavicle Data Solutions leverages Cloud, Data & Analytics technologies to deliver complex business & digital transformation solutions to our clients. As a Minority Business Enterprise (MBE) with a 40% women workforce, Wavicle fosters a diverse & equitable environment where innovative professionals come together as a team and enable our clients to realize their goals in their transformation journey. Our team members collaborate by infusing their creative problem solving skills, agile working & tech know-how to drive value for our clients.
At Wavicle, a Top Workplace award winner, you’ll find a challenging and rewarding work environment where our 500 team members based in US, India Canada work from 42 cities in a remote/hybrid, digitally connected way. We offer a competitive benefits package that includes: healthcare, retirement, life insurance, short/long-term disability, unlimited paid time off, short-term incentive plans (annual bonus) and long-term incentive plans.
WHY WAVICLE?
Watch here to learn: https://vimeo.com/654661550
THE OPPORTUNITY
Wavicle is seeking an experienced BigQuery Database Administrator (DBA) to manage and optimize our Google Cloud Platform (GCP)-based data solutions. As a BigQuery DBA, you will be responsible for ensuring the efficient operation of our data warehouse, managing data ingestion, performing backups, maintaining security standards, and optimizing performance to handle large datasets.
WHAT YOU WILL GET TO DO
- Manage and administer Google BigQuery environments, ensuring high availability, performance, and scalability.
- Design, implement, and maintain BigQuery data models, schemas, and ETL pipelines.
- Monitor and optimize BigQuery queries for performance improvements, cost optimization, and efficiency.
- Troubleshoot and resolve database performance issues, slow-running queries, and other related issues.
- Implement security and compliance controls, including access management, auditing, and encryption.
- Collaborate with data engineers, data scientists, and other teams to support data analytics and reporting needs.
- Manage data integration tasks from diverse sources (e.g., on-premises databases, cloud storage) to BigQuery.
- Perform data backups and disaster recovery procedures.
- Automate repetitive tasks using scripting or GCP-native tools (e.g., Cloud Functions, Dataflow).
- Document database designs, procedures, and best practices for the team.
WHAT YOU BRING TO THE TEAM
- Proven experience with Google BigQuery and Google Cloud Platform services (e.g., Cloud Storage, Dataflow, Pub/Sub).
- Strong proficiency in SQL and BigQuery-specific SQL functions and optimization.
- Experience with ETL tools (e.g., Apache Beam, Cloud Data Fusion, Talend) and data pipeline automation.
- Familiarity with database performance tuning, indexing, and query optimization.
- Knowledge of cloud-based data security, access control, and data governance.
- Experience with GCP billing, cost management, and data query cost optimization in BigQuery.
- Ability to troubleshoot and resolve database-related issues efficiently.
- Proficiency in scripting languages such as Python, Bash, or similar.
- Excellent communication skills and the ability to work collaboratively in a team environment.
- Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent experience.
PREFERRED QUALIFICATIONS
- Experience with other cloud data warehousing solutions (e.g., Amazon Redshift, Snowflake).
- Familiarity with data visualization tools (e.g., Looker, Tableau, Power BI).
- Google Cloud certification (e.g., Professional Data Engineer, Google Cloud Certified - Associate Cloud Engineer).
- Knowledge of machine learning and AI tools integration with BigQuery.
EQUAL OPPORTUNITY EMPLOYER
Wavicle is an Equal Opportunity Employer and committed to creating an inclusive environment for all employees. We welcome and encourage diversity in the workplace regardless of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information or veteran status.
