RQ04205 - Database Administrator - Senior

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

Essential technologies experience:

Task 1

Monthly Performance Status Report

Deliverables

All deliverables that consultant worked on during past month are included

Progress and specific accomplishment against the deliverable are described

Status of consultant s deliverable compared to the project Baseline

Estimated Completion Date

Monthly

Task 2

Manage and administer the database and application servers used to support the Driver& Vehicle data quality analysis

Deliverables

Apply database and system patches and perform database change management activities

Create, configure, reorganize, and migrate database / objects

Conduct database capacity planning and database disaster recovery planning

Design, test, and manage database backup and recovery

Provide support for development and performance optimization of programs/jobs such as SQL*Loader jobs, data loading jobs, transformation/ETL jobs, PL/SQL & SQL scripts and Unix/Linus scripts etc

Provide administration support on application server and the setup & development on IBM InfoSphere or Informatica Data Quality

Estimated Completion Date

Throughout the project

Task 3

Support the project delivery of data extraction, data analysis, data profiling and data cleansing of the Driver & Vehicle

Deliverables

Support project related data extraction, profiling and data masking activities

Liaise with project stakeholders to analyze data quality issues and provide root cause analysis

Provide support for development and performance optimization of programs/jobs such as ETL, Perl, Java, Python and Machine Learning programs etc

Estimated Completion Date

According to the project schedule to be defined by the Project Manager and Technical

Coordinator

Task 4

Knowledge transfer to ministry staffs or resources designated by the ministry

Deliverables

Documentations

Walk-through sessions

Estimated Completion Date

Throughout the project

Skill Set Requirements:

Proven extensive experience in designing, deploying, administrating and tuning high volume and high-performance databases

Proven extensive experience in administrating Oracle 12c on Linux/Windows and database performance tuning

Experience with data quality technologies and tools such as Infosphere, Informatica & OEDQ and the installation of the tools

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

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

Experience with the Application Lifecycle Management (ALM) Tool

Proven extensive experience with high volume data extraction from heterogenous data sources, data loading, data profiling, masking, transformation and cleansing

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

Experience and proficient in developing SQL*Loader scripts, optimized PL/SQL, complex queries with SQL, Unix/Linux scripts ( Perl), Excel and one or more other programming languages

Experience and knowledge with Siebel EIM/EAI, OCH, EBS and PowerBI

Experience with data modelling, data mining and segmentation techniques

Knowledge of Machine Learning technology including environment setup, Python/R/Jupiter programming to perform data analysis

Strong analytical skills, critical thinking and problem-solving skills to analyze and interpret data

Excellent analytical, problem-solving and decision-making skills: verbal and written communication skills: interpersonal and negotiation skills

Ability to work independently and with good quality on concurrent multiple projects

Experience and Skill Set Requirements

Data Base Administration Experience -30%

Proven extensive experience in designing, deploying, administrating and tuning high volume and high-performance databases

Proven extensive experience in administrating Oracle 12c on Linux/Windows and database performance tuning

Data Quality Tools and Environments - 25%

Experience with data quality technologies and tools such as Infosphere, Informatica & OEDQ and the installation of the tools

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

Experience with the Application Lifecycle Management (ALM) Tool

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

Data Cleansing and Transformation Experience - 25%

Proven extensive experience with high volume data extraction from heterogenous data sources, data loading, data profiling, masking, transformation and cleansing

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

Experience and proficient in developing SQL*Loader scripts, optimized PL/SQL, complex queries with SQL, Unix/Linux scripts ( Perl), Excel and one or more other programming languages

Experience and knowledge with Siebel EIM/EAI, OCH, EBS and PowerBI

Experience and good knowledge with data modelling, data mining and segmentation technique

Knowledge of Machine Learning technology including environment setup, Python/R/Jupiter programming to perform data analysis

Problem Solving and Communication - 20%

Excellent analytical, problem-solving and decision-making skills: verbal and written communication skills: interpersonal and negotiation skills

Ability to work independently and with good quality on concurrent multiple projects

Requirements

Technical Skills

Experience and knowledge with Siebel and PowerBI

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

Experience with data quality technologies and tools such as Infosphere and Informatica and the installation of the tools

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

Experience and proficient in ETL technology, tools and programming

Experience and proficient in developing PL/SQL, complex queries with SQL, Unix/Linux scripts ( Perl), Excel and one or more other programming language

Nice to Have:

Public Sector