Senior DB Architect: AWS PostgreSQL, DynamoDB & Iceberg

Peregrine Advisors; Washington (District of Columbia); Hybrid; USD 150,000 - 210,000; Full time

Job summary

Peregrine Advisors seeks a seasoned Database Engineer to own the database layer of a federal agency's enterprise data platform. You will design physical models for Amazon Aurora (PostgreSQL-compatible), DynamoDB, and Iceberg on S3, optimize performance, and ensure auditability in a regulated environment.

You will implement schema migrations, loading patterns, and access controls, while shaping scalable data architectures and governance practices.

Qualifications

• Deep ownership of a database layer across multiple platforms.
• Experience tuning large data platforms for performance and auditability.

Responsibilities

• Own physical design, partitioning, indexing, and storage layout at scale.
• Tune queries and plans for large datasets.
• Implement schema migrations and access controls (Apache Ranger).
• Collaborate to shape new capabilities and data tools.

Skills

Database design

Query tuning

Data modeling

AWS

PostgreSQL

Tools

Amazon Aurora PostgreSQL-compatible

DynamoDB

Apache Iceberg

S3

Job description

Peregrine Advisors seeks a seasoned Database Engineer to own the database layer of a federal agency's enterprise data platform. You will design physical models for Amazon Aurora (PostgreSQL-compatible), DynamoDB, and Iceberg on S3, optimize performance, and ensure auditability in a regulated environment.

You will implement schema migrations, loading patterns, and access controls, while shaping scalable data architectures and governance practices.