Already filled
Don't miss the next one. Get matching roles delivered to your inbox.
RA
Rapisource LLC
SQL Database Developer 3
Job summary
Austin
Software Developer
Work model
Hybrid
4 weeks ago
Job description
Solicitation Reference Number: 302CSD2654
Direct Client: Office of the Attorney General of Texas
Working Title: Software Developer 2 - SQL Database Developer
Work Location: Austin, TX - Telework
Job Description
- 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.
Note: 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 Qualifications
Minimum Requirements
| Years | Required/Preferred | Experience |
|---|---|---|
| 5 | Required | Experience as a Database Developer or similar role. |
| 5 | Required | Strong hands-on expertise with PostgreSQL, including SQL, PL/pgSQL, stored procedures, triggers, indexing, and query optimization. |
| 5 | Required | Demonstrated experience working with large-scale, high-volume enterprise applications and mission critical data environments. |
| 5 | Required | Strong understanding of relational database design, normalization, and data modeling principles. |
| 5 | Required | Proficiency in performance tuning, execution plan analysis, and troubleshooting complex SQL behaviors. |
| 5 | Required | Experience working in Agile/Scrum teams and collaborating on multi-disciplinary project delivery. |
| 5 | Required | Foster 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. |
| 5 | Required | Excellent problem-solving and analytical skills. |
| 5 | Required | Ability to work in a fast-paced environment with shifting priorities and multiple concurrent projects. |
| 5 | Required | Ability to work independently and as part of a team. |
Preferred Qualifications
| Years | Required/Preferred | Experience |
|---|---|---|
| 1 | Preferred | Experience with ETL pipelines, data integration tools, and batch processing frameworks. |
| 1 | Preferred | Familiarity with CI/CD processes and database deployment automation. |
| 1 | Preferred | Exposure to cloud platforms (AWS, Azure, or similar) and managed PostgreSQL services. |
| 1 | Preferred | Experience supporting government or public sector systems. |