Senior Database Engineer

Role Description

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

Qualifications

• 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

Requirements

• 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

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.