Oracle PL/SQL Developer - Need Passport copy & Bachelor's copy for submission

Bits & Bytes Technology SolutionsMenands, NY🇺🇸United StatesPosted Sep 19, 2026

Why This Role Stands Out

This remote Oracle PL/SQL Developer role offers significant project impact within a reputable government agency, providing an excellent platform for your mid-to-senior level expertise. If you are a seasoned developer looking to contribute to a vital program with flexible work options, you will thrive in this challenging and rewarding opportunity. Submit your application to explore this exciting career growth.

Quick Overview

Seniority

Mid Senior

Work mode

Remote

Location

Menands, NY, United States

Posted

12 hours ago

OraclePL/SQLSQL.NET

Job Description

Job Description: Software Developer (Expert) – HBITS-08-15016

Position Details

Position Title: Software Developer
Skill Level: Expert (84+ Months Experience)
Agency: NYS Department of Health (DOH) / Office of Information Technology Services (OITS)
Project Name: Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) / NYWIC MIS-EBT Project
Location: Riverview Center, 150 Broadway, Suite 600, Menands, NY 12204
Telecommute Option: Yes, up to 50% telecommuting allowed
Engagement Duration: 30 Months
Target Start Date: October 30, 2026
Work Schedule: Full-Time (40 hours/week); 7:30 AM – 4:00 PM or 8:00 AM – 4:30 PM (includes 30-minute unpaid lunch)
Interview Format: Webcasting with camera required

Project Overview

The NYWIC (New York Women, Infants, and Children) system is a statewide .NET/Oracle-based application supporting the administration of New York's WIC nutrition program.

Within this environment, the DataMart team handles the design, development, and ongoing maintenance of the enterprise data warehouse and reporting layer. The consultant will work alongside Software Analysts, Data Modelers, Informatica Developers, and OBIEE Developers to implement enhancements, update data structures, and maintain accurate, reliable, and timely reporting for business users, program administrators, and regulatory stakeholders.

Day-to-Day Responsibilities

Develop, test, and execute Oracle SQL queries against the Production NYWIC database schema for program validation and data analysis.
Create and maintain a library of reusable SQL queries that run on a recurring basis with configurable parameters.
Assist DOH program staff in understanding NYWIC data structures across application modules to help define new reporting requirements.
Help program staff build new ad-hoc queries within the NYWIC DataMart OBIEE system using established user guidelines.
Collaborate with DataMart team members, program staff, and the NYWIC application vendor to build a knowledgebase of system data mappings between the core application and DataMart.
Participate in reviewing and documenting regression test scripts for User Acceptance Testing (UAT) and support overall UAT efforts.
Work closely with ITS and Program managers to ensure all efforts adhere to standard agency policies and procedures.

Mandatory & Requested Qualifications

Oracle PL/SQL: Minimum 84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL.
Requirements Gathering: Minimum 84 months of experience meeting with business staff to elicit business requirements.
Oracle Reports Troubleshooting: Minimum 84 months of experience collaborating with business staff or end users to analyze and troubleshoot Oracle reports.
Technical Documentation: Minimum 84 months of experience creating software documentation, including functional specifications and technical specifications.
Database Query Optimization: Minimum 48 months of experience analyzing and optimizing Oracle SQL queries to improve database performance.
Test Script Facilitation: Minimum 48 months of experience preparing or facilitating the creation of testing scenarios and test scripts.
User Documentation: Minimum 36 months of experience creating user documentation, such as user guides or training presentations.
OBIEE Experience: Minimum 36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end-user experience.
Education: Bachelor's Degree in an Information Technology-related field from an accredited institution.