> Markdown version of [/jobs/ext/3051008-senior-software-engineer-data-infrastructure-rdbms](https://www.wearedevelopers.com/jobs/ext/3051008-senior-software-engineer-data-infrastructure-rdbms). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Software Engineer, Data Infrastructure (RDBMS) - **Company:** TRM Labs - **Location:** United States - **Experience:** Expert - **Salary:** $200,000.0 - $220,000.0 - **Contract:** Temporary contract - **Skills:** Query Performance, Application Programming Interfaces (APIs), Artificial Intelligence, Software Quality, Databases, Data Infrastructure, Data Integrity, Data Stores, Relational Databases, Software Debugging, Distributed Systems, Github, Python (Programming Language), PostgreSQL, Operational Databases, Query Optimization, Sql Optimization, Large Language Models, Debezium, Real Time Data - **Published:** September 24, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=914217a264e68e84 ## About the Role * 5-8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres) * Deep SQL optimization skills (Explain Plans, CTEs, window functions, partitioning, index design, query-planner behavior in distributed environments), increasingly paired with AI-assisted query analysis * Hands-on experience with CDC tools (PeerDB, Fivetran, Debezium, Datastream, Airbyte) and comfort using AI tooling to debug replication failure modes * Fluency with database profiling (pganalyze or equivalent) 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; Postgres extension development is a plus * Daily use of AI coding tools (Claude, Copilot) to accelerate development and produce higher-quality output faster, with the judgment to know when to trust or reject AI output * A track record of using AI-assisted analysis to drive measurable cost or performance improvements in production database systems, * Priorities and targets to change quickly as we experiment and iterate * Work that often requires operating with a high degree of ambiguity * A high level of personal ownership and accountability * Close collaboration across teams and functions * Frequent, high-touch communication * Creative problem solving and out-of-the-box thinking * A pace that rewards urgency, adaptability, and outcomes This environment is energizing for people who enjoy building, solving hard problems, and making progress in situations that are not always fully defined. It also requires comfort navigating ambiguity, adjusting course as new information emerges, and maintaining focus and positivity in a fast-moving and intense environment. We also recognize that this style of operating is not for everyone. If you are primarily optimizing for predictability or a consistently balanced workload, we encourage you to use the interview process to pressure test whether this environment is truly the right fit. We want teammates who thrive here, not just survive here. At the same time, many people find this work deeply rewarding. If you are excited by meaningful problems, motivated by ambitious goals, and energized by working alongside mission-driven colleagues, there is a good chance you will find TRM to be an exceptional place to grow and contribute. Learn more about Interviewing at TRM ## Description The Data Platform team builds and owns highly available, scalable data infrastructure for TRM's products and services. As a Senior Software Engineer on Data Infrastructure (RDBMS), you will develop, operate, and scale the relational database systems that serve data at petabyte scale, helping build a safer financial system for billions of people. This role is uniquely broad at TRM: you own the serving layer end to end, from query performance to cost to availability, on infrastructure that product teams depend on every day. The impact you will have: * Keep customer-facing APIs fast and available at five-nines by owning query tuning, index design, and schema optimization on petabyte-scale Postgres/Citus, directly determining whether product teams can serve data in real time * Cut storage and compute costs materially by using AI-assisted analysis (pganalyze paired with Claude) to detect compression and data-model opportunities, then shipping validated changes to production * Remove team toil by building agentic automation for routine database operations, such as self-serve pgbouncer provisioning, disk scaling, and blue-green deployments, so any engineer can run them safely * Protect data integrity and latency by driving agentic validation of database changes before they reach production * Keep real-time data flowing by managing CDC pipelines (PeerDB, Fivetran, Debezium) and using AI tooling to debug replication failures faster * Shape the next-generation platform by migrating workloads off first-gen infrastructure and prototyping new data stores with AI-accelerated spikes * Raise the whole team's leverage by codifying your workflows into AI-native runbooks and internal tooling that teammates reuse, * The Data Platform team is distributed, not distant. We operate async-first across US and Canada working hours with intentional synchronous touchpoints when speed demands it * We own the petabyte-scale data infrastructure that powers TRM's products. The scope is large, the mission is real, and the work is technically demanding * Team culture is product-focused, customer-focused, coaching-oriented, scrappy when needed, and process-oriented when executing against OKRs * You will work alongside senior engineers who care deeply about their craft and hold high standards for code quality, operational excellence, and cross-team communication Team Operating Rhythms: * Distributed, not distant: most collaboration happens async in Slack, Notion, and GitHub, and meetings are purposeful and minimal * Primary timezone overlap across US and Canada working hours; our north star is no IC spending more than 3-4 hours per week in meetings * Written-first culture: technical specs and decision docs drive alignment before code On Call Requirements: * On Call Requirements - Pending Regional Compliance Review. This role carries an on-call rotation (approximately once every 15 days; each shift is a 24-hour window across 2 days). On-call is clear to proceed for United States; the Canada portion requires People Ops / Deel provincial confirmation before this section is finalized and posted. See the On-Call Compliance note in the Post-Fill Summary. Learn about TRM Speed in this position: * Within 30 days, eliminate a single point of failure by shipping self-serve scaling automation (pgbouncer provisioning, disk resizing) that any teammate can run, freeing senior engineering time * Within the first quarter, identify a compression opportunity with AI-assisted analysis, validate it with a proof of concept, and ship it to production for a measurable storage-cost reduction with zero availability impact * Within 90 days, coordinate a schema change across three product-engineering teams in parallel and deliver the platform changes ahead of a product deadline so a customer feature ships on time, We hire and grow against three leadership principles. They're the standards for how we operate, treat each other, and make decisions. * Impact-Oriented Trailblazer: We put customers first and move with speed, focus, and adaptability. We treat every plan like an experiment - test, ship, measure, and iterate quickly. * Master Craftsperson: We care deeply about our craft. We balance speed with high standards, own outcomes end-to-end, and invest in getting better everyday. * Inspiring Colleague: We add clarity and energy, not noise. We bring humility, candor, and a one-team mindset - giving and receiving feedback to make the team stronger., By submitting your application, you agree to allow TRM Labs to process your personal information in accordance with our Privacy Policy. We collect the information you provide (such as your resume, work history, and contact details) solely for the purpose of evaluating your candidacy for current and future roles at TRM. Because our hiring cycles for certain positions may span 24 to 36 months, we retain your personal information for up to 36 months from the date of your application. After that period, your data is deleted unless a different retention period is required or permitted by law. If you are located in the European Economic Area, the United Kingdom, or another jurisdiction with applicable data protection laws, you have the right to access, correct, or request deletion of your personal data at any time before that period ends. To exercise any of these rights, contact us at privacy@trmlabs.com. To notify TRM Labs that you believe this job posting is non-compliant, please submit a report through this form. No response will be provided to inquiries unrelated to job posting compliance. The use of AI tools of any kind (including but not limited to notetakers, interview assistants, and real-time coaching tools such as Otter.ai, Fireflies, Fathom, Cluey, or similar) during TRM interviews is not permitted without prior approval from TRM. TRM uses its own internal tools for note-taking to ensure a consistent and confidential experience for all candidates. We are committed to providing reasonable accommodations to applicants with disabilities, and requests can be made via this form.