About Azur HROur ServicesOpportunities

Opportunities

PROGRAMMER ANALYST LEVEL 3 (COBOL) - INDUSTRY CANADA 240 DAYS

Ottawa

Job Summary

Title: PROGRAMMER ANALYST LEVEL 3 (COBOL) - INDUSTRY CANADA 240 DAYS
Security Clearance: Reliability Status
Travel Required: No
Years Experience: 10
Start Date: immediate
Term of Contract: 1 Years
Employer Type: Public Sector
Language: English

Description

There is a requirement for a senior Programmer Analyst to perform application design and development, adaptive, corrective and proactive maintenance and operational support for the Spectrum Management System (SMS), as well as, expertise in the areas of system and requirements analysis, server modeling, application and software testing, data cleansing and migration, data integration and detailed IT system specification and documentation. The work will require both the maintenance of the existing legacy COBOL applications along with maintenance of Fortran programs, as well as the development of new modules using the suite of Oracle tools including Oracle Designer and Forms and Reports and extensive knowledge of PL/SQL. There is also a need for a knowledge transfer of these duties to internal Industry Canada staff through mentoring and training. The environment consists of Microfocus COBOL and Oracle tools on both Unix and Windows. There is also a requirement to support/troubleshoot periodical production runs as well as the day to day operations. The senior Programmer Analyst will assist Industry Canada employees to ensure the smooth flow of data between Industry Canada and corresponding U.S. agencies: Federal Communications Commission (FCC) and the National Telecommunications Agency (NTIA). This requires knowledge and experience with Oracle Tools, Compaq Tru64 Unix, Unix scripting, and Perl scripting.

Duties

The senior Programmer Analyst must provide the following deliverables: 

→ System design documents including user and data requirements, impact analysis reports and functional specifications.

→ System software test plans including fully documented results.

COBOL code change according to specifications provided by IC personnel.

→ Oracle Designer web forms to specifications.

→ Various reports (i.e., data cleansing, application data, technical analysis, bug reports, etc.)

→ Oracle PL/SQL utilities including packages, functions, procedures, DML, DDL statements, etc.  

Reporting Requirements:  

The Programmer Analyst will provide the Project Authority with a detailed progress report on a monthly basis which could include the following:  

→Company and Client information

→The month in which work was performed

→The date in which work was performed

→A detailed description of daily tasks performed

→A detailed report of upcoming work

→Daily hours worked

 

Qualifications

SECURITY  

The Contractor’s proposed resource must have a valid security clearance at the level of “Reliability” for the duration of the Contract.

Mandatory Technical Criteria  

M1 The proposed resource must demonstrate that they have 10+ years of experience in order to meet the minimum mandatory experience for the resource category and level requested (Programmer/Analyst – Level 3). 

M2 The proposed resource must have recent and comprehensive experience programming MicroFocus COBOL. Recent and comprehensive experience is defined as a minimum of 2 years of experience within the last 5 years in developing and maintaining MicroFocus COBOL applications in both batch and client/server environments. This must be clearly demonstrated in the proposal by specifying the projects the proposed resource worked on, duration of the projects, which must include a project start date and end date, along with the role(s) and responsibilities the proposed resource had on the project. 

M3 The proposed resource must have recent and comprehensive experience developing COBOL programs that employ embedded Oracle *SQL (PL/SQL). Recent and comprehensive experience is defined as a minimum of 2 years of experience within the last 5 years in developing and maintaining COBOL applications that employ embedded Oracle *SQL (PL/SQL) in both batch and client/server environments. This must be clearly demonstrated in the proposal by specifying the projects the proposed resource worked on, duration of the projects, which must include a project start date and end date, along with the role(s) and responsibilities the proposed resource had on the project. 

M4 The proposed resource must have recent and comprehensive experience programming Oracle PL/SQL. Recent and comprehensive experience is defined as a minimum of 2 years of experience within the last 5 years in the creation and maintenance of PL/SQL utilities including tables, database triggers, constraints, procedures, functions, packages, database links, views, sequences, grants, roles, indexes and synonyms. This must be clearly demonstrated in the proposal by specifying the projects the proposed resource worked on, duration of the projects, which must include a project start date and end date, along with the role(s) and responsibilities the proposed resource had on the project. 

M5 The proposed resource must have recent and comprehensive experience using the Oracle Designer CASE tool to perform data modeling and database generation. Recent and comprehensive experience is defined as a minimum of 1 year of experience within the last 7 years in the creation and administration of server models, roles, grants, constraints, and storage definitions, implementations of databases, tables, domains, packages, procedures and functions. This must be clearly demonstrated in the proposal by specifying the projects the proposed resource worked on, duration of the projects, which must include a project start date and end date, along with the role(s) and responsibilities the proposed resource had on the project.  

