Senior Database Developer, AWS

OpenDataJobs • Washington, DC

14h • 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 highly motivated individual who thrives on owning hard problems and delivering solutions within the federal government's mission. This is an opportunity to shape a large, high-volume 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.
• Neptune or Neo4j experience.
• 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.
• Design and tune large data platforms, focusing on the physical model.
• 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 new capabilities, tools, and lines of business within the firm.

Benefits

• Medical, dental, and vision insurance with the 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