Sr. Database Engineer, Postgre SQL/AWS Aurora

ABC Legal Services

Oregon

Hybrid

USD 140,000 - 150,000

Full time

10 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health insurance
Dental insurance
Vision insurance
401(k) with company match
Paid time off
7 paid company holidays
4 floating holidays

Job summary

ABC Legal Services is seeking a Database Engineer to own and scale the PostgreSQL/Aurora-driven core platform. You will optimize a large relational schema, review migrations for correctness, and diagnose production issues affecting process serving, billing, and reporting.

You will partner with Infra, Dev, and Data Science to improve data access, performance, and safety, while handling sensitive data and ERP-related flows. This role offers a path to impact across a national leader.

Qualifications

  • 5+ years in production relational databases with strong PostgreSQL/Aurora experience.
  • Deep SQL skills: joins, CTEs, plans, indexes, triggers, transactions.
  • Experience reviewing migrations and maintaining data security and access.
  • Collaborative work with engineering teams on database-backed designs.

Responsibilities

  • Serve as PostgreSQL and AWS Aurora SME for Skye’s operational DB.
  • Manage a large relational schema with high-volume data and history.
  • Review schema changes for correctness, performance, and safety.
  • Triage production DB issues: slow queries, locks, replication lag.
  • Improve query performance and indexing for large tables and dashboards.
  • Automate routine maintenance and recurring reports.
  • Support DB refresh, backup, staging, and release workflows with Infra.
  • Collaborate with Infra, Dev, and Data Science on reliability and analytics.
  • Ensure safe access for reporting users and PII-bearing tables.
  • Engage with ERP-related data flows when needed.

Skills

PostgreSQL
AWS Aurora
SQL performance
Data modeling
Schema migrations
Query optimization
Production database tuning

Education

Bachelor's degree in engineering or software field
Master’s degree a plus

Tools

Linux
Bash scripting
Metabase / BI tooling
pgAdmin / monitoring tools
CloudWatch / Aurora Insights

Job description

About ABC Legal Services:

ABC Legal Service is proud to be the national leader in service of process. We are a team of 1000 and growing with offices in Los Angeles, Oklahoma City, Phoenix, Brooklyn, Chicago, Washington DC, and more. Seattle is our home and headquarters. We’ve been successful in this unique business for over 30 years and we continue to advance our technology and business processes to remain years ahead of what our competition is able to offer. Our focus is to expand our technology lead, acquire and integrate less efficient competitors, and tap into new segments through an integrated inbound marketing and sales approach.

Job Overview

ABC Legal is looking for a detail-oriented Database Engineer to help own, improve, and scale the PostgreSQL database layer behind Skye, our core legal-services platform. Skye supports high-volume process serving, court filing, operational workflows, customer facing applications, mobile field work, integrations, reporting, billing, and automation. Its primary operational database is PostgreSQL across all environments, with AWS Aurora reader/writer topology in production and major staging environments.

This role is ideal for someone who enjoys deep database work: understanding complex schemas, reviewing migrations, tuning high-volume queries, diagnosing production issues, improving operational safety, and helping application engineers make better data-access decisions. Accounting, ERP, or NetSuite/Boomi experience is helpful because some important data flows touch billing and payments, but this is fundamentally a PostgreSQL/Aurora database engineering role.

What You’ll Do
  • Serve as a PostgreSQL and AWS Aurora subject‑matter expert for our 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/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 closely 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/PII‑bearing tables.
  • Work with accounting‑related data flows when needed, including invoices, payments, billing accounts, vendor/payee data, and ERP integration tables.
What We’re Looking For
  • 5+ years of experience working with production relational databases (8+ years a plus).
  • Strong production experience with PostgreSQL, ideally including AWS Aurora PostgreSQL.
  • Strong SQL skills, including joins, CTEs, 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, PII, production safety, and release risk.
  • Clear written communication for documenting findings, tradeoffs, and recommended fixes.
  • Bachelor’s degree in engineering or software field preferred, Master’s Degree is a plus.
Very Nice to Have
  • Experience with Linux, Bash, scripting, cron, or other orchestration/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, BI 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 / iPaaS integrations, accounting, billing, AR/AP, payments, invoices, credit memos, customer deposits, vendor payments, or working‑table integration patterns.

We know that a company's success starts with its employees. We also know that an individual's success starts with the right career opportunity.

Benefits
  • Health, Dental, Vision insurance
  • 401(k) with company matching
  • Paid time off
  • 7 Paid company holidays
  • 4 Floating holidays per-year
  • Life Insurance and AD&D Insurance
  • Long Term Disability
  • Health Care Reimbursement Flexible Spending Account
  • Dependent Care Flexible Spending Account
  • EAP (Employee Assistance Program)
  • Pet Insurance
Schedule

Full-Time Monday through Friday. Flexible schedule

Salary Range

$140,000-$150,000 depending on experience

Application closing date: November 30, 2026, 11:59PM

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Database Engineer, Postgre SQL/AWS Aurora
Sr. Database Engineer, Postgre SQL/AWS Aurora

Abclegalservices • United States

Remote
USD 150,000 - 190,000
Sr. Database Administrator
Sr. Database Administrator

FinQuery, LLC • Atlanta (GA)

On-site
USD 120,000 - 160,000
Annual development stipend
Mentorship program
Sabbatical after 5 years
+5
Senior PostgreSQL DBA: Lead Data Architecture & AI
Senior PostgreSQL DBA: Lead Data Architecture & AI

FinQuery, LLC • Atlanta (GA)

On-site
USD 120,000 - 160,000
Annual development stipend
Mentorship program
Sabbatical after 5 years
+5
Sr. Database Administrator
Sr. Database Administrator

Finquery, Formerly Leasequery • Atlanta (GA)

On-site
USD 120,000 - 180,000
Annual development stipend
Mentorship program
Sabbatical after 5 years
+9
Senior PostgreSQL Database Engineer, RDS
Senior PostgreSQL Database Engineer, RDS

Amazon • Seattle (WA)

On-site
USD 131,400 - 227,000
Mentorship opportunities
Flexible work-life balance
Competitive health benefits
+2
Database Analyst / Administrator
Database Analyst / Administrator

Kmrg • United States

Remote
USD 140,000 - 175,000
Senior PostgreSQL/AWS Aurora Engineer - Performance & Scale
Senior PostgreSQL/AWS Aurora Engineer - Performance & Scale

Abclegalservices • United States

Remote
USD 150,000 - 190,000
Database Analyst / Administrator
Database Analyst / Administrator

Kmrg, Llc • Washington

Remote
USD 140,000 - 175,000
Manager, Database Administration
Manager, Database Administration

ticketnetwork • South Windsor (CT)

Hybrid
USD 100,000 - 120,000
Medical, Dental, Vision, Life Ins.
401K and more
Paid Time Off and Holidays
+5
Senior PMT-ES, Amazon Aurora
Senior PMT-ES, Amazon Aurora

Amazon Web Services (AWS) • East Palo Alto (CA)

On-site
USD 175,000 - 237,000