Welcometo Yoush Consulting. Are you an independent IT Consultant or wish to becomeone?
Areyou looking to partner with an organization that presents you to consultingopportunities 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 PerformanceStatus Report
Deliverables
- All deliverables thatconsultant worked on during past month are included
- Progress and specificaccomplishment against the deliverable are described
- Status of consultant’sdeliverable compared to the project Baseline
Estimated CompletionDate
Monthly
Task 2
Manage and administerthe database and application servers used to support the Driver& Vehicledata quality analysis activities.
Deliverables
- Apply database andsystem patches and perform database change management activities
- Create, configure,reorganize, and migrate database / objects
- Conduct databasecapacity planning and database disaster recovery planning
- Design, test, and managedatabase backup and recovery
- Provide support fordevelopment and performance optimization of programs / jobs such as SQL*Loaderjobs, data loading jobs, transformation / ETL jobs, PL / SQL & SQL scripts andUnix / Linus scripts etc
- Provide administrationsupport on application server and the setup & development on IBM InfoSphereor Informatica Data Quality
Estimated CompletionDate
Throughout the project
Task 3
Support the projectdelivery of data extraction, data analysis, data profiling and data cleansingof the Driver & Vehicle data.
Deliverables
- Support project relateddata extraction, profiling and data masking activities
- Liaise with projectstakeholders to analyze data quality issues and provide root cause analysis
- Provide support fordevelopment and performance optimization of programs / jobs such as ETL, Perl,Java, Python and Machine Learning programs etc
Estimated CompletionDate
- According to the projectschedule to be defined by the Project Manager and Technical
- Coordinator
Task 4
Knowledge transfer toministry staffs or resources designated by the ministry
Deliverables
- Documentations
- Walk-through sessions
Estimated CompletionDate
Throughout the project
Skill Set Requirements :
- Proven extensiveexperience in designing, deploying, administrating and tuning high volume andhigh-performance databases
- Proven extensiveexperience in administrating Oracle 12c on Linux / Windows and databaseperformance tuning
- Experience with data qualitytechnologies and tools such as Infosphere, Informatica & OEDQ and theinstallation of the tools
- Experience in databasemigration, setup and management of on Premise, Cloud or Hybrid environments
- Experience and knowledgeon Cloud technology and solution including data transfer between on Premise andCloud
- Experience with theApplication Lifecycle Management (ALM) Tool
- Proven extensiveexperience with high volume data extraction from heterogenous data sources,data loading, data profiling, masking, transformation and cleansing
- Experience andproficient in ETL technology, tools ( InfoSphere, Informatica etc) andprogramming
- Experience andproficient in developing SQL*Loader scripts, optimized PL / SQL, complex querieswith SQL, Unix / Linux scripts ( Perl), Excel and one or more otherprogramming languages
- Experience and knowledgewith Siebel EIM / EAI, OCH, EBS and PowerBI
- Experience with datamodelling, data mining and segmentation techniques
- Knowledge of MachineLearning technology including environment setup, Python / R / Jupiter programmingto perform data analysis
- Strong analyticalskills, critical thinking and problem-solving skills to analyze and interpretdata
- Excellent analytical,problem-solving and decision-making skills : verbal and written communicationskills : interpersonal and negotiation skills
- Ability to workindependently and with good quality on concurrent multiple projects
Experience and Skill SetRequirements
Data Base AdministrationExperience - 30%
- Proven extensiveexperience in designing, deploying, administrating and tuning high volume andhigh-performance databases
- Proven extensiveexperience in administrating Oracle 12c on Linux / Windows and databaseperformance tuning
Data Quality Tools andEnvironments - 25%
- Experience with dataquality technologies and tools such as Infosphere, Informatica & OEDQ andthe installation of the tools
- Experience in databasemigration, setup and management of on Premise, Cloud or Hybrid environments
- Experience with theApplication Lifecycle Management (ALM) Tool
- Experience and knowledgeon Cloud technology and solution including data transfer between on Premise andCloud
Data Cleansing andTransformation Experience - 25%
- Proven extensiveexperience with high volume data extraction from heterogenous data sources,data loading, data profiling, masking, transformation and cleansing
- Experience andproficient in ETL technology, tools ( InfoSphere, Informatica etc) andprogramming
- Experience andproficient in developing SQL*Loader scripts, optimized PL / SQL, complex querieswith SQL, Unix / Linux scripts ( Perl), Excel and one or more otherprogramming languages
- Experience and knowledgewith Siebel EIM / EAI, OCH, EBS and PowerBI
- Experience and goodknowledge with data modelling, data mining and segmentation technique
- Knowledge of MachineLearning technology including environment setup, Python / R / Jupiter programmingto perform data analysis
Problem Solving andCommunication - 20%
- Excellent analytical,problem-solving and decision-making skills : verbal and written communicationskills : interpersonal and negotiation skills
- Ability to workindependently and with good quality on concurrent multiple projects