> Markdown version of [/jobs/ext/3003718-oracle-pl-sql-developer](https://www.wearedevelopers.com/jobs/ext/3003718-oracle-pl-sql-developer). 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 PL/SQL Developer - **Company:** Bits & Bytes Technology Solutions - **Location:** Menands, United States (Remote available) - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Data Analysis, Software Documentation, Data Mart, Data Structures, Data Warehousing, Database Queries, Database Schema, Oracle Business Intelligence Enterprise Edition, Oracle SQL Developer, Regression Testing, SQL Stored Procedures, SQL Databases, User Environment Management, Test Scripts, Database Performance, Information Technology, Oracle Reports - **Published:** September 19, 2026 - **Apply:** https://www.dice.com/job-detail/dd4d80c4-ee51-4abd-9dd2-e3aff630a591 ## About the Role 1. Oracle PL/SQL: Minimum 84 months of experience creating SQL queries and stored procedures using Oracle PL/SQL. 2. Requirements Gathering: Minimum 84 months of experience meeting with business staff to elicit business requirements. 3. Oracle Reports Troubleshooting: Minimum 84 months of experience collaborating with business staff or end users to analyze and troubleshoot Oracle reports. 4. Technical Documentation: Minimum 84 months of experience creating software documentation, including functional specifications and technical specifications. 5. Database Query Optimization: Minimum 48 months of experience analyzing and optimizing Oracle SQL queries to improve database performance. 6. Test Script Facilitation: Minimum 48 months of experience preparing or facilitating the creation of testing scenarios and test scripts. 7. User Documentation: Minimum 36 months of experience creating user documentation, such as user guides or training presentations. 8. OBIEE Experience: Minimum 36 months of experience using OBIEE (Oracle Business Intelligence Enterprise Edition), including end-user experience. 9. Education: Bachelor's Degree in an Information Technology-related field from an accredited institution. ## Description 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. ## Related Videos - [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) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [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) - [The Innovation Formula: Fast Prototyping, Data Analysis, and Real User Insights](https://www.wearedevelopers.com/videos/1421-the-innovation-formula-fast-prototyping-data-analysis-and-real-user-insights) - [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data) - [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) - [93 Java Interview Questions You Should Prepare For](https://www.wearedevelopers.com/magazine/14-93-java-interview-questions-you-should-prepare-for) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Should senior developers refuse interview coding challenges?](https://www.wearedevelopers.com/magazine/29-should-senior-developers-refuse-interview-coding-challenges) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)