Senior Database Developer, AWS

OpenDataJobs • Washington, DC

1d • 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 across Amazon Aurora, DynamoDB, and Apache Iceberg tables on S3. The position is for a data and technology innovation hub and a Benefit Corporation working within the federal government. The work is described as real, hard, and important, with opportunities to shape the platform and contribute to the firm's growth.

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 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, and storage layout at scale), query and plan tuning on large datasets, and data models.
• Build the infrastructure 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's growth 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