Job Description
Role PostgreSQL Database Developer Location Austin, TX 78741. The working position is Telework.This is 100% remote. 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 Responsibilities • Design, 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 Qualifications • 5+ 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 Qualifications • Experience 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 Information • All 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. Thanks& Regards, K Hemanth Kumar | Sr IT Technical Recruiter | Kairos Technologies Inc M 972.853.5149 | O 214.389.5616 Ext 301 | E [email protected] Pay $50.00 - $60.00 per hour Work Location Remote Apply To this Job