Programmer Analyst

State of Maine•Augusta, ME

1d•$57,775 - $81,066•Remote

About The Position

The Department of Administrative and Financial Services (DAFS) Office of Information Technology (OIT) provides information technology support to over 13,000 employees. OIT oversees large scale enterprise applications that support the critical and diverse business needs of the State of Maine and its agencies. MaineIT is seeking a highly talented individual who will represent our C.A.R.E. values in all that they do. At MaineIT we: Practice Customer-focus, ensuring that our customers are heard, and their needs are met. Hold ourselves to a high level of Accountability by being transparent with our stakeholders. Maintain an effective level of Responsiveness by providing timely updates in a proactive manner. Strive to provide Empathy driven, people-focused services by applying emotional intelligence skills and behaviors.

Requirements

Knowledge of high-level programming languages and enterprise class application development tools such as PL/SQL, SQL Developer, and Oracle APEX
Knowledge of program documentation procedures.
Knowledge of structured programming.
Knowledge of all phases of the project development cycle.
Knowledge of systems analysis and design techniques.
Knowledge of state government or business application areas.
Ability to work effectively as a member of a team.
Ability to communicate effectively via verbal or written communication methods
Familiarity with application testing techniques and processes.
Knowledge of Oracle Cloud Infrastructure (OCI) services and cloud-based application deployment concepts.
Knowledge of Oracle Database architecture, SQL performance tuning, and database optimization techniques.
Knowledge of data warehousing methodologies, including Kimball dimensional modeling, star schema design, and ETL/ELT processes.
Skill in developing, testing, debugging, and maintaining Oracle PL/SQL code and database objects.
Skill in analyzing business requirements and translating them into technical solutions.
Familiarity with source code management and software release processes.
Ability to troubleshoot and resolve complex application and database issues.
A Bachelors Degree in Computer Sciences or an equivalent industry certification -OR- an Associates Degree in Computer Information Science with 1 year application development experience -OR- 2 years application development experience

Responsibilities

Evaluates existing code and migrate current functionality into new technology
Test and debug programs to ensure proper functionality
Educate users on the use of programs and program features
Create documentation in support of enhancements and reported issues
Writes final user, system, and program documentation in order to facilitate system use and future modifications.
Maintains existing systems and responds to problems in order to ensure programs remain effective.
Leads or participates in walk-throughs of system and program designs, coding, and testing in order to minimize occurrence of program problems.
Attends and participates in vendor, agency, and computer-based training programs in order to develop technical skills and expand knowledge of automation technology products and capabilities.