Senior Programmer Analyst - Legacy Systems
| Location: | Ottawa, Ontario |
| Openings: | 1 |
Description:
Senior Programmer Analyst - Legacy Systems
Background
A Level 3 Programmer Analyst will apply their expertise in the field of relational databases along with their knowledge regarding sustaining legacy systems. The division will rely on the Programmer to provide efficient methods of sustaining and enhancing existing Legacy information system solutions. These activities include porting and cleaning Legacy system data, Legacy information system betterment development, and providing support in multiple environments for the continuity and improvement of business practices within the organization.
Technical Criteria
Must hold a post-secondary degree or diploma in an engineering, technology, or software domain.
Must have a minimum of one hundred and twenty (120) months of demonstrated experience as a software developer.
Must have sixty (60) months of demonstrated experience within the last one hundred and twenty (120) months designing customized software solutions that take into consideration the expected lifetime of a legacy application (An information system that may be based on outdated technologies but is critical to day-to-day operations.).
Must have sixty (60) months of demonstrated experience within the last one hundred and twenty (120) months developing in each of the following environments:
- Microsoft Access
- Microsoft Visual Basic for Applications (VBA)
Must have a valid Government of Canada Secret Clearance.
Should have a minimum of thirty-six (36) months demonstrated experience within the last one hundred and twenty (120) months in the extraction, transformational and load (ETL) of data between different Relational Databases.
Should have twenty-four (24) months within the last one hundred and twenty (120) months of demonstrated experience developing in one or more of the following nine (9) languages:
- HTML
- .NET
- Java
- JavaScript
- Python
- CSS
- SQL
- Oracle Database
- PHP
Should have twenty-four (24) months of demonstrated experience within the last one hundred and twenty (120) months developing in SAP ABAP.
Should have twenty-four (24) months demonstrated experience within the last one hundred and twenty (120) months working with technical data on complex DND systems/equipment used for in-service support programs involving at least one of the following:
- Royal Canadian Air Force aircraft
- Radar and Communications Systems
- Royal Canadian Navy ships
Tasks to be performed:
- Provide technical subject matter expertise related to the development and sustainment of applications that embody Microsoft Visual Basic for Applications and Microsoft Access;
- Develop, implement, manage, and/or, support Legacy software applications.
- Proactively collaborate with team members, to understand problems and brainstorm solutions for Legacy information systems;
- Develop, maintain and manage the repository of documentation that describes all Legacy information systems configurations;
- Document all code to the standard of software development best practices;
- Communicate detailed designs of calculations, algorithms and data interfaces, using visual flow charts and diagrams;
- Perform interim and final quality reviews of applications, including the development of test data, test cases, and support of user acceptance testing;
- Provide Subject Matter Expert (SME) advice and guidance on the selection of the best suited software programs, tools, processes and methodologies to support Business Owners;
- Write, modify, improve and maintain code associated with Legacy information systems:
- databases
- user interfaces
- reports;
- Provide software release management support to legacy applications;
Perform an action:
