Job Id: NY-RFP18-17 (99991021) (by Mail)
Oracle Warehouse Builder (OWB) Developer with OBIEE, Data Modeling, SQL/ Performance Tuning, Oracle Security, Unix, Attunity Compose and shell scripts Experience
Location: 110 State Street, Albany, NY 12236 (OSC)
Duration: 5 Years
Interview: in-person/ Video Conference
OSC is seeking a Proposer that can supply a Consultant to supplement the FirstNY technical leadership.
Under the direction of the FirstNY Manager, the Consultant shall:
A. Lead small, ad-hoc groups of FirstNY Team members in moderate to large-scale projects while providing technical guidance, mentoring, and support in the following areas:
i. Performance tuning FirstNY;
ii. Troubleshooting and managing resolution of complex technical problems involving FirstNY;
iii. Data modeling for reporting and analytics; and
iv. Designing solutions to satisfy requirements for system changes and enhancements.
B. Implement Oracle Security, including users, roles, object and system privileges, application contexts, and Virtual Private Database and associated policies in conformance with the:
i. FirstNY Security Guide, which defines the security level of all secured FirstNY data elements; and
ii. FirstNY Technical Reference Manual, which outlines the methodology for implementing the aforementioned security.
C. Assist the FirstNY Team in performing the conversion from Oracle Warehouse Builder to Attunity Compose;
D. Work with the FirstNY Team to assist in maintaining and configuring FirstNY’s instance of OBIEE utilizing the FirstNY repository database (“RPD”);
E. Create and maintain korn shell scripts in an IBM AIX environment;
F. Report to the FirstNY Manager on the status of tasks and any issues encountered in applications; and
G. Other related duties as identified by the FirstNY Manager.
The FirstNY Data Warehouse Reporting and Analytics System (“FirstNY”) maintains centralized data to be accessed by OSC employees and the public. FirstNY is supported by a team of OSC employees and consultants (“FirstNY Team”) within the Division of the Chief Information Officer (“CIO”). The Senior ETL Developer is intended to supplement technical leadership of the FirstNY Team. This requires mastery of performance tuning an enterprise data warehouse reporting and analytics system as well as providing technical guidance to a team of software developers on a range of concurrent, complex technical issues.