RQ- Database Administrator - Senior

RQ04205 - Database Administrator - Senior

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

• 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

• 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 Info Sphere or Informatica Data Quality.

• 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.

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

• 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. Info Sphere, 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 Power
  
  BI.
• 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.

• Experience and knowledge with Siebel and Power
  
  BI.
• 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.