SQL Programmer - REMOTE - 1105
Our client, the State of Maine, is looking for 2 individuals to assist in meeting the timeline of two existing projects, while supporting current users with the current production environments. Resources will provide continued support after projects go-live. WE DO NOT WORK ON C2C Top 3 Skills: PLSQL - TSQL Data Warehouse Review & Convert Coding Job Description: Prepare detailed design specifications for highly complex and large-scale systems to plan and facilitate system development and programming. Maintain assigned systems, responding to and resolving system problems to ensure systems are continuously available and function properly. Develop systems employing higher level languages such as 3 GL's, 4 GL's, enterprise class application development tools, system utilities, and project management tools to prepare systems for implementation. Diagnose and isolate complex application software problems; formulates and implements effective solutions considering system capacity, limitations, time requirements, and desired results to resolve system problems and prevent reoccurrence. Design and develop subroutines in support of system development efforts to achieve maximum productivity. Perform difficult, complex, and specialized programming assignments to ensure users and business needs are met. The ability to switch between multiple priorities while maintaining momentum on current work. Customer-focused approach when working with other teams and business contacts Familiar with a shared team development environment, including the ability to perform tasks for all aspects of the SDLC. Ability to complete work in an Oracle Cloud environment. Knowledge and application of Data Warehouse design and development principles Understanding Kimball method and how it is applied Data warehouse Star Schema experience Candidates MUST reside in U.S., and preferably in Eastern or Central time zones. US citizenship, permanent residency, or currently valid work visas are necessary. Project length goes through June 2026 at a minimum. Please send resume and cover letter to mkolkin@compass-sys.com