Movojobs
Back to results

Added

Closed listing

New Value Solutions

Oracle Database Modeller (D#5547)

  • Ottawa, ON, Canada

Contract

This opening has closed.

The original listing is kept below for reference.

Find open jobsMore jobs with this employer
About employer

Job details

Job type
Contract
Closing date
Experience
Minimum 10 years of experience within the past 15 years working as a software developer, database modeller and/or database administrator.
Posting language
English
Posted

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

New Value Solutions, a national IT consulting company, is seeking a Senior Oracle Database Modeller for a long-term engagement. The successful candidate will have extensive Oracle database experience with particular strength in data modelling, PL/SQL development, database performance optimization and data integration.

This is a hybrid engagement supporting a client in the National Capital Region (NCR), and may include substantial onsite work.

Responsibilities

  • Design and maintain conceptual, logical and physical data models for Oracle databases.
  • Develop and maintain complex SQL queries and Oracle PL/SQL stored procedures, functions, packages and triggers.
  • Analyze and optimize database performance, including query tuning and indexing.
  • Identify and resolve database performance bottlenecks using appropriate monitoring and diagnostic tools.
  • Support extraction, transformation and loading of data between relational database systems.
  • Use Oracle development and data modelling tools to support database design and maintenance.

Requirements

  • Minimum 10 years of experience within the past 15 years working as a software developer, database modeller and/or database administrator.
  • Minimum 3 years within the past 5 years developing and maintaining Oracle databases, including complex SQL and Oracle PL/SQL stored procedures, functions, packages and triggers.
  • Strong experience designing conceptual, logical and physical data models for Oracle databases.
  • Strong Oracle SQL and PL/SQL development experience.
  • Experience with database performance optimization, query tuning and indexing.
  • Post-secondary degree or diploma in engineering, science, computer science, mathematics or a technology domain.

Preferred

  • Experience performing ETL activities between relational database systems.
  • Experience with Microsoft Access, Microsoft Azure DevOps, Oracle SQL Developer and/or Oracle SQL Developer Data Modeller.
  • Aviation or aerospace experience.

If you have the necessary expertise and are able to work in Canada, please submit your resume. While we thank all candidates in advance for their application, only those shortlisted will be contacted.

ID# 5547

About employer
More about this job

Responsibilities

Design and maintain conceptual, logical, and physical Oracle database models, and develop complex SQL queries and PL/SQL database objects. Optimize database performance, diagnose bottlenecks, and support data extraction, transformation, and loading between relational database systems.

Requirements

Requires at least 10 years of relevant software development, database modelling, or database administration experience, including at least 3 recent years developing and maintaining Oracle databases with complex SQL and PL/SQL. Candidates must have strong Oracle data modelling and performance optimization experience, plus a post-secondary degree or diploma in a relevant technical field; ETL, specified database tools, and aviation or aerospace experience are preferred.

Skills

  • Oracle Database Modelling
  • Oracle SQL
  • PL/SQL Development
  • Conceptual, Logical, And Physical Data Modelling
  • Database Performance Optimization
  • Query Tuning
  • Indexing
  • Performance Bottleneck Analysis
  • SQL Queries
  • Stored Procedures
  • Functions
  • Packages
  • Triggers
  • ETL
  • Data Integration
  • Database Monitoring And Diagnostics

Visa sponsorship

Not detected in the job text

Categories

  • Technology
  • Data & Analytics
  • Software
  • Consulting

Keywords

  • Oracle Database
  • Oracle SQL
  • PL/SQL
  • Data Modelling
  • Conceptual Data Models
  • Logical Data Models
  • Physical Data Models
  • Stored Procedures
  • Functions
  • Packages
  • Triggers
  • Database Performance Optimization
  • Query Tuning
  • Indexing
  • Performance Monitoring
  • Diagnostic Tools
  • ETL
  • Data Integration
  • Relational Databases
  • Microsoft Access
  • Microsoft Azure DevOps
  • Oracle SQL Developer
  • Oracle SQL Developer Data Modeller
  • Aviation
  • Aerospace

Report this job