1 month ago
Remote, CanadaMid Level
Responsibilities
- Provide technical escalation support for database-related customer issues through email, ticketing systems, and video calls.
- Triage issues against SLA targets and investigate connector logs, query plans, replication slots, transaction logs, sync state, and destination table state.
- Support database authentication, SSL and SSH configuration, CDC setup, network configuration, permissions, schema evolution, incremental cursors, and destination typing.
- Validate database compatibility, maintain testing environments, and reproduce customer behavior across database, warehouse, and lake systems.
- Contribute Java and Kotlin fixes and improvements to Airbyte’s open-source database connectors and Bulk CDK.
- Review and test community connector contributions and maintain knowledge of connector and platform releases.
- Collaborate with Engineering and Product on customer issues, feature requests, reliability, and performance improvements.
- Partner with Solutions Engineering and Sales Engineering on enterprise onboarding, CDC architecture, schema modeling, and production readiness.
- Train and mentor Technical Support Engineers on database connectors, JDBC, CDC, schema evolution, query optimization, and the Airbyte protocol.
- Create troubleshooting documentation, runbooks, knowledge-base content, and AI-assisted support automation initiatives.
Requirements
- At least 2 years of experience in software engineering, data engineering, technical support, DevOps, QA, or a similar role supporting developers or technical users.
- Fluency in SQL and hands-on experience investigating query plans, isolation levels, and performance bottlenecks.
- Proficiency in Java or Kotlin, including the ability to read, write, and debug JVM-based connector code.
- Hands-on experience with relational databases, data warehouses, or data lakes, including CDC, schema evolution, and query optimization.
- Experience with JDBC and common database drivers, including debugging connection, authentication, SSL, and SSH tunnel issues.
- Understanding of AWS, GCP, or Azure and data integration concepts such as ELT and ETL workflows.
- Strong troubleshooting, communication, self-direction, and ambiguity-management skills.
- Preferred experience with PostgreSQL, MySQL, MSSQL, Oracle, MongoDB, Snowflake, BigQuery, Redshift, ClickHouse, Iceberg, Delta Lake, S3, GCS, or Azure Blob.
- Preferred familiarity with Airbyte’s Bulk CDK, open-source database connectors, Kubernetes, Docker, multi-tenant architectures, CI/CD pipelines, GitHub workflows, AI-assisted development tools, and automated runbooks.
Benefits
- Remote work in Canada for candidates in the Pacific, Mountain, or Central time zones.
- Flexible PTO with encouragement to take at least 25 days annually, plus provincial public holidays.
- Extended health coverage in addition to provincial public healthcare and access to virtual healthcare.
- Group retirement savings plan and statutory Canada/Québec pension, employment insurance, and workers’ compensation coverage.
- Professional development budget, conference sponsorship, and book reimbursement.
Tech Stack
AirbyteAmazon RedshiftAWSAzureClickHouseDatabricksDockerGoogle BigQueryGoogle Cloud PlatformJavaKotlinKubernetesMicrosoft SQL ServerMongoDBMySQLPostgreSQLSnowflakeSQL
Categories
BackendSolutions Engineering
About Airbyte
Airbyte builds an open-source data integration platform that replicates data from hundreds of sources into warehouses, lakes, and operational systems. It offers both self-hosted OSS and a managed cloud service with enterprise features, serving data teams and companies building production AI agents that need unified, permission-aware access to business data. Founded in 2020 and headquartered in San Francisco, the privately held company supports 600+ connectors.