database Engineer (sql)Công Ty Cổ Phần Dược Phẩm Pharmacity

Be responsible for database management including configuration, security, resource monitoring and reporting, troubleshooting, and the development of specialized programs.
Main Responsibilities
1. Build and operate data warehouse:

• Work closely with ERP, Software team and functional departments to define data flow and data meaning
• Do ETL jobs, create and manage sources connect with data warehouse
• Work with analysis team to design suitable data set for reports
• Update data set structure as business changing and requirements
• Create documents related on data structure and definition
• Handle problems related to database.

2. Improve data warehouse environment performance:

• Create suitable data warehousing and data loading solution based on product requirement from analysis team and Machine Learning team
• Work with technical IT team to improve data warehouse environment, consult and come up with solutions to make data can be stored bigger, loaded faster with saving cost
• Control cost and capacity of data warehouse environment, keep tracking and alerting with any issues and solve ASAP to make sure report system and ML tools working well
• 3. Data Security and Integrity
• Create and manage connections come out from data warehouse
• Keep connections stable with security
• Keep tracking and alerting if there is any issue make data wrong