Position: Programmer Analyst (Oracle Technology)

Company: inRound Innovations
Location: Ottawa
Category: Other
Industry: Government (incl military)
Type: Contract
Required Experience: Experienced (5+ Years)
Start Date: TBD

Required Skills:
All Skills: M: MS SQL Server, Application Development: Software: PL/SQL, All Skills: O: Oracle

Required Education: University

Language Requirements: Speak English,Read English,Write English

Job Description:
Our Ottawa based client is seeking a Programmer Analyst (Oracle Technology) for a 2 year contract position, with optional 1 year contract extension.

All candidates must possess reliability status clearance.

Bilingualism in considered an asset.


The Programmer / Analyst – Oracle and Microsoft Technology must:

-Review the DEAIS business requirements and the DEAIS functional specifications documents of an approved project within the DEAIS application portfolio and provide via email the level of effort and time estimates for all assigned tasks of the project;
-Review the DEAIS business requirements and the DEAIS functional specifications of an approved project within the DEAIS application portfolio and provide via email feedback or written comments that are inserted directly into the documents regards to the clarity and validity of the processes and functions that are defined in the documents;
-Design, build, and modify application prototype of the proposed solution for use in packaging screenshots to be incorporated with the functional specifications document, client reviews and approval, and to explore different design options;
-Create and design data model of the proposed solution for use in application programming in accordance with departmental database standards and guidelines;
-Design and implement application code in accordance with departmental development standards;
-Code database triggers, stored procedures, packages for use in application programming in accordance with departmental database standards and guidelines;
-Conduct impact analysis on newly requested enhancements of existing applications within the DEAIS application portfolio;
-Provide on-site and telephone technical support to DEAIS clients for assigned application defects within DEAIS application portfolio;
-Perform data analysis, data migration into applications as requested;
-Perform application security analysis based on DND standards for existing applications within the DEAIS application portfolio;
-Develop unit test plan documenting scripts and results as requested;
-Provide a readme document for application deployment;
-Provide a deployment check list for application deployment;
-Create and/or update departmental Standard Operating Procedures (SOP) as requested;
-Attend technical meetings and record decisions and action items reports; and
-Provide a bi-weekly status report outlining work in progress, work completed, and work planned using a template that will be provided by the Technical Authority.

Other Requirements:
None

The ideal candidate will have::
  • experience in a minimum of 2 projects in the last 5 years with designing, building and modifying applications and data models from functional specifications.
  • a minimum of 4 years of experience in the last 7 years in maintaining in-service application code for web-enabled and client-server multi-tiered custom Oracle applications built using Oracle Forms and Reports 6i or higher.
  • experience in a minimum of 3 projects in performing data analysis, data conversion, and data migration into custom Oracle applications.
  • experience in Relational Database Design in a Microsoft SQL Server environment version SQL or higher
  • experience in Relational Database Design in an Oracle environment version 8i or higher.
  • experience in using Oracle Designer and Sybase PowerDesigner for the purposes of data modeling or code generation.
  • experience in developing custom applications built using Oracle Forms 6i and Reports 6i or higher.
  • experience in developing and maintaining PL/SQL database scripts using SQL Navigator 5.5 or higher.
  • experience in developing and maintaining Transact SQL database scripts using SQL Server 2000 or higher.
  • experience in producing software functional specifications based on business requirements.

    Company Info: inRound Innovations
    A division of inRound Innovations. inRound Innovations Inc. is a privately owned Canadian corporation specializing in Workforce Optimization & IT Recruitment Services. Our recruiting services are based on a solid foundation of proven resource assessment methodology and customer satisfaction. We appreciate the interest of all applicants, however, only candidates selected for an interview will be contacted. inRound Innovations is an equal opportunity employer. If selected for an interview, please advise us if you require special accommodation.


    		•