Senior Database Specialist Azure/MSSQL - New HC

JOB PURPOSE

• Support to develop and maintain MS SQL Databases and Data Warehouse within De Heus applications and Data Lake; as well as Support to manage and ensure that all databases are highly available, with proper backup & recovery strategy
• Support to ensure all database back-end activities of Developer team (internal Dev team and out-source Dev team) work properly
• Support Data Analitics team to build 1 back-end data lake for De Heus Asia, which can serve Vietnam, Cambodia, Myanmar, Indonesia and can be extended further per requirement

KEY ACTIVITIES

Develop, maintain, monitor and improve system

• Support to administering MS SQL Server 2014 and higher version
• Support to instalL, maintain & monitor MS SQL Server instances
• Support to managing system/database security
• Support to configure and maintain database backups strategy & disaster recovery
• Implement and manage high availability solutions (database replication, database mirroring, log shipping)
• Optimizing database performance (optimizing queries, database tuning)
• Provide troubleshooting & technical service desk requirements
• Support to ensure effective support is in place for all aspects of the database management
• Support to ensure incident management protocols and process are effectively and consistently followed
• Support to ensure required high availability of MS Database
• Support to ensure existing database supports for business requirements
• Support to ensure high quality on time completion of all database projects
• Support to ensure proactive planning to ensure database effectively supports De Heus growth and business goals and objectives
• Automating administrative tasks (Integration Services)
• Database programming (triggers, procedures, functions)
• Creating reports with Crystal Reports and Reporting Services,
• Good knowledge about ERP, DW & LAA
• Managing access and security
• Implementing required reports

Develop, maintain, backup and restore database of local applications

• Implement and manage high availability solutions (database replication, database mirroring, log shipping)
• Support to ensure required high availability of MS Database
• Automating administrative tasks (Integration Services)
• Database programming (triggers, procedures, functions)
• Managing access and security
• Support developer team for database review, build and optimize from design phase to operational phase

Create, maintain, optimize database for datalake and data warehouse

• Implement and manage high availability solutions (database replication, database mirroring, log shipping)
• Support to ensure required high availability of MS Database
• Automating administrative tasks (Integration Services)
• Database programming (triggers, procedures, functions)
• Using SQL server technologies, service and databases for creating data lake, data warehouse together with Data Engineer team
• Optimize query script to improve performance of server, ensure data quality and data accuracy
• Manage access of users (both application users and technical users) to any data table, data cube, database and and data warehouse both for on-premise and cloud
• Regularly check database performance, optimize data usage and data processing to have better cost of ms. Azure.
• Maintain the right balance of data storage and data processing in between on-premise and cloud

RESULT

• Ensure system can work smoothly
• Guarantee database highly available, file backup always ready for restoring task.
• Provide right access to De Heus systems
• Ensure system can work smoothly
• Guarantee database highly available, file backup always ready for restoring task.
• Provide right access to De Heus local systems
• Databases of application which build by local team/outsource team work properly
• Datalake and data warehouse work properly
• Report and dashboard
• Database governance prototypes and procedure (who do what by when)

Qualifications:

• Bachelor degree or equivalent in related system database areas
• Ms. Azure fundamental certificate, Ms. Azure SQL database & service certificate

Experience:

• Minimum 3 years experience in successfully supporting/managing database in a multinational organization. Fresher with high competence can be considered.
• Hands on experience on Azure operation, Azure Data Factory, Azure Blob storage, Data Lake and data warehousing

Competencies:

• Strong understanding of database structures, theories, principles, and practices
• Working technical experience with designing, building, installing, configuring, and supporting database servers, particularly Microsoft SQL Server.
• Familiarity with SQL query nomenclature and fundamentals.
• Experience with Visual Studio and/or SSIS is a plus
• MCDBA certification is a plus
• Hands-on database tuning and troubleshooting experience.
• Good verbal and written communication skills (reading, writing, listening, oral, presentation)

Language(s)

• Proficiency in English.
• Effective communication in Vietnamese

Other Requirements:

• Problem-solving and good analytical skills
• Communication, teamwork and negotiation skills
• Self-motivated; Proven record for actively soliciting feedback, continuous learning and self-development.

• Annual Health Check, Year End Party: once per year
• Company Trip, Team Building, Family Day: twice per year
• Health Insurance (Generali care 24/24 Insurance)
• Birthday Gift, Staff Gift
• Free parking batch