Recherche d'emploi > Toronto, ON > Temporaire > Database administrator

RQ04205 - Database Administrator - Senior

Yoush Consulting
Toronto, Ontario, Canada
41,5 $ / heure (estimé)
Temps plein

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
  • Il y a plus de 30 jours
Emplois reliés
SIX Payment Services
Canada

Worldline is hiring a senior database administrator to join our North America IT operations team. As a Worldline DBA, you will be a critical member of the team managing our production and non-production databases. You will build, configure, and optimize SQL Server database engines in a variety of en...

Maarut Inc
Toronto, Ontario

Experience and Skill Set Requirements: Must Haves: At least 10years of relevant experience as a Database Administrator Experiencein database replication / Real-Time data delivery with either MSSQLor Oracle products (5+ years) Experience administering Oracle 12C+,MSSQL, Azure SQL, Elastic Pools, SQLM...

BMO Financial Group
York, Ontario

Understands data in terms of its business and technical lifecycle (Create, Release, Update, and Delete), technical underpinnings of database theories (e. Assists in creation, implementation/installation, configuration, change, and support of data models, databases, data marts, data warehouses. Proac...

Global Technical Talent
Toronto, Ontario

Create physical database designs, operate and administer the database management system (DBMS) including database optimization, performance tuning, backup, and recovery. The consultant will be responsible for creating physical database designs and operating and administering the database management ...

Randstad Canada
Toronto, Ontario

Title: Database Administrator_ Senior. At least 10 years of relevant experience as a Database Administrator. Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support. Experience...

PET VALU
Markham, Ontario

A hands-on Senior Database Administrator who thrives in a dynamic work environment. This role involves working with other database service team members, cross-functional IT and business team members to ensure high security, high availability, high performance Pet Valu databases, including but not li...

BMO
Toronto, Ontario

Applies expertise to transform from on-premise databases to cloud data services and leverages cloud database technologies available (e. Manages and maintains enterprise databases, adhering to data governance and management policies. Designs databases that follow standards for data integrity, structu...

Randstad Canada
Toronto, Ontario

Title: Database Administrator_ Senior. At least 10 years of relevant experience as a Database Administrator. Creation of functional and technical specifications for database development, analyze requirements and help project team in solution, technical design, implementation, and support. Experience...

Motorola Solutions
Toronto, Ontario
Télétravail

Being a critical member of the Infrastructure team as a database administrator overseeing production and non-production databases. Database lifecycle & management: database health and security, upgrades, archiving, capacity management, high availability, backup and DR recovery procedures are all bui...

PeopleToGo
Toronto, Ontario

One (1) Senior Database Administrator,. Role: Senior Database Administrator. Informix Database Administrator (designing, developing, installing, configuration). Install and configure various types of databases. ...