Senior PostgreSQL/Aurora DB Engineer: Scale & Optimize

ABC Legal Services

Oregon

Hybrid

USD 140,000 - 150,000

Full time

10 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior PostgreSQL/AWS Aurora Engineer - Performance & Scale
Senior PostgreSQL/AWS Aurora Engineer - Performance & Scale

Abclegalservices • United States

Remote
USD 150,000 - 190,000
Sr. Database Engineer, Postgre SQL/AWS Aurora
Sr. Database Engineer, Postgre SQL/AWS Aurora

Abclegalservices • United States

Remote
USD 150,000 - 190,000
Remote PostgreSQL/Aurora DBA — Performance & Automation
Remote PostgreSQL/Aurora DBA — Performance & Automation

Highbrow LLC • United States

Remote
USD 130,000 - 190,000
PostgreSQL/Aurora DBA
PostgreSQL/Aurora DBA

Highbrow LLC • United States

Remote
USD 130,000 - 190,000
Senior PostgreSQL/Aurora DBA – Data Warehouse & Cloud
Senior PostgreSQL/Aurora DBA – Data Warehouse & Cloud

The Dignify Solutions, LLC • Jersey City (NJ)

On-site
USD 90,000 - 120,000
Senior PostgreSQL Platform Engineer | AI-Driven Automation
Senior PostgreSQL Platform Engineer | AI-Driven Automation

trm-labs • United States

Remote
USD 180,000 - 240,000
Senior PostgreSQL Engineer — High-Volume Data Platform
Senior PostgreSQL Engineer — High-Volume Data Platform

Verra Mobility Corporation • Mesa (AZ)

Hybrid
USD 140,000 - 190,000
Senior PostgreSQL DBA for AWS RDS/Aurora – Remote Europe
Senior PostgreSQL DBA for AWS RDS/Aurora – Remote Europe

Recruiter4you • United States

Remote
USD 132,000 - 198,000
Senior PostgreSQL Reliability Engineer (Remote)
Senior PostgreSQL Reliability Engineer (Remote)

Joblet-AI • United States

Remote
USD 120,000 - 150,000
Equity
Bonuses
Health insurance
+1
Remote Senior PostgreSQL Database Engineer | AWS Performance
Remote Senior PostgreSQL Database Engineer | AWS Performance

Discovery Machine, Inc. • United States

Remote
USD 140,000 - 190,000