Oracle PL/SQL Programmer

Summary:

Will at a minimum include, but is not limited to:

a. Application development using Oracle Forms, Reports, and PL/SQL;

b. Database development through PL/SQL triggers, packages, procedures, functions and other objects;

c. Operating system and ETL development with AIX Kornshell scripting;

d. Write comprehensive test scripts for developer testing of Oracle applications;

e. Handle day-to-day management of assigned projects and prioritize workload to ensure project deadlines are met;

f. Knowledge and usage of Oracle development "best practices";

g. Work closely with end users in defining and documenting requirements;

h. Execute all design stages from the test environment to QA and move-to-production of final files;

i. Write software user manuals and technical documentation;

j. A transfer of knowledge to the Lottery team is expected through individual mentoring and/or planned group training for Oracle Forms, Report and PL/SQL;

k. The Lottery reserves the right to extend or expand the statement of work of the resultant Agreement to other related projects.

1.3 PREFERRED SKILLS AND EXPERIENCE

a. Minimum 5 - 8 years professional experience within an Oracle environment; comfort and knowledge of

Oracle 12g and Oracle 19c;

b. Certification in Oracle PL/SQL preferred;

c. Advanced skill sets in Oracle Forms and Reports (10g and higher), Oracle Databases (11g and higher),

PL/SQL;

d. Experience with Oracle Application Server and WebLogic;

e. Experience with migrating from Oracle 11g to Oracle 12c to 19 c;

f. Experience with Unix AIX and Kornshell scripting;

g. Knowledge of TOAD or Ultra Edit;

h. Knowledge of Rapid Application Development and prototyping;

i. Ability to communicate technical information effectively;

j. Ability to work in a team environment with multiple developers, consultants and project managers;

k. Ability to collaborate development efforts and work within a standards-based environment; and

l. Ability to design curriculum to train developers in PL/SQL, Oracle Forms, and Oracle Reports.
\n

Education: Bachelors Degree