13 Aug
|
Yoush Consulting
|
Toronto
13 Aug
Yoush Consulting
Toronto
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 workplace 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.
📌 Database Administrator - Senior (Toronto)
🏢 Yoush Consulting
📍 Toronto