Database Engineer, Postgre SQL/AWS Aurora

ABC Legal is looking for a detail-oriented Database Engineer to help own, improve, and scale the PostgreSQL database layer behind Skye, our core legal-services platform. Skye supports high-volume process serving, court filing, operational workflows, customer facing applications, mobile field work, integrations, reporting, billing, and automation. Its primary operational database is PostgreSQL across all environments, with AWS Aurora reader/writer topology in production and major staging environments. This role is ideal for someone who enjoys deep database work: understanding complex schemas, reviewing migrations, tuning high-volume queries, diagnosing production issues, improving operational safety, and helping application engineers make better data-access decisions. Accounting, ERP, or NetSuite/Boomi experience is helpful because some important data flows touch billing and payments, but this is fundamentally a PostgreSQL/Aurora database engineering role. What You’ll Do:

• Serve as a PostgreSQL and AWS Aurora subject-matter expert for our internal system 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, such as repacking, cleanup, monitoring checks, and recurring reports.

• Support database refresh, backup, restore, staging, and release workflows in partnership with Infrastructure.

• Collaborate closely 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 when needed, including invoices, payments, billing accounts, vendor/payee data, and ERP integration tables., Lead global commercial and operational initiatives to accelerate Private AI adoption. Establish governance and operating rhythms, run monthly business reviews, prioritize accounts and use cases, define strategic metrics, align ecosystem and commercial strategies, and build business cases and growth models to guide executive decision-making., Artificial Intelligence * Enterprise Web * Information Technology * Productivity * Sales * Software * Database Own full-cycle recruiting for mid- and senior-level G&A, Sales, and Marketing roles. Develop sourcing strategies, conduct structured interviews, lead calibrated debriefs, manage candidate pipelines, and advise hiring managers. Track funnel metrics, maintain Greenhouse data, influence stakeholders, coordinate offers with Finance, HR, and Compensation, and improve recruiting workflows through AI and automation. Top Skills: AIAutomationGemGreenhouse PNC Bank

• 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.

Very Nice to Have:

• Experience with Linux, Bash, scripting, cron, or other orchestration/automation tools used for database maintenance and operational workflows.

• Java experience, especially in applications using MyBatis, Spring, or similar data access frameworks.

• Experience with reporting workloads, BI tooling, Metabase-style access patterns, PostGIS, or geospatial query performance.

• Experience with AWS monitoring tools, CloudWatch, RDS/Aurora Performance Insights, pg_stat_statements, pgAdmin, or similar observability tools.

• 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.

• Secondary bonus: experience with NetSuite, Boomi, ERP / iPaaS integrations, accounting, billing, AR/AP, payments, invoices, credit memos, customer deposits, vendor payments, or working-table integration patterns.

Own and scale the PostgreSQL and AWS Aurora database layer for a high-volume legal-services platform. Responsibilities include schema and migration review, query and index tuning, production issue diagnosis, lock and replication troubleshooting, database maintenance automation, backup and restore support, access control, and collaboration with infrastructure, software development, and data science teams. The role also supports reporting, billing, PII-sensitive data, and ERP-related data flows. The summary above was generated by AI

About ABC Legal Services: ABC Legal Service is proud to be the national leader in service of process. We are a team of 1000 and growing with offices in Los Angeles, Oklahoma City, Phoenix, Brooklyn, Chicago, Washington DC, and more. Seattle is our home and headquarters. We’ve been successful in this unique business for over 30 years and we continue to advance our technology and business processes to remain years ahead of what our competition is able to offer. Our focus is to expand our technology lead, acquire and integrate less efficient competitors, and tap into new segments through an integrated inbound marketing and sales approach., We know that a company’s success starts with its employees. We also know that an individual’s success starts with the right career opportunity. Join our team today!

• 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

Schedule: Full-Time Monday through Friday. Flexible schedule Salary Range: $140,000-$150,000 depending on experience, 86K-173K Annually Senior level 86K-173K Annually Senior level Machine Learning * Payments * Security * Software * Financial Services Lead the design and development of ETL solutions for regulatory risk compliance at PNC, requiring advanced programming skills and collaboration on data-intensive applications. Top Skills: AlteryxCa7 Job SchedulerDevops ToolsInformatica Powercenter 9.6Microsoft Power BiOracle SqlPl/SqlTableauTeradataUnix Shell Scripting

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute