Oracle PL /SQL Developer

Job Roles & Responsibilities:

Bachelor’s or Master’s degree in Computer Science, Information Technology.
• Minimum of 5+ years of advanced experience in MS ACCESS/ VB Programmer.
• Minimum of 5+ years of experience with familiarity with Office 365 Suite.
• Experience with ORACLE.
• Minimum of 5+ years of SQL/ PL-SQL experience.
• Familiarity with TOAD and/or PL/SQL developer.
• Minimum of 5+ years of experience working in a windows environment.
• Ability to design, implement and test the required services for the Fund.
B. The Loan Processing Database designed by the Consultant(s) in MS ACCESS may
include, but will not be limited to the following:
• Process and calculate multiple loans.
• Track loan repayments and amortization schedule.
• Maintain outstanding loan balances.
• Generate various loan reports.
Tier 3 Members – Loan Processing MS Access Database - 23REQ0162 5
• Store member identifying data and loan information.
• User interface should mirror existing loan module to the best extent possible.
• Import data from external sources (MS Excel, txt, csv) and import data through
ODBC connections.
• User screens should be easy to navigate with input validations to avoid data
exceptions.
• Generate export files (MS Excel, txt, csv) to be sent to the City’s central payroll
management system for processing.
• Database must accommodate multiple users simultaneously.
• Log-in screen for database that has username and password ability.
• Audit tracking on all database tables (ability to identify user entered, changed,
and approved the data, etc.)
• Build approval module to prepare loan data for export.
• Potential data conversion to the Fund’s pension administration system.