Open Data is hiring a Development DBA

Peregrine Advisors Benefit Inc. is seeking a Development DBA to support data engineering and application database needs across client engagements. The role centers on designing, optimizing, and maintaining relational and cloud-based database systems that underpin production applications and analytical workflows, with an emphasis on performance, reliability, and developer enablement. Why Peregrine Peregrine is a Benefit corporation, legally committed to creating measurable social value alongside business performance. We offer mission-driven, technically challenging work on complex initiatives, paired with direct client access, real ownership of your work product, and a culture that rewards initiative. Who You Are You are a pragmatic, detail-oriented database professional who thrives at the intersection of application development and data infrastructure. You understand that a poorly tuned query or an ill-designed schema can undermine even the best application code, and you take pride in making sure that never happens. You collaborate naturally with software engineers, data engineers, and architects, speaking their language while holding the line on database best practices. You take ownership without being asked and care deeply about correctness, performance, and the long-term maintainability of the systems you build. Responsibilities Database Design & Development Design and implement logical and physical data models for new application features, ensuring normalization, referential integrity, and scalability Author and review stored procedures, functions, views, triggers, and complex SQL queries across relational database platforms (SQL Server, PostgreSQL, or equivalent) Collaborate with software engineers during the full development lifecycle to ensure database designs align with application requirements and performance targets Define and enforce database coding standards, naming conventions, and schema change management practices across development teams Build and maintain schema migration scripts and manage versioned deployments through CI/CD pipelines Performance & Optimization Profile and tune slow queries, identify missing indexes, and resolve locking and blocking issues in development and production environments Conduct execution plan analysis and implement query rewrites, index strategies, and statistics management to meet SLA requirements Establish performance baselines and monitor database health metrics; proactively identify and resolve bottlenecks before they impact users Cloud & DevOps Integration Support cloud-hosted database environments (Azure SQL, AWS RDS/Aurora, or equivalent); assist in migrations from on-premises to cloud platforms Integrate database change management into CI/CD workflows using tools such as Flyway, Liquibase, or equivalent migration frameworks Participate in infrastructure-as-code efforts, contributing database configuration and provisioning scripts using Terraform, Bicep, or CloudFormation Collaboration & Firm Development Partner with DBAs, data engineers, and solution architects to align database design with broader data platform and enterprise architecture strategies Contribute to internal tooling, knowledge base articles, or mentorship to strengthen Peregrine’s data engineering capabilities and bench depth