Senior Database Engineer

About

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.

Contract Details

• 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.