Senior Database Engineer, Postgre SQL/AWS Aurora

ABC Legal Services

Database Engineer scaling PostgreSQL and AWS Aurora for ABC Legal Services’ core legal-services platform. Optimizing production queries, schemas, reliability, access, and operational workflows.

Posted 8/4/2026full-timeRemote • 🇺🇸 United StatesSenior💰 $140,000 - $150,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in PostgreSQL and AWS Aurora, with a strong focus on managing relational databases, optimizing query performance, and ensuring operational reliability. Proficient in SQL, database maintenance automation, and collaboration with cross-functional teams to support data-driven decision-making.

Highest-signal resume keywords

PostgreSQL ExpertiseAWS Aurora ExperienceStrong SQL SkillsDatabase Performance OptimizationCollaboration with Software Development

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Relational Database ManagementSchema Migration ReviewQuery Performance TuningIndexing and ConstraintsLock Contention AnalysisDatabase AutomationData Access ControlBI Tooling ExperienceGeospatial Query PerformanceAI-Assisted Development Tools

Soft Skills

Attention to DetailClear Written CommunicationGood Judgment

Tools & Technologies

LinuxBashMetabasePostGISAWS Monitoring ToolsMyBatisSpring

Certifications & Qualifications

Bachelor's Degree in Engineering or Software Field

Industry Keywords

High-Volume DatabasesOperational DataERP IntegrationAccounting Data FlowsPayments and Invoices

Tech Stack

Tools & technologies

AWSERPJavaLinuxPostGISPostgresSpringSQL

About the role

Key responsibilities & impact

Serve as a PostgreSQL and AWS Aurora subject-matter expert for 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, including repacking, cleanup, monitoring checks, and recurring reports
Support database refresh, backup, restore, staging, and release workflows with Infrastructure
Collaborate with Infrastructure, Software Development, and Data Science teams on reliability, performance, reporting, analytics, and operational data needs
Maintain safe access patterns for reporting users, Metabase, developers, and sensitive/PII-bearing tables
Work with accounting-related data flows including invoices, payments, billing accounts, vendor/payee data, and ERP integration tables

Requirements

What you’ll need

5+ years of experience working with production relational databases
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
Experience with Linux, Bash, scripting, cron, or other orchestration/automation tools used for database maintenance and operational workflows is very nice to have
Java experience, especially with MyBatis, Spring, or similar data access frameworks, is very nice to have
Experience with reporting workloads, BI tooling, Metabase-style access patterns, PostGIS, or geospatial query performance is very nice to have
Experience with AWS monitoring and observability tools is very nice to have
Experience using AI coding agents, or willingness to use AI-assisted development tools, is very nice to have
Experience with NetSuite, Boomi, ERP/iPaaS integrations, accounting, billing, AR/AP, payments, invoices, credit memos, customer deposits, vendor payments, or working-table integration patterns is a secondary bonus

Benefits

Comp & perks

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
Flexible schedule