Data Analysis Engineer

Responsibilities

• Microsoft SQL Server Administration Install, monitor, and maintain Microsoft SQL Server software/databases Implement, maintain and test backup and recovery processes

• Provides system and database troubleshooting and optimization and SQL query tuning

• Demonstrates an in-depth knowledge of database internals and data structures Account and access control management Management of replication/scale out technologies, such as Always On availability groups, and load balancing/workload management

• Automation of administrative tasks (Python, PowerShell, Bash) PostgreSQL Administration

• Help manage and maintain a MPP (Massively Parallel Processing) PostgreSQL based appliance Implement, maintain and test backup and recovery processes Manage and automate replication, failover/failback processes

• Manage and test upgrades Work with vendor, and infrastructure teams, to address break/fix (hardware failures), migrations and changes

• Provides system and database troubleshooting and optimization and SQL query tuning Snowflake Administration

• Manage setup and maintenance of accounts in conjunction with the infrastructure team

• Manage account, access control and shares Troubleshoot authentication and connectivity issues Work with Snowflake on outages/issues Server & Storage Administration

• Experience and understanding of working with physical infrastructure (servers, storage, networking, etc.)

• Coverage and escalation for systems, storage and data center changes and incidents

Qualifications/Skills Required

• Bachelor degree in computer science, or information technology, or other related field of study

• At least 5 years of experience in Microsoft SQL Server and PostgreSQL Database Administration/Engineering Experience with Snowflake Experience with Windows Server and Linux operating systems

• Understanding of networking and load balancing Scripting/programming (Python/Bash, Powershell)

Desired Skills

• IaC automation (Ansible, Terraform, etc.)

• Job schedulers/orchestrators (Airflow, Nomad, etc.)

• StorageLocal storage (NVMe, RAID)NAS (NFS/SMB)

• Physical infrastructure Servers, optics, cabling, rackspace, power, etc.

Company profile:

MMSTAR Technology Ltd. was established in Hong Kong and received innovation and technology funding from the Hong Kong University of Science and Technology and innovation and technology incubation funding from the Hong Kong Science Park when it was established.