Database Engineer

**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.