Note: The job is a remote job and is open to candidates in USA. Accord Technologies Inc is seeking a skilled Programmer Analyst with strong experience in enterprise software development and SQL/Oracle programming. The role involves reviewing, refactoring, and migrating legacy application logic into a modern AWS-based architecture, while collaborating with internal teams and third-party vendors to redesign core application functionality.
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
Skills
• SQL/ORACLE Programmer - Able to write, review SQL and PL-SQL code (SME)
• Business Analyst - Able to review SQL/PLSQL code, business rules, MS Code for sentencing rules
• Oracle
• SQL
• Weblogic
• Power BI
• AWS
• Lead Experience
• State client experience
• 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
• 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
Company Overview
• We are one of the pioneers in Information technology consulting and staffing industry. It was founded in undefined, and is headquartered in Sheridan, Wyoming, US, with a workforce of 51-200 employees. Its website is http://www.accordtecinc.com.
Apply Now
Apply Now