Senior Software Architect

RCMP requires providing the project team with skills required for the design and support of the modernization of the legacy Canadian Firearms Program (CFP) including maintenance and support of the existing legacy CFP applications, the Canadian Firearms Digital Service Solution (CFDSS) and Firearms Compensation Program System Integration (FCPSI) projects in the cloud as well as required changes to CFP systems for Bill-C21. Specialist will assist the Technical Authority with the execution of projects within the Digital Solutions & Systems Delivery (DSSD) Directorate of the IM/IT Program

Mandatory requirements

• Minimum of ten (10) years’ experience as an Application/Software Architect
• Five (5) years’ combined experience within the last ten (10) years performing two or more of the following:
  Developing complex technical architectures, frameworks and strategies, either for an organization or for a major application area, to meet the business and application requirements
  Ensuring the integration of all aspects of technology solutions
• Analyzing functional requirements to identify information, procedures and decision flows
• Evaluate existing procedures and methods, identify and document database content, structure, and application subsystems, and develop data dictionary
• Identifying and documenting system specific standards relating to programming, documentation and testing, covering program libraries, data dictionaries, naming conventions, etc.
• Five (5) years’ combined experience within the last ten (10) years performing two or more of the following:
  Interpret legislation to drive out technical system requirements
  Analyze and evaluate alternative technology solutions to meet business problems
  Monitor industry trends to ensure that solutions fit with government and industry directions for technology
  Define and document complex interfaces of manual to automated operations within application sub-systems, to external systems and between new and existing systems
  Lead design of new systems and system components defining input/output sources, in depth detailed technical plan
• Ten (10) years’ experience within the last fifteen (15) years utilizing the following:
  PowerBuilder, PL/SQL combined with following:
  ODB, C/JD, BC
  XML V.1+
  SQL
  RBAC/Security
• Ten (10) years’ experience within the last fifteen (15) years utilizing the following Oracle databases V 10+

General tasks

• Collaborate and assist in planning the releases of CFDSS product(s) deliverables, FCPSI Application Programming Interfaces (APIs) and legacy CFP/CFIS application maintenance and release life cycle : assist the project manager with different tasks to be inserted in the Microsoft schedule plan, test their unit of work by developing proper test cases, communicate through emails and meetings when risk are identified, risk manage by providing alternate or optimize solution and control the software development (code review, unit testing) and delivery process
• Develop complex technical architectures, frameworks and strategies, to meet the CFP business and CFP IM/IT application requirements
• Design, develop and implement technical solutions to satisfy day-to-day operations (eg. new business/legislative requirements, bug fixes etc…) that align with preapproved RCMP CFP IT technical architecture, frameworks and strategies in order to meet business and application requirements
• Analyze and evaluate alternative technology solutions to meet CFP Policy business problems
• Develop, execute test cases to ensure aligned with CFP business requirements/user stories. Test designed and developed solutions to ensure their integration with all aspects of the pre-existing CFP IT applications
• Monitor industry trends to ensure that developed IT solutions (see bulletin point 3.1.3) fit with government and industry directions for technology
• Analyze CFP functional requirements to document information, procedures and decision flows
• Document pre-existing and new developed CFP IT solutions with respect to database content, structure and application sub-systems, and data dictionary as well as database procedures and methods. In addition, provide recommendations to modernize CFP IT solutions based on industry and government IT trends
• Collaborating with various IM/IT groups within the RCMP to ensure CFP application changes to environments (DEV, QC, UAT) are deployed using DEVOPS tools and pipelines. When required, working closely with relevant development teams responsible for building the automation tools used to develop and deploy the required functions for the new or existing applications
• Define and document complex CFP interfaces to automate data sharing with external systems and between CFP application sub-systems. This also includes making required changes to CFP applications to support these interfaces
• Develop and maintain CFP documentation related to release management, build procedures, system configuration and dependencies.
• Document CFP system architecture, CFP IT solutions and CFP IT architecture updates for each release using MS Word, MS Excel or MS Visio. Documentation will be used to assist development teams with maintenance and support.
• Define CFP IT input/output sources, including detailed plan for technical design phase, and obtain IM/IT approval of the system proposals.
• Identify and document CFP system specific standards relating to programming, documentation and testing, covering program libraries, data dictionaries, naming conventions, etc.
• Consult with CFP Policy to ensure developed IT solutions adhere to legislation by participating and collaborating to design discussion with Business Analyst (BA) and technical team to drive out technical system requirements
• Facilitate knowledge transfer of CFP system architecture components and business processes to RCMP team leaders and development team members through workshops, meetings and submission of documentation