What are the responsibilities and job description for the Database Administrator with Snowflake and Python position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, ConnectedX, Inc., is seeking the following. Apply via Dice today!
Role: Database Administrator with Snowflake and AWS, Python
Location: Plano, TX -Onsite
Duration: 12 Months - W2 Contract
Job Description:
Role: Database Administrator with Snowflake and AWS, Python
Location: Plano, TX -Onsite
Duration: 12 Months - W2 Contract
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