5 months ago
Toronto, CanadaMid Level
Responsibilities
- Serve as the primary technical escalation point for database-related customer issues through email, ticketing systems, and video calls.
- Triage and prioritize issues, meet SLA targets, and investigate connector logs, query plans, replication slots, transaction logs, sync state, and destination table state.
- Support onboarding and troubleshooting for SSH tunnels, network configuration, database permissions, CDC, warehouse and lake authentication, schema evolution, incremental cursors, and typed destination tables.
- Validate database version compatibility, maintain testing environments, and reproduce customer behavior on database and warehouse instances.
- Contribute Java and Kotlin fixes, error handling improvements, and schema-evolution and CDC hardening to Airbyte’s open-source database connectors and Bulk CDK.
- Review and test community contributions to database sources and destinations.
- Collaborate with Engineering and Product to resolve root causes, communicate customer needs, and influence database reliability and performance priorities.
- Partner with Solutions Engineering, Sales Engineering, Sales, and Customer Success on technical onboarding, architecture reviews, production readiness, and expansion efforts.
- Train and mentor Technical Support Engineers on JDBC, CDC, schema evolution, query optimization, destination typing, normalization, and the Airbyte protocol.
- Create and maintain troubleshooting guides, knowledge-base articles, connector documentation, runbooks, and AI-assisted support automation.
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, and self-directed problem-solving skills.
- Ability to work Sun–Thu, Mon–Fri, or Tue–Sat shifts.
- Experience with PostgreSQL, MySQL, MSSQL, Oracle, MongoDB, Snowflake, BigQuery, Redshift, ClickHouse, or similar systems is preferred.
- Experience with Iceberg, Delta Lake, S3, GCS, or Azure Blob is preferred.
- Familiarity with Airbyte’s Bulk CDK or open-source database connector contributions is preferred.
- Experience with Kubernetes, Docker, multi-tenant architectures, developer-facing or embedded platform products, CI/CD pipelines, GitHub workflows, AI-assisted development tools, or automated playbooks is preferred.
Benefits
- Remote work in Canada time zones: Pacific, Mountain, and Central.
- Flexible shift options: Sun–Thu, Mon–Fri, or Tue–Sat.
Tech Stack
Amazon RedshiftAWSAzureClickHouseDatabricksDockerGoogle BigQueryGoogle Cloud PlatformJavaKotlinKubernetesMicrosoft SQL ServerMongoDBMySQLPostgreSQLSnowflakeSQL
Categories
BackendData 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.