Aurora SQL Architect — Enterprise Data Platform

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

Benefits offered by this job

Health benefits

401(k) match

Unlimited PTO

Certification support

Job summary

Peregrine Advisors is seeking a senior database developer to design and maintain queries, stored procedures, and views on Amazon Aurora (PostgreSQL-compatible). You will work with DynamoDB, S3, and Apache Iceberg to turn raw data into usable assets.

This hybrid Washington, DC area role requires 4+ years of database development, strong SQL, and the drive to grow toward physical design ownership. You will join a mission-driven team delivering value for government clients.

Qualifications

• Solid SQL on a modern relational platform (Amazon Aurora, PostgreSQL-compatible).
• Experience writing stored procedures and views that scale and audit well.
• Familiarity with DynamoDB, S3, and Apache Iceberg tables is a plus.
• Experience with query tuning and data loading into data stores.

Responsibilities

• Build and maintain queries, stored procedures, and views on Amazon Aurora (PostgreSQL-compatible).
• Tune queries, load data into platform stores (S3), and manage connectivity.

Skills

SQL

Amazon Aurora

PostgreSQL-compatible

Stored procedures

Views

DynamoDB

S3

Apache Iceberg

Query tuning

Data loading

ODBC/JDBC connectivity

PowerPoint

Excel

Tools

PowerPoint

Excel

Job description

Peregrine Advisors is seeking a senior database developer to design and maintain queries, stored procedures, and views on Amazon Aurora (PostgreSQL-compatible). You will work with DynamoDB, S3, and Apache Iceberg to turn raw data into usable assets.

This hybrid Washington, DC area role requires 4+ years of database development, strong SQL, and the drive to grow toward physical design ownership. You will join a mission-driven team delivering value for government clients.