Resume

Sumary

Danik Collin

What describes me the best:

Dependable. I am a dependable person who is great at time management.

Energetic. I am always energetic and eager to learn new skills.

Motivated. I am motivated to go to the gym before work to get fit and healthy.

  • Gatineau, Qc
  • (613) 606-3948
  • Icevu1@gmail.com

Education

Programming

Collège La Cité

Learned languages & Frameworks:
- VisualBasic - Java - C - C# - Python - SQL - HTML/CSS - PHP
- JavaScript - NodeJs - .Net - NoSQL(MongoDB)

Computer Engineering

Collège La Cité

Learned languages & Frameworks:
- Java - C++ - C - C# - Python - SQL - HTML - PHP - JavaScript - Css
- Ruby - Swift - IT, Android Studio - PowerBI - Arduino - Assembly

MCSE & MCSA Certification

Microsoft

Exam 764: Administering a Microsoft SQL Database

Exam 765: Provisioning SQL Databases

Exam 767: Implementing a Data Warehouse

Professional Experience

DBA

2018 - Present

8564663 Canada Inc. - Ottawa

  • Create and Implement ETL Package using Visual Studio 2019 to extract, transform, and load data from different data sources such as SQL, Oracle, Excel Spreadsheets to SQL Server 2017;
  • Migrate/Replicate databases from SQL 2014 to SQL 2017 using FULL/DIFF/LOG Backup/Restore methodology or/and using Log Shipping for database for reporting purpose;
  • Design, implemented and automated databases maintenance plans such as backups/restore, indexes maintenances, Logs shipping replication, databases access rights auditing using T-SQL scripts, Store Procedures, Views, UDF, PowerShell scripts;
  • Analyze and troubleshoot performance issues such as deadlocks, blocking, statistics, I/O bottlenecks using database tuning and monitoring tools such as SQL server Profiler, DMVs, System Catalog Views, Windows Performance Monitor, Query Plans, Database Tuning Advisor and Built in performance reports in SSMS;
  • Implement and maintain data encryption using TDE and EKP to protect sensitive data;
  • Install/upgrade SQL Servers 2014/2016/2017 and related components

Sales Associate

2019 - Present

Videotron LTE - Ottawa

  • Sales specialist with a advance knowledge in cellphones technology;
  • Tasked with maintaining the Kiosk's equipements and systems (IT);
  • Being able to adapt to the client's needs to be able to find the right device;
  • Being able to resolve any issues brought forward by the clients;
  • Achievement: Most sales company-wide for 2019