Senior Database Engineer, PostgreSQL/AWS Aurora

ABC Legal Services

. Serve as a PostgreSQL and AWS Aurora subject-matter expert for Skye’s operational database .

Posted 10/7/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 collaborating with cross-functional teams to address database needs and maintain data integrity.

Highest-signal resume keywords

PostgreSQL ExpertiseAWS Aurora ExperienceStrong SQL SkillsDatabase Performance OptimizationCollaboration with Application Engineers

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 AnalysisIndexing and ConstraintsLock Contention AnalysisAutomation ScriptingData Access FrameworksGeospatial Query PerformanceBI Tooling ExperienceAI-Assisted Development Tools

Soft Skills

Attention to DetailClear Written CommunicationGood Judgment

Tools & Technologies

LinuxBashCloudWatchPgAdminMetabaseRDS/Aurora Performance InsightsCronMyBatisSpringAI Coding Agents

Certifications & Qualifications

Bachelor's Degree in Engineering or Software FieldMaster's Degree

Industry Keywords

Operational DatabaseHigh-Volume DataData IntegrityERP IntegrationAccounting Data FlowsPayments and InvoicesVendor PaymentsData Access PatternsProduction SafetyRelease Risk

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 in partnership with Infrastructure
Collaborate 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, 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 (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
Experience with Linux, Bash, scripting, cron, or other orchestration/automation tools used for database maintenance and operational workflows (very nice to have)
Java experience, especially in applications using MyBatis, Spring, or similar data access frameworks (very nice to have)
Experience with reporting workloads, BI tooling, Metabase-style access patterns, PostGIS, or geospatial query performance (very nice to have)
Experience with AWS monitoring tools, CloudWatch, RDS/Aurora Performance Insights, pg_stat_statements, pgAdmin, or similar observability tools (very nice to have)
Experience using AI coding agents such as Codex, Claude, or similar tools; at minimum, willingness to use AI-assisted development tools as part of day-to-day engineering work (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 (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