Database Admin with Snowflake and Python

Role: Database Admin with Snowflake and Python

Location: Plano, TX -Onsite

Duration: 12+ Months

Job Description:

• Enhance and modify existing Python-based ELT processes within the Snowflake environment.
• Develop Python scripts to automate Snowflake administration tasks.
• Leverage AWS infrastructure, including S3, EC2, EKS, and implement Unix shell scripting and Python scripting for automation.
• Administer Snowflake in sub-prod, production, and global environments, including creating databases, schemas, tables, views, external stages, and storage integrations.
• Troubleshoot data issues, debug Python code, and optimize SQL queries and business logic.
• Manage Snowflake features such as Streams, Tasks, Cloning, Time Travel, multi-cluster warehouses, and ensure scalability for diverse workloads.
• Implement security best practices for role-based access, user privileges, and integrate with external tools as required.
• Proactively design and implement process improvements, such as automation of manual tasks, optimizing data flows, and ensuring cost-effectiveness and scalability.
• Utilize optimization techniques like materialized views, clustering, micro-partitioning, and caching to enhance query performance.
• Administer Snowflake SSO/Okta integration, AD Group setups, access control, encryption, and security policies (Network, Row Access, Masking).
• Support integration of Tableau, SAS, Python, and JDBC connections with Snowflake.
• Manage CI/CD pipelines within Snowflake, oversee schema changes, and ensure smooth deployment processes