Oracle SQL Developer

Overview Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience Oracle SQL Developer to play a key role within a high-impact technical services team. At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including: Highly competitive pay ratesLocal support staff for responsive, personal serviceComprehensive benefits package, including:Medical insurance (with employer cost sharing)Life insuranceA 401(K) plan with company matchFlexible spending through a cafeteria plan Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks. Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Responsibilities 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 also need to exhibit a high level of skill in data aggregation and analysis. This position works for 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 Qualifications Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. Years Required/Preferred Experience 8 Required Skill in designing, coding and supporting using Oracle SQL and PL/SQL 8 Required Jasper Reports Development 8 Required Unit Testing 8 Required Agile 5 Preferred Knowledge of JIRA/Bitubucket 3 Preferred Experience with Texas Student Data System (TSDS)