PostgreSQL Database Developer

PostgreSQL Database DeveloperThis is 100% remote.LinkedIn and resume must match.LONG TERM DURATIONState government experience is preferred, not required12 years overall and 5 years in most skills. Refer to the attachment for the skills matrix that shows you what they are looking for.Austin, TX 78741. The working position is Telework.The Office of the Attorney General of Texas is seeking an experienced and highly motivated PostgreSQL Database Developer to support mission-critical enterprise applications and large-scale data environments. This opportunity is ideal for a hands-on database professional with deep expertise in PostgreSQL development, performance optimization, and enterprise data architecture.The selected consultant will play a key role in designing, developing, and optimizing complex database solutions that support high-volume applications across the agency. Candidates should possess strong technical skills, excellent analytical abilities, and the capability to thrive in a fast-paced Agile environment.Key ResponsibilitiesDesign, develop, and optimize PostgreSQL database components including SQL queries, PL/pgSQL functions, triggers, stored procedures, and indexing strategies.Collaborate with application development, integration, and business teams to deliver scalable, data-driven enterprise solutions.Analyze complex datasets and data flows to ensure system reliability, integrity, accuracy, and performance.Lead database performance tuning efforts through query optimization, execution plan analysis, indexing improvements, and database refactoring.Support logical and physical data modeling initiatives aligned with enterprise architecture standards and scalability requirements.Troubleshoot database-related issues and provide detailed root cause analysis for bottlenecks and data inconsistencies.Participate actively in Agile/Scrum ceremonies including sprint planning, code reviews, technical discussions, and solution design sessions.Ensure compliance with agency security standards, governance policies, and database best practices.Support modernization, migration, and upgrade initiatives involving PostgreSQL and related technologies.Required Qualifications5+ years of experience as a Database Developer or similar role.Strong hands-on expertise with PostgreSQL including SQL, PL/pgSQL, stored procedures, triggers, indexing, and query optimization.Experience supporting large-scale, high-volume enterprise applications and mission-critical systems.Strong understanding of relational database concepts, normalization, and data modeling principles.Expertise in performance tuning, execution plan analysis, and troubleshooting complex SQL/database behaviors.Experience working within Agile/Scrum delivery environments.Strong collaboration, communication, analytical, and problem-solving skills.Ability to manage multiple priorities and work effectively both independently and within cross-functional teams.Preferred QualificationsExperience with ETL pipelines, data integration tools, and batch processing frameworks.Familiarity with CI/CD processes and database deployment automation.Exposure to cloud platforms such as AWS or Azure and managed PostgreSQL services.Prior experience supporting government or public sector environments is a plus.Additional InformationAll deliverables and work products produced under this engagement shall be considered “work made for hire” and remain the property of the Office of the Attorney General of Texas.Candidates may be subject to criminal background checks in accordance with Texas state requirements.No interview or candidate selection-related expenses will be reimbursed by the client.We are looking for candidates who can bring strong technical expertise, ownership, and collaboration skills to support critical state initiatives. Qualified professionals with strong PostgreSQL development experience are encouraged to apply.