> Markdown version of [/jobs/ext/2976515-oracle-plsql-developer-w2-only-albany](https://www.wearedevelopers.com/jobs/ext/2976515-oracle-plsql-developer-w2-only-albany). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Oracle PLSQL Developer-W2 Only-Albany

- **Company:** Isite Technologies Inc
- **Location:** New York, NY, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Software Documentation, Databases, Data Mart, Data Structures, Oracle Business Intelligence Enterprise Edition, Oracle SQL Developer, Regression Testing, SQL Stored Procedures, SQL Databases, Test Scripts, Database Performance, Information Technology, Oracle Reports
- **Published:** September 18, 2026
- **Apply:** https://www.dice.com/job-detail/f0278714-f52c-43d5-b500-dba5407d1ba1

## About the Role

* 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

## Description

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

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

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

 4. 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

 5. 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

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

 7. Provide general support for user acceptance testing efforts
 8. Work closely with ITS and Program managers to ensure adherence to standard
policies and procedures


## Related Videos

- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Are Classical Automation Frameworks Dead? How AI Agents Are Transforming QA](https://www.wearedevelopers.com/videos/100243-are-classical-automation-frameworks-dead-how-ai-agents-are-transforming-qa)
- [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one)
- [Fighting test flakiness with time machines](https://www.wearedevelopers.com/videos/834-fighting-test-flakiness-with-time-machines)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Technical Documentation For Developers](https://www.wearedevelopers.com/magazine/128-technical-documentation-for-developers)
- [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)
- [SQL Murder Mystery: A game for hobby detectives who want to learn SQL](https://www.wearedevelopers.com/magazine/38-sql-murder-mystery-a-game-for-hobby-detectives-who-want-to-learn-sql)
- [93 Java Interview Questions You Should Prepare For](https://www.wearedevelopers.com/magazine/14-93-java-interview-questions-you-should-prepare-for)
- [Software Developer Salary in The Netherlands [2023]](https://www.wearedevelopers.com/magazine/217-software-developer-salary-in-the-netherlands-2023)