Senior PostgreSQL/AWS Aurora Engineer - Performance & Scale

Abclegalservices; United States; Remote; USD 150,000 - 190,000; Full time

Job summary

Abclegalservices seeks a senior database engineer to own the PostgreSQL/AWS Aurora backbone of a high-volume legal platform. You will optimize schemas, tune queries, and troubleshoot production issues to keep billing and reporting fast and reliable.

Collaborate across teams to implement safe migrations, codify best practices, and automate maintenance while handling large historical data and complex data access patterns.

Qualifications

• 5+ years of production relational database experience, 8+ years preferred.
• Strong PostgreSQL experience, AWS Aurora PostgreSQL preferred.
• Strong SQL skills covering joins, CTEs, plans, indexes, constraints, and transactions.
• Experience with large, high-volume databases and long-lived schemas.
• Clear written communication for documenting findings and fixes.

Responsibilities

• Serve as PostgreSQL and AWS Aurora SME for the operational DB behind the platform.
• Manage and improve a broad relational schema with hundreds of tables and historical data.
• Review migrations for correctness, performance, safety, indexing, grants, triggers.
• Triage production issues: slow queries, locks, replication lag, regressions.
• Improve query performance and indexing for large tables, reporting, and dashboards.
• Automate routine maintenance and collaborate with infra and data teams.

Job description

Abclegalservices seeks a senior database engineer to own the PostgreSQL/AWS Aurora backbone of a high-volume legal platform. You will optimize schemas, tune queries, and troubleshoot production issues to keep billing and reporting fast and reliable.

Collaborate across teams to implement safe migrations, codify best practices, and automate maintenance while handling large historical data and complex data access patterns.