RQ04205 - Database Administrator - Senior

Welcometo Yoush Consulting. Are you an independent IT Consultant or wish to become

one?

Are

you looking to partner with an organization that presents you to consulting

opportunities and supports you as a partner?

4318 - Database Administrator - Senior - 1 Year Contract - Hybrid Work - Toronto

We are seeking the services of one (1) Senior Database Administrator.

Essential technologies experience :

Task 1

• Monthly Performance

Status Report

Deliverables

consultant worked on during past month are included

accomplishment against the deliverable are described

deliverable compared to the project Baseline

Estimated Completion

Date

Task 2

the database and application servers used to support the Driver& Vehicle

data quality analysis activities.

Deliverables

system patches and perform database change management activities

reorganize, and migrate database / objects

capacity planning and database disaster recovery planning

database backup and recovery

development and performance optimization of programs / jobs such as SQL

jobs, data loading jobs, transformation / ETL jobs, PL / SQL & SQL scripts and

Unix / Linus scripts etc

support on application server and the setup & development on IBM InfoSphere

or Informatica Data Quality

Estimated Completion

Date

Task 3

delivery of data extraction, data analysis, data profiling and data cleansing

of the Driver & Vehicle data.

Deliverables

data extraction, profiling and data masking activities

stakeholders to analyze data quality issues and provide root cause analysis

development and performance optimization of programs / jobs such as ETL, Perl,

Java, Python and Machine Learning programs etc

Estimated Completion

Date

schedule to be defined by the Project Manager and Technical

Task 4

ministry staffs or resources designated by the ministry

Deliverables

Estimated Completion

Date

Skill Set Requirements :

experience in designing, deploying, administrating and tuning high volume and

high-performance databases

experience in administrating Oracle 12c on Linux / Windows and database

performance tuning

technologies and tools such as Infosphere, Informatica & OEDQ and the

installation of the tools

migration, setup and management of on Premise, Cloud or Hybrid environments

on Cloud technology and solution including data transfer between on Premise and

Cloud

Application Lifecycle Management (ALM) Tool

experience with high volume data extraction from heterogenous data sources,

data loading, data profiling, masking, transformation and cleansing

proficient in ETL technology, tools ( InfoSphere, Informatica etc) and

programming

proficient in developing SQL

with SQL, Unix / Linux scripts ( Perl), Excel and one or more other

programming languages

with Siebel EIM / EAI, OCH, EBS and PowerBI

modelling, data mining and segmentation techniques

Learning technology including environment setup, Python / R / Jupiter programming

to perform data analysis

skills, critical thinking and problem-solving skills to analyze and interpret

data

problem-solving and decision-making skills : verbal and written communication

skills : interpersonal and negotiation skills

independently and with good quality on concurrent multiple projects

Experience and Skill Set

Requirements

Data Base Administration

Experience - 30%

experience in designing, deploying, administrating and tuning high volume and

high-performance databases

experience in administrating Oracle 12c on Linux / Windows and database

performance tuning

Data Quality Tools and

Environments - 25%

quality technologies and tools such as Infosphere, Informatica & OEDQ and

the installation of the tools

migration, setup and management of on Premise, Cloud or Hybrid environments

Application Lifecycle Management (ALM) Tool

on Cloud technology and solution including data transfer between on Premise and

Cloud

Data Cleansing and

Transformation Experience - 25%

experience with high volume data extraction from heterogenous data sources,

data loading, data profiling, masking, transformation and cleansing

proficient in ETL technology, tools ( InfoSphere, Informatica etc) and

programming

proficient in developing SQL

with SQL, Unix / Linux scripts ( Perl), Excel and one or more other

programming languages

with Siebel EIM / EAI, OCH, EBS and PowerBI

knowledge with data modelling, data mining and segmentation technique

Learning technology including environment setup, Python / R / Jupiter programming

to perform data analysis

Problem Solving and

Communication - 20%

problem-solving and decision-making skills : verbal and written communication

skills : interpersonal and negotiation skills

independently and with good quality on concurrent multiple projects