SQL Database Developer 3

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Rapisource LLC, is seeking the following. Apply via Dice today!Solicitation Reference Number: 302CSD2654Direct Client: Office of the Attorney General of TexasWorking Title: Software Developer 2 - SQL Database Developer Work Location: Austin, TX - TeleworkJD: Design, develop, and optimize SQL queries, functions, triggers, and stored procedures in PostgreSQL for high‑volume enterprise applications.Collaborate with application and integration teams to support end‑to‑end delivery of data‑driven solutions.Analyze complex datasets and data flows to ensure reliability, integrity, and accuracy across systems.Lead performance tuning initiatives, including indexing strategies, query refactoring, and database optimization techniques.Support data modeling activities, ensuring alignment with enterprise architecture and application scalability needs.Troubleshoot database issues and provide root‑cause analysis for performance bottlenecks and data inconsistencies.Participate in code reviews, design sessions, and sprint planning as part of an Agile delivery team.Ensure all database objects and processes adhere to agency policies, data governance standards, and compliance requirements.Assist in migration, upgrade, and modernization efforts involving PostgreSQL and associated data platforms.The above job description and requirements are general and may change based on the specific needs and requirements of the organization and project.CANDIDATE SKILLS AND QUALIFICATIONSMinimum Requirements:Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.YearsRequired/PreferredExperience5RequiredExperience as a Database Developer or similar role.5RequiredStrong hands-on expertise with PostgreSQL, including SQL, PL/pgSQL, stored procedures, triggers, indexing, and query optimization.5RequiredDemonstrated experience working with large-scale, high-volume enterprise applications and mission critical data environments.5RequiredStrong understanding of relational database design, normalization, and data modeling principles.5RequiredProficiency in performance tuning, execution plan analysis, and troubleshooting complex SQL behaviors.5RequiredExperience working in Agile/Scrum teams and collaborating on multi-disciplinary project delivery.5RequiredFoster effective collaboration and communication within the project team, including developers, testers, and stakeholders. Actively participate in meetings, discussions, and code reviews to ensure alignment and efficient workflow.5RequiredExcellent problem-solving and analytical skills.5RequiredAbility to work in a fast-paced environment with shifting priorities and multiple concurrent projects.5RequiredAbility to work independently and as part of a team.1PreferredExperience with ETL pipelines, data integration tools, and batch processing frameworks.1PreferredFamiliarity with CI/CD processes and database deployment automation.1PreferredExposure to cloud platforms (AWS, Azure, or similar) and managed PostgreSQL services.1PreferredExperience supporting government or public sector systems.