Senior Database Engineer, Postgre SQL/AWS Aurora

Job not on LinkedIn

🔥 4 hours ago

🇺🇸 United States – Remote

💵 $140k - $150k / year

⏰ Full Time

🟠 Senior

☁️ Cloud Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

ABC Legal Services

WebsiteLinkedInAll Job Openings

201 - 500 employees

⚖️ Legal

🤝 B2B

📋 Compliance

Legal • B2B • Compliance

ABC Legal Services is a leading provider of service of process solutions in the United States. The company offers reliable and transparent legal document delivery across all 50 states and numerous countries, utilizing a vast network of professional process servers. With a focus on technology and efficiency, ABC Legal uses a mobile app to provide GPS-tracked evidence and real-time updates for every process serve. The firm is recognized for its comprehensive services, making it the trusted choice for law firms, government entities, and individuals seeking legal document services. ABC Legal also offers support in eFiling and various enterprise solutions.

📋 Description

• 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

• 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

• 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