Talent.com

Oracle dba Jobs in Prince Edward, ON

Last updated: 10 hours ago
  • Promoted
Specialized IT Consultant – Senior

Specialized IT Consultant – Senior

2iResourcingON, Canada
Full-time
If interested, please share your latest resume at.RQ08199 - Specialized IT Consultant – Senior.Ministry of Public and Business Service Delivery and Procurement. Candidate must be able to work 3 days...Show moreLast updated: 3 days ago
Forgerock Developer

Forgerock Developer

Infinity SolutionsON, Canada
Full-time
Quick Apply
Skills and Responsibilities : Strong IAM experience (8+ years) with Authentication, Authorization and Federation, LDAP Experience in administration and migra...Show moreLast updated: 2 days ago
Oracle OTM Developer / Designer

Oracle OTM Developer / Designer

Juventus ConsultingOntario
This contract opportunity is for 5 months, the end client is in BC, with locations in Memphis, TN.Per Diem expenses range from 60 to 100 USD, depending on travel location.Some remote work is possib...Show moreLast updated: 30+ days ago
RQ08372 - Technology Architect - Senior

RQ08372 - Technology Architect - Senior

S M Software Solutions IncON, CA
Full-time
Quick Apply
We have received a new requirement from one of the ministries in Ontario.Please refer to the details provided below : We are unable to submit a candidate without below mandatory documents.Please ens...Show moreLast updated: 4 days ago
JPC - 1322 - Business Systems Analyst (BSA)

JPC - 1322 - Business Systems Analyst (BSA)

ITS GlobalOntario
CA$93.79–CA$94.40 hourly
Our Client is hiring a Business Systems Analyst to work with our product managers, user experience designers, architects, developers, test teams, and vendors to elicit solutions that support the on...Show moreLast updated: 30+ days ago
  • Promoted
NoSQL DBA Lead

NoSQL DBA Lead

InnovectureOntario, Canada
Full-time
At least 2+ years of experience as a manager and 8+ years of senior DBA position working with MongoDB technology.PostgreSQL experience will be good to have along with other database technologies.Ex...Show moreLast updated: 7 days ago
AWS RDS DBA

AWS RDS DBA

Emonics LLCOntario, Canada
CA$30.00–CA$40.00 hourly
Design, engineer, and deploy on a breadth of RDBMS and NoSQL database technologies and platforms like AWS RDS, Redshift, DynamoDB, DocumentDB, Neptune, PostgreSQL, MongoDB, Db2 LUW, SQL Server, Ora...Show moreLast updated: 30+ days ago
  • New!
Database Administrator - Intermediate

Database Administrator - Intermediate

Cleo ConsultingON, Canada
Full-time
Quick Apply
Assignment : RQ00249 - Database Administrator - Intermediate Requisition : RQ00249 Job Title : Database Administrato...Show moreLast updated: 10 hours ago
  • Promoted
Program Manager

Program Manager

AdeccoOntario, Canada
Adecco is hiring an experienced.This role is pivotal in driving enterprise-wide ERP, PLM, CPQ, and CX implementations.As a Program Manager, you will lead large-scale IT and business transformation ...Show moreLast updated: 23 days ago
  • Promoted
Plant Controller

Plant Controller

Agropur CooperativeGolden Horseshoe, ON, Canada
The role, as a business partner to the manufacturing operational team, ensures the accuracy of financial information, helps to understand the financial results, optimizes operations, and assists wi...Show moreLast updated: 9 days ago
  • Promoted
Applications Architect (RQ08380) Ministry of Transportation

Applications Architect (RQ08380) Ministry of Transportation

