Data Windows Server

HUANGKAI ZHAO

ac2yer@r.postjobfree.com 669-***-****

EXPERIENCE

Hainan Airline, ETL Engineer July, 2014– September 2016

•Outsourced employees for People’s Government of Hainan Province in China and in main charge of data exchange and data analyst for Hainan citizen data market.

•Designed and administrated the database for Citizen Management System of Hainan Province China.

•Designed ETL workflow to analyze the information of data, improved the quality of data details and transfer data according to requirement.

•Administrated large data sets of citizen information (more than 10 million).

Hainan Airline, Development Manager October, 2016– June, 2017.

•Lead a team of research and development Engineer to develop Enterprise management software for People’s Government of Hainan Province.

•Installed, configured, & maintained the software and relevant database for the government client.

•Responsible for the communication between the government client and the development team.

RESPONSIBILITIES

•Installed and Configured various Operating System (CentOS-7x, RHEL-6x, Windows server 2003 / 2008 etc.) by VMware Workstation.

•Configured various Operating System network environment.

•Installed and Configured FTP server, vsftp for RHEL-6x & FileZilla for Windows server.

•Installed and Configured oracle database (Oracle11c, Oracle1 2g) for RHEL-6x, SQL Server database (SQL Server-2008) for Windows server.

•Various database backup and recovery, monitoring and optimizing database performance.

•Administrating and installing Oracle RAC & ASM.

•Creating user accounts, roles and granting required access permissions and privileges to the users based on the applications they are accessing for various database.

•Creating indexes to facilitate optimal performance for various database.

•Designed tables, constraints, views etc. for various database.

•Experienced in designing and managing database structure by PowerDesigner.

•Installed and Configured ETL tools (Kettle,Informatica).

•Experienced in developing mapping for fact loading from various dimension tables.

•Experienced in data Warehouse/Data mart, ODS.

•Experienced in collecting and link metadata from diverse data sources, including relational databases (Oracle, Sqlserver, Mysql…), XML and flat files (Excel,TXT,CSV…) .

•Experienced in Standardizing various type of data format, fixing data error, clearing redundant data & analysting data by designing script (java script), SQL query (pl/sql, sql)& ETL workflow.

•Experienced in Designing Linux shell scripts for ETL tools to automate sessions.

•TECHNICAL SKILLS

•

• Java script, C++, SQL Queries, Windows, Linux/Unix, B2Bi, Oracle, Sqlserver, Mysql, Kettle, Excel, Words

•AWARDS AND ACTIVITIES

•

•Awards: The best project team of Hainan Airline Technical Department in 2016 (Development Manager)

•

•EDUCATION

•

•Harbin Institute of Technology Harbin, HeiLongJiang Province/CHINA

•Bachelor of Computer Science and Technology August, 2010 - June. 2014

•Related Coursework: C++, Java, TCP/IP Analysis and Programming, Computer Network, Data Structure, Software Engineering, Introduction to Communications, Operating System, XML, Digital Logic, Web Design, Compiling Technique, Principle of Database System

Contact this candidate