M6 The proposed resource must have recent and comprehensive experience developing Oracle Forms using Oracle Forms Builder. Recent and comprehensive experience is defined as a minimum of 5 years of experience within the last 8 years in the creation and administration of Oracle Forms applications in a client-server or web application deployment environment. This must be clearly demonstrated in the proposal by specifying the projects the proposed resource worked on, duration of the projects, which must include a project start date and end date, along with the role(s) and responsibilities the proposed resource had on the project. 

M7 The proposed resource must have recent and comprehensive experience writing data requirements, functional requirements, test plans, and end-user documentation. Recent and comprehensive experience is defined as a minimum of 2 years of experience within the last 10 years. This must be clearly demonstrated in the proposal by specifying the projects the proposed resource worked on, duration of the projects, which must include a project start date and end date, along with the role(s) and responsibilities the proposed resource had on the project.  

M8 The proposed resource must provide at least two (2) client references, including contact names and phone numbers, for whom the proposed resource has gained their experience, and in total, provide full coverage of the range of services listed.  

Point Rated Technical Criteria  

R1 Further to Mandatory Requirement M2, the proposed resource will be given points for their years of experience in programming MicroFocus COBOL in both batch and client/server environments over and above the minimum of 2 years of experience within the last 5 years required in M2 above.  

R2 Further to Mandatory Requirement M3, the proposed resource will be given points for their years of experience in developing MicroFocus COBOL programs that employ embedded Oracle *SQL (PL/SQL) in both batch and client/server environments over and above the minimum of 2 years of experience within the last 5 years required in M3 above.  

R3 Further to Mandatory Requirement M4, the proposed resource will be given points for their years of experience in programming Oracle PL/SQL over and above the minimum of 2 years of experience within the last 5 years required in M4 above.  

R4 Further to Mandatory Requirement M5 above, the proposed resource will be given points for their years of experience in using the Oracle Designer CASE tool to perform data modeling and database generation over and above the minimum of 1 year of experience within the last 7 years required in M5 above.  

R5 Further to Mandatory Requirement M6 above, the proposed resource will be given points for their years of experience in developing Oracle Forms using Oracle Forms Builder over and above the minimum of 5 years of experience within the last 8 years required in M6 above.  

R6 Further to Mandatory Requirement M7, the proposed resource will be given points for their years of experience in writing data requirements, functional requirements, test plans, and end-user documentation over and above the minimum of 2 years of experience within the last 10 years required in M7 above.  

R7 The proposed resource should demonstrate that they have recent and appreciable experience writing shell scripts for Unix. Recent experience is defined as in the last 5 years and appreciable experience should be clearly demonstrated in the proposal by specifying the projects the proposed resource worked on, duration of the projects, which should include a project start date and end date, along with the role(s) and responsibilities the proposed resource had on the project.  

R8 The proposed resource should demonstrate that they have recent and appreciable experience in the Spectrum Management or Telecommunication field to adequately understand the business, operational and data model requirements. Recent experience is defined as in the last 5 years and appreciable experience should be clearly demonstrated in the proposal by specifying the projects the proposed resource worked on, duration of the projects, which should include a project start date and end date, along with the role(s) and responsibilities the proposed resource had on the project.

Tasks - Deliverables

The Programmer Analyst will perform tasks assigned by IC personnel who will determine the priority and schedule of tasks. The primary activity of the work required is perfective and corrective maintenance in response to approximately 200 action requests a year submitted by the regional/district office user community. These requests may be for design enhancements, program bugs, ad-hoc reports or database updates.

Tasks, assigned by IC personnel, may include but are not limited to the following:

• Adaptive, corrective and proactive maintenance and operational support for the CANCOORD System. CANCOORD is an Oracle based application used to store and manipulate data that represents administrative and technical information on Canadian radio stations sent for international frequency coordination since 1950. CANCOORD allows users to send requests for frequency assignment coordination to the US agencies.

• Adaptive, corrective and proactive maintenance and operational support for the USCOORD system. USCOORD is the automated Oracle based application used to receive, process and permanently store frequency coordination requests sent to Industry Canada from these agencies in the United States: FCC (Federal Communications Commission), FAA (Federal Aeronautical Agency), JCS (Joint Chief of Staff) and NTIA (National Telecommunications Agency). It provides read only access to Industry Canada staff at district offices across Canada. Administrative and technical staff in Ottawa have update capability necessary for the administrative processing and technical evaluation of USA frequency coordination records.

