Software Developer 2

Job Title - Software Developer 2
Duration - Full Time/Long Term
Work Location- Remote (Within United States)

Position Summary:
We are Seeking a dedicated Senior Database Developer will be responsible for optimizing and enhancing database performance within the Statewide Education Data System (SEDS). This role requires expertise in Oracle SQL and PL/SQL, including advanced concepts like bulk collect, ref cursors, table functions, and handling JSON/XML data within CLOBs. The developer must have extensive experience in performance tuning of stored procedures, materialized views, and complex queries to minimize SGA/PGA/TempSpace usage. Proficiency in indexing strategies, partitioning, and parallel execution is crucial. Working within an Agile SDLC framework, the developer will collaborate with stakeholders to ensure accurate ETL processes, efficient data transformations, and optimized reporting for Texas’s 1200 school districts. Strong documentation, unit testing, and debugging skills using tools like SQL Trace, TKPROF, and AWR/ASH reports are essential.

PRINCIPAL DUTIES AND RESPONSIBILITIES (May perform any or all of the following):

• Expertise working with Oracle SQL and PL/SQL (advanced concepts such as bulk collect, handling data in JSON/XML format
• Expertise with writing complex Oracle queries and optimizing them to reduce SGA/PGA/TempSpace usage
• Proficient in storing, querying, manipulating JSON data in Oracle database tables
• Proficient in creating complex queries and views using data stored in JSON format
• Proficient in optimizing performance of stored procs and views accessing data stored in JSON format
• Documentation skills
• Dev/Unit Testing
• Agile development

ABOUT ISHIR
ISHIR is a digital innovation and enterprise AI services provider. We work with startups and enterprises to shape the future through accelerated innovation, deep technical expertise, access to global digital talent and a passion for complex problem-solving. With our help, our clients overcome their most difficult digital challenges leveraging AI.

We are not just consultants, we are partners in our clients’ success, assisting them with re(gaining) competitive edge by identifying opportunities for differentiation, industry disruption, scalable innovation, and go-to-market strategies that deliver successful outcomes.

At ISHIR, we help bold businesses accelerate innovation through Talent, Speed-to-Market, and AI. We help make an impact by solving real problems using innovation, improved customer experiences and the right technologies.

As an ISHIR employee, you will get the advanced training you need to be successful, and the opportunity to apply it. You must be passionate about technology, crave responsibility, and be eager to apply your knowledge to real business solutions for our startup and enterprise customers. These are the qualities of a person destined for success at ISHIR.

ISHIR attracts a special type of individual—someone who is proactive, thrives on challenges, feeds off success, and looks at moving targets not as obstacles but as opportunities. ISHIR is an exciting place to work. It is imbued with an entrepreneurial spirit and promotes self-reliance, open communication, and collaboration.