What are the responsibilities and job description for the Database Administrator with Snowflake and Python position at ConnectedX, Inc.?
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