• Application design and development, adaptive, corrective and proactive maintenance and operational support for Spectrum signature code maintenance.

• Application design and development, adaptive, corrective and proactive maintenance and operational support for the Radio Model Equipment system.

• Adaptive, corrective and proactive maintenance and operational support for the Land /Mobile system including the Automatic Selection of Radio Frequencies (AutSel) system. The frequency selection component uses the sub-allocation data, occupancy data and radio environment data to select potential available Radio Spectrum within a defined geographical area.

• Adaptive, corrective and proactive maintenance and operational support for the Microwave system. The Microwave system is a part of the Assignment Licensing System (ALS); it is a tool to evaluate the Electromagnetic Compatibility Studies of the Microwave assignments in Canada. Microwave users have the option to submit the technical analysis in an on-line mode or batch mode.

• Develop and maintain user and data requirements, functional specifications, Test plans, system and impact analysis documentation according to specifications provided by IC personnel.

• Develop, maintain and execute software testing plans including unit testing, integration testing, system testing, regression testing, acceptance testing.

• Develop and maintain Report layouts using various reporting tools according to specifications provided by IC personnel.

• Build systems to integrate with the new COTS application according to specifications provided by IC personnel.

• Training and mentoring of Industry Canada staff on the above tasks. Writing procedural documentation, hands on demonstration, and simplifying procedures where possible.

• Research new software and technology.

• Perform the migration of SMS applications to newer Oracle technologies and platforms.

• Develop and maintain SMS applications using Oracle Forms Builder and deploy on a web platform according to specifications and standards.

Company Profile

Industry Canada’s Chief Information Office/Business Solutions Branch (CIO/BSB) requires the services of a senior Programmer Analyst to maintain, to the minimum extent possible, its existing legacy Spectrum Management System (SMS) of Spectrum, Information Technologies and Telecommunications (SITT) Sector to maintain services to spectrum users in order to ensure the success of the Spectrum Application Modernization (SAM) Project.

The services will be required for one (1) year from date of contract award (tentative start date is June 2014), with the irrevocable option to extend the period of the Contract by up to one (1) additional one (1) year period under the same terms and conditions.

Industry Canada’s Spectrum, Information Technologies and Telecommunications (SITT) Sector manages all activities related to the radiofrequency spectrum within Canada.

The Spectrum Application Modernization (SAM) Project has received Preliminary Project Approval (PPA) from Treasury Board. The scope of the project is to modernize the Spectrum Management System (SMS) currently in place. The SAM project will achieve this by engaging a vendor to supply an integrated Commercial-off-the-Shelf (COTS) product for spectrum management. The project is expected to take 5 years. The need for the SAM project comes from the fact that the current SMS is composed of many disparate systems built on a variety of older (and in some cases outdated) technologies and platforms. The current SMS is costly to maintain due to its complexity and does not provide the flexibility needed to keep pace with the changing business needs in terms of how spectrum will need to be managed now and in the future. Some of our key applications are the Electromagnetic Compatibility (EMC) and the Coordination Systems. EMC is an essential national application that is used daily by over 350 staff in regional and district offices to ensure that radio equipment or a radio system has the ability to operate in its normal electromagnetic environment without degradation and without adversely affecting the operation of other equipment or systems. The Coordination system is a spectrum management application, which will allow the Industry Canada staff to process and reference international frequency coordination requests, and district offices to reference the coordination message and proposal records. There is vital need to ensure there is continued support for the legacy EMC and the Coordination applications for the duration of the transition to SAM.  

In order to transition to the new COTS product, production data from the current system needs to be cleansed and integrated/migrated to the COTS product. In addition, while the SAM project mandate is to modernize the SMS, it is expected that the integrated COTS product will likely not be able to replace all existing SMS functionality in its entirety. As such, for the few areas of functionality not incorporated into the COTS product, work will need to be done to modernize the remaining SMS functionality and build interfaces to the COTS product.

In order to ensure the success of the SAM project, the services of a senior Programmer Analyst are required to maintain to the minimum extent possible its existing legacy Spectrum Management System in order to maintain services to spectrum users.

How to Apply

Email

Kindly submit your resume to azurhr@azurhr.com

If you have any questions* in regards to this position please email us.
*To apply for this position please enter your email address and upload your resume above.

Tweet this opportunity!
Mobile Version »