Snowflake Platform Architect

Greetings of the season! My name is Adam Smith, I am from Armehtech Solutions which is a U.S based, staffing, and recruitment firm. I would like to update you on open positions with our esteemed clients. Please go through the Job Description. Send me your updated resume and expected rate for the below position

Position: Snowflake Platform Architect
Location: Cincinnati, OH(Remote)
Duration: Long term

Note: Looking for experience Snowflake Platform and Automation side.

Look for current job role as Snowflake Architect and previously worked as Principal Data Engineer/Senior Data Engineer.

JOB DESCRIPTION:

What you will be doing
• Work in a globally distributed team to provide robust enterprise data platform in Snowflake
• Design, optimize, document and implement the operational aspects in supporting the snowflake cloud
platform. Including cost monitoring and optimizations, User security auditing
• Implement/support automation for production deployment in Snowflake
• Implement Snowflake standards and methodologies for DB security – both infrastructure and app level
• Implement/support automation Snowflake - Accounts/Databases and access roles
• Diagnose and troubleshoot database errors
• Implement data sharing /replication – cross cloud/cross region for internal/external clients
• Create Snowflake utilization and capacity plan
• Tune the DB performance and improve Snowflake queries.
• Identify system bottlenecks in the DB and recommend solutions
• Implement Snowflake user /query log analysis and alerts
• Implement data encryption/decryption/masking policies to protect PII/PCI data

What you bring:

• Hands on experience with Snowflake
• Experience implementing Snowflake external functions
• Hands-on experience in administering Snowflake in AWS
• Experience with Agile and DevOps concepts
• Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.)
• Experience with architecting and maintaining high availability production systems
• Experience with developing monitoring architecture and implementing monitoring agents, dashboards,
escalations and alerts
• Knowledge of security controls for the Public cloud ( encryption of data in motion/rest and key
management )
• Demonstrated proficiency of index design, query plan optimization and analysis required
• Demonstrated knowledge and hands-on experience with AWS alerting/monitoring tools
• Experience with AWS CLI and Networking
• Strong communication and written skills
• Self-starter with ability to take direction and manage tasks with minimal supervision within an
energized, collaborative and entrepreneurial environment

Experience & Certification Required:
- Snowflake Advanced certification - Very nice to have
- Snowpro core certification required
- Experience in development of SQL, Python, and Shell based scripting to build a variety of reporting and application data warehouses - Preferred

- Experience in Data Injection

Data Pipeline
Schema
Infrastructure
Real time batch data into Snowflake
Some admin exp
Exp with Change

Best Regards,
Adam Smith| IT Technical Recruiter | Armehtech Solutions LLC
919 north market street suite 950 Wilmington, Delaware. 19801, USA
E-Mail: adam@armehtech.com  
Web: www.armehtech.com
USA / UK / INDIA