Programmer / PL/SQL / Datawarehouse (Remote role)

State of Maine; Augusta (ME); Remote; USD 80,000 - 110,000; Full time

Job summary

The State of Maine is seeking a mid-senior level Programmer for a remote role focused on PL/SQL and Data Warehouse development. The ideal candidate will have State Government experience and be responsible for supporting agency users, maintaining systems, and developing complex applications within a collaborative team environment.

Qualifications

• Must have State Client experience.
• Expertise in PL/SQL, TSQL, and Data Warehouse development.

Responsibilities

• Preparing detailed design specifications for complex systems.
• Maintaining assigned systems and resolving problems.
• Developing systems using higher-level languages and tools.

Skills

PL/SQL

TSQL

Data Warehouse

Job description

Programmer / PL/SQL / Datawarehouse (Remote role)

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from State of Maine

Require candidate with State Govt experience

Top 3 Skills:

• PL/SQL - TSQL
• Data Warehouse
• Review & Convert Coding

The Datawarehouse team is seeking individuals to assist in meeting project timelines for the existing PRISM and OMS ReFRAME projects, while supporting agency users with current production environments. Resources will provide ongoing support after project go-live.

Responsibilities include:

1. Preparing detailed design specifications for highly complex, large-scale systems to facilitate system development and programming.
2. Maintaining assigned systems, resolving system problems to ensure continuous availability and proper functioning.
3. Developing systems using higher-level languages such as 3GLs, 4GLs, enterprise application development tools, system utilities, and project management tools.
4. Diagnosing and resolving complex application software issues, implementing effective solutions considering system capacity, limitations, and desired outcomes.
5. Designing and developing subroutines to support system development efforts for maximum productivity.
6. Performing complex programming tasks to meet user and business needs.
7. Managing multiple priorities effectively while maintaining progress on current work.
8. Adopting a customer-focused approach when collaborating with other teams and business contacts.
9. Working within a shared team development environment, covering all aspects of the SDLC.
10. Completing work in an Oracle Cloud environment.
11. Applying Data Warehouse design and development principles, including knowledge of Kimball methodology and Star Schema design.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology

Industries

• Government Administration and Government Relations Services

Referrals increase your chances of interviewing at State of Maine by 2x.

Get notified about new Software Engineer jobs in Augusta, ME.

Additional Requirements

Must have State Client experience and expertise in PL/SQL, TSQL, and Data Warehouse development.