ABC Legal Services
ABC Legal Services
ABC Legal Services oferă servicii de comunicare a actelor de procedură și de livrare a documentelor juridice pentru firme de avocatură, entități guvernamentale și persoane fizice. Rețeaua sa de agenți profesioniști pentru comunicarea actelor de procedură asigură acoperire în toate cele 50 de state ale SUA și în numeroase țări, iar tehnologia îi ajută pe clienți să monitorizeze sarcinile prin dovezi de comunicare urmărite prin GPS și actualizări în timp real ale stadiului. Compania oferă, de asemenea, suport pentru depunerea electronică și soluții pentru organizații care gestionează fluxuri de lucru cu volume mari de documente juridice.

Senior Database Engineer, PostgreSQL and AWS Aurora

Lead database reliability and performance for ABC Legal’s high-volume legal-services platform. Apply deep PostgreSQL and AWS Aurora expertise across query tuning, operational workflows, and production data systems.

Descriere

  • Own PostgreSQL and AWS Aurora expertise for Skye’s operational database
  • Manage and optimize a large relational schema spanning hundreds of tables, high-volume operational data, and extensive historical records
  • Review database changes for correctness, performance, safety, indexing, grants, triggers, foreign keys, and migration quality
  • Investigate and resolve production database problems such as slow queries, lock contention, blocking transactions, runaway queries, replication lag, and performance regressions
  • Optimize queries and indexes for large tables, reporting workloads, assignment and routing processes, mobile API payloads, and internal operational dashboards
  • Automate recurring database maintenance and operational work, including repacking, cleanup, monitoring checks, and scheduled reports
  • Partner with Infrastructure on database refreshes, backups, restores, staging, and release processes
  • Work with Infrastructure, Software Development, and Data Science teams on reliability, performance, reporting, analytics, and operational data requirements
  • Maintain secure access patterns for reporting users, Metabase, developers, and tables containing sensitive or personally identifiable information
  • Support accounting data flows involving invoices, payments, billing accounts, vendor and payee records, and ERP integration tables

Cerințe

  • At least five years of experience with production relational databases; eight or more years is advantageous
  • Strong production experience with PostgreSQL, preferably including AWS Aurora PostgreSQL
  • Advanced SQL proficiency covering joins, CTEs, query plans, indexes, constraints, triggers, transactions, and lock behavior
  • Experience diagnosing high-volume databases with large tables, long-lived schemas, and real production workloads
  • Ability to separate inherent query cost from lock contention, blocking, poor execution plans, missing indexes, and excessive application call volume
  • Meticulous approach to reviewing schema migrations and operational database changes
  • Experience partnering with application engineers on database-backed application design and performance
  • Sound judgment regarding access control, personally identifiable information, production safety, and release risk
  • Clear written communication when documenting findings, tradeoffs, and recommended fixes
  • Bachelor’s degree in engineering or a software-related field preferred
  • Master’s degree is advantageous
  • Experience with Linux, Bash, scripting, cron, or other orchestration and automation tools for database maintenance and operational workflows is highly desirable
  • Java experience, particularly with MyBatis, Spring, or comparable data-access frameworks, is highly desirable
  • Experience with reporting workloads, BI tools, Metabase-style access patterns, PostGIS, or geospatial query performance is highly desirable
  • Experience with AWS monitoring tools, CloudWatch, RDS or Aurora Performance Insights, pg_stat_statements, pgAdmin, or comparable observability tools is highly desirable
  • Experience using AI coding agents such as Codex or Claude, or willingness to use AI-assisted development tools in daily engineering work, is highly desirable
  • Experience with NetSuite, Boomi, ERP or iPaaS integrations, accounting, billing, accounts receivable or payable, payments, invoices, credit memos, customer deposits, vendor payments, or working-table integration patterns is a secondary bonus

Beneficii

  • Health, dental, and vision insurance
  • 401(k) with company matching
  • Paid time off
  • Seven paid company holidays
  • Four floating holidays per year
  • Life insurance and AD&D insurance
  • Long-term disability coverage
  • Health care reimbursement flexible spending account
  • Dependent care flexible spending account
  • Employee Assistance Program
  • Pet insurance
  • Flexible schedule

Locuri de muncă similare

Staffing For Doctors

Bilingual Employment Law Intake Specialist

Staffing For Doctors

Handle employment law inquiries for a remote legal practice, screening prospective clients and arranging consultations. Support English- and Spanish-speaking workers and route qualified matters to legal counsel.

Deschide
Staffing For Doctors

Bilingual Medical Caller, Primary Care (Remote)

Staffing For Doctors

Contact patients in English and Spanish to schedule primary care visits and encourage follow-up at a multi-specialty community health center. Handle outbound calls, appointment coordination, and electronic health record updates remotely.

Deschide
Eventogy

Product Engineer (Frontend and Full Stack)

Eventogy

Build Eventogy’s event management platform across Next.js, React, TypeScript and Laravel, from admin tools and attendee sites to APIs. Develop AI-assisted features for enterprise clients in regulated industries.

Deschide
Valneva

Senior Business Operations Manager, Vaccine Logistics

Valneva

Lead Valneva’s U.S. vaccine logistics and business operations, spanning distribution, pricing, contracting, and regulatory compliance. Coordinate teams and partners to maintain reliable supply, improve efficiency, and support the vaccine portfolio.

Deschide