Senior Software Engineer (Data Infrastructure/RDBMS)

Location: Remote in North America, United States; primary timezone overlap across US and Canada working hours. Participation in in-person R&D work weeks is required 1–2 times per quarter at a TRM hub or designated location, with additional travel possible.

Company

hirify.global provides AI-powered intelligence platforms that help public and private sector agencies investigate illicit activity, build cases, and disrupt crime.

What you will do

• Develop, operate, and scale petabyte-scale PostgreSQL/Citus relational database systems serving TRM products and services.
• Own the database serving layer end to end, including query tuning, index design, schema optimization, cost, availability, and customer-facing API performance.
• Use AI-assisted analysis with pganalyze and Claude to identify compression, data-model, cost, and performance improvements and deploy validated changes.
• Build agentic automation for database operations such as pgbouncer provisioning, disk scaling, blue-green deployments, and pre-production change validation.
• Manage CDC pipelines with PeerDB, Fivetran, Debezium, Datastream, or Airbyte and use AI tooling to debug replication failures.
• Migrate workloads from first-generation infrastructure, prototype new data stores, and codify workflows into reusable AI-native runbooks and internal tooling.

Requirements

• 5–8 years of experience building and operating production PostgreSQL, including Citus, Aurora, AlloyDB, or equivalent distributed PostgreSQL.
• Deep SQL optimization skills covering Explain Plans, CTEs, window functions, partitioning, index design, and query-planner behavior in distributed environments.
• Hands-on experience with CDC tools including PeerDB, Fivetran, Debezium, Datastream, or Airbyte, plus the ability to use AI tooling to debug replication failure modes.
• Fluency with database profiling using pganalyze or an equivalent tool to interpret metrics and logs, including using LLMs to summarize performance findings.
• Production automation experience in Python or Go, including agentic automation of routine database tasks.
• Daily use of AI coding tools such as Claude or Copilot, with judgment to evaluate and reject unreliable AI output.
• A track record of using AI-assisted analysis to deliver measurable cost or performance improvements in production database systems.
• Ability to participate in an on-call rotation approximately once every 15 days, with each shift covering a 24-hour window across two days; the Canada portion is pending provincial compliance confirmation.

Nice to have

• PostgreSQL extension development experience.

Culture & Benefits

• Distributed, async-first collaboration across US and Canada working hours, with purposeful meetings and a written-first approach using technical specifications and decision documents.
• Most individual contributors spend no more than 3–4 hours per week in meetings.
• Participation in in-person R&D work weeks is supported with coordinated and approved travel, lodging, and workspace; accommodations are available for legitimate caregiving, health, immigration, and similar constraints.
• Work in a product-focused, customer-focused, coaching-oriented, process-oriented environment with high ownership, adaptability, and emphasis on operational excellence.
• AI fluency is a baseline expectation and is evaluated during the interview process.

Hiring process

• Recruiter introduction, hiring manager interview, and first-round interviews focused on the most critical skills.
• Final hands-on case study, usually in a panel format, plus an AI skills assessment and Leadership Principles interview.
• References followed by an offer and compensation discussion.