Job Description :Welcome to 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 - TorontoWe are seeking the services of one (1) Senior Database Administrator.Essential technologies experience:Task 1· Monthly Performance Status ReportDeliverables· 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 BaselineEstimated Completion Date· MonthlyTask 2· Manage and administer the database and application servers used to support the Driver& Vehicle data quality analysis activities.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 QualityEstimated Completion Date· Throughout the projectTask 3· Support the project delivery of data extraction, data analysis, data profiling and data cleansing of the Driver & Vehicle data.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 etcEstimated Completion Date· According to the project schedule to be defined by the Project Manager and Technical· CoordinatorTask 4· Knowledge transfer to ministry staffs or resources designated by the ministryDeliverables· Documentations· Walk-through sessionsEstimated Completion Date· Throughout the projectSkill 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 (e.g. InfoSphere, Informatica etc) and programming· Experience and proficient in developing SQL*Loader scripts, optimized PL/SQL, complex queries with SQL, Unix/Linux scripts (e.g. 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 projectsExperience and Skill Set RequirementsData 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 tuningData 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 CloudData 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 (e.g. InfoSphere, Informatica etc) and programming· Experience and proficient in developing SQL*Loader scripts, optimized PL/SQL, complex queries with SQL, Unix/Linux scripts (e.g. 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 analysisProblem 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 projectsRequirementsTechnical 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 (e.g. Perl), Excel and one or more other programming languageNice to Have:· Public Sector
