Database Administrator

Design, Development, Healthcare, Management
October 27, 2024
Remote

Job Description

  • Remote
  • Austin

State of Texas Health & Human Services Commission


Job Title : Snowflake Data Base Administrator

Location : Austin, TX (4 days remote and 1 day onsite )

Duration : 12 months



USC and GC

Pay rate : $70-$75/hr on W2



Required Skills

  • Strong overall understanding of Snowflake architecture and its components.
  • Hands-on experience with Snowflake objects such as Databases, Procedures, Tasks, and Streams.
  • Expertise in using Snowflake’s cloning capabilities for databases and schemas.
  • Proven experience in managing Snowflake Warehouses and optimizing performance for efficient query execution.
  • Proficiency in Snowflake RBAC (Role-Based Access Control), including implementation of roles and privileges.
  • Experience with integrating Snowflake SSO (Single Sign-On) and SCIM (System for Cross-domain Identity Management) for secure access and identity management.
  • Familiarity with CI/CD pipelines and version control for managing Snowflake code deployments.
  • Experience working with data integration tools like Informatica and ADF for seamless ETL/ELT processes.
  • Ability to automate administrative tasks using Snowflake SQL and scripting languages like Python or Shell scripting.
  • Expertise in monitoring and troubleshooting Snowflake environments, including usage tracking and query profiling.
  • Strong understanding of Snowflake’s security features such as data masking, encryption, and network policies.
  • Technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.
  • Experience on an agile sprint team.
  • Experience with JIRA software.
  • Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality.

Preferred Skills

  • Proven ability to write well designed, testable, efficient code by using best software development practices.
  • Understanding of security principles and how they apply to healthcare data.
  • Experience with state of the art software components for a performance metrics data visualization or business intelligence environment.
  • Excellent oral and written communication skills.
  • Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.
  • Bachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience.
  • Prior experience in the Healthcare Industry.
  • Prior experience working with PII or PHI data.
  • Prior experience working with HL7 data.
  • Prior experience with Azure.

Source ⇲

To apply, please visit the following URL:https://www.whatjobs.com/pub_api__cpl__1756282750__5076?utm_campaign=publisher&utm_medium=api&utm_source=5076&geoID=28489→

Related Jobs