Senior Database Architect: AWS PostgreSQL & Iceberg

Peregrine Advisors; Washington; Hybrid; USD 140,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, and vision covered

Employer-paid life and disability

401(k) with company match

Unlimited paid time off

Sponsored professional certifications

Job summary

Peregrine Advisors seeks a database-focused engineer to own the database layer of a federal agency data platform. You will design physical models, optimize performance, and ensure scalable data governance across Aurora, DynamoDB, and Iceberg tables on S3.

You will implement migrations, S3 loading patterns, and access controls in a regulated setting, maintaining auditability and reliability for analysts and systems.

Qualifications

• 7+ years of database development and administration experience
• Bachelor’s degree
• Experience with Amazon Aurora (PostgreSQL-compatible), DynamoDB, and S3 with Apache Iceberg
• Physical design at scale: partitioning, indexing, and storage layout
• Query tuning and EXPLAIN-plan optimization on large datasets
• Logical and physical data modeling
• PL/pgSQL and S3 load patterns into relational and Iceberg stores
• Basic proficiency in writing, PowerPoint, and Excel

Responsibilities

• Own the database layer design, modeling, and performance tuning
• Implement schema migrations, S3 load patterns, and access controls
• Build scalable, auditable, and regulated data platforms

Skills

Database ownership

Aurora/DynamoDB/S3

Physical design

Query tuning

Data modeling

PL/pgSQL

Stored procedures

S3 data loading patterns

Governed access controls

Excel/PowerPoint

Education

Bachelor’s degree

Tools

AWS Schema Conversion Tool

Apache Ranger

Iceberg on S3

Neptune/Neo4j (preferred)

Job description

Peregrine Advisors seeks a database-focused engineer to own the database layer of a federal agency data platform. You will design physical models, optimize performance, and ensure scalable data governance across Aurora, DynamoDB, and Iceberg tables on S3.

You will implement migrations, S3 loading patterns, and access controls in a regulated setting, maintaining auditability and reliability for analysts and systems.