The PL/SQL Programmer will function as a senior technical resource for a large, high-profile development effort extending a pension administration system. This position will also be responsible for the developing packages, stored procedures, functions, triggers, views, and other database objects to support Information Systems Department development efforts.
Assist in development of the Windows Development and Production Environment (WDPE), which is a project that is mandated to establish standards for development and production support for application systems on a Windows platform.
In this role, the selected candidate will convert the SMART Oracle pl/sql functions and procedures (pkg_rts package and pkg_tfa package etc) to RIR; convert PV Analyze Oracle pl/sql functions and procedures to RIR.
The Predictive Modeler is responsible for performing data analysis, utilizing data mining techniques, producing predictive models, querying and manipulating data, and demonstrating excellent reasoning skills.
In this role, the selected candidate will be responsible for analyzing performance issues and providing recommendation based on testing results; maintain database configurations in compliance with release management and change management policies.
Change management/implementation: independently review, implement, and verify changes/solutions of high complexity and risk to meet customer and/or trade/company information technology infrastructure needs. May lead or participate in a change advisory board.
The Software Engineer will develop and maintain extract/transform/load routines to gather data from various data sources and for developing applications to support the departments research and reporting needs.