This job board retrieves part of its jobs from: Emploi Étudiant | Toronto Jobs | Work From Home

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

   Canadian Tech jobs   

Website updated every day with fresh jobs in the IT industry

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

Oracle Database Developer – Level 3

Nexus Systems Group Inc.

This is a Full-time position in Ottawa, ON posted September 23, 2022.

Our public sector client is looking for an Oracle Database Developer – Level 3 to design/develop application and/or data components, with a focus on extract, transform and load (ETL), stored procedures, data schemas/models, data mapping, and queries to implement system-to-system integration Responsibilities Lead all development activities for the assigned system components which includes, but is not limited to, design, coding, documentation, unit testing, defect resolution; Work closely with business analysts and systems analysts during the development process to verify and confirm requirements, data mapping and solution design; Provide recommendations on best coding design, impacts and options; Write database and/or ETL scripts for assigned application components; Work closely with project team to confirm that the data schema/model and application code meets the business and system requirements that are outlined in the detailed design, during the analysis and user acceptance, testing, and implementation phases of the development lifecycle; Documents data schema, data models, solution deployment and/or other code/system procedures Participate in all phases of the systems development lifecycle from analysis and design, development and coding, acceptance testing, and implementation, and work with project team members to review, evaluate, and approve project deliverables and documentation; Design, develop and code application components, data schemas, database, prototypes as a proof-of concept during design phase, including ETL processes, data translation tables, and/or database stored procedures Coding, testing, and debugging of the code drop/code release developed based on the assigned application components; Code all assigned database and/or application components in accordance with the approved detailed design specifications; Prepare code drop/code release deployment packages in preparation for release to production, and co-ordinate code deployment into various environments (i.e.

test, staging, and production); Conduct and assist in code and design reviews; Provide accurate estimates for newly proposed functionality/enhancements and review the estimates from other team members for completeness and accuracy; Work with the Cluster technical staff to identify performance and/or availability issues for the code drop/code release developed and provide solutions; Lead development activities during the defect resolution cycle during the acceptance test Obtain Client or Cluster application architect approval for all code drop/code release changes for assigned application components; Provide a defect free code drop/code release according to the Cluster’s development standards for the assigned application components; Provide quality assurance for the code drop/code release (includes: unit testing, functional testing, load testing, tuning and regression testing, providing defect resolution and a fully tested application component); Provide documented source code for the assigned database, data schema and/or application components and obtain approval, acceptance, and sign-off by the Cluster on the final code drop/code release; Obtain acceptance and approval by the Cluster and the project team for all assigned deliverables; Ensure all artefacts / deliverables are in compliance with Government of Ontario – Information Technology Standards (GO ITS) 54 Standards; Actively participate in and contribute to regular project team meetings to provide status updates, raise risks/issues, and provide recommendations Lead workshops, demos, and/or other sessions and when required to facilitate and lead meetings; Provide weekly report confirming status of the assigned tasks Experience and Skill Set Requirements Very strong technical experience/skills in Database: Oracle Enterprise Edition preferred Database Design Tool: Oracle Designer preferred Development/Programming Language: Java Enterprise, Java, JavaScript, VB Script, HTML, DHTML, XML, JSON, AJAX, JDBC/SQL, NoSQL Strong experience with ETL Tools/Software (e.g.

Informatica) Experience with designing/developing/implementing data models, data schemas Experience performing data mapping Strong experience/knowledge in PL/SQL Experience interfacing with relational databases Experience with data/application security Nexus is one of North America’s leaders in the provision of technology staff augmentation and strategic resource consulting.

With a team of talented professionals using best of breed methodologies, Nexus consistently over delivers with quick, quality and trusted results to its clients and consultants.