Sql jobs in Canada

Responsibilities:

Responsible for managing the interchange of data between the server and the users. Required to translate technical systems specifications into working, tested applications. This includes: developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests. Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and

• Experience in programming and analysis; specialized software package support at the specified experience level
• Ability to collaborate with IT Professionals throughout the Software Development Life Cycle
• Experience in structured methodologies for the development, design, implementation and maintenance of applications
• Experience in design, code, test, debug and document applications
• Experience in the use of object and/or third generation language development tools
• Experience in one or more programming languages
• Experience in application design, latest design patters, deployment and troubleshooting
• Experience with relational and hierarchical database technologies
• Experience in the use of information retrieval packages using query languages
• Experience with one or more communications protocols
• Experience in structured methodologies for the design, development, implementation and maintenance of applications
• Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts
• Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
• A team player with a track record for meeting deadlines

Knowledge and experience with developing all server-side logic, definition and maintenance of the central database, and ensure high performance and responsiveness to requests from the front-end. Knowledge and experience with front-end technologies. Knowledge and experience to integrate the front-end elements into the application.

• Knowledge and experience with programming Internet-ready applications
• Knowledge and experience in rapid application development (RAD) methodologies
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Experience with middleware and gateways
• Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging
• Ability to provide post-implementation support and resolve any post-implementation technical issues
• Experience conducting design walkthrough sessions with project team
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
• Ability to provide user and system documentation as required

The consultant must have the following number of years experience with the tools and/or products:

• Oracle 12C or higher – 10+
• DB SQL including DB Objects such as Tables, Views, Sequences, Store Procedure, Functions, Triggers – 5 Years +
• Node such as NPM – 5+
• RXJS – 5+
• Spring Framework (MVC, Security, JPA, Boot)
• WebSphere v8.5 or higher – 5+
• Bitbucket – 3+
• Experience with AODA/WCAG 2.0 AA – a must
• Experience with Responsive Web application development
• REST API
• Hibernate/JPA
• Maven (a plus)
• Knowledge of security gateways and protocols (JWT, Oauth2.0, SSL Certificates)
• Solid Understanding of Agile
• Knowledge of major architectures style (message oriented, reactive, event based)
• Rest API design and implementation (load balancing, discovery, resiliency)

• Maven
• Knowledge of security gateways and protocols (JWT, Oauth2.0, SSL Certificates)
• Solid Understanding of Agile
• Knowledge of major architectures style (message oriented, reactive, event based)
• Rest API design and implementation (load balancing, discovery, resiliency)

• Java language knowledge and experience - 25%
• 10+ years of demonstrated experience with the use of Java language
• WebSphere v8.5 or higher - 5+
• Hibernate/JPA
• Technical Skills - 40%
• Node such as NPM - 5+
• RXJS - 5+
• Bootstrap, jQuery 3+
• Spring Framework (MVC, Security, JPA, Boot)
• Bitbucket 3+
• Experience with Responsive Web application development
• Maven
• DevOPS
• Oracle database knowledge and experience - 15%
• DB SQL including DB Objects such as Tables, Views, Sequences, Store Procedure, Functions, Triggers 5 Years +
• 10+ years of experience in Oracle database version 11G +
• AODA Experience - 10%
• Experience with AODA/WCAG 2.0 AA a must
• Demonstrated experience with AODA compliance
• Soft Skills - 10%
• Excellent analytical, problem-solving and decision making skills
• Strong leadership and collaboration skills
• Proven track record for building strong working relationships
• A demonstrated team player with a track record for meeting deadlines
• Strong verbal and written communication skills

• Spring Framework (MVC, Security, JPA, Boot)