Senior Software Engineer, Data Infrastructure – RDBMS
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior engineer operating petabyte-scale PostgreSQL infrastructure for TRM Labs’ AI-powered crime-intelligence platforms. Automating database operations, optimizing performance, and managing CDC pipelines remotely across LATAM.
Responsibilities:
- Develop, operate, and scale relational database systems serving data at petabyte scale
- Own the serving layer end to end, including query performance, cost, and availability
- Maintain five-nines customer-facing API performance and availability through query tuning, index design, and schema optimization
- Use AI-assisted analysis with pganalyze and Claude to identify and ship compression and data-model improvements
- Build agentic automation for pgbouncer provisioning, disk scaling, and blue-green deployments
- Drive validation of database changes before production deployment
- Manage CDC pipelines using PeerDB, Fivetran, and Debezium
- Debug replication failures using AI tooling
- Migrate workloads from first-generation infrastructure and prototype new data stores
- Create AI-native runbooks and internal tooling
- Collaborate asynchronously with distributed teams across US and Canada working hours
- Participate in an on-call rotation approximately once every 15 days, with each shift a 24-hour window across 2 days
Requirements:
- 5–8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres)
- Deep SQL optimization skills, including Explain Plans, CTEs, window functions, partitioning, index design, and query-planner behavior in distributed environments
- Hands-on experience with CDC tools such as PeerDB, Fivetran, Debezium, Datastream, or Airbyte
- Fluency with database profiling using pganalyze or equivalent to interpret metrics and logs
- Production automation experience in Python or Go
- Daily use of AI coding tools such as Claude or Copilot
- Track record of using AI-assisted analysis to drive measurable cost or performance improvements in production database systems
- Willingness and ability to participate in an on-call rotation
- Ability to work across US and Canada working hours
- Participation in in-person R&D work weeks and potential additional travel
- AI fluency is a baseline expectation and is evaluated during interviews
Benefits:
- In-person R&D work weeks typically 1–2 times per quarter
- TRM coordinates and covers approved travel, lodging, and workspace for work weeks
- Accommodations for legitimate caregiving, health, immigration, and similar constraints
- Competitive benefits, wellness programs, and time away from work, varying by country and local employment requirements
Similar Jobs
Data Architect
Databricks Data Architect designing secure Lakehouse architectures and AI-ready data platforms for Devoteam clients. Modernizing legacy systems across cloud and multi-cloud environments.
Senior Data Engineer
Senior Data Engineer building auditable GCP data pipelines for DysrupIT’s financial billing and invoicing platform. Ensuring accurate reconciliation, lineage, and trusted financial data.
Senior Software Engineer, Data Acquisition
Senior software engineer building distributed crawling and ingestion systems for People Data Labs, a provider of people and company data. Improving scalable backend services and data products.
IT Architect, Data Scientist
IT Architect/Data Scientist supporting DLH’s federal health and national-security programs. Leading cloud architecture, data science, interoperability, security engineering, and compliance for SCHARE.
Senior Business Data Engineer
Senior Business Data Engineer building AWS data infrastructure and automated reporting for Nex’s family motion-gaming platform. Improving pipeline reliability and supporting cross-functional business teams.
Senior Data Engineer
Senior Data Engineer building Python, Spark, and Databricks pipelines for Quantiphi’s data and AI solutions. Leading cloud migration, CI/CD automation, and scalable analytics engineering.
Senior Data Engineer – IBM DB2
Senior Data Engineer modernizing IBM DB2 data environments. Building reliable ETL/ELT pipelines and AWS integrations for enterprise applications and payroll systems.
Lead Data Architect
Lead Data Architect owning enterprise data architecture for C5MI Insight’s federal SAP S/4HANA modernization program. Leading data governance, migration, analytics architecture, and master data teams.
FBS Data Engineer, SQL, Power BI
Data Engineer supporting Farmers’ P&C insurance analytics and financial loss reporting solutions. Translating business data needs into requirements, integrations, dashboards, and validated reporting.
Data Engineer – Insurance
Data Engineer building analytics solutions, data pipelines, and enterprise integrations for Farmers Insurance. Improving data quality, reporting, dashboards, and regulatory-compliant business outcomes.
Power BI Data Engineer
Power BI Data Engineer building Azure data pipelines, dimensional models, and executive dashboards for Legence. Transforming complex data into actionable business intelligence across the full BI lifecycle.
Azure Data Engineer
Azure Data Engineer building Azure and Microsoft Fabric data solutions for Quisitive, a global Microsoft cloud partner. Delivering pipelines, integrations, and analytics projects for clients.
Senior Data Engineer
Senior Data Engineer building multi-region data infrastructure for Horizon3’s NodeZero autonomous cybersecurity platform. Supporting Federal workloads, warehouses, pipelines, orchestration, and BI reporting.
Data Engineer, Snowflake
Data Engineer Snowflake diseñando pipelines cloud y transformaciones ELT/ETL para Logicalis Spain. Participación en proyectos de ingeniería de datos, IA y analítica avanzada.
Data Engineer
Data Engineer building Python and AWS data pipelines for 540’s U.S. Army financial-system modernization initiative. Improving secure, scalable data transformation and governance.
Senior Manager, Data Engineering
Data engineering leader building Databricks and Azure platforms for Cushman & Wakefield, a global commercial real estate services firm. Managing engineers, platform delivery, governance, and stakeholder outcomes.
Data Architect
Data Architect designing Azure-integrated data platforms for Tieto’s agricultural analytics projects. Building scalable datasets, ETL pipelines, warehouses, and lakes.
Data Engineer
Data Engineer building scalable cloud pipelines, models, and enterprise data products for a major U.S. insurer. Supporting analytics, reporting, governance, and operational data capabilities.
Senior Data Engineer
Engenheiro de Dados SR desenvolvendo pipelines, Data Lakes e governança para o Grupo SysMap. Empresa brasileira de tecnologia acelerando a transformação digital de organizações.
Data Engineer
Data Platform Engineer owning cloud infrastructure, Terraform, CI/CD, and observability for Seer Interactive’s digital marketing consultancy. Automating analytics and AI platform operations.