Oracle / PL/SQL Specialist

Forensics Tracking System (FORTS)

Sexual Offender Management System (SOMS)

Patient Cash Application (PCA)

Forensic Tracking System (FORTS) & the Sexual Offender Management System (SOMS) are used to track patients incarcerated by the state judicial system. The Patient Cash Application (PCA) tracks the cash of patients in the OMH facilities.

Daily Tasks will include but not limited to the following:

1. Write complex queries in PL/SQL for multiple applications.

2. Participate in daily Scrum meetings to support Agile methodology used for system development on multiple systems.

3. Write migration scripts for QA and Production for multiple applications.

4. Develop scripts for automating support and maintenance for multiple applications.

5. Interact with business users to translate requirements into technical models.

1. Good comm skills are a big priority
2. Duration: 24 months