A

ABC Legal Services

Tech-enabled process serving for law firms

Senior Database Engineer - PostgreSQL/AWS Aurora

Database AdministrationConfirmed live in the last 24 hours
Full-timeRemote in USA$140k - $150kRemote

About the Job

Requirements

  • At least 5 years of experience working with production relational databases; 8 or more years is a plus.
  • Strong production experience with PostgreSQL, ideally including AWS Aurora PostgreSQL.
  • Strong SQL skills, including joins, common table expressions, query plans, indexes, constraints, triggers, transactions, and lock behavior.
  • Experience investigating high-volume databases with large tables, long-lived schemas, and real production load.
  • Ability to distinguish intrinsic query cost from lock contention, blocking, bad plans, missing indexes, and application call-volume issues.
  • Strong attention to detail when reviewing schema migrations and operational changes.
  • Experience collaborating with application engineers on database-backed application design and performance.
  • Good judgment around access control, personally identifiable information, production safety, and release risk.
  • A bachelor's degree in engineering or a software field is preferred; a master's degree is a plus.

Responsibilities

  • Serve as a PostgreSQL and AWS Aurora subject-matter expert for the internal system Skye’s operational database.
  • Manage and improve a large relational schema with hundreds of tables, high-volume operational data, and substantial historical data.
  • Review database changes for correctness, performance, safety, indexing, grants, triggers, foreign keys, and migration hygiene.
  • Analyze and triage production database issues, including slow queries, lock contention, blocking transactions, runaway queries, replication lag, and performance regressions.
  • Improve query performance and indexing for large tables, reporting workloads, assignment and routing workflows, mobile API payloads, and internal operational dashboards.
  • Automate routine database maintenance and operational tasks, such as repacking, cleanup, monitoring checks, and recurring reports.
  • Support database refresh, backup, restore, staging, and release workflows in partnership with Infrastructure.
  • Collaborate with Infrastructure, Software Development, and Data Science teams on reliability, performance, reporting, analytics, and operational data needs.
  • Help maintain safe access patterns for reporting users, Metabase, developers, and sensitive or personally identifiable information-bearing tables.
  • Work with accounting-related data flows when needed, including invoices, payments, billing accounts, vendor/payee data, and ERP integration tables.

Desired Qualifications

  • Experience with Linux, Bash, scripting, cron, or other orchestration and automation tools used for database maintenance and operational workflows.
  • Java experience, especially in applications using MyBatis, Spring, or similar data access frameworks.
  • Experience with reporting workloads, business intelligence tooling, Metabase-style access patterns, PostGIS, or geospatial query performance.
  • Experience with AWS monitoring tools, CloudWatch, RDS/Aurora Performance Insights, pg_stat_statements, pgAdmin, or similar observability tools.
  • Experience using AI coding agents such as Codex, Claude, or similar tools; at minimum, willingness to use AI-assisted development tools as part of day-to-day engineering work.
  • Secondary bonus: experience with NetSuite, Boomi, ERP or iPaaS integrations, accounting, billing, accounts receivable/accounts payable, payments, invoices, credit memos, customer deposits, vendor payments, or working-table integration patterns.

About the Company

ABC Legal Services

Tech-enabled process serving for law firms

ABC Legal Services provides process serving solutions for law firms, delivering legal documents to recipients with proof of delivery. Clients upload documents, track progress online, and receive confirmations, with services including point-to-point special delivery and subscription routes, GPS-based proof of service, venue validation, and optional e-filing where available. It differentiates itself with a nationwide and international network of over 2,000 process servers, handling more than 1 million documents annually across all 50 states and 77 countries, and by serving as the U.S. Department of Justice's Central Authority for international service of process. The company aims to offer fast, reliable, tech-enabled service of process and maintain leadership through its large network and real-time tracking capabilities.

Company size
501-1,000
Company stage
Not listed
Total funding
Not listed
Headquarters
Seattle, WA
Founded
1974

Recently Posted Jobs

Explore more opportunities at ABC Legal Services

See more jobs