Senior Database Engineer - GCP

We are seeking a versatile Senior Database Engineer to design, manage, and optimize a robust data ecosystem within the Google Cloud Platform (GCP). In this role, you will serve as the essential bridge between application development teams and data infrastructure. You will manage a diverse portfolio of Relational and NoSQL databases while architecting sophisticated ETL/ELT pipelines to power our BigQuery data warehouse. This position requires a high-level blend of deep SQL expertise, sophisticated pipeline orchestration, and a steadfast commitment to 24/7 production reliability for mission-critical systems.

Location: Toronto, ON (GTA)
Assignment Type: Hybrid (Primarily remote, onsite approx. once per month)
Contract Duration: 6-month contract with potential for extension
Rate: $66.19-$73.97/hr

Advantages
Cutting-Edge Stack: Lead the management of a diverse, modern data ecosystem on GCP.

Hybrid Flexibility: Enjoy a primarily remote work-from-home setup with minimal onsite requirements in the GTA.

Impactful Ownership: Act as a subject matter expert, influencing schema design and query optimization for multiple application teams.

End-to-End Scope: From infrastructure management and version control to high-level BI dashboarding.

Responsibilities
Database Administration & Modeling

Manage, monitor, and tune Cloud SQL (MySQL, PostgreSQL, MSSQL) and NoSQL instances (Firestore, BigTable, Elastic) for peak performance.

Design scalable schemas using advanced normalization and denormalization techniques.

Develop complex stored procedures, views, and automated database jobs, utilizing MSSQL Change Tracking and Change Data Capture (CDC) features.

Data Engineering & Analytics

Build and orchestrate robust data pipelines using Apache Airflow (Cloud Composer) and Apache Beam (Dataflow).

Architect reporting solutions on BigQuery and design automated, insightful dashboards in Looker Studio and other BI tools.

Move data seamlessly across the ecosystem to support real-time and batch analytics.

Infrastructure & Operations

Manage Linux-based VMs for database hosting and utility tasks.

Implement database version control and migrations using Liquibase.

Deploy high-fidelity monitoring and observability tools to streamline incident response and performance bottleneck analysis.

Provide 24/7 support for mission-critical database incidents and participate in production deployment calls.

Qualifications
Experience: 5+ years of experience in Database Engineering, Data Engineering, or a Senior DBA role.

Cloud Platform Mastery: Extensive experience with Google Cloud Platform (GCP) services, including Cloud SQL, BigQuery, and NoSQL offerings.

Database Expertise: Expert-level SQL skills with deep knowledge of MySQL, PostgreSQL, and MSSQL.

NoSQL Proficiency: Hands-on experience managing document-based stores like Firestore, Datastore, or Elastic.

Orchestration Skills: Experience with workflow orchestration (Airflow) and stream/batch processing (Dataflow/Beam).

Technical Toolkit: Strong command of Linux/Unix environments, Python scripting for automation, and database version control (Liquibase).

Education: Bachelor’s degree in Computer Science, Information Systems, or a related technical field.

Summary
If you're interested in the Senior Database Engineer - GCP role based in Toronto, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.