Programmer Analyst

KēSTA I.T.•Lansing, MI

About The Position

The Programmer Analyst (Senior Oracle PL/SQL Data Developer) is a core member of a technology team supporting agency applications and data services. The role designs, develops, and maintains database structures, PL/SQL code, and data integrations that move data securely, efficiently, and accurately across assigned systems. Work includes project and maintenance activities, such as new implementations, upgrades, and system integrations. The position provides technical leadership on data-related work, including data modeling, ETL development, and integrating agency-specific data into vendor-hosted solutions. It collaborates with Data Architects, Database Administrators, application support staff, and vendors. The role requires strong technical proficiency, problem-solving ability, independent judgment, and may report to a project lead, project manager, or manager.

Requirements

8+ years of experience supporting enterprise applications at a senior level.
8+ years of Oracle PL/SQL development, including packages, procedures, and functions.
8+ years of experience using Oracle development tools such as Toad or SQL Developer.
8+ years of experience designing, creating, and maintaining Oracle database objects.
8+ years of logical and physical data modeling and database normalization.
8+ years of data analysis, data quality, and metadata management.
8+ years of developing and integrating web services (SOAP and/or REST).
8+ years of database programming for data migration and data conversion.
Experience supporting or integrating vendor-hosted or COTS systems.
Ability to work independently with sound judgment and provide technical leadership on data tasks.

Responsibilities

Design, develop, and maintain database objects, including tables, views, indexes, triggers, and constraints, to support application and integration requirements.
Develop and optimize PL/SQL packages, procedures, and functions supporting business logic, data services, and ETL processes.
Support data design and modeling activities, including logical and physical data models and normalization.
Lead and execute data migration and data conversion tasks for new implementations, upgrades, and system integrations.
Develop and consume SOAP and REST web services for data integrations between internal systems and vendor-hosted COTS solutions.
Analyze data and metadata to ensure accuracy, integrity, and compliance with agency standards.
Partner with Data Architects and DBAs on performance tuning, code reviews, and database best practices.
Troubleshoot data issues, identify root causes, and implement corrective solutions.
Participate in planning, estimation, documentation, and technical design sessions for new projects and ongoing maintenance efforts.
Provide technical leadership on data-related tasks such as data modeling, ETL development, and integration.