Digital Health Technology team powers digital experiences and engagement to enhance the lives of millions of people every day through connected care. We build, deliver and manage a portfolio of data management platforms and mobile offerings in support of our core businesses. We thrive on simple and elegant architecture and agility. You’ll be immersed in a dynamic high-growth environment and empowered to excel, take informed risks, and drive ingenuity across the enterprise.

Snowflake DBA

Digital Health Technology team powers digital experiences and engagement to enhance the lives of millions of people every day through connected care. We build, deliver and manage a portfolio of data management platforms and mobile offerings in support of our core businesses. We thrive on simple and elegant architecture and agility. You’ll be immersed in a dynamic high-growth environment and empowered to excel, take informed risks, and drive ingenuity across the enterprise.

We are recruiting a Snowflake Database Administrator to join our DHT team in China.

Let's talk about the role:

As part of a data-driven organization, the primary role of the DBA is to unlock the full potential of our data platform and maintenance of the data platform & ultimately putting data at the fingertips of various stakeholders in the world. You will share the ownership of our data platform, from ingress through transformation and access/integration.   

Let's talk about responsibilities:

Snowflake China DBA responsibilitiesWork with the US, APAC and EU teams and make sure that the Snowflake environment follows the standards and the architecture.Help develop, deploy and troubleshoot ETL logicHelp US, APAC and EU teams to investigate data platform related issues.Work with Snowflake support to address any product related issues.Design, implement, and manage the Snowflake accounts to ensure high availability and scalability.Design, configure and manage Snowflake accounts, including database schema, access control, and security policies.Implement cost control measures.Help other Snowflake users with query optimization.Monitor and tune Snowflake performance, including resource utilization and system health.Troubleshoot and resolve technical issues related to Snowflake, including system failures, data integrity, data quality, data replication, data sharing and access issues.Collaborate with data engineers, analytic engineers, and data consumers to design and implement data pipelines and analytic processes.Maintain data quality and consistency across the Snowflake environment.Ensure compliance with industry regulations and best practices related to data privacy and security.Stay updated with new Snowflake features and best practices and make recommendations for improvements to the Snowflake environment.Develop and maintain documentation related to the Snowflake environment, including architecture diagrams, standard operating procedures, and troubleshooting guides.Provide training and support to other members of the data team as needed.

Let's talk about qualifications and experience:

Minimum of 5 years of experience working as a DBA in Snowflake or Oracle or Teradata or similar large database management system.Experience managing multi-terabyte and multi-billion row database systems.Advanced SQL knowledge and experience working with relational databases.Good understanding of shell scripts Good understanding of ETL methodsExperience with AWS cloud services, including S3, EC2, IAM etc.Ability to work with remote team membersBachelor’s degree in computer science, or other relevant fields Minimum of 10 years of related experience in the IT industryExposure to TerraformExposure to Kafka, DBT or any ETL toolExposure to HIPPA and/or GDPR and/or Chinese privacy rules

Joining us is more than saying “yes” to making the world a healthier place. It’s discovering a career that’s challenging, supportive and inspiring. Where a culture driven by excellence helps you not only meet your goals, but also create new ones. We focus on creating a diverse and inclusive culture, encouraging individual expression in the workplace and thrive on the innovative ideas this generates. If this sounds like the workplace for you, apply now! We commit to respond to every applicant.