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.
-
Dba/Sql DeveloperImmigration And Refugee Board Of Canada | Commission De L'Immigration Et Du Statut De Réfugié Aug 2019 - Jun 2024Ottawa, Canada Area -
Technical Advisor, Database Administration (Dba)Department Of Justice Canada | Ministère De La Justice Du Canada Sep 2017 - Apr 2019Ottawa, Canada AreaProvides 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. -
Senior Database Administrator & ItCanadian Commercial Corporation - Corporation Commerciale Canadienne Sep 2015 - Sep 2017Ottawa, Canada AreaAnalyzed 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; -
Dba / Data Conversion SpecialistTransportation Safety Board Of Canada - Bureau De La Sécurité Des Transports Du Canada Jun 2012 - Mar 2015GatineauAs 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. -
Dba / Data Conversion SpecialistPatrimoine Canadien -- Canadian Heritage Jun 2011 - May 2012Ottawa, Canada AreaAs 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 -
Dba / Data Conversion SpecialistExport Development Canada | Exportation Et Développement Canada - Edc Mar 2010 - May 2011Ottawa, Canada AreaI 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 -
Dba / Data Conversion SpecialistCanadian Air Transport Security Authority May 2009 - Feb 2010Ottawa, Canada AreaAs 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.
-
Dba / Data Conversion SpecialistCanadian Radio-Television And Telecommunications Mar 2008 - Mar 2009GatineauI 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
-
Dba / Data Conversion SpecialistStatistics Canada May 1998 - Feb 2008Ottawa, Canada AreaStatistics 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
Benoit Pelletier Education Details
-
Computer And Information Sciences, General
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?
-
Benoît Pelletier
Montreal, Qc1fbn.ca -
5sylart.com, sylart.com, statsradio.com, statsradio.com, statsradio.com
-
Benoit Pelletier
Canada -
Benoit Pelletier
Laval, Qc1yahoo.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial