Senior Software Engineer, Data Infrastructure (RDBMS)

Accountabilities:

• Develop, operate, and scale highly available relational database infrastructure supporting petabyte-scale workloads.

• Own query performance, index design, schema optimization, and database tuning for production PostgreSQL and distributed PostgreSQL environments.

• Maintain high availability and performance for customer-facing systems by identifying and resolving database bottlenecks.

• Use AI-assisted analysis and database profiling tools to identify opportunities for storage, compute, compression, and data-model optimization, then validate and deploy improvements safely.

• Build agentic automation for routine database operations, including connection-pool provisioning, disk scaling, blue-green deployments, and other self-service workflows.

• Develop safeguards and automated validation processes to protect data integrity and system performance before database changes reach production.

• Manage change-data-capture and replication pipelines using technologies such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte.

• Investigate and resolve replication failures and other database reliability issues, leveraging AI tooling where appropriate to accelerate troubleshooting.

• Contribute to platform modernization efforts by migrating workloads from legacy infrastructure and evaluating or prototyping new data-storage technologies.

• Develop AI-native runbooks, internal tooling, and reusable workflows that increase engineering efficiency and reduce operational toil.

• Partner with product and engineering teams to coordinate schema changes and infrastructure improvements across multiple teams and product initiatives.

• Participate in an on-call rotation and support the reliability of production database infrastructure.

• Contribute to technical documentation, written decision-making, and a culture of operational excellence and continuous improvement.

Requirements:

• 5–8 years of experience building and operating production PostgreSQL environments, including technologies such as Citus, Aurora, AlloyDB, or equivalent distributed PostgreSQL systems.

• Deep SQL optimization expertise, including Explain Plans, CTEs, window functions, partitioning, index design, and query-planner behavior in distributed environments.

• Strong understanding of relational database architecture, performance tuning, scalability, availability, and reliability.

• Hands-on experience with CDC and replication technologies such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte.

• Experience with database profiling and performance analysis tools such as pganalyze or equivalent, including the ability to interpret metrics, logs, and performance data.

• Production automation experience using Python, Go, or comparable programming languages.

• Experience designing or implementing automation for routine database and infrastructure operations; PostgreSQL extension development is a plus.

• Strong experience using AI coding and analysis tools such as Claude or Copilot to accelerate development, troubleshoot systems, and improve output quality.

• Sound judgment when working with AI-generated output, including the ability to evaluate, validate, modify, or reject AI recommendations when necessary.

• Demonstrated experience using AI-assisted analysis to achieve measurable improvements in database performance, reliability, or infrastructure costs.

• Strong analytical and problem-solving skills, with the ability to investigate complex technical issues and develop practical solutions.

• Strong written and verbal communication skills, with the ability to collaborate effectively across distributed engineering teams.

• Comfortable working in an async-first environment with written technical specifications, decision documents, and purposeful synchronous collaboration.

• Ability to operate effectively in a fast-moving environment with evolving priorities, ambiguity, and a high degree of individual ownership.

• Willingness and ability to participate in an on-call rotation, subject to applicable regional requirements.

Benefits:

• Estimated annual base salary for the role is US$200,000–US$220,000, with compensation adjusted for applicable geographic factors outside the United States.

• Potential eligibility to participate in an equity plan.

• Remote-first working environment across North America, including Canada.

• Distributed, async-first team culture with purposeful meetings and written-first technical collaboration.

• Primary collaboration overlap across US and Canadian working hours.

• Opportunity to work on petabyte-scale data infrastructure and technically demanding distributed systems.

• Significant ownership across database performance, availability, cost optimization, automation, and reliability.

• Opportunity to work extensively with AI-assisted engineering, agentic automation, and AI-native operational tooling.

• Collaboration with experienced engineers who emphasize code quality, operational excellence, and strong cross-team communication.

• Opportunity to contribute to meaningful technology infrastructure supporting a mission-driven organization.

• Reasonable accommodations are available for applicants with disabilities.