W2 only---SQL Database developer ---Remote
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