Data Analysis Engineer

Responsibilities

• Microsoft SQL Server AdministrationInstall, monitor, and maintain Microsoft SQL Server software/databasesImplement, 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 structuresAccount and access control managementManagement 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 applianceImplement, maintain and test backup and recovery processesManage and automate replication, failover/failback processes

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

• Provides system and database troubleshooting and optimization and SQL query tuningSnowflake Administration

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

• Manage account, access control and sharesTroubleshoot authentication and connectivity issuesWork with Snowflake on outages/issuesServer & 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/EngineeringExperience with SnowflakeExperience 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 infrastructureServers, 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.