Senior Oracle Data Migration Engineer (Hybrid)

Kardow; Ottawa; Hybrid; CAD 110,000 - 150,000; Full time

Job summary

New Value Solutions seeks a Senior Oracle Data Migration Developer for a long-term federal government engagement. The role requires extensive software/database development with recent Oracle data migration expertise and strong database programming skills. Experience with MS Access/VBA applications is highly valuable.

The position is a hybrid engagement servicing a client in the National Capital Region (NCR) and may include substantial onsite work.

Qualifications

• Minium 10 years of software development or database modeling in the last 15 years.
• Minimum 1 year in past 5 years migrating data to Oracle environments.
• Strong data migration experience: ETL/ELT, mapping and load.

Responsibilities

• Migrate data from files, legacy systems and relational databases into Oracle environments.
• Extract, transform, map and load data into Oracle staging/production.
• Develop and maintain queries, stored procedures, functions, and triggers.
• Support DB development with Oracle PL/SQL and/or MS SQL Server T-SQL.
• Develop and troubleshoot Access applications with VBA.
• Support Oracle APEX development as needed.
• Ensure data quality and integrity throughout migration activities.

Skills

Oracle PL/SQL

SQL Server T-SQL

Data migration

Access VBA

Azure DevOps

Education

Post-secondary degree in engineering, science, CS, math or technology

Tools

Oracle SQL Developer

Azure DevOps

APEX Office Print

Job description

New Value Solutions seeks a Senior Oracle Data Migration Developer for a long-term federal government engagement. The role requires extensive software/database development with recent Oracle data migration expertise and strong database programming skills. Experience with MS Access/VBA applications is highly valuable.

The position is a hybrid engagement servicing a client in the National Capital Region (NCR) and may include substantial onsite work.