Benoit Pelletier

Benoit Pelletier Email and Phone Number

DBA at Immigration and Refugee Board of Canada
Benoit Pelletier's Location
Greater Ottawa Metropolitan Area, Canada
About Benoit Pelletier

I'm a certified Microsoft Database Administrator with a Bachelor’s degree in computer science, and hands-on experience overseeing the design, data modeling, development and maintenance of various database systems for the last 20 years, I enjoy solving large, complex data problems, and feel a sense of accomplishment when a solution is determined and built. I can quickly identify new solutions that will not only help solve major business problems, but also ensure the business maintains local, federal and business sector compliance, due to my extensive research skills and deep industry knowledge.I have analyzed and document requirements, written design specifications and conducted technical knowledge-transfer seminars for all aspects of the conversion process. I have installed, configured, tuned and tested production databases and supported the implementation, monitoring and testing of production database backup and recovery procedures. I have monitored the performance of databases to identify and implement optimization improvements and created SQL Server scripts to perform backup, validate database status, manage logins and manage connections.I have developed database policy, procedures and standards in support of SQL Server and MySQL databases and participated in the design and development of database server architecture. I have the ability to reflect and to plan, to formulate ideas, to prepare architectural plans, to analyze situations and to make recommendations or action plans.

Benoit Pelletier's Current Company Details

DBA at Immigration and Refugee Board of Canada
Benoit Pelletier Work Experience Details
  • Immigration And Refugee Board Of Canada | Commission De L'Immigration Et Du Statut De Réfugié
    Dba/Sql Developer
    Immigration And Refugee Board Of Canada | Commission De L'Immigration Et Du Statut De Réfugié Aug 2019 - Jun 2024
    Ottawa, Canada Area
  • Department Of Justice Canada | Ministère De La Justice Du Canada
    Technical Advisor, Database Administration (Dba)
    Department Of Justice Canada | Ministère De La Justice Du Canada Sep 2017 - Apr 2019
    Ottawa, Canada Area
    Provides technical advice, guidance and assistance to client organisations on IT capabilities and plans that could support the achievement of their strategic, operational and financial program objectives. Conducts cost-benefit analyses to ensure the most effective delivery of services.
  • Canadian Commercial Corporation - Corporation Commerciale Canadienne
    Senior Database Administrator & It
    Canadian Commercial Corporation - Corporation Commerciale Canadienne Sep 2015 - Sep 2017
    Ottawa, Canada Area
    Analyzed database, middle tier, application requirements and participate in the development of effective and efficient database and application solutions for Agresso, BMO, OpenText migration and other projects by optimizing database designs and doing performance tuning to improve efficiency and increase system reliability;
  • Transportation Safety Board Of Canada - Bureau De La Sécurité Des Transports Du Canada
    Dba / Data Conversion Specialist
    Transportation Safety Board Of Canada - Bureau De La Sécurité Des Transports Du Canada Jun 2012 - Mar 2015
    Gatineau
    As a data conversion specialist, the scope of work involved working with the IM/IT Solutions Operations Group to provide day to day operations and maintenance of the database management system environment. In addition, I developed and improved new databases for legacy applications, provided expert advice on database management and designing, developing, testing, execution, and quality assurance of both automated and manual data migration of over 10 million historical records from relational database management system (RDBMS) Oracle to enterprise RDBMS MS SQL 2008 R2 across ASIS and MARSIS projects.
  • Patrimoine Canadien -- Canadian Heritage
    Dba / Data Conversion Specialist
    Patrimoine Canadien -- Canadian Heritage Jun 2011 - May 2012
    Ottawa, Canada Area
    As a data conversion specialist, the scope of work involved migrating over 1 million records in the Virtual Museum of Canada (VMC) and ensuring the integrity of the data quality process (including data cleansing, data validation, data manipulation, data quality tests, data refining, data filtering and tuning). It is a crucial area to maintain to ensure the VMC remains a unique interactive space that brings together Canadian museum collections and riches in a variety of thought-provoking and instructive contents. VMC contains over 500 virtual exhibits promoting the content of Canadian museums and other heritage organizations
  • Export Development Canada | Exportation Et Développement Canada - Edc
    Dba / Data Conversion Specialist
    Export Development Canada | Exportation Et Développement Canada - Edc Mar 2010 - May 2011
    Ottawa, Canada Area
    I worked as a Data Conversion Specialist during the development and implementation of Kamatura Risk Management (KRM), a large and complex enterprise risk management application supported by SQL Server databases. KRM completely integrates credit portfolio management, market risk management, asset and liability management, Basel II and other capital allocation technologies, transfer pricing, and performance measurement by extracting, transform and loading over 10 million records from EDC legacy databases
  • Canadian Air Transport Security Authority
    Dba / Data Conversion Specialist
    Canadian Air Transport Security Authority May 2009 - Feb 2010
    Ottawa, Canada Area
    As a data conversion specialist, I worked to improve the trust factor of business analysts, and continuously monitor the quality of their data, and improve its completeness, correctness, timeliness, accuracy, uniqueness, integrity and relevance in support of two large and complex enterprise software application development solutions: SITT_ADMIN and MMIS_STAGING. These applications process over two million records daily.
  • Canadian Radio-Television And Telecommunications
    Dba / Data Conversion Specialist
    Canadian Radio-Television And Telecommunications Mar 2008 - Mar 2009
    Gatineau
    I administrated enterprise-level SQL Server databases in support of the Data Collection System (DCS) Project, a large and complex enterprise software application development project. The project’s stakeholders were business analysts and over 1000 end users across Canada. As a data conversion specialist, i formulated a data quality strategy that involved data stewards, subject matter experts, the data governance team and decision makers for DCS by profiling enterprise data, framing the quality rule, validating data, analyzing exceptions, cleansing data and standardization, ongoing monitoring and data quality reporting for over 5 million records
  • Statistics Canada
    Dba / Data Conversion Specialist
    Statistics Canada May 1998 - Feb 2008
    Ottawa, Canada Area
    Statistics Canada produces statistics that help Canadians better understand their country—its population, resources, economy, society and culture. In Canada, providing statistics is a federal responsibility. As Canada’s central statistical agency, Statistics Canada is legislated to serve this function for the whole of Canada and each of the provinces and territories.

Benoit Pelletier Skills

Data Analysis Data Conversion Database Administration Software Development Sql Server Reporting Services

Benoit Pelletier Education Details

Frequently Asked Questions about Benoit Pelletier

What is Benoit Pelletier's role at the current company?

Benoit Pelletier's current role is DBA at Immigration and Refugee Board of Canada.

What schools did Benoit Pelletier attend?

Benoit Pelletier attended Université Du Québec En Outaouais.

What skills is Benoit Pelletier known for?

Benoit Pelletier has skills like Data Analysis, Data Conversion, Database Administration, Software Development, Sql Server Reporting Services.

Not the Benoit Pelletier you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.