Oracle PLSQL Developer-W2 -Albany, NY-Hybrid

Job in City of Albany, Albany, Albany County, New York, 12201, USA

Listing for: ISite Technologies Inc

Full Time position
Listed on 2026-09-25

Job specializations:

IT/Tech
Database Administrator, Data Analyst, IT Business Analyst

Salary/Wage Range or Industry Benchmark: 90000 - 120000 USD Yearly USD 90000.00 120000.00 YEAR

Position: Oracle PLSQL Developer-W2 Only-Albany, NY-Hybrid
Location: City of Albany

Day-to-Day Tasks ---

Develop, test and execute Oracle SQL queries against the schema of the
Production NYWIC database upon request, for program validation and data analysis

Develop and maintain a library of SQL queries that can be executed on a recurring
basis with different parameters, for similar requests

Assist DOH program staff in understanding NYWIC data structures within the
NYWIC modules, for developing new report requirements

Assist DOH program staff in developing new ad-hoc queries within the NYWIC
Datamart OBIEE system, using defined user guidelines and additional guidance
from the NYWIC Datamart team as needed

Work with NYWIC Datamart team members, program staff, and the NYWIC
application vendor as needed to develop a knowledgebase of system data
mappings between the NYWIC application and the Datamart, for program
assistance

Participate in review and/or documentation of regression test scripts for user
acceptance testing

Provide general support for user acceptance testing efforts

Work closely with ITS and Program managers to ensure adherence to standard
policies and procedures

--
- Required Qualifications ---

84 months of experience creating software documentation including functional specifications and technical specifications
48 months of experience preparing or facilitating the creation of testing scenarios and test scripts
36 months of experience creating user documentation such as user guides or training presentations
36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end user experience
Bachelor's Degree in an Information Technology related field, from an accredited institution.
48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance
84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL
84 months of experience meeting with business staff to elicit business requirements
84 months of experience working with business staff or end users to analyze or troubleshoot Oracle reports