We are seeking a skilled Programmer Analyst with strong experience in enterprise software development, SQL/Oracle programming, and cloud-based modernization initiatives. The ideal candidate will review, refactor, and migrate legacy application logic including PL/SQL code, stored procedures, and Crystal Reports into a modern AWS-based architecture. This role involves understanding existing business logic, documenting current workflows, and collaborating with both internal teams and a thirdparty vendor. They will support the redesign of core application functionality, including modules such as records, classification and sentence computation, to ensure accurate operation within the updated system.
Key Responsibilities
· Review and document existing application architecture, data models, workflows, and stored procedures.
· Rewrite and optimize Oracle PL/SQL packages, functions, triggers, and views for migration to a cloud environment.
· Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS.
· Extract, map, validate, and transform data to support ETL and database conversion activities. · Analyze, document, and refactor core logic modules such as sentence computation.
· Convert legacy DHTML-based UI forms to modern formats as part of system redesign.
· Understand and document scheduled jobs and backend automation processes.
· Collaborate with a third-party vendor to clarify requirements and support modernization efforts.
Required Technical Skills :
· Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).
· Strong SQL expertise including query optimization and performance tuning.
· Experience with data migration, ETL workflows, and schema transformation.
· Ability to understand logic from legacy applications and undocumented code.
· Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).
· Experience with task schedulers for data automation.
Preferred Qualifications:
· Experience with AWS database and reporting services.
· Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
· Scripting experience (Python, PowerShell).
· Experience with Offender Management or enterprise justice systems.
· Experience working with external vendor teams on modernization projects.
SQL Developer • Denver, CO, Colorado, USA
Mortgage Cadence, a wholly-owned subsidiary of Client, has been partnering with mortgage lenders since 1999, offering the industry's only true one-stop shop mortgage technology solutions designed f... Show more
Boeing is currently looking for a Senior Developer to join their team in Englewood, CO.This position will focus on supporting Boeing Digital with the development of critical external customer self-... Show more
Location: Denver, CO or Remote (Mountain time zone).US Citizens and Green cards are Preferred.Designing and developing high volume data ingestion components and cloud architecture solutions.Selecti... Show more
Product Testers are wanted to work from home in the UK to fulfill upcoming contracts with local and international companies.We guarantee 15-25 hours per week with an hourly pay of between £18/hr.Th... Show more
Data Architect (AWS, Azure, GCP).CapTech is a team of master builders, creators, and problem solvers who help clients grow efficient, successful businesses.We unite diverse skills and perspectives ... Show more
Location: 2x week onsite in Castle Rock, CO (Must be local).Top skills: Azure (Data Lake, Data Factory), SSIS, SQL Server (Must have most if not all skills). Show more
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more
CapB is looking for an MS SQL Database and Support Specialist to join our IT department.The ideal candidate will be responsible for supporting our MS SQL databases, performing T-SQL programming, tr... Show more
Locations: Iselin, NJ or Charlotte, NC or Broomfield, CO.Duration: 6 - 12+ months, Could extend.Our Production Services team manages our core infrastructure assets.Our team is the first line of sup... Show more
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more
We are seeking a Salesforce Mulesoft Developer to design, develop, and optimize integrations between Salesforce and enterprise applications using Mulesoft Anypoint Platform.The ideal candidate will... Show more
By working at Sally Beauty, you would be part of the largest hair and beauty supplier in the world and we are on a mission to empower our customers to express themselves through hair and we need pa... Show more
Medical Assistant Position at South Denver OBGYN.OnPoint Medical Group is searching for an outstanding Medical Assistant to join our team at South Denver OBGYN in Castle Rock! Come join a great gro... Show more
SynergisticIT Job Opportunities.Since 2010 Synergisticit has helped jobseekers get employed in the tech job market by providing candidates the requisite skills, experience, and technical competence... Show more
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of bet... Show more
SynergisticIT is looking for entry-level software programmers, IT enthusiasts, Python/Java developers, Data analysts/Data Scientists.We welcome candidates with all visas and citizens to apply.Recen... Show more
Review and label digital content including text, images, and documents.Every task you complete helps improve how technology interprets information and performs in practical settings.Detail-oriented... Show more
Synergisticit Job Opportunities.Since 2010 Synergisticit has helped jobseekers get employed in the tech job market by providing candidates the requisite skills, experience, and technical competence... Show more
Job description: List of key skills needed:.Writing scripts that can be automated to interact with various DBs and APIs.Prior Database experience is helpful due to the complexity of the UIM databas... Show more
Behavioral Health Medical Coding & Compliance Specialist.Looking to join a compassionate community dedicated to providing exceptional mental health outcomes? Community Reach Center is that place.We... Show more
