Dayn Barlow
Manager Data Engineering at Avanti Software Inc.- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Microsoft Certified: Azure Data Fundamentals
MicrosoftFeb, 2022- Nov, 2024 -
Microsoft Certified: Azure Fundamentals
MicrosoftJan, 2021- Nov, 2024 -
Microsoft Certified: Azure Database Administrator Associate
MicrosoftFeb, 2023- Nov, 2024
Experience
-
Avanti Software Inc.
-
Software Development
-
100 - 200 Employee
-
Manager Data Engineering
-
Apr 2023 - Present
Avanti provides all your people management all from one single suite, including Payroll, Human Resources, Recruitment, Time & Attendance, and Self-Service; optimized for Canadian businesses. All of our data, development, and people are located in Canada. From the hiring process all the way through to retirement, we've got you covered.
-
-
Data Engineer
-
May 2022 - Apr 2023
Avanti provides all your people management all from one single suite, including Payroll, Human Resources, Recruitment, Time & Attendance, and Self-Service; optimized for Canadian businesses. All of our data, development, and people are located in Canada. From the hiring process all the way through to retirement, we've got you covered.
-
-
-
Rocky View County
-
Canada
-
Government Administration
-
100 - 200 Employee
-
Information Systems Supervisor
-
Jul 2015 - Dec 2020
• Lead and assist a team of 7 IT professionals and 2 telecom specialists supporting business operations• Design, recommend, implement, and support solutions primarily utilizing Microsoft stack• Chair Change Control Board balancing risk mitigation and progress• Lead team and collaborate with troubleshooting and root cause analysis• Assist IT Manager with budget forecasting and implementationKey Achievements:• Coach IT staff on architecture update MS SQL environment • Collaborate on data center move with no client operational down time• Coordinate infrastructure for centralized water and wastewater SCADA• Demonstrate flexibility and adaptability when compensating for data center construction delays with no adjustment to go live date• Mentor IT staff to transition support of ETL processes I had implemented• Primary office move with consolidation of a satellite office*My position ceased in December 2020 due to corporate restructuring/COVID-19. Show less
-
-
Information Systems Team Lead
-
Jul 2013 - Jul 2015
• Lead and assist a team of 6 IT professionals and 2 telecom specialists supporting business operations• Enhance ETL solutions creating business unit collaboration and efficiency• Coordinate and administer backend servers and software to meet need of businessKey Achievements:• Extend Commvault data protection with automated offsite data replication with tiering for disaster recovery including branch offices utilizing CommVault deduplication technology.• Design, code, and implement ETL processes from disparate database systems for Assessment and Tax Notices abstracting print production from MS Dynamics GP to a 3rd party vendor.• Coordinate the County’s implementation of AFRRCS system• Mentor IT staff to transition support of Dynamics GP support• Collaborate with in house team and vendor on data migration of custom applications with SQL Server databases into CityView Suite ERP inclusive of migration of SQL Server FileTable documents into SharePoint with metadata Show less
-
-
Systems Analyst
-
Jun 2003 - Jul 2013
• Design, recommend, implement, and support a variety of vendor solutions with custom in house designed systems primarily with Microsoft stack• Architect, implement and maintain SQL Server and SQL Server Reporting Services• Implement and maintain firewalls from multiple vendors• Architect and implement Commvault data protection solutionKey Achievements:• Implement Commvault backup system with software deduplication• Refactoring disparate legacy databases to centralized SQL Server, designing and coding of .NET applications with VSTO document generation, and SSRS reporting to meet needs of business Show less
-
-
Computer Support Technician
-
Oct 1997 - Jun 2003
First line support County Employees with IT infrastructure.Design and implement database solutions utilizing SQL Server 6.5 ->2000 with MSAccess, VB6 front ends
-
-
Education
-
Southern Alberta Institute of Technology (SAIT)
Business Intelligence Data Analysis and Reporting Certificate -
Microsoft
DP-900 Azure Data Fundamentals -
Microsoft
AZ-900 Microsoft Azure Fundamentals -
Mount Royal University
Leadership Development Certificate -
Brent Ozar Ltd
SQL Query Performance Tuning -
Denny Cherry & Associates
SQL Server Security -
Alberta Municipal Health and Safety Association
Leadership for Safety Excellence -
Commvault Education Services
V11 Core Fundamentals, Implementation and Maintenance -
Commvault Education Services
Commvault Administration, Archiving and Indexing -
New Era Technology
ITIL 2 Foundation Certification, IT Service Management -
Southern Alberta Institute of Technology / SAIT
Diploma, Computer Engineering -
Tisdale Composite Highschool
High School Diploma