Senior PostgreSQL Database Developer (AWS)

OpenDataJobs • Washington, DC

2d • Hybrid

About The Position

Peregrine Advisors is seeking a Senior PostgreSQL Database Developer to own the database layer of a federal agency's enterprise data platform. This role involves shaping the structure and performance of a large, high-volume platform across Amazon Aurora, DynamoDB, and Apache Iceberg tables on S3. The work is described as real, hard, and important, focusing on database design, modeling, and performance tuning. This is presented as a starting point, with opportunities to grow within the firm.

Requirements

• Sole United States citizenship and the ability to obtain a Public Trust determination.
• Hybrid role based in the Washington, DC metropolitan area, requiring regular commuting into DC.
• 7+ years of database development and administration experience.
• Bachelor’s degree.
• Experience with Amazon Aurora (PostgreSQL-compatible), DynamoDB, and S3 with Apache Iceberg tables.
• Experience with physical design at scale: partitioning, indexing, and storage layout.
• Experience with query and EXPLAIN-plan tuning on large datasets.
• Experience with logical and physical data modeling.
• Experience with PL/pgSQL stored procedures and S3 load patterns into the relational and Iceberg stores.
• Basic proficiency in writing, PowerPoint, and Excel.

Nice To Haves

• Schema migration tooling (AWS Schema Conversion Tool).
• Apache Ranger access controls.
• Experience with Neptune or Neo4j.
• Federal information technology or high-volume transaction experience.
• Familiarity with AI-assisted developer tooling.

Responsibilities

• Own the database layer of a federal agency's enterprise data platform, including physical design, models, and performance.
• Shape how a large, high-volume platform is structured and tuned across Amazon Aurora, DynamoDB, and Apache Iceberg tables on S3.
• Build a database layer that performs, including physical design (partitioning, indexing, and storage layout at scale), query and plan tuning on large datasets, and data models.
• Develop the pipes and guardrails around the database layer, including schema migrations, S3 load patterns into relational and Iceberg stores, stored procedures, and Apache Ranger access controls.
• Contribute to the firm itself by developing new capabilities, tools, and lines of business.

Benefits

• Medical, dental, and vision with the employee premium fully paid and half of dependent premiums.
• Employer-paid life, accidental death, and short-term and long-term disability insurance.
• A 401(k) matched 100% up to 4% of salary, vesting immediately.
• Unlimited paid time off.
• Sponsored professional certifications and continuing education.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior