companyPeregrine Advisors Benefit Inc. logo

Development Database Administrator

Peregrine Advisors Benefit Inc.Remote — Washington, District of Columbia, United States
Remote Full-time

Clicking Apply Now takes you to AutoApply where you can tailor your resume and apply.


Unlock Your Potential

Generate Job-Optimized Resume

One Click And Our AI Optimizes Your Resume to Match The Job Description.

Is Your Resume Optimized For This Role?

Find Out If You're Highlighting The Right Skills And Fix What's Missing

Experience Level

Mid to Senior

Qualifications

To excel in this role, you should have a comprehensive understanding of relational database management systems (RDBMS) and cloud-based database solutions. Proficiency in SQL and experience with database tuning and optimization are essential. Familiarity with DevOps practices and CI/CD pipelines will also be highly beneficial.

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.

About Peregrine Advisors Benefit Inc.

Peregrine Advisors Benefit Inc. is a Benefit Corporation dedicated to creating measurable social impact while achieving business success. We undertake mission-driven projects that are technically challenging and offer our team members opportunities for real ownership and direct client engagement.

Similar jobs

Tailoring 0 resumes

We'll move completed jobs to Ready to Apply automatically.