About the job
Peregrine Advisors Benefit Inc. is on the lookout for a skilled Development Database Administrator (DBA) to enhance data engineering and application database capabilities across our client engagements. This pivotal role involves designing, optimizing, and maintaining relational and cloud-based database systems that serve as the backbone of production applications and analytical workflows. You will focus on performance, reliability, and empowering developers.
Why Join Peregrine?
As a Benefit Corporation, Peregrine is legally committed to generating measurable social value alongside our business objectives. We provide mission-driven, technically engaging work on complex projects, direct access to clients, true ownership of your work, and a culture that values initiative and innovation.
Your Profile
You are a pragmatic and detail-oriented database expert who thrives at the intersection of application development and data infrastructure. Understanding that a poorly optimized query or a badly designed schema can compromise even the best application code, you take pride in ensuring that this never occurs. You naturally collaborate with software engineers, data engineers, and architects, effectively communicating while upholding database best practices. You take initiative and are deeply committed to the accuracy, performance, and long-term maintainability of the systems you build.
Key Responsibilities
Database Design & Development
- Craft and implement logical and physical data models for new application features, ensuring normalization, referential integrity, and scalability.
- Create and review stored procedures, functions, views, triggers, and complex SQL queries across relational database platforms such as SQL Server, PostgreSQL, or equivalent.
- Work closely with software engineers throughout the entire development lifecycle to ensure database designs meet application requirements and performance objectives.
- Establish and enforce database coding standards, naming conventions, and schema change management practices across development teams.
- Develop and maintain schema migration scripts and manage versioned deployments via CI/CD pipelines.
Performance & Optimization
- Analyze and tune slow queries, identify missing indexes, and address locking and blocking challenges in both development and production settings.
- Conduct execution plan analysis and implement query rewrites, indexing strategies, and statistics management to meet Service Level Agreement (SLA) standards.
- Establish performance baselines and monitor database health metrics, proactively identifying and resolving bottlenecks before they affect users.
Cloud & DevOps Integration
- Manage cloud-hosted database environments (such as Azure SQL, AWS RDS/Aurora, or similar); assist in migrations from on-premises to cloud platforms.
- Integrate database change management into CI/CD processes to enhance efficiency and reliability.

