RQ04205 - Database Administrator - Senior

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
30+ days ago