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
·
· 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 (e.g. InfoSphere, Informatica etc) andprogramming
· Experience andproficient in developing SQL*Loader scripts, optimized PL/SQL, complex querieswith SQL, Unix/Linux scripts (e.g. 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 (e.g. InfoSphere, Informatica etc) andprogramming
· Experience andproficient in developing SQL*Loader scripts, optimized PL/SQL, complex querieswith SQL, Unix/Linux scripts (e.g. 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
Requirements
Technical Skills
· Experience and knowledgewith Siebel and PowerBI
· Extensive experience inadministrating Oracle 12c on Linux/Windows and database performance tuning
· Experience with dataquality technologies and tools such as Infosphere and Informatica and theinstallation of the tools
· Experience in databasemigration, setup and management of on Premise, Cloud or Hybrid environments
· Experience andproficient in ETL technology, tools and programming
· Experience andproficient in developing PL/SQL, complex queries with SQL, Unix/Linux scripts(e.g. Perl), Excel and one or more other programming language
Nice to Have:
· Public Sector
