Oracle SQL/Jasper Consultant for Texas Education Agency, Austin, Tx

Pedigo Staffing Services; Austin (TX); Remote; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled Oracle SQL/Jasper Consultant to join their dynamic team. In this remote position, you will leverage your extensive experience in SQL and PL/SQL to design and support database solutions, develop Jasper Reports, and engage in unit testing. You will play a crucial role in enhancing data systems for Texas's educational institutions, working collaboratively with various stakeholders. This position offers the opportunity to make a significant impact while working within a structured Agile environment. If you are passionate about database development and eager to contribute to educational advancements, this role is perfect for you.

Qualifications

• 8+ years experience in Oracle SQL and PL/SQL required.
• Strong skills in Jasper Reports and Agile methodologies.

Responsibilities

• Perform advanced analysis and support for database and reports.
• Collaborate with agency stakeholders to ensure report accuracy.

Skills

Oracle SQL

PL/SQL

Jasper Reports Development

Unit Testing

Agile

JIRA

Bitbucket

Job description

Title: Oracle SQL/Jasper Consultant
Agency: Texas Education Agency
Solicitation: 70125043and4
Location: William B. Travis State Building, 1701 North Congress Avenue, Austin, Texas 7870
Duration: On-going, no ending date
Visa: Must be US Citizen, Green Card, EAD. No H1B
Telework Policy: The primary work location(s) will be at 100% Remote

REQUIRED/PREFERRED SKILLS:

• 8 years, Required - Skill in designing, coding and supporting using Oracle SQL and PL/SQL
• 8 years, Required - Jasper Reports Development
• 8 years, Required - Unit Testing
• 8 years, Required - Agile
• 5 years, Preferred - Knowledge of JIRA/Bitbucket

JOB DETAILS:
Texas Education Agency requires the services of 2 Developer/Programmer Analyst 3, hereafter referred to as Candidate(s), who meets the general qualifications of Developer/Programmer Analyst 3, Applications/Software Development and the specifications outlined in this document for the Texas Education Agency.

All work products resulting from the project shall be considered "works made for hire" and are the property of the Texas Education Agency. Potential Vendors (and their Candidates) must submit to and satisfy criminal background checks as authorized by Texas law. Texas Education Agency will pay no fees for interviews or discussions during the selection process.

This senior role performs advanced analysis involving all aspects of supporting, improving, and enhancing the database and reports for a large project. This position requires strong SQL, PL/SQL, and Stored Procedure skills. The worker will devise approaches to solving complex problems, provide thought leadership, manage project scope, and provide ongoing updates on project status. A high level of skill in data aggregation and analysis is also required. This position works for the IT-SEDS (Information Technology – Statewide Education Data System). Work assignments follow a defined software development life cycle (SDLC) process using an Agile-like approach for completing code changes for defined releases. This role works across multiple agency stakeholders to ensure the accuracy and efficacy of created reports, in the service of Texas’s 1200 school districts.

• Database and Jasper Reports Development
• Documentation
• Bugs: Core and PEIMS projects
• Dev/Unit Testing
• Participate in Agile development

Services are expected to start 04/16/2025 and are expected to complete by 08/31/2025. Total estimated hours per Candidate shall not exceed 872 hours. This service may be amended, renewed, and/or extended providing both parties agree to do so in writing.

Services shall be provided during normal business hours unless otherwise coordinated through the Texas Education Agency. Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM, excluding State holidays when the agency is closed.

The primary work location(s) will be at 100% Remote. Any and all travel, per diem, parking, and/or living expenses shall be at the Candidate's and/or Vendor's expense. Texas Education Agency will provide pre-approved, written authorization for travel for any services to be performed away from the primary work location(s). Pre-approved travel expenses are limited to the rates and comply with the rules prescribed by the State of Texas for travel by its classified employees, including any requirement for original receipts.

The Candidate(s) may be required to work outside the normal business hours on weekends, evenings, and holidays, as requested. Payment for work over 40 hours will be at the hourly rate quoted and must be coordinated and pre-approved through Texas Education Agency.