Programmer Analyst (Senior Oracle PL/SQL Data Developer)
Come, Innovate, Build, Disrupt & Thrive!
Position Overview
In this role, you will be a core member of a team of technology professionals supporting agency applications and data services. You will design, develop, and maintain the database structures, PL/SQL code, and data integrations that keep data moving securely, efficiently, and accurately across assigned systems.
The work spans both project and maintenance activities, including new implementations, upgrades, and system integrations. You will provide technical leadership on data-related tasks such as data modeling, ETL development, and integrating agency-specific data into vendor-hosted solutions.
You will collaborate closely with Data Architects, Database Administrators, application support staff, and vendors. The role calls for a high degree of technical proficiency, problem-solving ability, and independent judgment, and it may report to a project lead, project manager, or manager.
Key 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 that support 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 used in 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.
Required Qualifications
- 8+ years of experience supporting enterprise applications at a senior level
- 8+ years of Oracle PL/SQL development (packages, procedures, 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.
Available Benefits
- Medical Benefits (Platinum level plans available)
- Work from home / Hybrid / Onsite options
- PTO
- Holiday Pay
- VTO
- 401K
- Charitable Match
- Training reimbursement
About KēSTA I.T.
Our name says it all; KēSTA I.T. (Keys-to-I.T.) AND our people are our keys to our success!
KēSTA I.T. is a premier Utah-based technical staffing and consulting services firm. We specialize in temporary and permanent placement of Software, Hardware, Network, Cloud, CRM/ERP, Data, End-User support, Web and Executive / leadership-based positions on a full time and consulting basis.
If you're interested in a role where top performance is rewarded, personal time is valued, and excellence is demanded at every level we want to talk to you today!
Where do you want to go? We've got the keys! ~ KēSTA I.T.