PowerBuilder & Oracle PLSQL Architect

Isite Technologies Inc

Albany, NY, United States

5 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Adobe InDesign Extract Transform Load (ETL) Data Migration Relational Databases Oracle (Applications) PowerBuilder SQL Stored Procedures PL-SQL SQL Databases Data Processing Freeform SQL

Job description

Day-to-Day Tasks —

Participate in design review sessions with the program area.
Review existing data sets and application.
As needs arise, modify and support the applications until they can be replaced with a modern web-based version.
Day to day tasks will include, but are not limited to implementing requirements by designing, coding, and testing new features.
Documenting code-based business rules.

Requirements

84 months of experience with coding client-server relational database applications using PowerBuilder.
84 months of experience with Oracle and PL/SQL. Experience should include creating tables, stored procedures, triggers, views, and other objects.
48 months experience with writing complex SQL queries and reports such as multiple JOINs, subqueries, conditional logic or windows functions; experience with data manipulation, data migration, and creation of ETL scripts.
48 Months as a lead developer on projects that included multiple developers working on the same project/component, or had more than four developers on the team