Senior Oracle PL/SQL/Forms Developer / Application Modernization Specialist
Information Technology

Job Description:

On behalf of our public sector client, Affinity is seeing an Oracle Forms/PL/SQL Developer

Responsibilities:

Proof of Concept Phase
• Conduct a detailed assessment of the Vision application, Oracle database environment, PL/SQL code base, Oracle Forms, Reports, integrations, and related satellite systems to determine impacts associated with migration from ASCII to UTF-8.
• Assess impacts associated with supporting Indigenous Language names, alternate spellings, mononyms, and related business requirements across application, database, reporting, printing, and integration components.
• Identify technical dependencies, constraints, data quality issues, remediation activities, and implementation risks associated with database conversion and application enhancements.
• Evaluate and document technical options for storing, processing, displaying, printing, and exchanging Indigenous Language names across systems and downstream partners.
• Contribute to the development of target-state architecture, implementation options, resource estimates, timelines, and project plans.
• Support preparation of the final decision record, including recommendations, assumptions, dependencies, risks, and mitigation strategies.

Post-Proof of Concept (PoC) Implementation Phase
• Implement approved database and application changes required to support UTF-8 conversion and Indigenous Language name requirements.
• Modify and maintain Oracle PL/SQL code, Forms, Reports, database objects, interfaces, and integrations as required.
• Develop and execute unit testing activities and support system integration, regression, and user acceptance testing.
• Produce technical documentation including system architecture artifacts, technical specifications, data models, data flow diagrams, and operational support documentation.
• Support deployment planning, cutover activities, production validation, stabilization, and knowledge transfer.

Qualifications:
• Minimum 8 years of progressive experience designing, developing, maintaining, and supporting enterprise Oracle database applications using Oracle PL/SQL, Oracle Forms, and Oracle Reports.
• Demonstrated experience delivering Oracle application modernization, database migration, database upgrade, data conversion or legacy system remediation initiatives.
• Experience assessing, planning, and implementing UTF-8, Unicode, or multilingual character-set conversion projects.
• Experience conducting impact assessments and remediation planning for Oracle PL/SQL packages, stored procedures, triggers, Forms, Reports, interfaces, integrations, and dependent applications.
• Experience working with complex relational database models, data migration activities, performance tuning, and database optimization.
• Experience producing technical architecture documentation, logical and physical data models, data flow diagrams, technical specifications, and application dependency analyses.
• Experience preparing effort estimates, implementation plans, technical roadmaps, risk assessments, and dependency analyses for enterprise application initiatives.
• Experience supporting application deployments, production cutovers, post-implementation stabilization, and operational support.
• Demonstrated ability to provide technical leadership and collaborate effectively with architects, database administrators, business analysts, quality assurance specialists, project managers, and business stakeholders.
• Experience working within Agile, waterfall, or hybrid project delivery methodologies.
• Ability to translate complex technical concepts into business language and approval-ready deliverables

Preferred Qualifications
• Experience supporting multilingual, Unicode, or internationalization initiatives.
• Experience with Oracle Business Integration Suite, Oracle Integration technologies, or enterprise application integration patterns.
• Experience supporting public sector, registry, identity, or mission-critical transaction processing systems.
• Experience assessing and implementing database character-set conversions using Oracle tooling and best practices.

Affinity Earn:

Know someone who's great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 13526

#LI-Remote

Job Details

City : Victoria

Province/State : BC