Job Title

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 consultants 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 highvolume and highperformance 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 onPremise, Cloud or Hybrid environments. Experience and knowledge on Cloud technology and solution including data transfer between onPremise and Cloud. Experience with the Application Lifecycle Management (ALM) Tool. Proven extensive experience with highvolume 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 problemsolving skills to analyze and interpret data. Excellent analytical, problemsolving and decisionmaking 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. #J-18808-Ljbffr