What are the responsibilities and job description for the SQL/Oracle Programmer Analyst position at Sita Consulting Services, LLC?
Job Details
Required Skills & Experience:
(Minimum qualifications needed to be considered)
-
Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views)
-
Strong SQL expertise, including query optimization and performance tuning
-
Experience with data migration, ETL workflows, and schema transformation
-
Ability to understand and refactor legacy and undocumented application logic
-
Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms)
-
Experience with task schedulers for data automation
-
Advanced business analysis skills (reviewing SQL/PLSQL code and business rules)
Preferred Qualifications:
(Not required but considered a plus)
-
Experience with AWS database and reporting services
-
Knowledge of BI/reporting tools such as Power BI or AWS QuickSight
-
Scripting experience (Python, PowerShell)
-
Experience in Offender Management or enterprise justice systems
-
Experience working with external vendor teams on modernization projects