Carrer

Job Title: Oracle PL/SQL Developer

Location: St. Paul's, MN

Duration: 12 Months

The PL/SQL Developers will provide technical support to the MN.IT Enrollment System of Record (ESOR) team to develop, modify, and maintain ESOR for MNsure as well as enhance/assure future Open Enrollments are seamless. This includes changes required due to modifications or newly introduced code from adjoining systems such as Cúram, Connecture, EngagePoint product suite and other ESOR work. The PL/SQL Developers must be able to provide diagnostic analysis of the MNsure system as issues are reported. Successful Responders will work with the MN.IT team that will be supporting the ESOR process long term and provide knowledge transfer to those staff.

It is the on-going commitment of MN.IT to provide technology solutions that are reliable and flexible enough to meet fluctuating customer demand and increasing expectation of 7x24x365 system availability, all while decreasing on-going support expenses.

At a minimum, a proposed resource must meet the following mandatory qualifications. Resource submissions that do not clearly demonstrate that these mandatory qualifications are met will not be considered under this RFO.

B.S. or B.A. degree (4 year)

OR

Associate's degree (2 year) with 5 years' experience in PL/SQL Programming/Development.

A minimum of five (5) years of experience in designing, developing, and testing applications utilizing PL/SQL or Oracle (10g, 11g, or 12g).

Desired Skills

In addition to the Mandatory Qualifications, the proposed resource(s) will be evaluated on the following Desired Skills. Responder should demonstrate in its proposal the length, depth, and applicability of the proposed resource(s) prior experience in the desired skills below.

Computer Science or Information Technology degree

Experience in all aspects of the Software Development Life Cycle (SDLC)

Hands on experience working on health insurance programs which may be at the business or technical level

Experience in PL/SQL related to enrollment systems

Experience working with the following:

Data Architecture, Data Analysis, Data Modeling

Enterprise Data Warehousing

Oracle Database Administration

Account Creation, password reset

Role management

Oracle Audit Vault

Oracle Data Vault

Oracle Database Firewall

Advanced SQL and Oracle PL/SQL Development and experience with functions, procedures, packages and triggers, such as:

Oracle Job Scheduler

Oracle performance tuning, including:

Query tuning

Index tuning

Partitioning

Experience with Oracle Fine Grain Access Control (FGAC) development, configuration, and troubleshooting, which includes the following:

Forensic data analysis/troubleshooting

Oracle 11g

Hadoop

Subversion

Toad

JIRA

Confluence

Experience utilizing migration and version control systems.

Experience with secure coding principals such as OWASP Top 10, SANS Top 25.

Experience with IRS Pub 1075 and NIST 800-53 rev4.

Thanks