Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailAre 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
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
Full Time