Softline Technology Inc.ON, Canada
Full-time
The Application Architect will be responsible for the following activities and deliverables : .Develop, recommend, implement, and manage the application architecture (hardware, software, database, an...Show moreLast updated: 2 days ago
  • Promoted
System Developer

System Developer

ASUSOntario, Canada
Established in 1989, ASUS is a multinational company known for the world’s best motherboards and high-quality laptops, smartphones, monitors, graphics cards, routers and other technology solutions....Show moreLast updated: 16 days ago
Intern / Co-op – Learning Advisor Consultant - Fall Term (September – December 2024)

Intern / Co-op – Learning Advisor Consultant - Fall Term (September – December 2024)

OracleON, Canada
CA$45.00 hourly
Intern / Co-op – Learning Advisor Consultant – Fall Term (September – December 2024).Do you have an educational background in business or psychology? . Are you looking to build your training skills to...Show moreLast updated: 30+ days ago
Sr NoSQL Database Analyst

Sr NoSQL Database Analyst

hays-gcj-v4-pd-onlineOntario
CA$66.00 hourly
Our client is a Canadian financial servicespany.It is primarily known as a life insurancepany.Our client has a presence in investment management with over CAD$1. The candidate will be a member of a ...Show moreLast updated: 30+ days ago
HRFS Delivery Analyst -

HRFS Delivery Analyst -

AlightOntario, CA
CA$82,500.00 yearly
HRFS Delivery Analyst works as part of a team performing Application Data Maintenance for our clients.The Delivery Analyst may attend client calls or meetings in a supporting role to a Functional L...Show moreLast updated: 30+ days ago
Application Programmer

Application Programmer

York UniversityOntario, Canada
CA$80,992.00 yearly
Reporting to the Manager of Library Digital Systems and Initiatives, this role will work independently or as a part of a team to coordinate projects, research solutions, develop, design, implement ...Show moreLast updated: 30+ days ago
QA 6264-22

QA 6264-22

FoilconLa Gran YajaToronto, Ontario, Canada
CA$43.00 hourly
HM Note : This hybrid role is three (3) days in the office.Help organization transform way of doing QA.Transform from a manual environment to automated test framework. Not just focused on execution -...Show moreLast updated: 30+ days ago
Tax Manager - Indirect Tax

Tax Manager - Indirect Tax

Regal Executive SearchOntario, CA
CA$90,000.00 yearly
Our client, a leading bottled beverage manufacturer in the U.We are seeking an Indirect Tax Manager to join their team.The Indirect Tax Manager plays a critical role in all aspect of indirect tax c...Show moreLast updated: 30+ days ago
Oracle EBS Consultant

Oracle EBS Consultant

eTeamRemote, ON
CA$40.00–CA$45.00 hourly
Remote
Proficient in Oracle R Platform for Accounts Payable and Fixed Assets module.Good working experience with DB and integration knowledge with Oracle EBS. Proficient in SQL and relational modeling for ...Show moreLast updated: 30+ days ago
Sales Associate

Sales Associate

CB CanadaOntario, Canada
CA$17.50 hourly
Join WIRELESSWAVE, a subsidiary of Glentel.We are proud to be recognized as 2022 Best Place to Work by HR Director Magazine. Have you ever wanted a career that offers you an opportunity to build con...Show moreLast updated: 30+ days ago
Specialized IT Consultant – Senior

Specialized IT Consultant – Senior

2iResourcingON, Canada
3 days ago
Job type
  • Full-time
Job description

If interested, please share your latest resume at [email protected] / [email protected]

RQ08199 - Specialized IT Consultant – Senior

Client : Ministry of Public and Business Service Delivery and Procurement

Period : 12 months

Start Date : 2025-04-01

End Date : 2026-03-31

Working Hrs. : 7.25 Hrs. / day

Location : 777 Bay St

Hybrid : Candidate must be able to work 3 days onsite and 2 days remote.

Assignment Type : This position is currently listed as "Hybrid" as consultants may be required to work partly in the physical workplace and partly remotely. The details of this arrangement will be at the Hiring Manager's discretion.

Must Have :

  • Demonstrated development and solution design experience in an environment where Oracle, Informatica and Cognos are used together.
  • Demonstrated experience designing, developing, and implementing Informatica ETL solutions.
  • Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
  • Demonstrated experience in coordinating and planning for the modernization of large, complex multi-platform, multi-tier information technology systems, particularly in ETL design, data migration, and Fabric Data Factory integration.

Description

Evaluation Project Requirements Evaluation Breakdown

Technical Skills - 45%

  • Working knowledge of the entire Data Dictionary, data mapping.
  • Working knowledge of the Business Process Design Re-engineering for applications.
  • 5+ years of demonstrated experience and skills using Oracle Data Integrator and / or Informatica ETL tools.
  • Experience enhancing performance of ETL code and SQL Queries.
  • Experience developing ETL routines using Informatica and / or SSIS in a data warehousing environment or large data migration.
  • Experience Designing Data warehouse components and ETL Scripts.
  • Experience using PowerDesigner to review data models, as well as make changes and generate DDL's.
  • 5+ years of experience with Unix scripting.
  • Experience working with Oracle Databases (version 10.x or higher), DB2 Database, and with complex korn-shell scripts.
  • Experience in designing RDBMS SQL, DML and DDL (DB2 and Oracle) and the architectural implications associated with each platform in regards to ETL.
  • Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components.
  • Experience in developing the Application Code package using MS Visual Source Safe. Demonstrated experience performing system testing, unit testing, and user acceptance testing.
  • Demonstrates development and solution design experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence.
  • Demonstrate experience designing, developing and implementing Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
  • Experience in leading development and modelling of applications, specifically hierarchical data model applications.
  • Core Skills - 35%

  • Experience performing the design of data warehouse and related components, including working knowledge of SQL Server, Oracle SQL, PL / SQL, and their optimization techniques.
  • Experience with systems design and development, and related methods, techniques, practices and standards.
  • Working Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure support projects.
  • Experience documenting application designs and specifications, and drafting policies and procedures for ETL processes and Power BI-compatible formats.
  • Working knowledge of aggregate reporting and ETL processes, specifically using tools like Informatica, SSIS , and Fabric Data Factory.
  • Troubleshooting of production issues and creating fixes for any unplanned deployments.
  • Defect investigation, resolution and assignment to team members using defect / issue management tools, e.g. Client ALM or Client Service Manager.
  • Demonstrated experience in coordinating and planning for the modernization of large, complex multi-platform, multi-tier information technology systems, particularly in ETL design, data migration, and Fabric Data Factory integration.
  • Proven experience using a variety of methodologies to carry-out the software development lifecycle (e.g., Agile, waterfall, etc.).
  • Communication Skills - 15%

  • Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications.
  • Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives.
  • Public Sector Experience - 5%

  • Previous public sector experience in an organization of equivalent size.
  • J-18808-Ljbffr