Senior Software Engineer, Data Infrastructure – RDBMS

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, manage, and expand relational database systems capable of handling data at a petabyte scale.

• Take full ownership of the serving layer, encompassing query performance, cost management, and system availability.

• Ensure five-nines availability and performance for customer-facing APIs through effective query tuning, index design, and schema optimization.

• Leverage AI-driven analysis with tools like pganalyze and Claude to discover and implement improvements in compression and data modeling.

• Develop automated solutions for pgbouncer provisioning, disk scaling, and blue-green deployment processes.

• Oversee the validation of database modifications prior to production rollout.

• Manage Change Data Capture (CDC) pipelines utilizing PeerDB, Fivetran, and Debezium.

• Troubleshoot replication failures using AI-based tools.

• Transition workloads from legacy infrastructure and experiment with new data storage solutions.

• Produce AI-focused runbooks and develop internal tools.

• Collaborate asynchronously with distributed teams across the United States and Canada.

• Engage in an on-call rotation approximately once every 15 days, with each shift covering a 24-hour period over two days.

⛳️ Requirements

• 5–8 years of experience in building and managing production PostgreSQL systems (Citus, Aurora, AlloyDB, or similar distributed Postgres).

• Profound SQL optimization expertise, including working with Explain Plans, Common Table Expressions (CTEs), window functions, partitioning, index design, and query planner behavior in distributed settings.

• Practical experience with CDC tools such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte.

• Proficiency in database profiling using pganalyze or a comparable tool to analyze metrics and logs.

• Experience in production automation with Python or Go.

• Regular use of AI coding tools like Claude or Copilot.

• Proven history of utilizing AI-assisted analysis to achieve significant cost or performance enhancements in production database systems.

• Readiness and capability to participate in an on-call rotation.

• Capacity to work during US and Canada working hours.

• Willingness to take part in in-person R&D work weeks and possible additional travel.

• AI proficiency is a fundamental expectation and will be assessed during the interview process.

🏝️ Benefits

• In-person R&D work weeks typically occur 1–2 times each quarter.

• TRM organizes and covers the costs for approved travel, accommodation, and workspace for work weeks.

• Support for legitimate caregiving, health, immigration, and similar situations.

• Competitive benefits, wellness programs, and time off policies that vary by country and local employment regulations.