Role OverviewAs a Database Developer (SQL) at Peregrine Advisors, you will design and build the data layer for a federal enterprise platform. You will take responsibility for the accuracy and performance of your assigned components, including designing database schemas, writing SQL queries, and building data pipelines.
What You Will Do
Your day-to-day responsibilities will include designing database schemas, writing SQL queries, building and maintaining data pipelines, and making queries and databases fast enough for high-volume workloads.
Why It Might Be a Fit
We are looking for someone who enjoys building with SQL, takes responsibility for getting data right, and can take a database problem from design through delivery and stand behind how their work performs.
Requirements
- 4+ years of database development experience
- Bachelor's degree
- Working expertise in Amazon Aurora (PostgreSQL-compatible)
- Experience with Amazon DynamoDB
- SQL skills across complex queries, views, stored procedures, and functions
- Performance and query tuning
- ETL and ELT development
- Experience working within data security controls
- Experience loading data from S3 into the platform stores and connecting through ODBC and JDBC
Benefits
- Medical, dental, and vision insurance with the employee premium fully paid
- 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
]]>