Senior PostgreSQL Data Developer

Overview

JOB TITLE:

Data Developer

Cayuse Company

Cayuse Civil Services, LLC

LOCATION

Remote

Salary

$108,160.00-$147,680.00

Employee Type

Full-Time Salary Exempt

TRAVEL

No

RELOCATION

No

Employment in this role is conditional upon successful execution of the contract by the client.

The Work

he Data Developer will design, develop, and optimize database solutions in support of large-scale, high-volume enterprise applications. This role focuses on PostgreSQL development, performance tuning, and data integrity across complex data flows and mission‑critical systems. The Data Developer will collaborate closely with application, integration, and architecture teams to deliver secure, reliable, and scalable data-driven solutions in an Agile environment.

This position aligns with Cayuse’s core values of excellence, innovation, and accountability by delivering high-quality, efficient, and scalable automated testing solutions, ensuring timely and successful project execution in hybrid work environments.

Responsibilities

• 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.

Interested in remote work opportunities in Development & Programming? Discover Development & Programming Remote Jobs featuring exclusive positions from top companies that offer flexible work arrangements.

• 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 .
  
  

Qualifications

Here’s What You Need

The qualifications and skills listed below are intended to provide a general overview of the requirements for this position. However, due to the anticipated nature of the contract and the absence of a finalized task order from the client, this list should not be considered all-encompassing. Additional qualifications, certifications, skills, or experience specific to the client’s requirements may be identified and requested upon award of the task order. Candidates should demonstrate flexibility and a willingness to adapt to evolving responsibilities as outlined by the client.

• 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.
  

Desired Qualifications

• 1+ year of experience with ETL pipelines, data integration tools, and batch processing frameworks
• 1+ year of familiarity with CI/CD processes and database deployment automation

Browse our curated collection of remote jobs across all categories and industries, featuring positions from top companies worldwide.

• 1+ year of exposure to cloud platforms (e.g., AWS, Azure) and managed PostgreSQL services
• 1+ year of experience supporting government or public sector systems
  
  

Benefits

Our Commitment to you / overview of benefits

• 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
  
  

Reports to: Program Manager

Working Conditions

• Professional office environment.
• Must be physically and mentally able to perform duties extended periods of time.
• Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.
• Must be able to establish a productive and professional workspace.
• Must be able to sit for long periods of time looking at computer screen.
• May be asked to work a flexible schedule which may include holidays.
• May be asked to travel for business or professional development purposes.
• May be asked to work hours outside of normal business hours.
  
  

Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Cayuse is an Equal Opportunity Employer. All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.

Pay Range

USD $108,160.00 - USD $147,680.00 /Yr.