Database Administrator

$172,640 - $193,440/Yr

Indotronix International Corporation - Austin, TX

Full-time - Mid Level

Austin, TX

Professional, Scientific, and Technical Services

About the position

The Snowflake Database Administrator (DBA) will be responsible for the implementation and configuration of a data integration hub, utilizing agile methodologies to ensure efficient development and deployment. This role requires a strong understanding of Snowflake architecture and hands-on experience with its components, focusing on performance optimization, security, and integration with various data sources.

Responsibilities

• Implementation and configuration of the infrastructure for the data integration hub
• Design, development, and implementation (DD&I) of the data integration hub using agile methodology
• Validation of performance metric requirements
• Creation of Epics/User Stories/Tasks
• Automation of data acquisition from various data sources
• Development of complex SQL scripts
• Testing - integration, load, and stress
• Deployment/publication internally and externally
• Operations support and enhancement of the data integration hub
• Monitoring and troubleshooting Snowflake environments, including usage tracking and query profiling
• Automating administrative tasks using Snowflake SQL and scripting languages like Python or Shell scripting

Requirements

• 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
• Technical writing and diagramming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin)
• Experience on an agile sprint team
• Experience with JIRA software
• Ability to prioritize and complete work on time with high quality

Nice-to-haves

• Proven ability to write well designed, testable, efficient code using best software development practices
• Understanding of security principles and their application to healthcare data
• Experience with state-of-the-art software components for performance metrics data visualization or business intelligence
• Excellent oral and written communication skills
• Bachelor's degree in Computer Science, Information Systems, or Business or equivalent experience
• Prior experience in the Healthcare Industry
• Prior experience with an HHS agency
• Prior experience working with PII or PHI data
• Prior experience working with HL7 data
• Prior experience with Azure

Benefits

• Competitive salary ranging from $83.00 to $93.00 per hour
• Equal Opportunity Employer commitment