Cayuse Holdings provides a variety of IT services to clients across various industries, including government, commercial, and tribal sectors. Built on a foundat
Database Developer
Location
Texas
Posted
5 days ago
Salary
$108.2K - $147.7K / year
Seniority
Senior
Job Description
Database Developer
Cayuse Holdings
• 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.
Job Requirements
- 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
- 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
Related Guides
Related Job Pages
More Backend Engineer Jobs
Role Description Atuação no desenvolvimento de soluções back-end utilizando Node.js, voltadas à automação, integração com agentes de IA e evolução de servidores MCPs, garantindo escalabilidade, alta performance e integração com ecossistemas internos e parceiros. - Desenvolver e manter serviços back-end em Node.js (APIs e microsserviços) - Construir integrações com agentes de IA, LLMs e plataformas externas - Evoluir arquiteturas de automação e servidores MCPs - Garantir qualidade, performance, segurança e escalabilidade das aplicações - Atuar com boas práticas de engenharia de software (Clean Code, testes automatizados, observabilidade e documentação) - Desenvolver e otimizar integrações utilizando APIs REST, mensageria e eventos assíncronos - Apoiar decisões técnicas relacionadas à arquitetura e evolução dos sistemas Qualifications - Experiência sólida com Node.js e frameworks como NestJS, Express.js ou similares - Vivência com desenvolvimento de APIs REST e arquitetura de microsserviços - Experiência com integrações (APIs, mensageria, filas e eventos assíncronos) - Conhecimento em bancos de dados SQL e NoSQL - Experiência com ambientes cloud (AWS, Azure ou GCP) - Conhecimento em Docker, versionamento com Git e práticas de CI/CD - Experiência com monitoramento, observabilidade e troubleshooting em ambientes distribuídos Requirements - Experiência com IA Generativa, LLMs ou agentes inteligentes - Conhecimento em MCPs (Model Context Protocol) ou plataformas similares - Experiência com Docker/Kubernetes - Conhecimento em arquiteturas orientadas a eventos (Kafka, RabbitMQ, SQS ou similares) - Vivência em ambientes de alta disponibilidade e aplicações escaláveis Benefits - Oportunidades 100% remotas 👨🏻💻 - Vale home office 💻 - Feedbacks periódicos 💬 - Programa de indicações 🏅 - Acolhimento psicológico 🙋🏻♂️ - Ginástica laboral 🏋️ - Academia de conhecimento 🧠 - Convênio com escola de inglês 🔤 - Reuniões mensais de transparência 🔃 - Happy hour online 🍻 - Kit de boas-vindas 🎁
.NET Developer
DistroDistro is a marketplace to find, hire, and pay technical talent in over 200 countries. Join now for free.
• Collaborate with engineers, product owners, and stakeholders to design end-to-end solutions using ASP.NET Core, React, and Azure. • Translate user requirements into scalable solutions, following Agile/SCRUM and the full SDLC. • Build rich client-side experiences with React (Hooks, Redux/Context API, TypeScript). • Develop RESTful and GraphQL APIs with C#, ASP.NET Core Web API, and EF Core. • Implement cloud-native solutions on Azure (App Service, Functions, SQL Database, Blob Storage, Key Vault, DevOps pipelines). • Design and optimize SQL Server databases (SQL Server 2019/2022, Azure SQL). • Write unit/integration tests (xUnit, NUnit, Jest) and automate releases via Azure DevOps/GitHub Actions. • Participate in code reviews, pair programming, and technical design discussions. • Continuously update knowledge on .NET, React, Azure, and best practices.
• Design and implement multi-file coding tasks across bug fixing, feature development, refactoring, and testing • Write clear natural-language specifications and reference implementations • Develop and extend unit and integration test suites • Review peer-generated tasks for correctness, clarity, and realism • Identify edge cases, ambiguities, and potential failure modes • Ensure alignment between specifications, code, and expected outputs
• Design and implement multi-file coding tasks across bug fixing, feature development, refactoring, and testing • Write clear natural-language specifications and reference implementations • Develop and extend unit and integration test suites • Review peer-generated tasks for correctness, clarity, and realism • Identify edge cases, ambiguities, and potential failure modes • Ensure alignment between specifications, code, and expected outputs
