Daniel Viel

Experience

• 

  PCD Solutions

  Jun 2001 - Jul 2006

  Oracle DBA

  Oracle Databases installation, upgrade, configuration and migration Design, develop and implement backup and recovery strategy with RMAN under many media managementInstall and configure Oracle9i and 10g RAC (Real Application Cluster) on AIX, Linux and HP-UXInstall and configure Oracle in AIX-HACMP, HP-UX MC-ServiceGuard and Windows FailSafe a DRP/HA environment.Perform Database tuning and optimization.Design, develop and implement database monitoring and tuning toolsProvide technical assistance to system administrator, sale representatives and customersPerform database restore and recovery after system failures.Data recovery and reconstruction from corrupted export files and corrupted blocksBackup and alert Log monitoringPatch installation Show less

• 

  CGI

  Aug 2006 - Apr 2014

  Oracle DBA

  Perform Oracle Database, applications, stored procedures and SQL statements tuningDesign, develop and implement Online Backup and Recovery strategy and procedure with RMAN.Design, develop and implement Replication Management procedures.Perform Database Security and Data integrity ManagementDesign, develop and implement database monitoring and tuning toolsPerform Oracle Databases installation, configuration, upgrades and migrationsClone Production database to development and QA environmentsDesign, develop and implement application using Oracle APEXProvide leadership, mentoring and coaching in database design, development and management to other DBA team members and developers Show less

• 

  Atvent Solutions

  Apr 2014 - Jun 2016

  Oracle DBA

  Provided Oracle DBA support on many platforms performing applications and databases tuning, developing backup and recovery strategy, and anticipating reliability, availability, performance and security issues. Also performed Oracle database installations, upgrades, and migrations, and planned activities to automate database administration tasks and developed database administration tools.Perform Applications, stored procedures and SQL statements tuningPerform Oracle Database tuningPerform Oracle Databases installation, configuration, upgrades and migrationsPerform patch installationDesign, develop and implement Online Backup and Recovery strategy and procedure with RMAN.Design, develop and implement Replication proceduresDesign, develop and implement DataGuard disaster and recovery plan on SolarisPerform Database Security and Data integrity ManagementDesign, develop and implement database monitoring and tuning toolsClone Production database to development, test and QA environmentsProvide leadership, mentoring and coaching in database design, development and management to developers team membersDevelop and maintain installation and upgrade procedure for the multiple application versions.Maintain performance, accessibility, and Oracle server stability Show less

• 

  Desjardins

  Jul 2016 - Aug 2017

  Oracle DBA

  Provide Oracle DBA support for the Operation group at Desjardins performing the following tasks:Perform Oracle Databases creation, configuration, upgrades and migrationsPerform patch installation Design, develop and implement Online Backup and Recovery strategy and procedure with RMAN on CommVault media Manager.Perform Applications, stored procedures and SQL statements tuningImplement DataGuard disaster and recovery plan on LinuxPerform Database Security and Data integrity ManagementDesign, develop and implement database monitoring and tuning tools Clone Production database to development, test and QA environmentsMaintain performance, accessibility, and Oracle server stability Show less

• 

  National Bank of Canada

  Sept 2017 - May 2018

  Oracle DBA

  Provide Oracle DBA support for the BI Operation group at National Bank Of Canada performing the following tasks:Perform Oracle Databases configuration, upgrades and migrationsPerform GRID infrastructure configurationPerform Applications, stored procedures and SQL statements tuningPerform Oracle Database tuningDevelop Oracle Database monitoring toolsProvide Oracle Service Request supportClone Production database to development, test and QA environmentsProvide leadership, mentoring and coaching in database design, development and management to DBAs and developers.Maintain performance, accessibility, and Oracle server stability Show less

• 

  CGI

  Jun 2018 - now

  SAM (Software Asset Management) Senior Consultant at CGI in the CIO Team

  Design, Develop & Implement an ELP (Effective License Position) Application to complement FNMS (FlexNet Manager Suite). Perform Oracle Databases installation, configuration, upgrades and migrations Design, develop and implement Online Backup and Recovery strategy and procedure with RMAN. Maintain performance, accessibility, and Oracle server stability. Perform Applications, stored procedures and SQL statements tuning. Perform Oracle Database tuningDesign, Develop & Implement ETL (Extract Transform and Load) to feed FNMS Data to the ELP.Design, Develop & implement Hardware & Software Manual Data Entry in the ELP.Design, Develop & implement an Oracle license Consolidation System to defend against Oracle GLAS (Global Licensing Advisory Services) audits.Provide Oracle SME (Subject Matter Experts) function support in Oracle Program Licensing with informed decisions on Oracle licensing rules and policies into managing Oracle software assets.Ensure software compliance, perform license reconciliations, and manage licensing models and contracts.Ensure clear, concise, and effective communication, making complex technical information understandable and actionable.Perform Oracle ULA Global Deployment Exit (Certification).Provide Oracle Post ULA Certified License Pool allocation & compliance monitoring.Perform Oracle Licensing optimization with expertise in IT technologies, including hardware, software systems, network infrastructure, virtualization, and cloud computing.Provide SAM (Software Asset Management) integration support to FNMS. Provide ongoing education on Oracle licensing and best practice to the ITAM (IT asset management) Team and CGI’s members.Provide understanding of the common pitfalls and areas of risk in Oracle license estate.Provide appropriate action plans to improve processes and internal controls on Oracle licensing.Establish a CGI Policy on Java programming language installation. Show less