Senior Database Developer (PostgreSQL, AWS)

OpenDataJobs • Washington, DC

2d • Hybrid

About The Position

Peregrine Advisors is seeking a Senior Database Developer to own the database layer of a federal agency's enterprise data platform. This role involves the physical design, data models, and performance tuning of a large, high-volume platform across Amazon Aurora, DynamoDB, and Apache Iceberg tables on S3. The work is impactful, challenging, and offers the opportunity to grow within the firm by tackling complex problems and contributing to new capabilities.

Requirements

• U.S. citizenship and ability to obtain a Public Trust determination.
• Hybrid role requiring regular commuting into Washington, 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 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

• Design and tune a database layer that performs, including physical design (partitioning, indexing, storage layout at scale), query and plan tuning on large datasets, and robust data models.
• Implement the infrastructure around the database layer, such as schema migrations, S3 load patterns into relational and Iceberg stores, stored procedures, and Apache Ranger access controls.
• Contribute to the firm's growth by developing new capabilities, tools, and lines of business.

Benefits

• Medical, dental, and vision insurance with employee premium fully paid and half of dependent premiums.
• Employer-paid life, accidental death, and short-term and long-term disability insurance.
• 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