Database Developer

Cayuse Holdings

Data Developer responsible for designing and optimizing PostgreSQL database solutions at Cayuse. Collaborating with teams to deliver scalable data-driven solutions in an Agile environment.

Posted 5/30/2026full-timeRemote • Texas • 🇺🇸 United StatesMid-LevelSenior💰 $108,160 - $147,680 per yearWebsite

Tech Stack

Tools & technologies

CloudPostgresSQL

About the role

Key responsibilities & impact

Design, develop, and optimize SQL queries, functions, triggers, and stored procedures in PostgreSQL for high-volume enterprise applications.
Support data modeling activities, ensuring alignment with enterprise architecture, application requirements, and scalability needs.
Collaborate with application and integration teams to support end-to-end delivery of data-driven solutions, including new features, enhancements, and defect remediation.
Participate in code reviews, design sessions, and sprint planning as part of an Agile delivery team.
Analyze complex datasets and data flows to ensure reliability, integrity, and accuracy across systems and interfaces.
Troubleshoot database issues and provide root cause analysis for performance bottlenecks, data inconsistencies, and integration failures.
Lead performance tuning initiatives, including indexing strategies, query refactoring, and database optimization techniques.
Perform execution plan analysis and recommend changes to schema, indexing, or SQL logic to improve performance and scalability.
Ensure all database objects, code, and processes adhere to agency policies, data governance standards, and applicable security/compliance requirements.
Contribute to and maintain database development standards, best practices, and documentation.
Assist in migration, upgrade, and modernization efforts involving PostgreSQL and associated data platforms (e.g., moving from legacy systems, version upgrades, refactoring for cloud).
Support processes for backup, recovery, and environment management in collaboration with infrastructure and operations teams.
Other duties as assigned.

Requirements

What you’ll need

5+ years of experience as a Database Developer or in a similar role
5+ years of strong hands-on expertise with PostgreSQL, including: SQL PL/pgSQL, Stored procedures, Triggers, Indexing, Query optimization
5+ years of experience working with large-scale, high-volume enterprise applications and mission-critical data environments
5+ years with a strong understanding of relational database design, normalization, and data modeling principles
5+ years of proficiency in performance tuning, execution plan analysis, and troubleshooting complex SQL behaviors
5+ years of experience working in Agile/Scrum teams and collaborating on multi-disciplinary project delivery
5+ years demonstrating the ability to foster effective collaboration and communication within the project team (developers, testers, stakeholders), including active participation in meetings, discussions, and code reviews
5+ years demonstrating excellent problem-solving and analytical skills
5+ years showing the ability to work in a fast-paced environment with shifting priorities and multiple concurrent projects
5+ years demonstrating the ability to work independently and as part of a team
Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.

Benefits

Comp & perks

Medical, Dental and Vision Insurance; Wellness Program
Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
Short-Term and Long-Term Disability options
Basic Life and AD&D Insurance (Company Provided)
Voluntary Life and AD&D options
401(k) Retirement Savings Plan with matching after one year
Paid Time Off

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPostgreSQLPL/pgSQLStored proceduresTriggersIndexingQuery optimizationPerformance tuningExecution plan analysisData modeling

Soft Skills

CollaborationCommunicationProblem-solvingAnalytical skillsAdaptabilityTeamworkIndependenceActive participationEffective collaborationAgile/Scrum experience