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

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

Job summary

An established industry player is seeking experienced Oracle SQL/Jasper Consultants for a remote role. This position involves advanced analysis, coding, and support using Oracle SQL and PL/SQL, alongside Jasper Reports Development. Candidates will engage in Agile methodologies while collaborating with various stakeholders to ensure effective reporting for Texas's school districts. This is an exciting opportunity for those passionate about leveraging their technical skills to make a significant impact in the education sector. Join a dynamic team and contribute to meaningful projects that enhance the educational landscape.

Qualifications

• 8+ years of experience in Oracle SQL, PL/SQL, and Jasper Reports.
• Proficient in Agile methodologies and unit testing.

Responsibilities

• Perform advanced analysis to enhance database and reports.
• Work collaboratively across multiple agency stakeholders.

Skills

Oracle SQL

PL/SQL

Jasper Reports Development

Unit Testing

Agile Methodologies

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 and may include pre-selection requirements that potential Vendors (and their Candidates) submit to and satisfy criminal background checks as authorized by Texas law. Texas Education Agency will pay no fees for interviews or discussions, which occur during the process of selecting a Candidate(s).

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 also devise approaches to solving complex problems, provide thought leadership, manage project scope, and provide ongoing updates on project status. The worker will need to exhibit a high level of skill in data aggregation and analysis. This position works for the section of 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, Work Location With-in the United States. The working position is Telework. 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.