Senior Software Engineer (Data Infrastructure/RDBMS)
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Location: Remote in North America, with the role listed for the United States; primary timezone overlap across US and Canada working hours. The role includes an on-call rotation approximately once every 15 days; the Canada portion is pending provincial compliance confirmation.
Salary: $200,000–$220,000 US base salary per year, with possible equity-plan participation. Compensation varies by geography outside the United States.
Company
provides AI-powered intelligence solutions that help public and private sector agencies investigate illicit activity, disrupt crime, and build safer financial systems.
What you will do
- Develop, operate, and scale petabyte-scale PostgreSQL/Citus infrastructure supporting customer-facing APIs.
- Improve query performance, index design, schema efficiency, availability, and infrastructure costs.
- Use AI-assisted analysis with tools such as pganalyze and Claude to identify, validate, and ship database optimizations.
- Build agentic automation for pgbouncer provisioning, disk scaling, blue-green deployments, and database-change validation.
- Manage CDC pipelines using PeerDB, Fivetran, Debezium, Datastream, or Airbyte, and debug replication failures.
- Migrate workloads from first-generation infrastructure and develop AI-native runbooks and internal tooling.
Requirements
- 5–8 years of experience building and operating production PostgreSQL, including distributed variants such as Citus, Aurora, or AlloyDB.
- Deep SQL optimization experience covering explain plans, CTEs, window functions, partitioning, index design, and distributed query-planner behavior.
- Hands-on experience with CDC tools and database profiling using pganalyze or an equivalent platform.
- Production automation experience in Python or Go, including automation of routine database operations.
- Daily use of AI coding and analysis tools such as Claude or Copilot, with sound judgment when evaluating AI output.
- Availability for an on-call rotation approximately once every 15 days, subject to regional compliance review for Canada.
Nice to have
- PostgreSQL extension development experience.
- Experience delivering measurable AI-assisted cost or performance improvements in production database systems.
Culture & Benefits
- Distributed, async-first collaboration across US and Canada working hours, with purposeful synchronous meetings.
- Written-first operating style using technical specifications and decision documents to align before coding.
- Focus on product impact, customer outcomes, coaching, operational excellence, and cross-team communication.
- High ownership, rapid experimentation, frequent feedback, and work on technically demanding infrastructure.
- AI fluency is expected and applied AI skills are evaluated during the interview process.
Hiring process
- Recruiter introduction, hiring-manager interview, and first-round interviews focused on critical technical skills.
- Final interviews typically include 3–5 sessions, with a case study, AI skills assessment, and Leadership Principles interview.
- References are checked before the offer; the recruiter provides the detailed interview plan and preparation guidance.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →