Edison Yang
Database Administrator at St. Clement's School- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Carl Yan
XIAOTIAN knows well for technology of hardware terminals,especially for mobile terminals.
Carl Yan
XIAOTIAN knows well for technology of hardware terminals,especially for mobile terminals.
Carl Yan
XIAOTIAN knows well for technology of hardware terminals,especially for mobile terminals.
Carl Yan
XIAOTIAN knows well for technology of hardware terminals,especially for mobile terminals.
Experience
-
St. Clement's School
-
Canada
-
Education Administration Programs
-
1 - 100 Employee
-
Database Administrator
-
Nov 2019 - Present
• Develop and maintain SQL Server and Oracle Database for school system. • Maintain different platforms data – Data mapping, transferring, security, and accuracy. • Database and system user permission and security management. • Develop reports for multi departments using system tools and Crystal report. • Project management for school system transfer. Including data migration, data mapping to new system. And new system connects to other school platforms. • School system management - Powerschool/ Blackbaud/ Edsby/ Trillium. Show less
-
-
-
-
Database/ERP Administrator
-
Jan 2017 - Nov 2019
• Develop and maintain SQL Server Database, do backup and restore, create new database and import data for ERP system. Write Query to combine tables and extract data. • Develop and maintain ERP system, including business process, function, report development, daily trouble shooting, database maintaining, and change log control. • Develop and apply Jet report data warehouse. Work together with finance and BI team to create, modify and analysis ERP data reports for business management and strategy. Show less
-
-
-
New Concept Quality Doors
-
Construction
-
1 - 100 Employee
-
Database/ERP Administrator
-
Dec 2014 - Jan 2017
Develop and maintain company’s ERP system (Microsoft dynamics NAV 2013) • Develop and modify ERP operation report. Create and analysis business report for company management. • Create, backup and restore SQL Server Database, manage server-level and database-level roles, use SQL query to access company data, configure SQL Agent to run scheduled jobs. • Maintain and test the company’s B2B website and configurator system. • Maintain the timely back-up of important company system data and configurations using Idera SQL Safe, Veeam Backup, etc. • Administrate company’s website backend and edit website pages using Wordpress 4.3. Show less
-
-
Education
-
University of Windsor
Master of Engineering (MEng), Electrical and Computer Engineering -
University of Jinan
Bachelor's degree, Electrical and Computer Engineering