[Remote] PL/SQL Programmer Analyst - Sentence Computation | REMOTE
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 Apply tot his job