Oracle PL/SQL Developer

Trigyn Technologies Limited.; Village of Menands (NY); On-site; USD 110,000 - 160,000; Full time

Job summary

TRIGYN TECHNOLOGIES, INC. in Menands, NY seeks an Oracle PL/SQL Developer for a direct government client project. You will develop and test SQL queries, build reusable query libraries, and assist staff with data structures and ad-hoc queries within OBIEE.

The role requires extensive PL/SQL experience, ELT-style collaboration with business units, and delivering documentation and testing support throughout the software lifecycle. On-site with strong governance adherence.

Qualifications

• Involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 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
• months of experience creating software documentation including functional specifications and technical specifications
• 48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance
• 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.

Responsibilities

• Develop, test and execute Oracle SQL queries against the schema of production 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 program staff in understanding data structures within the NYWIC modules, for developing new report requirements
• Assist program staff in developing new ad-hoc queries within the Datamart OBIEE system, using defined user guidelines and additional guidance from the Datamart team as needed
• Work with Datamart team members, program staff, and the application vendor as needed to develop a knowledgebase of system data mappings between the 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.

Skills

Oracle PL/SQL

SQL queries

Requirements gathering

Documentation

Education

Bachelor’s Degree in Information Technology related field

Tools

OBIEE

Job description

Trigyn's direct government client has an immediate need for an Oracle PL/SQL Developer in Menands, NY.

Description

• Develop, test and execute Oracle SQL queries against the schema of production 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 program staff in understanding data structures within the NYWIC modules, for developing new report requirements
• Assist program staff in developing new ad-hoc queries within the Datamart OBIEE system, using defined user guidelines and additional guidance from the Datamart team as needed
• Work with Datamart team members, program staff, and the application vendor as needed to develop a knowledgebase of system data mappings between the 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.

Mandatory Qualification

• Is involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 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
• months of experience creating software documentation including functional specifications and technical specifications
• 48 months of experience analyzing, optimizing Oracle SQL queries and improving database performance
• 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.

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.