Senior Database Administrator

Yoush Consulting; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A consulting firm in Toronto is seeking a Senior Database Administrator for a 1-year hybrid contract. The successful candidate will manage databases, conduct performance tuning, and support data quality analysis. Key skills include extensive experience with Oracle 12c, proficiency in ETL technologies, and knowledge of data modeling. The role requires strong analytical capabilities and the ability to handle multiple projects simultaneously, ensuring high performance and quality control in a data-centric environment.

Qualifications

• Extensive experience in designing, deploying, and administrating high-volume databases.
• Proven experience with Oracle 12c performance tuning.
• Knowledge of ETL technologies and data quality tools.

Responsibilities

• Administer and manage the database and application servers.
• Support data extraction, analysis, and cleansing.
• Conduct capacity planning and database disaster recovery.

Skills

Database administration

SQL

ETL

Oracle 12c

Data quality technologies

Cloud technology

Machine Learning

Tools

Infosphere

Informatica

PowerBI

Job description

RQ04205 - Database Administrator - Senior

We are seeking the services of one (1) Senior Database Administrator for a 1 Year Contract – Hybrid Work – Toronto.

Task 1

• Monthly Performance Status Report
• 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 Baseline

Task 2

• Manage and administer the database and application servers used to support the Driver & Vehicle data quality analysis activities.
• 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/Linux scripts etc.
• Provide administration support on application server and the setup & development on IBM InfoSphere or Informatica Data Quality.

Task 3

• Support the project delivery of data extraction, data analysis, data profiling and data cleansing of the Driver & Vehicle data.
• 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 etc.
• According to the project schedule to be defined by the Project Manager and Technical.

Task 4

• Knowledge transfer to ministry staffs or resources designated by the ministry.
• Documentation.
• Walk-through sessions.

Skill 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 heterogeneous data sources, data loading, data profiling, masking, transformation and cleansing.
• Experience and proficiency in ETL technology, tools (e.g. InfoSphere, Informatica etc.) and programming.
• Experience and proficiency 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 modeling, data mining and segmentation techniques.
• Knowledge of Machine Learning technology including environment setup, Python/R/Jupyter 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 projects.

Requirements

• Experience and knowledge with Siebel and PowerBI.
• Extensive experience in administering 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 proficiency in ETL technology, tools and programming.
• Experience and proficiency in developing PL/SQL, complex queries with SQL, Unix/Linux scripts (e.g. Perl), Excel and one or more other programming language.