Sr. Database Engineer, Postgre SQL/AWS Aurora

ABC Legal Services$140K – $150K per yearUnited States only

Apply now

Opens the original posting on Himalayas.

Apply now Source: Himalayas

Apply on the original site

Companies in this catalog do not charge applicants. Never send money to apply.

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.

Loading job…

Sr. Database Engineer, Postgre SQL/AWS Aurora at ABC Legal Services · ApplyPick

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.

Sr. Database Engineer, Postgre SQL/AWS Aurora

Apply now

Sr. Database Engineer, Postgre SQL/AWS Aurora

Apply now

What You’ll Do:

Very Nice to Have:

Long Term Disability

Pet Insurance

Apply now