RQ04205 - Database Administrator - Senior
RQ04205 - Database Administrator - Senior
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 consultantsdeliverable 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 configurereorganize 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 PerlJava 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
Walkthrough sessions
Estimated CompletionDate
Throughout the project
Skill Set Requirements:
Proven extensiveexperience in designing deploying administrating and tuning high volume andhighperformance 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 sourcesdata 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 problemsolving skills to analyze and interpretdata
Excellent analyticalproblemsolving and decisionmaking 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 andhighperformance 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 sourcesdata 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 analyticalproblemsolving and decisionmaking 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
Required Experience:
Unclear Seniority
Employment Type
Contract
